Oracle 11g based on CentOS listener issue

view full story

http://www.linuxquestions.org – 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 (HowTos)