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

Restircted session due to sync filed with ora-65177

Application is unable to connect the database due to restricted session. sql> show pdbs; SQL> show con_name CON_NAME -----------------...

  • user permissions script for each of the databases
      Use the following script for this purpose for each database.  REF :This script is also present in the link https://www.sqlservercentral.co...
  • listener service register
    alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = demo.localdomain)(PORT = 1531))'; alter system set local_listene...
  • user ddl
    set head off REM set long 150 set linesize 150 set longchunksize 150 set pages 0 set long 99999999 set feedback off set echo off ...