Oracle As A Platform DB Settings(3.0)
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) ) )