OraFAQ Forum: Networking and Gateways » ORA-12545

Home » RDBMS Server » Networking and Gateways » ORA-12545 - amazing error

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

ORA-12545 - amazing error [message #66617]

Tue, 03 September 2002 02:45

Jagadeesh
Messages: 5
Registered: September 2002

Junior Member

Hello Gurus,

I have a Oracle 8.1.7 DB running on Solaris8. Through sqlnet, I am able to connect from all other machines except from a w2k machine which provide the error:12545 - Target host or object does not exist.

The amazing things are:
1. I am able to ping the DB host
2. I have tnsnames.ora in the client with IP address
3. If I restart the listener, I am able to connect from this client within a minute. After that, no chance. The client is also having a 8.1.5 DB.
4. From this client, I am able to conect to other 8.1.7 DBs without any problem.

Please help to sort out this problem...

Advance thanks and regards,
Jagadeesh.P

Report message to a moderator

Re: ORA-12545 - amazing error [message #66618 is a reply to message #66617]

Tue, 03 September 2002 04:53

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

Senior Member
Account Moderator

1. ping host work ok?
2. did you try tnsping??
3. Add the db server's IP address, hostname, and fully
   qualified domain name to the client machine's
   hosts  file and try again.

Report message to a moderator

Re: ORA-12545 - amazing error [message #66620 is a reply to message #66617]

Tue, 03 September 2002 20:43

K.K. Raj kumar
Messages: 33
Registered: July 2002

Member

Hello Mr. Rajendran,

In the reply to the above query, You have mentioned about tnsping??? What is that? Can you elaborate?? Is it a TCP/IP supported command or Oracle's command.

Regards

Raj kumar

Report message to a moderator

Re: ORA-12545 - amazing error [message #66622 is a reply to message #66620]

Wed, 04 September 2002 05:42

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

Senior Member
Account Moderator

its oracle utility availbale with default oracle installation.
functionality is same as PING.
it will check whether the database is available( checks listener not the database!) or not. used widely
to check if network is OK?
syntax:
tnsping <service_name>

Report message to a moderator

Re: ORA-12545 - amazing error [message #66644 is a reply to message #66617]

Mon, 30 September 2002 07:54

ulli
Messages: 24
Registered: September 1999

Junior Member

simply use the ip-address of the host in the listener.ora instead of a fully qualified name. in most cases it will work.

Report message to a moderator

Re: ORA-12545 - amazing error [message #66865 is a reply to message #66617]

Fri, 14 February 2003 01:42

Hazel Seow
Messages: 2
Registered: February 2003

Junior Member

Hi all,
I do face the same problem. What I have changed is added a new listener and configure the db's dispatcher to connect that new listener running at port 1542. However, the problem is when I tried to test on the another listener(delicated) using sqlplus user/passwd@<connect_string> on local/remote server it does not work at all. This goes the same as remote server trying to connect using the connect string. But if i have to connect from local server, using sqlplus user/passwd I managed to login. However, at client side I will not be able to do so. So what is the cause of it? Also one thing to take note is all the tnsping managed to work!

Report message to a moderator

Re: ORA-12545 - amazing error [message #67231 is a reply to message #66617]

Mon, 23 February 2004 17:38

Mike K
Messages: 1
Registered: February 2004

Junior Member

Hello,

This is a very old messasge (1-1/2 years), but, since people still probably stumble upon it in Google (like I did), I thought I would add:

I have encountered the same problem. TNSPing even worked correctly. (Architecture: client is win2k, server is win2k, private IP addresses (over VPN), no DNS). I finally solved it by adding the IP address and hostname (not the fully qualified hostname) of the server with the Oracle database into the winntsystem32driversetcHOSTS file on my client.

Mike K.

Report message to a moderator

Re: ORA-12545 - amazing error [message #67255 is a reply to message #66865]

Thu, 11 March 2004 01:10

MUKKAMALA SRINIVASAN
Messages: 1
Registered: March 2004

Junior Member

I HAVE FACED THE SAME PROBLEM RECENTLY.
I HAVE CHECKED NETWORK PROPERLY. DONE TNSPING.
MSN.

Report message to a moderator

Re: ORA-12545 - amazing error [message #67363 is a reply to message #66617]

Thu, 03 June 2004 03:42

Greg B.
Messages: 1
Registered: June 2004

Junior Member

I was facing the same problem.
server: Linux 9.0, Oracle 8.1.7
client: WinNT
Suprising solution was to set HOSTNAME in /etc/sysconfig/network to the name I thought my server had from the very beginning :)) and provided during oracle installation. Before that, uname -n returned 'localhost'...
Apart from that, because I cannot use DNS, both in listener.ora on the server and in tnsnames.ora on the client I used IP address instead of fully quallified name.

Report message to a moderator

Previous Topic:	Reg : ora-06401 invalid driver designator
Next Topic:	TNS error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 17:11:29 CDT 2024