OraFAQ Forum: Server Administration » Error Ora-12545 occuring while connecting to remote database

Home » RDBMS Server » Server Administration » Error Ora-12545 occuring while connecting to remote database

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

Error Ora-12545 occuring while connecting to remote database [message #129344]

Sun, 24 July 2005 10:21

DynamicLibra
Messages: 2
Registered: July 2005
Location: Lahore, Pakistan

Junior Member

Hi

Can any one please help me out as I m gettin the error ora-12545: Connect failed because target host or object does not exist while connecting remotely to the Oracle 8i 1.7 database.

Problem Picture: Since i have shifted the database to a new server machine the clients are unable to connect to it. But the database is working fine locally.

Steps taken so far:
1) I have made sure that listener service is up and running.
2) Have made sure that the settings for SID, port, and Address are the same in my TNSNAMES.ora and server listener and TNSNAMES.
3) Restarted the listener service.

Very Interestingly, after doing the 3rd step clients happen to connect but after opening a few sessions, or when the database server is rebooted or even if the services window of the server is closed and opened a number of times, the same error message again comes back.

Has it something to do with Dedicated/Shared mode setting of the server?

Thanx
Bilal Zafar

Report message to a moderator

Re: Error Ora-12545 occuring while connecting to remote database [message #129389 is a reply to message #129344]

Sun, 24 July 2005 23:30

Achchan
Messages: 86
Registered: June 2005

Member

Can you ping that machine with dns and IP address?

Report message to a moderator

Re: Error Ora-12545 occuring while connecting to remote database [message #129838 is a reply to message #129389]

Tue, 26 July 2005 22:24

DynamicLibra
Messages: 2
Registered: July 2005
Location: Lahore, Pakistan

Junior Member

Hi Achchan

Thanx for the help. its done.

But actually the problem was with the installation of the oracle 8i server. As that server machine had previously oracle 9i installed on it. And it couldn't have been cleaned properly.

By the way, after the fresh installation i faced
ORA-01034 ORACLE not available
ORA-27101 Shared memory realm does not exist.

To remove these errors i took following steps
1) Adjusted the parameters like shared_pool_size, loog_pool_size, java_pool_size, db_block_buffers etc in the INIT.ora file

2) IN the SQLNET.ora file
set SQLNET.AUTHENTICATION_SERVICES= (NONE)

And there it is! Up and running oracle 8i server

Thanx
DynamicLibra

Report message to a moderator

Re: Error Ora-12545 occuring while connecting to remote database [message #129933 is a reply to message #129838]

Wed, 27 July 2005 06:19

Achchan
Messages: 86
Registered: June 2005

Member

Hi DynamicLibra,
congratulations! And furthermore thanks alot for your comprehensive posts.I think this is the true way to help other ones to avoid that problems.New users should learn from you,although your problem had solved you posted other complete notes.
Great work!

Report message to a moderator

Previous Topic:	requirement of disk for a databse in oracle
Next Topic:	MarshallingXAException error during Transaction.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 09:39:49 CST 2025