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
(ADDRESS = (PROTOCOL = TCP)(HOST = OraSrv1)(PORT = 1521))
(SERVICE_NAME = orcl)
My listner.ora in client
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_g)
(SID_NAME = ORCL)
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclient)(PORT = 1521))
Any help in resolving this issue will be greatly appreciated. Thank you in advance.