OraFAQ Forum: Networking and Gateways » TNS:protocol adapter error

Home » RDBMS Server » Networking and Gateways » TNS:protocol adapter error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS:protocol adapter error [message #166832]

Sun, 09 April 2006 22:35

gajini
Messages: 262
Registered: January 2006

Senior Member

Hi,

While I'm trying to connect to my database named "NEWDB' through SQLPLUSW,it says the following error,

SQL> connect sys/welcome123 as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

But when i try to connect with SQLPLUS,it get connected.

1) What is the eror here?

2) Why it's not getting connected with SQLPLUSW,but gets connected with SQLPLUS?

Please anyone answer for these questions to clear my doubt.

Report message to a moderator

ora-12154 Error [message #169344 is a reply to message #166832]

Wed, 26 April 2006 06:13

mathewcos
Messages: 3
Registered: April 2006
Location: Kerala

Junior Member

Friends,

I am getting ora-12154 error when connecting from client mechine(Windows 2000 professional) to DB server(Windows XP mechine).

I am trying to connect like this from client machine

C:> sqlplus u2/u2@tomat

Then error is comming

======================
I can able to connect from Server like this
C:> sqlplus u2/u2@tomat
=========================

My listener configuration

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = d-166)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = MAT)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = mat)
)
)

My Service name conf in tnsnames.ora in client side

TOMAT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = D-166)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MAT)
)
)

What will be the problem? Plz help me

regards
Mathew

Report message to a moderator