Oracle As A Platform DB Settings (2.2)
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 Usage Engine. 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 Usage Engine 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) ) )