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

Log in as the Oracle user.
```
ssh -Y oracle@myserver
```
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
```
Start the BI Publisher database listener (LISTENER).
```
./lsnrctl start
```
Start the OCSDMDW database listener (LISTENER2).
```
./lsnrctl start LISTENER2
```
To check the status of either listener mentioned above, use the following command:
```
./lsnrctl status
```