V11 Service Pack 11
Loading...

Prerequisites - Oracle RAC Agent

Before you configure an Oracle RAC client, obtain the following information:

Name

Description

Physical client name

The client name of the Oracle RAC node.

Oracle RAC database name

  1. Log on to the physical client as the Oracle user.
  2. Set the ORACLE_SID environment variable:

    UNIX

    export ORACLE_SID=<ORACLE SID>

    export ORACLE_SID=<ORACLE SID>

    Windows

    set ORACLE_SID=<ORACLE SID>

  3. Verify the Oracle RAC database name.

    To see all Oracle RAC instances for the Oracle RAC configuration, run the following query :

    select instance_name, host_name from gv$instance;

    To see one Oracle RAC instance for the Oracle RAC configuration, run the following query :

    select instance_name from v$instance;

Oracle user name (ORACLE_USER)

This is the Operating System (OS) user name for the Oracle application. The user has complete administrative privileges (read and write permissions) on the Oracle database files and can perform database backups.

On UNIX, the user must be part of the user group used when you installed the Oracle Agent

Instance name (ORACLE_SID)

Name of the ORACLE instance running on each node.

To verify the instance is correct and belongs to the Oracle RAC database, do the following:

  1. Log on to the physical client as the Oracle user.
  2. Set the ORACLE_SID environment variable.

    On UNIX:

    export ORACLE_SID=<ORACLE SID>

    On Windows:

    set ORACLE_SID=<ORACLE SID>

  3. Verify the RAC database name

    v$instance

Connect string user name and password

This is the Oracle database user name. Provide the user name and password of the database user that has sysdba privileges.

Connect string name

The Connect string name is used to connect to each RAC database node.

The following rules apply to the Connect string name:

  • The Connect string cannot contain a "/" (slash) because the backup streams are distributed across all the configured Oracle RAC nodes.
  • The Connect string must connect to a dedicated client/instance from any of the RAC nodes.
  • The Connect string must connect to the database in started (NOMOUNT) mode when you perform a restore.

    This is needed to make sure database backups and restores are load balanced and work according to the stream reservation (per node basis).

    The Connect string can be a TNS alias name configured in the tnsnames.ora (located in $ORACLE_HOME/network/admin or the $TNS_ADMIN folder).

    For example:

    RACDB1 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = lx64rac1)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)(SERVICE_NAME = racdb)
    (INSTANCE_NAME = racdb1)(UR=A)
    )
    )

    where, RACDB1 is the instance name and racdb is the RAC database name.

TNS_ADMIN folder

This is an environment variable parameter that points to the directory where the SQL*Net configuration files for example, sqlnet.ora and tnsnames.ora) are located. This parameter is optional and only needs to be set when the SQL*Net configuration are present in a non-default location. If this is not set the configuration files are obtained from $ORACLE_HOME/network/admin directory.

ORACLE_HOME

The Oracle application install path in the Oracle RAC node.

SCAN connect

If you use SCAN connect to invole RMAN, then the <ProfictName> software must be installed on the same path on all Oracle RAC nodes.

Last modified: 2/27/2018 12:27:40 AM