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:

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

go to cmd prompt


type

c:\set ORACLE_SID=(ur database name)

conn system/(urpassowrd)@dbname

hopefully it should work

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

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.

What tool are you using ? SQL*Plus or something else ?