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 126.96.36.199.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) ) )
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 )