Below are examples of configurations in listener.ora and tnsnames.ora
| Rw ui textbox macro |
|---|
type | tip| 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 | tip
| Info |
|---|
Example - tnsnames.ora configuration | Code Block |
|---|
MZ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)
(HOST = example_hostname)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = mz)
)
) |
|
...
