14 Replies Latest reply: Nov 19, 2012 5:01 AM by Harsh_v RSS

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

    Harsh_v
      Hi experts,


      I am facing problem "ORA-12514" error. my database is register in listener but when i connected throw "sqlplus" then i got "ORA-12514" error.
      As show below


      [oracle@sun3 ~]$ lsnrctl status
      
      LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 19-NOV-2012 14:40:15
      
      Copyright (c) 1991, 2005, Oracle.  All rights reserved.
      
      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
      STATUS of the LISTENER
      ------------------------
      Alias                     listener1
      Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
      Start Date                19-NOV-2012 13:57:59
      Uptime                    0 days 0 hr. 42 min. 15 sec
      Trace Level               off
      Security                  ON: Local OS Authentication
      SNMP                      OFF
      Listener Parameter File   /u01/app/oracle/product/10.2.0/network/admin/listener.ora
      Listener Log File         /u01/app/oracle/product/10.2.0/network/log/listener1.log
      Listening Endpoints Summary...
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.4)(PORT=1521)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2)))
      Services Summary...
      Service "orcl1.us.oracle.com" has 1 instance(s).
        Instance "orcl1", status READY, has 1 handler(s) for this service...
      Service "orcl1XDB.us.oracle.com" has 1 instance(s).
        Instance "orcl1", status READY, has 1 handler(s) for this service...
      Service "orcl1_XPT.us.oracle.com" has 1 instance(s).
        Instance "orcl1", status READY, has 1 handler(s) for this service...
      The command completed successfully
      [oracle@sun3 ~]$ cat /u01/app/oracle/product/10.2.0/network/admin/listener.ora
      
      SID_LIST_LISTENER =
        (SID_LIST =
          (SID_DESC =
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = /u01/app/oracle/product/10.2.0)
            (PROGRAM = extproc)
          )
        )
      
      LISTENER1 =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
      #      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.4)(PORT = 1521))
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
      
          )
        )
      [oracle@sun3 ~]$ sqlplus "mcarbon/mcarbon@orcl1"
      
      SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 19 14:43:04 2012
      
      Copyright (c) 1982, 2005, Oracle.  All rights reserved.
      
      ERROR:
      ORA-12514: TNS:listener does not currently know of service requested in connect
      descriptor
      
      
      Enter user-name:
      ERROR:
      ORA-01017: invalid username/password; logon denied
      
      
      Enter user-name:
      ERROR:
      ORA-01017: invalid username/password; logon denied
      [oracle@sun3 ~]$ cat /u01/app/oracle/product/10.2.0/network/log/listener1.log
      
      19-NOV-2012 14:00:19 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl1)(CID=(PROGRAM=sqlplus@sun3)(HOST=sun3)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.4)(PORT=53680)) * establish * orcl1 * 12514
      TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
      19-NOV-2012 14:01:02 * ping * 0
      19-NOV-2012 14:08:34 * service_update * orcl1 * 0
      19-NOV-2012 14:18:37 * service_update * orcl1 * 0
      WARNING: Subscription for node down event still pending
      19-NOV-2012 14:23:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=sun3)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
      19-NOV-2012 14:23:59 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl1)(CID=(PROGRAM=sqlplus@sun3)(HOST=sun3)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.4)(PORT=53505)) * establish * orcl1 * 12514
      TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
      19-NOV-2012 14:28:40 * service_update * orcl1 * 0
      19-NOV-2012 14:30:38 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl1)(CID=(PROGRAM=sqlplus@sun3)(HOST=sun3)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.4)(PORT=5290)) * establish * orcl1 * 12514
      TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
      19-NOV-2012 14:38:43 * service_update * orcl1 * 0
      WARNING: Subscription for node down event still pending