OraFAQ Forum: Networking and Gateways » ORA-12560: TNS:protocol adapter error occurred

Home » RDBMS Server » Networking and Gateways » ORA-12560: TNS:protocol adapter error occurred

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

ORA-12560: TNS:protocol adapter error occurred [message #157900]

Tue, 07 February 2006 01:47

matrik02
Messages: 64
Registered: November 2005

Member

Why i can connect successful by type this command connect sys/change_on_install as sysdba on the server side but on client side i got this error message ORA-12560: TNS:protocol adapter when i type the same command.Why i got this error .For your information,i can success connect scott/tiger@psm2006 on client side as usual.

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error occurred [message #157920 is a reply to message #157900]

Tue, 07 February 2006 04:06

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

What was the command that you ran???

What if you try something like this from the client side.

 connect sys/change_on_install@psm2006 as sysdba

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error occurred [message #158010 is a reply to message #157920]

Wed, 08 February 2006 00:13

matrik02
Messages: 64
Registered: November 2005

Member

I try use this command sys/change_on_install as sysdba on server side and it can connect.Then i test this command sys/change_on_install as sysdba on client side and then got the error "Re: ORA-12560: TNS:protocol adapter error occurred".But if i connect scott account on client side it can connect connect scott/tiger@psm2006 .why it happend?how to solve it?

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error occurred [message #158026 is a reply to message #158010]

Wed, 08 February 2006 01:51

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

You need a service (tnsnames) i.e. psm2006to connect from client side and you are providing the service name when trying through "scott" but no service name when connecting as "sys".

try the following from the client side.

connect sys/change_on_install@psm2006 as sysdba

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error occurred [message #158035 is a reply to message #158026]

Wed, 08 February 2006 02:52

mb.sharma
Messages: 1
Registered: March 2005
Location: Pune

Junior Member

on command line...

set oracle_sid=sidname
connect sys/sys@___ as sysdba

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error occurred [message #158042 is a reply to message #158035]

Wed, 08 February 2006 03:56

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

mb.sharma wrote on Wed, 08 February 2006 14:22

on command line...

set oracle_sid=sidname

there is no reason for setting ORACLE_SID on client side.

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error occurred [message #158059 is a reply to message #158010]

Wed, 08 February 2006 05:17

orausern
Messages: 826
Registered: December 2005

Senior Member

See

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:670117794561

for similar question and Tom Kyte's suggestions.

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error occurred [message #160413 is a reply to message #158059]

Sat, 25 February 2006 05:32

matrik02
Messages: 64
Registered: November 2005

Member

it work nowk..Thanks you so much for helping me.

Report message to a moderator

Previous Topic:	How to connect to a remote oracle server
Next Topic:	Login with Cellphone

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 02 15:10:02 CDT 2026