Sunday, 11 November 2018

ORA-12505: TNS:listener does not currently know of SID given in connect



Either the SID is misspelled in the tnsnames, or the listener isn't listening for it. Check the tnsnames.ora first. If it looks ok, do a 'lsnrctl status' on your server, to see what databases the listener is listening for.
-
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Featured post

duplicate db from standy to other server

 Duplicate Testuat   $ export ORACLE_SID=Testuat3 $ sqlplus '/as sysdba' Testuat3 SQL> alter system set cluster_database=FALSE sc...