troubleshooting Question

ORA-12560: TNS: protocol adaptor error

Avatar of ijeevan
ijeevan asked on
Oracle Database
30 Comments1 Solution9594 ViewsLast Modified:
Hi  Am new to Oracle.
Ive installed and configured Oracle 11g Server in Oracle Enterprise Server 5.
Ive started necessary services and I was able to log in to SQL Plus from the server.
Now, Ive installed Oracle client in Windows XP Prof with SP2.
Ive configured tnsnames.ora and listener.ora.
I can connect to database in the server using SQL Developer. But when I am trying to connect via SQL PLUS and am getting

ORA-12560: TNS: protocol adaptor error

I can make a tnsping to the server from client.

My tnsnames.ora in client

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = OraSrv1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

My listner.ora in client


SID_LIST_ORCL =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_g)
      (SID_NAME = ORCL)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oraclient)(PORT = 1521))
  )


Any help in resolving this issue will be greatly appreciated. Thank you in advance.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 30 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 30 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros