Home » RDBMS Server » Networking and Gateways » Help! ORA-12560 TNS protocol adapter error (split)
Help! ORA-12560 TNS protocol adapter error (split) [message #252324] Wed, 18 July 2007 11:19 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe it is time to open an Indian language forum.

Regards
Michel
Re: Username & Password for Oracle 9i-SQL Plus [message #252326 is a reply to message #252324] Wed, 18 July 2007 11:27 Go to previous messageGo to next message
Littlefoot
Messages: 20897
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.
Re: Username & Password for Oracle 9i [message #252331 is a reply to message #252324] Wed, 18 July 2007 11:41 Go to previous messageGo to next message
BlackSwan
Messages: 25042
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.
Re: Username & Password for Oracle 9i [message #252372 is a reply to message #252331] Wed, 18 July 2007 13:09 Go to previous message
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"
Previous Topic: ORA-40815 Variable GOBAL.M_LANG_CODE does not exist
Next Topic: Security risk to Listener service
Goto Forum:
  


Current Time: Wed Dec 07 05:16:50 CST 2016

Total time taken to generate the page: 0.11834 seconds