1 2 Previous Next 16 Replies Latest reply: Dec 7, 2011 11:44 PM by sb92075 RSS

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

    jim
      Helllo ! I have just performed a new oracle 11g installation on a Windows pc. However I get error ORA-12514 when attempting to connect to the database using sql plus or even when doing a connection test with oracle net manager.

      Below are the contents of my files:

      Listner.ora
      # listener.ora Network Configuration File: C:\app\dfernandes\product\11.2.0\dbhome_1\network\admin\listener.ora
      # Generated by Oracle configuration tools.

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\dfernandes\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\dfernandes\product\11.2.0\dbhome_1\bin\oraclr11.dll")
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )
      )

      ADR_BASE_LISTENER = C:\app\dfernandes


      tnsnames.ora
      # tnsnames.ora Network Configuration File: C:\app\dfernandes\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.

      ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
      (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
      )
      )

      ORCL =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      )
      )


      when I run the command lsnrctl services I just get the below.....
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
      Services Summary...
      Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Handler(s):
      "DEDICATED" established:0 refused:0
      LOCAL SERVER
      The command completed successfully

      ......which probably tells me (I'm assuming) that my database is not registered with the listener.

      Can someone please help ? I'm not very familiar with oracle connection issues. Thanks !
        • 1. Re: ORA-12514: TNS:listener does not currently know of service request
          user13328581
          have you seen this thread

          http://edstevensdba.wordpress.com/2011/03/19/ora-12514/
          • 2. Re: ORA-12514: TNS:listener does not currently know of service request
            sb92075
            when I run the command lsnrctl services I just get the below...
            It would have been MUCH more helpful if you had posted the complete results.

            open a Command Window & do EXACTLY as below

            sqlplus
            / as sysdba
            startup
            exit

            COPY commands above & results then PASTE all back here
            • 3. Re: ORA-12514: TNS:listener does not currently know of service request
              Shivananda Rao
              Post the outcome of lsnrctl status.

              Also did you try registering your database with the listener using "alter system register;" ?
              • 4. Re: ORA-12514: TNS:listener does not currently know of service request
                jim
                Hi ! Thanks for your response. Below is the output :

                C:\Users\jim>sqlplus

                SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 8 15:46:17 2011

                Copyright (c) 1982, 2010, Oracle. All rights reserved.

                Enter user-name: / as sysdba

                Connected to:
                Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
                With the Partitioning, OLAP, Data Mining and Real Application Testing options

                SQL> startup
                ORA-01081: cannot start already-running ORACLE - shut it down first
                SQL> exit
                Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Pr
                oduction
                With the Partitioning, OLAP, Data Mining and Real Application Testing options

                C:\Users\jim>
                • 5. Re: ORA-12514: TNS:listener does not currently know of service request
                  sb92075
                  post content of sqlnet.ora file from DB Server system

                  open a Command Window & do EXACTLY as below


                  lsnrctl status
                  lsnrctl service

                  COPY results from above & PASTE all back here
                  • 6. Re: ORA-12514: TNS:listener does not currently know of service request
                    jim
                    Hi srp, below is the result of the lsnrctl status

                    C:\Users\dfernandes>lsnrctl status

                    LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-DEC-2011 15:54
                    :01

                    Copyright (c) 1991, 2010, Oracle. All rights reserved.

                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
                    STATUS of the LISTENER
                    ------------------------
                    Alias LISTENER
                    Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
                    ction
                    Start Date 08-DEC-2011 15:03:32
                    Uptime 0 days 0 hr. 50 min. 29 sec
                    Trace Level off
                    Security ON: Local OS Authentication
                    SNMP OFF
                    Listener Parameter File C:\app\dfernandes\product\11.2.0\dbhome_1\network\admi
                    n\listener.ora
                    Listener Log File c:\app\dfernandes\diag\tnslsnr\sedona\listener\alert\l
                    og.xml
                    Listening Endpoints Summary...
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                    Services Summary...
                    Service "CLRExtProc" has 1 instance(s).
                    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                    The command completed successfully

                    C:\Users\dfernandes>
                    • 7. Re: ORA-12514: TNS:listener does not currently know of service request
                      jim
                      Hi sb,

                      Contents of sqlnet.ora file:

                      # sqlnet.ora Network Configuration File: C:\app\dfernandes\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
                      # Generated by Oracle configuration tools.

                      # This file is actually generated by netca. But if customers choose to
                      # install "Software Only", this file wont exist and without the native
                      # authentication, they will not be able to connect to the database on NT.

                      SQLNET.AUTHENTICATION_SERVICES= (NTS)

                      NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)




                      ----------------------------------------------------------------------------

                      below is the output of
                      lsnrctl status
                      lsnrctl service

                      C:\Users\dfernandes>lsnrctl status

                      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-DEC-2011 15:58
                      :44

                      Copyright (c) 1991, 2010, Oracle. All rights reserved.

                      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
                      STATUS of the LISTENER
                      ------------------------
                      Alias LISTENER
                      Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
                      ction
                      Start Date 08-DEC-2011 15:03:32
                      Uptime 0 days 0 hr. 55 min. 12 sec
                      Trace Level off
                      Security ON: Local OS Authentication
                      SNMP OFF
                      Listener Parameter File C:\app\dfernandes\product\11.2.0\dbhome_1\network\admi
                      n\listener.ora
                      Listener Log File c:\app\dfernandes\diag\tnslsnr\sedona\listener\alert\l
                      og.xml
                      Listening Endpoints Summary...
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                      Services Summary...
                      Service "CLRExtProc" has 1 instance(s).
                      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                      The command completed successfully

                      C:\Users\dfernandes>lsnrctl service

                      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-DEC-2011 15:58
                      :54

                      Copyright (c) 1991, 2010, Oracle. All rights reserved.

                      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
                      Services Summary...
                      Service "CLRExtProc" has 1 instance(s).
                      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                      Handler(s):
                      "DEDICATED" established:0 refused:0
                      LOCAL SERVER
                      The command completed successfully

                      C:\Users\dfernandes>
                      • 8. Re: ORA-12514: TNS:listener does not currently know of service request
                        sb92075
                        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                        above means that no remote client can ever connect any DB on this system


                        post last 100 - 150 lines from file below
                        c:\app\dfernandes\diag\tnslsnr\sedona\listener\alert\log.xml
                        • 9. Re: ORA-12514: TNS:listener does not currently know of service request
                          jim
                          Hi! Below is the contents of file c:\app\dfernandes\diag\tnslsnr\sedona\listener\alert\log.xml

                          <msg time='2011-12-08T16:02:51.581+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:02:52.783+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>Listener completed notification to CRS on start
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:02:52.783+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>
                          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:03:48.335+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>08-DEC-2011 16:03:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dfernandes))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * services * 0
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:03:51.096+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>08-DEC-2011 16:03:51 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dfernandes))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:05:13.888+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>System parameter file is C:\app\dfernandes\product\11.2.0\dbhome_1\network\admin\listener.ora
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:05:13.904+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>Log messages written to c:\app\dfernandes\diag\tnslsnr\sedona\listener\alert\log.xml
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:05:13.904+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>Trace information written to c:\app\dfernandes\diag\tnslsnr\sedona\listener\trace\ora_4512_4516.trc
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:05:13.920+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>Trace level is currently 0
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:05:13.920+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:05:13.935+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>Started with pid=4512
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:05:13.935+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:05:13.951+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:05:15.199+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>Listener completed notification to CRS on start
                          </txt>
                          </msg>
                          <msg time='2011-12-08T16:05:15.199+11:00' org_id='oracle' comp_id='tnslsnr'
                          type='UNKNOWN' level='16' host_id='SEDONA'
                          host_addr='fe80::e487:38ca:d34a:79c4%10'>
                          <txt>
                          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                          </txt>
                          </msg>
                          • 10. Re: ORA-12514: TNS:listener does not currently know of service request
                            sb92075
                            user6464686 wrote:
                            Hi! Below is the contents of file c:\app\dfernandes\diag\tnslsnr\sedona\listener\alert\log.xml
                            every connect request that the listener gets is logged to file above.
                            which should have included the posted ORA-12514 error in the title.

                            You need to force the error again & the post tailend from log.xml that contains "12514" status code
                            • 11. Re: ORA-12514: TNS:listener does not currently know of service request
                              jim
                              Hi sb,

                              done. below is the tail end of the file.....

                              <msg time='2011-12-08T16:24:01.936+11:00' org_id='oracle' comp_id='tnslsnr'
                              type='UNKNOWN' level='16' host_id='SEDONA'
                              host_addr='fe80::e487:38ca:d34a:79c4%10'>
                              <txt>08-DEC-2011 16:24:01 * (CONNECT_DATA=(SERVICE_NAME=orcl)(SERVER=DEDICATED)(CID=(PROGRAM=C:\app\dfernandes\product\11.2.0\dbhome_1\jdk\jre\bin\java.exe)(HOST=SEDONA)(USER=dfernandes))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50157)) * establish * orcl * 12514
                              </txt>
                              </msg>
                              <msg time='2011-12-08T16:24:01.952+11:00' org_id='oracle' comp_id='tnslsnr'
                              type='UNKNOWN' level='16' host_id='SEDONA'
                              host_addr='fe80::e487:38ca:d34a:79c4%10'>
                              <txt>TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                              </txt>
                              </msg>
                              • 12. Re: ORA-12514: TNS:listener does not currently know of service request
                                sb92075
                                open Command Window & do as below

                                sqlplus
                                / as sysdba
                                select instance_name from v$instance;
                                exit

                                COPY all from above then PASTE back here
                                • 13. Re: ORA-12514: TNS:listener does not currently know of service request
                                  jim
                                  Hello sb...below is the output.....

                                  C:\Users\dfernandes>sqlplus

                                  SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 8 16:36:51 2011

                                  Copyright (c) 1982, 2010, Oracle. All rights reserved.

                                  Enter user-name: / as sysdba

                                  Connected to:
                                  Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
                                  With the Partitioning, OLAP, Data Mining and Real Application Testing options

                                  SQL> select instance_name from v$instance;

                                  INSTANCE_NAME
                                  ----------------
                                  orcl

                                  SQL> exit
                                  Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Pr
                                  oduction
                                  With the Partitioning, OLAP, Data Mining and Real Application Testing options

                                  C:\Users\dfernandes>
                                  • 14. Re: ORA-12514: TNS:listener does not currently know of service request
                                    jim
                                    just wanted to mention also that I have a loopback adapter enabled. While doing the oracle install I ensured that all other network connections (wired and wireless) were disabled except for the loopback adapter. The loopbck adaptor has a static IP 192.168.2.5 which is present in my hosts file
                                    1 2 Previous Next