1 2 Previous Next 19 Replies Latest reply on Jun 25, 2007 6:25 PM by Madrid

    ORA-12514: TNS:listener does not currently know of service requested

    DBA2011
      Sometime listener behaviour is strange, wondering why?

      SQL> connect sys/test@testdb as sysdba;
      ERROR:
      ORA-12514: TNS:listener does not currently know of service requested in connect
      descriptor

      SQL> connect sys/test@testdb as sysdba;
      Connected.

      listener.ora
      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = OracleLab)(PORT = 1521))
      )
      )

      SID_LIST_listener_name=
      (SID_LIST=
      (SID_DESC=
      (GLOBAL_DBNAME=TESTDB)
      (SID_NAME=TESTDB)
      (ORACLE_HOME=D:\oracle\Product\db)))


      (SID_LIST=
      (SID_DESC=
      (GLOBAL_DBNAME=TESTDB1)
      (SID_NAME=TESTDB1)
      (ORACLE_HOME=D:\oracle\Product\db)))

      (SID_LIST=
      (SID_DESC=
      (GLOBAL_DBNAME=DEV)
      (SID_NAME=DEV)
      (ORACLE_HOME=D:\oracle\Product\db9i)))
        1 2 Previous Next