This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Dec 7, 2011 9:44 PM by sb92075 RSS

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

jim Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    (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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points