Appendix A - Oracle Home Settings

Below are examples of configurations in listener.ora and tnsnames.ora.

Example - Oracle Listener Configuration File

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
       (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)
                     (HOST = example_hostname)
                     (PORT = 1521)
          )
       )
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
     (SID_DESC =
        (GLOBAL_DBNAME = mz)
        (ORACLE_HOME = /opt/oracle/product/12.2.1.0)
        (SID_NAME = MZ)
     )
  )

Example - tnsnames.ora Configuration

MZ =
  (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)
                  (HOST = example_hostname)
                  (PORT = 1521)
       )
     )
     (CONNECT_DATA =
       (SERVICE_NAME = mz)
     )
  )