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>; select * from dba_tablespaces; exit

If this fails, open the Oracle target database.

2.Verify that you can access the recovery catalog (if used) as follows:

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

Start SQL*Plus and type:

connect <Recovery_Catalog_Login> select * from rcver;

exit

If this fails, open the recovery catalog.

3.Verify that the TNS listener is correctly configured for the Oracle target database and for the recovery catalog database. This is required for properly establishing network connections:

Export <ORACLE_HOME> as described on page 117. Start the listener from the <ORACLE_HOME> directory: bin/lsnrctl status <service>

exit

If it fails, start up the TNS listener process and see the Oracle documentation for instructions on how to create a TNS configuration file (LISTENER.ORA).

Export <ORACLE_HOME> as described on page 117.

118

Chapter 1