connection problems

[poolboy]

I am using doa345. I have an executable on my development machine that does simple queries on two different databases.

When I put the exe on another machine one of the queries works, the other does not. Here is a partial listing of the error from the sqlnet.log:

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

I hope this is a simple or common problem. Thank you.

 

[Marco Kalter]

This is what the error messages guide says:

TNS-12545 Connect failed because target host or object does not exist

Cause: The address specified is not valid, or the program being connected to does not exist.

Action: Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps "oracle" is missing). If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.

This seems like an Oracle Net configuration issue. If you can connect to the same database with other tools, make sure that the Oracle Home is as expected.

------------------
Marco Kalter
Allround Automations

[This message has been edited by mkalter (edited 31 July 2002).]