10 Replies Latest reply on Sep 10, 2013 12:49 PM by EdStevens

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

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

      Hi All, I am searching for solution in google from past 3 days, could you please help.

       

      I have installed Oracle11g on windows2008, on launching sqlplus developer - am getting an error : no more data to read from socket.

       

      so, thought of trying from command promt, i am getting below 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)     )   )

       

      C:\Users\garalapa>lsnrctl status

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

      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 10-SEP-2013 03:51 :37 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                10-SEP-2013 03:26:57 Uptime                    0 days 0 hr. 24 min. 40 sec Trace Level              off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File  E:\Oracle\product\11.2.0\dbhome_1\network\admin\listen er.ora Listener Log File        e:\oracle\diag\tnslsnr\C0006411\listener\alert\log.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 3 handler(s) for this service... Service "orcl.Extranet.hp.com" has 1 instance(s).   Instance "orcl", status BLOCKED, has 1 handler(s) for this service... The command completed successfully

       

      C:\Users\garalapa>C:\Users\garalapa>lsnrctl service

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

      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 10-SEP-2013 03:52 :16 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 3 handler(s) for this service...     Handler(s):       "DEDICATED" established:0 refused:0         LOCAL SERVER       "ORACLE SERVER" established:0 refused:0 current:0 max:25 state:ready         CLRExtProc         (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_768_1A30D8CB.ORA))       "ORACLE SERVER" established:0 refused:0 current:0 max:25 state:ready         CLRExtProc         (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_768_1A30D8CB.ORA)) Service "orcl.Extranet.hp.com" has 1 instance(s).   Instance "orcl", status BLOCKED, has 1 handler(s) for this service...     Handler(s):       "DEDICATED" established:0 refused:0 state:ready         LOCAL SERVER The command completed successfully

       

      Thanks, Ravi