OraFAQ Forum: Networking and Gateways » ORA-12545 Error "Connect Failed Target host or object does not exist", pls HELP

Home » RDBMS Server » Networking and Gateways » ORA-12545 Error "Connect Failed Target host or object does not exist", pls HELP

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12545 Error "Connect Failed Target host or object does not exist", pls HELP [message #115852]

Thu, 14 April 2005 13:34

anin
Messages: 7
Registered: April 2005

Junior Member

Hi,

I'm a newbie and I'm trying to connect to my network oracle DB.I get ORA-12545 Error "Target host or object does not exist".

I configured the local net service name using net8 configuration assistant.

Everything is commented in the sqlnet.ora

Any help would be appreciated.

thanks.

Report message to a moderator

Re: ORA-12545 Error "Connect Failed Target host or object does not exist", pls HELP [message #115853 is a reply to message #115852]

Thu, 14 April 2005 13:36

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Can you ping the network machine?
can you tnsping the database from client?
ELSE
post the contents of tnsnames.ora
post the connect string you are using.

Report message to a moderator

Re: ORA-12545 Error "Connect Failed Target host or object does not exist", pls HELP [message #115855 is a reply to message #115853]

Thu, 14 April 2005 13:46

anin
Messages: 7
Registered: April 2005

Junior Member

My SQLNet.ORA file:

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world

Have attached the TNSNAMES.ora

CONNECTION STRING:

Dim oc As String = "Data Source=server name; USER ID=myuserid;Password=mypass;Connection Lifetime=30;"

Dim objConn As New OracleClient.OracleConnection(oc)
Dim cmd As New OracleCommand()

Thanks for your interest

Attachment: Tnsnames.ora
(Size: 8.85KB, Downloaded 2147 times)

Report message to a moderator

Re: ORA-12545 Error "Connect Failed Target host or object does not exist", pls HELP [message #115860 is a reply to message #115855]

Thu, 14 April 2005 14:08

anin
Messages: 7
Registered: April 2005

Junior Member

Why do I have 2 folders under c:\oracle as ora81 and another as ora92
which one should I use ?

Also other than that I have c:\orant8i

so clueless. help pleez

Tnsping doesn't work.

Report message to a moderator

Re: ORA-12545 Error "Connect Failed Target host or object does not exist", pls HELP [message #115861 is a reply to message #115860]

Thu, 14 April 2005 14:13

anin
Messages: 7
Registered: April 2005

Junior Member

The TNSping error is

TNS-03505: Failed to resolve name

Report message to a moderator

Re: ORA-12545 Error "Connect Failed Target host or object does not exist", pls HELP [message #115862 is a reply to message #115860]

Thu, 14 April 2005 14:14

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

seems there are two versions of oracle client installed.
Each client has its own sqlnet.ora and tnsname.ora.
You use whichver you want.
Make sure the corresponding tnsnames.ora is updated. and comments of all entries in sqlnet.ora

Report message to a moderator