How do I fix the TNS protocol adapter error in Oracle 11g?
How do I fix the TNS protocol adapter error in Oracle 11g?
How to Fix ORA-12560: TNS: Protocol Adapter Error
- Make sure the windows service is up and running.
- Make sure your ORACLE_SID is set to the instance name you’re trying to connect to. If either one or two are not correct you will get the error as seen below.
Where is Oracle_sid stored?
registry
ORACLE_SID is stored in the registry. Note that there are no spaces around the equal sign. In Windows, the LOCAL command can also be used to define the ORACLE_SID.
How do I bring up the listener in Oracle?
Do the following:
- Log on to the host where the Oracle database resides.
- Change to the following directory: Solaris: Oracle_HOME/bin. Windows: Oracle_HOME\bin.
- To start the listener service, type the following command: Solaris: lsnrctl START. Windows: LSNRCTL.
- Repeat step 3 to verify that the TNS listener is running.
What is the difference between Sid and service name in Oracle?
Oracle SID is the unique name that uniquely identifies your instance/database where as Service name is the TNS alias that you give when you remotely connect to your database and this Service name is recorded in Tnsnames.
What does TNS mean in text?
TNS. Take No Stuff (polite form) TNS.
Why do I get an oracle ora-12154 TNS error?
If you are working on 64-bit then you have to use the Oracle drivers, which also means you have to install it separately as they are not part of standard Windows installation – that’s the ODAC package you installed. Now, as you get an ORA-12154: TNS:could not resolve the connect identifier specified error your installation seems to work in general.
What does TNS : protocol adaptor error 12560 mean?
12560: TNS: protocol adaptor Error hmmm, you still haven’t told me anything about the OS or anything (and hopefully it is an OS that existed when 8i was production – last century – and if it isn’t don’t bother asking). Also, sql developer? use sqlplus please.
What causes the no listener error in TNS?
The docs note the cause and action on the TNS No Listener errors, recommending to re-start the listener: Cause – The connect request could not be completed because no application is listening on the address specified, or the application is unable to service the connect request in a sufficiently timely manner.
Why is my terminal server not compatible with Oracle 8i?
Terminal Server is not compatible with Oracle 8i, you’ll hit ORA-12560. Terminal Service interferes with database creation creating the TNS:Protocol Adapter Error. Using Remote Control on the virtual server worked where the Remote Desktop didn’t. I am installing Oracle 11.1.0 on windows xp.