| 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. |
|
| Back to top |
|
 |
| 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 |
|
|
| Back to top |
|
|
| 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"
(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. |
|
| Back to top |
|
|
| 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 |
|
| Back to top |
|
|
| 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. |
|
| Back to top |
|
|
|
|
