MQSeries.net :: View topic - ORA-12162 TNS:net service error

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ORA-12162 TNS:net service error

ORA-12162 TNS:net service error

« View previous topic :: View next topic »

Author

Message

smdavies99

Posted: Mon May 09, 2011 11:50 pm Post subject: ORA-12162 TNS:net service error

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

I have been trying to get 6.1.0.9 working on RHEL 5.5 with a remote ORacle 10 DB.
I'm stumped by this error.

Code:

May 10 09:31:37 yeps51792 WebSphere Broker v6109[4267]: (MYBROKER.TESTEG)[8]BIP2322E: Database error: SQL State '08001'; Native Error Code '12162'; Error Text '[DataDirect][ODBC Oracle driver][Oracle]ORA-12162: TNS:net service name is incorrectly specified '. : MYBROKER.579ce0d4-2f01-0000-0080-95769b00c7a0: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 459: ImbOdbcHandle::checkRcInner: :

The ORacle 10 client is installed (UKor823.so needs libclntsh.so)
The sqlnet.ora looks like this

Code:

names.default_domain = mybiz
SQLNET.EXPIRE_TIME = 120

The TNSNAMES.ora looks like this

Code:

esbd.mybiz =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = ebiz-dev)(Port = 1521)))
(CONNECT_DATA = (SERVICE_NAME = esbd.mybiz))
)

The odbcini that $ODBCINI points to looks like this

Code:

[ODBC Data Sources]
ESBREFDSN=DataDirect 5.3 Oracle Wire Protocol

;# Oracle stanza
[ESBDSN]
Driver=/opt/ibm/mqsi/6.1/ODBC32/V5.3/lib/UKor823.so
Description=DataDirect 5.3 Oracle Wire Protocol
HostName=ebiz-dev
PortNumber=1521
SID=ESBD
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

tnsping & sqlplus all work fine to the target DB from the account that broker is running from.
The DSN is defined and mqsi_setupdatabase has been run.

I'm stumped. Normally this all falls into place without problem. Any thoughts. I've probably missed something silly but at the moment I can't put my finger on it.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

mqjeff

Posted: Tue May 10, 2011 3:10 am Post subject: Re: ORA-12162 TNS:net service error

Grand Master

Joined: 25 Jun 2008
Posts: 17447

smdavies99 wrote:

(SERVICE_NAME = esbd.mybiz)

smdavies99 wrote:

SID=ESBD

smdavies99

Posted: Tue May 10, 2011 4:04 am Post subject: Re: ORA-12162 TNS:net service error

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

mqjeff wrote:

[quote="smdavies99"

Code:

]

(SERVICE_NAME = esbd.mybiz)

smdavies99 wrote:

SID=ESBD

That is handled by the sqlnet.ora.

Code:

names.default_domain = mybiz

Well it is in Oracle land...
tnsping trcproute & sqlplus all work fine.

All the internet references to this problem seem to say 'Set the ORACLE_SID correctly'.
If I do

Code:

export ORACLE_SID=ESBD

I get:-

Code:

BIP2393E: Database error: ODBC return code '-1' from datasource 'ESBDSN'.
BIP2322E: Database errorL SQL State '00001'; Native Error Code '12545'; Error Text '[DataDirect][ODBC Oracle Driver][Oracle]Ora-12545: Connect faile because target or host does not exist'.

ODBC trace confirms that a login failed. I know that the DSN uses the correct Username/password. I've set them in a script that does login/select using sqlplus with the same params.
All the settings (apart from the pathnames) were taken from a working 6.1.0.9 Solaris system.
baffled.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

fschofer

Posted: Tue May 10, 2011 4:37 am Post subject:

Knight

Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany

Hi,
are your execution groups 32 or 64 bit, maybe the odbc64.ini needs to be modified too.

Regards
Frank

smdavies99

Posted: Tue May 10, 2011 4:45 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Everything (inc the OS) is 32bit so your question does not apply.
This is really a test system to try to get to the bottom of some issues with 6.1.0.9 on Solaris & SAP/CRM Connection Caching. What should have been a simple task is turning out to be just the opposite.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ORA-12162 TNS:net service error

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP