Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to Login to Idle Instance from SQL*Plus in windows

658523Sep 24 2010 — edited Sep 24 2010

Hello,
I'm cloning the db from windows to windows enviornment. At auxilary instance after configuring the Listener and making Password file to right folder when I try to connect to Idle Instance through sql*plus by follwring connad

c:\sqlplus sys/password as sysdba

It gives me ORA-12518 Tns: Listener could not hand off client conenction error
Then I put the follwing parameter in listener.ora DIRECT_HANDOFF_TTC_LISTENER=OFF and restart listener and then try to connect it gives me Ora-12560: TNS protocol adapter error.
I try to connect through tnsnames but give me same error.

Kindly tell me how to resolve this issue as its not allowing me to connect to an idle instance so that I can go further.
I'm using 10gR2 on windows server 2003.

Regards,

Abbasi

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2010

Added on Sep 24 2010

#general-database-discussions

12 comments

1,374 views