/
Oracle As A Platform DB Settings(4.0)

Oracle As A Platform DB Settings(4.0)

Dec 20, 2023

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.

VariableDescription

ORACLE_HOME

Example value: /opt/oracle/product/12

This environment variable specifies where Oracle is installed.

ORACLE_SID

Example value: MZ

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)
     )
  )