Oracle Specific Environment Variables
These environment variables only apply when using an Oracle database. The variables below are set on the machine where Oracle is installed.
| Variable | Description |
|---|---|
ORACLE_HOME | Example value: This environment variable specifies where Oracle is installed. |
ORACLE_SID | Example value: This environment variable specifies the Oracle SID to be used by Note! The Oracle SID name can not be longer than 8 characters. |
ORACLE_DATA | Example value: /opt/oracle/databases/<data_directory> The directory where the database will be stored. This directory must exist prior to installation. |
Note!
In order for to function properly, the following Oracle file needs configuration:
$ORACLE_HOME/network/admin/listener.ora
See below for examples.
Listener and Tnsnames Example
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)
)
)
0 Comments