Integrating Oracle and Data Protector

Troubleshooting

Start SQL*Plus from the <ORACLE_HOME> directory:

bin/sqlplus /nolog

Start SQL*Plus and type:

connect <Target_Database_Login>

exit

and then

connect <Recovery_Catalog_Login>

exit

If this fails, see the Oracle documentation for instructions on how to create a TNS configuration file (TNSNAMES.ORA).

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

Export <ORACLE_HOME > as described on page 117. Start SQL*Plus from the <ORACLE_HOME> directory: bin/sqlplus /nolog

Start SQL*Plus and type:

connect <Target_Database_Login> as SYSDBA exit

and

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:

Export <ORACLE_HOME> as described on page 117 and start SQL*Plus: bin/sqlplus /nolog

Chapter 1

119