| cannot connect to DB on another machine [message #67589] |
Wed, 03 November 2004 06:29  |
Roberta
Messages: 2
Registered: November 2004
|
Junior Member |
|
|
Hello,
We have an application (running on venturer machine) that tries to connect to a DB instance on another machine (vulture) and it fails. The listener was up, there is nothing relevant in the listener.log file. The host in the listener.ora file and in the tnsnames.ora file are the same as the correct host (as received by running hostname). This is the entry in the tnsnames.ora on the machine on which the application runs (on venturer): (all this is on hp unix)
pvclbn =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcpcom.world)
(PROTOCOL = TCP)
(host = vulture)
(Port = 1525)
)
)
(CONNECT_DATA =
(SID = PVCLBN)
(GLOBAL_NAME = pvclbn.world)
)
)
The following is from sqlnet.log:
Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcpcom.world)(PROTOCOL=TCP)(host=vulture)(Port=1525)))(CONNECT_DATA=(SID=PVCLBN)(GLOBAL_NAME=pvclbn.world)(CID=(PROGRAM=)(HOST=venturer)(USER=oper))))
VERSION INFORMATION:
TNS for HPUX: Version 8.0.6.3.0 - Production
TCP/IP NT Protocol Adapter for HPUX: Version 8.0.6.0.0 - Production
Time: 31-OCT-2004 23:29:10
Tracing not turned on.
Tns error struct:
nr err code: 12206
TNS-12206: TNS:received a TNS error during navigation
ns main err code: 12545
TNS-12545: Connect failed because target host or object does not exist
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Connect failed because target host or object does not exist
nt secondary err code: 22
nt OS err code: 0
Does anyone have any ideas about what the problemcould be?
Oracle version of DB is 8.1.7
Thanks,
Roberta
|
|
|
|
| Re: cannot connect to DB on another machine [message #67594 is a reply to message #67589] |
Fri, 05 November 2004 00:49  |
Roberta
Messages: 2
Registered: November 2004
|
Junior Member |
|
|
I found the problem.
I removed the sqlnet.ora file from <ORACLE_HOME>/network/admin (since it is supposed to use the <ORACLE_HOME>/net80/admin) and then it worked.
Now I know why it looked at the file under network - in the Registry the TNS_ADMIN was pointing to NETWORK and not to NET80. After I changed it, it didn't matter any more if there was/wasn't and sqlnet.ora file under network/admin.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
