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!

cannot connect to database after change of server ip

793965Feb 28 2012 — edited Mar 1 2012

hi gems..

the ip of our database server has got changed.
Windows server, 11gr2 database version, archivelog mode.

i have changed the tnsnames.ora and the listener.ora manually with the new ip.

I am able to connect to sqlplus "/as sysdba" (since authentiacetion services is NTS)
But i am not able to connect to 'sqlplus sys/password@sid as sysdba'

it is throwing the error of
ERROR:
ORA-12560: TNS:protocol adapter error

pls help...

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2012

Added on Feb 28 2012

#general-database-discussions

34 comments

2,934 views