Filter
Top Products
Integrating SAP R/3 and Data Protector
Troubleshooting
Chapter 2226
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).