Oracle 11gR2


I installed Oracle 11gR2 server in my machine. OS is Windows 2008 64 bit server.

I am the administrator of the machine and also included in ora_dba group.

But when I try to login in the same machine where server is installed as "sqlplus / as sysdba" its giving error like

ora-12560 TNS Protocol adapter error.

I started oracle services in the machine also.

I set ORACLE_SID also as there in tnsnames. ora at the command prompt.

Still am getting the error. What else I can check?

Can you please suggest all the possible options to avoid this error and get connected to idle instance?

Who is Participating?
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Since you are on the local machine, I do not believe this has anything to do with the listener.  You should be doing a BEQUETH connection so the listener isn't involved.

>>I set ORACLE_SID also as there in tnsnames. ora

Forget about the tnsnames.ora file for now.

If your database name is ORCL:
Make sure the Windows Service, OracleServiceORCL is started.
From a command prompt:  
sqlplus / as sysdba

replace ORCL with whatever the database is named.
HuaMinChenBusiness AnalystCommented:
Can you use the relevant IP of the machine, as the hostname in TNS?
GouthamAnandAuthor Commented:
Tried but still getting the same error.
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

HuaMinChenBusiness AnalystCommented:
1. Run lsnrctl in database BIN folder
2. Then run
services your_sid_name
GouthamAnandAuthor Commented:
Done. But still not able to connect.
HuaMinChenBusiness AnalystCommented:
what do you get by the current check?
GouthamAnandAuthor Commented:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myIpconfig)(PORT=1521))(C
Services Summary...
Service "myservicename" has 1 instance(s).
  Instance "myservicename", status UNKNOWN, has 1 handler(s) for this service...
      "DEDICATED" established:0 refused:0
The command completed successfully
HuaMinChenBusiness AnalystCommented:
Can you show me the details of your Listener.ora file?
GouthamAnandAuthor Commented:
Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.