ORA-12541 TNS:no listener after rebooting database

Products

• Data Loss Prevention Oracle Standard Edition 2
• Data Loss Prevention

Issue/Introduction

After rebooting the Oracle database server, DLP is unable to connect to the database.

Running the 'lsnrctl status' command on the Oracle server results in the following error:  The listener supports no services
 



Trying to connect to the database through sqlplus on the Enforce server results in: ORA-12541 TNS:no listener

Trying to connect to the database through sqlplus on the Oracle server as the protect user results in: ORA-01034: ORACLE not available 

Environment

DLP 15.5
Oracle 12c on Linux

Cause

The database is not running.

Resolution

Restart oracle on the DB server

1. On the database server, open a command prompt. 
2. Connect to sqlplus as the sys user:

sqlplus /nolog
conn sys as sysdba

3. run the startup command:

startup

4. The database should show that it's starting.
Example:

SQL> startup 
ORACLE instance started.

Total System Global Area  655609856 bytes
Fixed Size                  2255992 bytes
Variable Size             629146504 bytes
Database Buffers           16777216 bytes
Redo Buffers                7430144 bytes
Database mounted.
Database opened.

5. Running the 'lsnrctl services' command on the database server should show the listener is running.
Example:

Services Summary...
Service "protect" has 1 instance(s).
Instance "protect", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully

6. Restart services on the Enforce Server and confirm you are able to login successfully.

Additional Information

Verify the ORACLE_HOME and PATH variables are set on the Oracle server before running the startup command.

For linux:
echo $ORACLE_HOME
echo $PATH