HP OpenView Storage Data Protector B6960-96008 User Manual

Integrating SAP R/3 and Data Protector

Troubleshooting

Chapter 2

215

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