[SOLVED] Oracle 11g based on CentOS listener issue

anwar-it0 · 05-26-2013, 01:29 AM

Good day,
I installed Oracle 11g R2 on CentOS 6.4 it’s successfully and run it .. it worked locally with no problems
But when I tried to connect it using LAN I failed
and error ORA-12504 was the result
there is no IPTables or SELinux issue because I stop it
the server is pingable from PC
I’m trying to connect using this command :
Sqlplus system/password@hostname AS SYSDBA
Result is :
"ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"
Any suggestions ..
Regards

anwar-it0 · 05-26-2013, 02:02 AM

BTW ..
i tried "tnsping hostname"
the result was
OK (0 msec) and it's normal result
means the listener is working

TB0ne · 05-27-2013, 10:11 AM

Quote:

Originally Posted by anwar-it0

Good day,
I installed Oracle 11g R2 on CentOS 6.4 it’s successfully and run it .. it worked locally with no problems But when I tried to connect it using LAN I failed
and error ORA-12504 was the result there is no IPTables or SELinux issue because I stop it the server is pingable from PC I’m trying to connect using this command:
Sqlplus system/password@hostname AS SYSDBA

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

Did you try to look up the error on the Oracle knowledegbase, and (since Oracle is NOT a free product, and you're paying for it, right??), contacted Oracle support???

https://forums.oracle.com/forums/thr...40573&tstart=0
http://www.dbasupport.com/forums/sho...n-CONNECT_DATA

hyperdaz · 05-27-2013, 10:53 AM

http://www.dbforums.com/oracle/16768...nect_data.html

I had the same issue quite some time ago... My issue I believe was a mismatch in tnsnames.ora between placing the IP and the servers hostname...

Code:

		# tnsnames.ora Network Configuration File: /opt/oracle11g/product/11.2.0/db1//network/admin/tnsnames.ora
		# Generated by Oracle configuration tools.
		
		XXXXX =
		  (DESCRIPTION =
		    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname )(PORT = xxxx))
		    (CONNECT_DATA =
		    )
		      (SERVER = DEDICATED)
		      (SID_NAME = xxxxx)
		    )
		  )
		
		LISTENER_XXXXX =
		    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname )(PORT = xxxx))

Don't know if this is your issue, I would double and triple check the tnsnames.ora and listen.ora