Integrating Oracle and Data Protector

Troubleshooting

4.Verify that the Oracle target database and the recovery catalog database are configured to allow remote connections with system privileges:

Set the <ORACLE_HOME> directory.

Start SQL*Plus from the <ORACLE_HOME> directory: bin\sqlplus /nolog

Start SQL*Plus and type:

connect <Target_Database_Login> as SYSDBA exit

Connect to the recovery catalog:

bin\sqlplus connect <Recovery_Catalog_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 init<DB_NAME>.ora file.

5.If you use the recovery catalog database, verify that the target database is registered in the recovery catalog:

bin\sqlplus

Start SQL*Plus and type:

connect <Recovery_Catalog_Login>; select * from rc_database;

exit

If this fails, start the configuration using Data Protector or see the Oracle documentation for details about how to register an Oracle target database in the recovery catalog database.

Chapter 1

123