TNS:protocol adapter error

[Srinivasa Raghavan]

Hi all ,
I'm getting this error ora-12560:TNS : protocol adapter error , when i'm trying to connect to my local oracle Db what might be the problem ?
[ November 21, 2004: Message edited by: srini vasan ]

[R NATARAJAN]

Originally posted by srini vasan:
Hi all ,
I'm getting this error ora-12560:TNS : protocol adapter error , when i'm trying to connect to my local oracle Db what might be the problem ?

[ November 21, 2004: Message edited by: srini vasan ]

Oracle Installation Problem
Can be easily corrected by using Oracle Net Configuration utility

A Service name has to be created in your local machine to describe the Oracle Server Name, its hostname ,port address and protocal
For example in our office Oracle 9i is installed in a server named Bulls.

We create a service name by providing the following details

SERVICE NAME: amarml.bulls
Protocol : TCP
PORT ID : 1521

After creating above service name ,

We are able to connect to the above server by providing username,password as usual and servicename=amarml

If you have any further problems

please furnish all the environment details

[Srinivasa Raghavan]

But it was working well before ..
Since i got this error .. i thought some dll's got corrupted & reinstalled Oracle 10g but then getting the same error..
I'll try your sugession as well ...

[ilango gurusamy]

Hi
I have Oracle 9i installed on my stand alone machine. I get the same problem when i try to connect to Oracle using SYS and the password.

I wonder why this happens. Could you throw more light on the problem?

thanks
ilango

Originally posted by R NATARAJAN:


Oracle Installation Problem
Can be easily corrected by using Oracle Net Configuration utility

A Service name has to be created in your local machine to describe the Oracle Server Name, its hostname ,port address and protocal
For example in our office Oracle 9i is installed in a server named Bulls.

We create a service name by providing the following details

SERVICE NAME: amarml.bulls
Protocol : TCP
PORT ID : 1521

After creating above service name ,

We are able to connect to the above server by providing username,password as usual and servicename=amarml

If you have any further problems

please furnish all the environment details

[MUSTAFA ELSHIEKH]

hello,

please just check your TNSNAMES.ora file and the listener too,
and check if the listener is started on the Administrative tools.

then check it again.

Regards,
Mustafa.