HP A.06.11 - Manual (Page 207)

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\lsnrctl status service
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.
Figure 41 Checking the status of the Oracle listener
a. The status of the respective listener service in the Services window should
be Started, otherwise you must start it manually.
b. Start the SQL Plus from the ORACLE_HOME directory:
bin\sqlplus
At the SQL 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).
Integration guide for Oracle and SAP 207