HP Application Recovery Manager software Integration guide (March 2008)

UNIX:

Export the ORACLE_HOME and DB_NAME variables as follows:

• if you are using an sh - like shell, enter the following commands:

ORACLE_HOME="ORACLE_HOME"

export ORACLE_HOME

DB_NAME="DB_NAME"

export DB_NAME

• if you are using a csh - like shell, enter the following commands:

setenv ORACLE_HOME "ORACLE_HOME"

setenv DB_NAME "DB_NAME"

Windows:

Set the ORACLE_HOME and DB_NAME variables.

2. Start SQL*Plus from the bin directory in the ORACLE_HOME directory:

sqlplus /nolog

3. Start SQL*Plus and type:

connect user_name/password@service as sysdba;

select * from dba_tablespaces;

exit

If this fails, open the Oracle target database.

• From the application system, verify that the Oracle target database is configured

to allow remote connections with the system privileges:

1. Export or set the ORACLE_HOME and DB_NAME variables as described in

Step 1 on page 135.

2. Start SQL*Plus from the bin directory in the ORACLE_HOME directory:

sqlplus /nolog

3. Start SQL*Plus and type:

connect Target_Database_Login as SYSDBA

exit

Repeat the procedure using SYSOPER instead of SYSDBA.

If this fails, see the Oracle documentation for instructions about how to set up the

password file and any relevant parameters in the initDB_NAME.ora file.

Additionally, if your configuration or backup failed:

Integration guide 135