Set the ORACLE_SID variable

A system identifier (SID) identifies each Oracle database instance for internal connectivity on the Oracle server itself. (Connectivity from Oracle Clients to the server is controlled by the TNS names system configured later.) The environment variable for the system identifier is ORACLE_SID.

About this task

Decide on an SID to use for your Tivoli® Netcool® Performance Manager database instance. The assumed default for the Tivoli Netcool Performance Manager installation is PV. IBM recommends using this default SID unless your site has established Oracle SID naming conventions.

To set the ORACLE_SID environment variable:

1. Log in as oracle.
2. Open the .profile file with a text editor.
3. Add the following line anywhere between the Begin and End Oracle Settings comment lines:

     ORACLE_SID=PV; export ORACLE_SID

   For example:

    # -- Begin Oracle Settings --
    umask 022
    ORACLE_BASE=/opt/oracle
    ORACLE_HOME=/opt/oracle/product/12.1.0
    ORACLE_SID=PV; export ORACLE_SID
    NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
    ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
    LD_LIBRARY_PATH=$ORACLE_HOME/lib
    TNS_ADMIN=$ORACLE_HOME/network/admin
    PATH=$PATH:$ORACLE_HOME/bin:/usr/ccs/bin:/usr/delphi/bin
    EXTPROC_DLLS=ONLY:${LD_LIBRARY_PATH}/libpvmextc.so
    export PATH ORACLE_BASE ORACLE_HOME NLS_LANG
    export ORA_NLS33 LD_LIBRARY_PATH TNS_ADMIN
    export EXTPROC_DLLS
    # -- End Oracle Settings --
    

4. Save and exit the .profile file.
5. Enter the following shell command to activate the change to your profile:

    $ . ./.profile 
    

6. Make sure the variable was set by entering the following command:

    $ env | grep ORACLE_SID