Cannot find trace file or user_dump directory

Products

• Data Loss Prevention Enforce

Issue/Introduction

Cannot find Oracle trace file or user_dump directory.

Directory not found.

Environment

Symantec Data Loss Prevention (DLP)

Oracle

Cause

The normal destination of a trace file is the USER_DUMP directory.

Assuming the installation steps were followed according the Symantec Data Loss Prevention Oracle Installation and Upgrade Guide, the path for the USER_DUMP directory is:

 \oracle\diag\rdbms\protect\trace

If Oracle was installed differently, an Oracle command will need to be issued in order to find the user_dump directory.

Resolution

Log in to

1. Log into SQLPlus using the command line by typing:
   
   sqlplus /nolog
   
   Note: The Oracle SQL*Plus application is case sensitive.
   
   
2. At the SQL> command prompt, to connect as the sysdba user, type:
   
   connect sys/password@protect as sysdba
   
   where password is the SYS password
   
   
3. Once connected, type:
   
   show parameter user_dump_dest;
   
   to display the USER_DUMP directory