Hello All,
We have a single server. Oracle applications & oracle DB are installed in the same machine under 2 different users.
tnsnames.ora in application has the entry "host=machine_name"
tnsnames.ora & listener.ora in DB has the entry "host=ipaddress"
I tested sql connections from applications as below
sqlplus apps/***@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip)(PORT=****))(CONNECT_DATA=(SID=****)))' ...Working
sqlplus apps/***@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=machine name )(PORT=***))(CONNECT_DATA=(SID=****)))' ...erroring out saying
ERROR:
ORA-12224: TNS:no listener
======================================================================================================================
I Changed listener.ora in DB replacing host=machinename and again tested above 2 statements from application. Both worked.
I am not sure why ip addresses are there is tnsnames & listener as i am new to the env