404 Redirect Error on Enforce due to Listener misconfiguration.

Products

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

Issue/Introduction

When trying to access the Enforce console, browser keeps refreshing "404 error".

404 redirects to an eternal loop

Environment

There are internal function calls to the Oracle database that revolves around the computer name.

Cause

This error is caused by a communication issue between Enforce and the Database.

Resolution

1. Go to Oracle Server
2. Open an elevated Command Directory aka run cmd as administrator
3. go to your "Oracle Home" installation directory [(DataDrive):\oracle\product\12.2.0.1\db_1]
4. run the NETCA by using the following command: %ORACLE_HOME%/BIN/NETCA
5. Select the "Listener Configuration"
6. Follow screenshotted steps below: 

Delete the current listener service

Select Listener, next, and yes you want to delete

Select the "Listener Configuration"

Select Add

"LISTENER" is the default listener name, Enter your password

Select the "TCP" protocol

Use the standard port number of 1521

Select no

click finish

Continue with Next Steps: 

1. open CMD (as administrator)
2. run the following command to stop the listener: lsnrctl stop
3. open "listener.ora"  [(Datadrive):\oracle\product\12.2.0.1\db_1\network\admin\listner.ora]
4. change the following key value in the "listener.ora" file
5. From: (ADDRESS = (PROTOCOL = IPC)(KEY =[INCORRECT VALUE]))
6. To: (ADDRESS = (PROTOCOL = IPC)(KEY = [CORRECT VALUE]))
7. add the following line to the end of the "listener.ora" file: SECURE_REGISTER_LISTENER = (IPC)
8. Save & Close "listener.ora"
9. run the following command in CMD to start the listener(open a new window as administrator if you closed the previous one)
   lsnrctl start
10. run SQL Plus in the CMD windows
    sqlplus /nolog
11. connect to the database
    conn sys/<password> as sysdba
12. run the following command
    ALTER SYSTEM SET local_listener = '(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PROTECT)))' SCOPE=both;
    **note that it is case sensitive and sensitive to spaces, recommend to copy/paste the command
13. run the following command to register the listener
    ALTER SYSTEM REGISTER;
14. exit SQL
    exit;
15. verify the change to the listener: 
    lsnrctl services

 

Configure Local NET Service name:

open the "Oracle Net Configuration Assistant"

Start > All Programs > Oracle 12.2.0.1 > Configuration and Migration Tools > Net Configuration Assistant

Select the "Local Net Service Name Configuration"

Select "Add"

enter "protect" as the service name

select "TCP"

Hostname: IP Address of the Oracle Server  (or FQDN) use the standard port number of 1521

use the default service name of "protect"

select "No, do not test"

click "Finish" to close the assistant

 

Create the Oracle User Account for DLP:

Open CMD

change directory to where you extracted your Oracle Tools

C:\OracleInstall\Tools

open SQL Plus: sqlplus /nolog

run the "oracle_create_user.sql" script: @oracle_create_user.sql

you will be prompted for the following information

SYS Password:

SID:

Username:

Password:

 

Verify the database is setup correctly: Open CMD

- open SQL Plus

sqlplus /nolog

- Log on as the SYS user

connect sys/<SYS Password>@protect as sysdba

- Run the following query

SELECT * FROM v$version;

confirm the versions listed are all showing the correct version (12.2.0.1)

exit SQL Plus

exit