View Full Version : Help me---ora12560 tns protocol error
vamshikrishna
Feb 9, 2006, 10:40 PM
Hi every one am facing some problem regarding oracle 9i I have installed it on my PC with os xp and whenever I log in with 'scott" and "tiger" I get the error ora-12560 tns protocol error can some one please help me regarding this.
Also I have tried editing tnsname.ora but I could hardly understand what it was meant to be since am a newbie. It would be if someone can help me
Thanks... :confused:
mnhk2006
Feb 19, 2006, 11:10 PM
Since Oracle 9i is a networking component, you need to provide the database name in the HOST STRING entry. It is nothing but the database name what you created at the time of installation. Try with this. This may solve your problem
m89
Apr 19, 2007, 09:02 AM
go to cmd prompt
type
c:\set ORACLE_SID=(ur database name)
conn system/(urpassowrd)@dbname
hopefully it should work
gautam1978
Jul 10, 2007, 02:06 AM
hi every one am facing some problem regarding oracle 9i i have installed it on my pc with os xp and whenever i log in with 'scott" and "tiger" i get the error ora-12560 tns protocol error can some one please help me regarding this.
Also i have tried editing tnsname.ora but i could hardly understand what it was meant to be since am a newbie. It would be if someone can help me
thnx....... :confused:
Dear chek the tnsname.ora file it resides in your system in ora92\network\admin
If this file contains your DB name entry then check in the services that you listener is running or not check it and revert back
DBA
Dec 15, 2008, 09:00 AM
Check addresses used for proper protocol specification.
Before reporting this error, look at the error stack and check for lower level transport errors.
For further details, turn on tracing and reexecute the operation.
Turn off tracing when the operation is complete.
If you want to query other oracle errors, Oracle Errors and DBA Tips (http://www.allaboutoracle.com) may help you.
ordba
Dec 15, 2008, 10:13 PM
What tool are you using ? SQL*Plus or something else ?