Oracle As A Platform DB Settings(3.3)

Owned by Jenni Wallin
Oct 02, 2023
2 min read

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