Integrating SAP R/3 and Data Protector

Troubleshooting

Start the Server Manager (Oracle8/9i) or SQL Plus (Oracle9i) from the <ORACLE_HOME> directory:

bin\svrmgrl (Oracle8/8i) or

bin\sqlplus (Oracle9i)

At the SVRMGR (Oracle8/8i) or SQL (Oracle9i) prompt, type:

connect <user>/<passwd>@<service>

select * from dba_tablespaces;

exit

If it fails, open the Oracle Target Database.

2.Verify that the TNS listener is correctly configured for the Oracle Target Database. This is required for properly establishing network connections:

Export <ORACLE_HOME> as described on page 225 and start the listener from the <ORACLE_HOME> directory:

bin/lsnrctl start <service> exit

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

Export <ORACLE_HOME> as described on page 225 and start the Server Manager (Oracle8/8i) or SQL Plus (Oracle9i) from the

<ORACLE_HOME> directory: bin/svrmgrl (Oracle8/8i) bin/svrmgrl (Oracle9i)

At the SVRMGR (Oracle8/8i) or SQL (Oracle9i) prompt, type: connect <Target_Database_Login>

exit

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

226

Chapter 2