SQL Performance (MOSC)

MOSC Banner

Getting error when using sqltrcanlzr.sql with control_file.txt

edited Mar 2, 2019 4:15PM in SQL Performance (MOSC) 11 commentsAnswered

Hello All,

Description : I am control_file.txt with many trace files in it and running START sqltrcanlzr.sql control_file.txt.In our environment we do not have permissions to create files under the trace directory for control_file.txt.

So i created the file under /tmp and changed the directory path of TRCA$INPUT2 to point /tmp (SQL>  create or replace directory TRCA$INPUT2 as '/tmp'; ).

This is a RAC environement with two instances.All trace files included in control_file.txt are of instance 3 and TRCA$INPUT2 to point /tmp is done in instance 3.

But getting below error when run in instance 3:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center