Filter
Top Products
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.