Not able to login to Enforce: ORA-01034 and ORA-27101

Products

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

Issue/Introduction

The Enforce web interface is inaccessible with an error "HTTP Status 404 -" and the DLP tomcat log is full of various database connection errors. Upon testing the connection to the Oracle database from the Enforce server with the SQLPlus utility, you receive the error:

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0      Serial number : 0

Resolution

ORA-01034 and ORA-27101 normally indicate that the database instance you're attempting to connect to is shut down.

Log on to the server and start up the instance.

 

THEN:

Make sure that your ORACLE_HOME and ORACLE_SID are correct. To see the current values in windows, at the command prompt type -

echo %ORACLE_HOME%

Then

echo %ORACLE_SID%

If the values are not your current oracle home and SID you need to correct them. This can be done in Windows environment variables.

To correct Windows Environment variables, Right-Click on My Computer -> Properties -> Advanced System Settings.