How to Start, Stop, and Check the Status of the Oracle Database Listeners

1. Log in as the Oracle user.

   ssh -Y oracle@myserver

2. Use the export ORACLE_HOME variable to restart the listener. Ensure that this variable identifies (set to equal) the directory path on which you installed the Oracle database software. For example:

   export ORACLE_HOME=/home/oracle/app/oracle/product/<oracle-database-software-version>/dbhome_1
   cd $ORACLE_HOME/bin

3. Start the BI Publisher database listener (LISTENER).

   ./lsnrctl start

4. Start the OCSDMDW database listener (LISTENER2).

   ./lsnrctl start LISTENER2

5. To check the status of either listener mentioned above, use the following command:

   ./lsnrctl status