This discussion is archived
2 Replies Latest reply: Sep 10, 2013 5:50 AM by EdStevens RSS

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

69edbc16-b177-422e-9b7c-ad6328cd17a4 Newbie
Currently Being Moderated

Hi All, I tried all the options available in google to solve this issue, but none of them seems to be working, could you please help me with this error:

C:\Users\garalapa>sqlplus scott/tiger@localhost SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 10 03:37:24 2013 Copyright (c) 1982, 2010, Oracle.  All rights reserved. ERROR: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

listener.ora --------------- # listener.ora Network Configuration File: E:\Oracle\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 = E:\Oracle\product\11.2.0\dbhome_1)       (PROGRAM = extproc)       (ENVS = "EXTPROC_DLLS=ONLY:E:\Oracle\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 = E:\Oracle

sqlnet.ora ------------- # sqlnet.ora Network Configuration File: E:\Oracle\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= (NONE) # NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

tnsnames.ora ------------- # tnsnames.ora Network Configuration File: E:\Oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. LISTENER_ORCL =   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) 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.Extranet.hp.com)     )   )

Thanks Ravi

  • 1. Re: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
    EdStevens Guru
    Currently Being Moderated

    69edbc16-b177-422e-9b7c-ad6328cd17a4 wrote:

     

    Hi All, I tried all the options available in google to solve this issue, but none of them seems to be working, could you please help me with this error:

    C:\Users\garalapa>sqlplus scott/tiger@localhost SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 10 03:37:24 2013 Copyright (c) 1982, 2010, Oracle.  All rights reserved. ERROR: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

    listener.ora --------------- # listener.ora Network Configuration File: E:\Oracle\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 = E:\Oracle\product\11.2.0\dbhome_1)       (PROGRAM = extproc)       (ENVS = "EXTPROC_DLLS=ONLY:E:\Oracle\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 = E:\Oracle

    sqlnet.ora ------------- # sqlnet.ora Network Configuration File: E:\Oracle\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= (NONE) # NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

    tnsnames.ora ------------- # tnsnames.ora Network Configuration File: E:\Oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. LISTENER_ORCL =   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) 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.Extranet.hp.com)     )   )

    Thanks Ravi

     

    Can you really read that?

    Neither can we.  I know the editor for this forum has some issues with formatting, but they aren't that bad.

     

    Show us the output of 'lsnrctl status'.  And be sure to keep it reasonably formatted.

     

    Your use of "@localhost" in the connect string is very suspicious.  I doubt you have an entry in your tnsnames.ora for 'localhost'.  These might help your understanding of how the pieces fit together:

     

    see: http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/  (Help! I can’t connect to my database  )

    see: http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/  ( Help! I can’t connect to my database (part duex) )

    see: http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/ (ora-12154 TNS:could not resolve the connect identifier specified)

    see: http://edstevensdba.wordpress.com/2011/02/27/tnsping-101/  (tnsping-101 )

    see: http://edstevensdba.wordpress.com/2011/03/19/ora-12514/  (ora-12514  Listener does not know of requested service )