Help me---ora12560 tns protocol error

mnhk2006 · Feb 19, 2006, 10: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

Quote:

Originally Posted by vamshikrishna

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.......

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, 08: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 may help you.

ordba · Dec 15, 2008, 09:13 PM

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

Help me---ora12560 tns protocol error

Add your answer here.

Check out some similar questions!