root@erpnode1 PROD_erpnode1]# cat tnsnames.ora 
#
# $Header: ad8itns.ora 120.0.12020000.2 2014/04/11 17:03:33 srveerar ship $
#
# ###############################################################
# 
# Do not edit settings in this file manually. They are managed
# automatically and will be overwritten when AutoConfig runs.
# For more information about AutoConfig, refer to the Oracle
# E-Business Suite Setup Guide.
# 
# ###############################################################

#

#
# Net8 definition for the database
#

PROD = (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=erpnode1)(PORT=1521))
                (CONNECT_DATA= (SERVICE_NAME=PROD)
                         (INSTANCE_NAME=PROD))
            )

PROD_LOCAL =
            (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=erpnode1)(PORT=1521))
            )

PROD_REMOTE =
            (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=erpnode1)(PORT=1521))
            ) 

#
# Intermedia
#
extproc_connection_data =
          (DESCRIPTION=
              (ADDRESS_LIST =
                  (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
              )
              (CONNECT_DATA=
                  (SID=PLSExtProc)
                  (PRESENTATION = RO)
              ) )

IFILE=/u01/oracle/PROD/12.1.0/network/admin/PROD_erpnode1/PROD_erpnode1_ifile.ora


[root@erpnode1 PROD_erpnode1]#