Cannot find trace file or user_dump directory

book

Article ID: 184410

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

Symantec Data Loss Prevention (DLP)
Oracle

Cannot find Oracle trace file or user_dump directory.

Directory not found.

Cause

The normal destination of a trace file is the user_dump directory.
Assuming the installation steps were followed in the Symantec Data Loss Prevention Oracle Installation and Upgrade Guide, this 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
    (Refer to the Symantec Data Loss Prevention Oracle Installation and Upgrade Guide)
    Note: The Oracle SQL*Plus application is case sensitive.
  2. At the SQL> command prompt, to connect as the sysdba user, type: connect sys/[email protected] as sysdba where password is the SYS password
  3. Once connected, type: show parameter user_dump_dest; to display the user_dump directory