Checking the status of the oracle listener – HP A.06.11 User Manual
Page 141
1.
Export or set the ORACLE_HOME and DB_NAME variables as described in
2.
Start SQL*Plus from the bin directory in the ORACLE_HOME directory:
sqlplus /nolog
3.
Start SQL*Plus and type:
connect Recovery_Catalog_Login
select * from rcver;
exit
If this fails, open the recovery catalog.
•
Verify that the listener is correctly configured for the Oracle target database and
the recovery catalog database. This is required to properly establish network
connections:
1.
Export or set the ORACLE_HOME variable as described in
2.
Start the listener from the bin directory in the ORACLE_HOME directory:
lsnrctl status service
If this fails, startup the listener process and see the Oracle documentation for
instructions on how to create a configuration file (LISTENER.ORA).
On Windows, the listener process can be started in the Control Panel
> Administrative Tools > Services.
Figure 28 Checking the status of the Oracle listener
The status of the respective listener service in the Services window should be
Started, otherwise you must start it manually.
Integration guide for Oracle and SAP
141