Versions Compared

Key

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

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

tiptip
Rw ui textbox macro
type
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)
     )
  )    
Rw ui textbox macro
type
Info

Example - tnsnames.ora configuration

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

...