Versions Compared

Old Version 1

changes.mady.by.user Kevin Wu

Saved on

compared with

New Version Current

changes.mady.by.user Kevin Wu

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Info

...

Example - Oracle Listener Configuration

...

FIle

Code Block

...

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)
     )
  )
Info

...

Example - tnsnames.ora configuration

Code Block

...

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