OraFAQ Forum: Networking and Gateways » ora -12560 tns adaptor error

Home » RDBMS Server » Networking and Gateways » ora -12560 tns adaptor error

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

ora -12560 tns adaptor error [message #66729]

Thu, 21 November 2002 13:20

Shah
Messages: 36
Registered: June 2002

Member

Hi
I have an oracle 8.1.7 server on windows 2000 server. I created a database and it works fine. I tried to create another database on the same machine and I keep getting ORA-12560. I have tried the listener.ora file. I have stopped and started the listener. I am relatively new to oracle. Any suggestions on how can get rid of this error.
TIA
shah

Report message to a moderator

Re: ora -12560 tns adaptor error [message #66732 is a reply to message #66729]

Fri, 22 November 2002 07:17

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1. add the second database to listener.
2. reload the listener.
3. restart the listener.
4. add entries in your tnsnames.ora, so that you can
   access the both the databases  like
   connect user1 / password@database1
   connect userx / pass@database2

Report message to a moderator

Re: ora -12560 tns adaptor error [message #66803 is a reply to message #66729]

Sun, 19 January 2003 21:24

Tim Stimson
Messages: 1
Registered: January 2003

Junior Member

I was running windows 2000K server and terminal serving to the box, I got the exact error you described. I cancelled the database creation after 3 or so attempts. I then went to the Box itself and did the exact same operation. It worked perfectly. This was a very clean test box and I was logged in as administrator in both cases. If your using terminal server you may wish to stop and try creating the database directly from the server console instead.

Report message to a moderator

Re: ora -12560 tns adaptor error [message #66813 is a reply to message #66803]

Tue, 21 January 2003 15:06

Hemal Dalia
Messages: 1
Registered: January 2003

Junior Member

Check your sqlnet.ora for this parameter
"names.preferred_servers" which may point to any where else.

Report message to a moderator

ora9i ora -12560 tns adaptor error [message #67012 is a reply to message #66732]

Sun, 01 June 2003 06:51

Burak Karaoglu
Messages: 1
Registered: June 2003

Junior Member

Hi all,

I use oracle 9i .I have a problem when I creating database. I installed 9i but when I tring to create database I see this error messages. 12560 tns adaptor error. I think my listener doesnt work properly.When I examine trac ,there was some socket error.as a result I couldnt create database.I tried xp,2000 and 2003. but didnt.

Report message to a moderator

Previous Topic:	Oracle 8.0.5 on RH 6.2 , Multiple instances problem
Next Topic:	master_peer encapsulor start failure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 08 03:19:59 CST 2025