How to Make Trace Files Created by Oracle Readable by All Users ?

Problem Description:

~~~~~~~~~~~~~~~~~~~~

How do you make all trace files that Oracle creates readable to owner, group,

and world or public?

Any “*.trc” files created by Oracle have permissions of 640, with owner of

Oracle and group DBA.

For example: -rw-r—– oracle dba

Setting umask in the users login script (.cshrc or .profile) does not effect the

permissions on any trace files that are created by Oracle.

Solution Description:

~~~~~~~~~~~~~~~~~~~~~

Edit the “init.ora” file to include the “_trace_files_public”

parameter by doing the following steps:

1. Change your location to the “dbs” directory

% cd to $ORACLE_HOME/dbs

2. Edit the “init.ora” file

Add the line:

_trace_files_public = true

3. Save the file.

4. Bounce the database so the new parameters take effect.

or if using spfile

1. Modify spfile via following sql command

SQL> alter system set “_trace_files_public” = true scope=spfile;

2. Bounce the database so the new parameter takes effect.