Integrating SAP R/3 and Data Protector

Troubleshooting

Troubleshooting on Windows Systems

Prerequisites Concerning the Oracle Side of the Integration

The following steps should be performed to verify that Oracle is installed as required for the integration to work. These steps do not include verifying Data Protector components.

1.Verify that you can access the Oracle Target Database and that it is opened, as follows:

Set <ORACLE_HOME> and <ORACLE_SID> variables.

Start the Server Manager (Oracle8/8i) 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 this 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:

Start the listener from the <ORACLE_HOME> directory: bin\lsnrctl80 status <service> (for Oracle8) or bin\lsnrctl status <service> (for Oracle8i/9i) quit

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

The listener process can be started from the Windows desktop. In the

Control Panel, go to Administrative Tools, Services.

Chapter 2

215