OraFAQ Forum: Networking and Gateways » Help! ORA-12560 TNS protocol adapter error (split)

Home » RDBMS Server » Networking and Gateways » Help! ORA-12560 TNS protocol adapter error (split)

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

Help! ORA-12560 TNS protocol adapter error (split) [message #252324]

Wed, 18 July 2007 11:19

DAYA KIRAN
Messages: 2
Registered: July 2007
Location: ANDRA PRADESH

Junior Member

hi friends,
i just installed the oracle8i version but when i entered the username:scott Password:tiger then i saw a messege that is ORA-12560 TNS protocol adapter error..
please help me
how can i do this.

[Updated on: Wed, 18 July 2007 11:32]

Report message to a moderator

Re: Username & Password for Oracle 9i-SQL Plus [message #252325 is a reply to message #252324]

Wed, 18 July 2007 11:26

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Maybe it is time to open an Indian language forum.

Regards
Michel

Report message to a moderator

Re: Username & Password for Oracle 9i-SQL Plus [message #252326 is a reply to message #252324]

Wed, 18 July 2007 11:27

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

@DAYA KIRAN, please, keep this Forum in English.

Edit your message and translate it so that other Forum members could participate in discussion.

Report message to a moderator

Re: Username & Password for Oracle 9i [message #252331 is a reply to message #252324]

Wed, 18 July 2007 11:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please NOTE this thread was dormant for about 1 year & now hijacked twice by different posters in the last 24 hours.

Report message to a moderator

Re: Username & Password for Oracle 9i [message #252372 is a reply to message #252331]

Wed, 18 July 2007 13:09

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

ORA-12560: TNS:protocol adapter error occurred

Cause of above error:-Oracle classify this as a ‘generic protocol adapter error’. In my experience it indicates that Oracle client does not know what instance to connect to or what TNS alias to use.

Possible Remedies:If running on the server (or workstation) that is running the database (i.e. if the database is local to the machine) then try explicitly setting ‘ORACLE_SID’. e.g.

set ORACLE_SID=<sid>

and then try again.

e.g if DB name is ORCL then on windows.

set ORACLE_SID=orcl

And if it is linux o/s then

export ORACLE_SID=orcl

better try to connect like as below

D:/>sqlplus "sys/<password>@sid as sysdba"

suppose password is strongbullin and orcl is sid(database name)

D:/>sqlplus "sys/strongbullin@orcl as sysdba"

Report message to a moderator

Previous Topic:	ORA-40815 Variable GOBAL.M_LANG_CODE does not exist
Next Topic:	Security risk to Listener service

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 00:19:15 CST 2025