Home » RDBMS Server » Server Administration » ORA-12560: TNS:protocol adapter error
ORA-12560: TNS:protocol adapter error [message #62908] Mon, 23 August 2004 20:17 Go to next message
Tony
Messages: 190
Registered: June 2001
Senior Member
I get the above error when attempting to:

connect system/manager from my SQL*Plus session.  However, I have no trouble at all when I need to connect to this database as system/manager from Enterprise Manager.  I compared the tnsnames.ora file with another from a database that is functional...what resolves differently when connecting as system between SQL*Plus and Enterprise Manager??

Thanks!

Tony

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error [message #62916 is a reply to message #62908] Tue, 24 August 2004 06:24 Go to previous messageGo to next message
Ken Jones
Messages: 70
Registered: January 2004
Member
Hi
Do you have multiple ORACLE_HOMES on your client?
Ken

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error [message #62917 is a reply to message #62916] Tue, 24 August 2004 07:47 Go to previous message
Tony
Messages: 190
Registered: June 2001
Senior Member
Hi Ken,
I searched and found only one instance of ORACLE_HOMES on my client.
Thanks.
Tony

Report message to a moderator

Previous Topic: 'Unable to extend segment temp by 128 in tablespace TEMP'
Next Topic: Installaing two Oracle Homes
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 08:23:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.