Home » RDBMS Server » Server Utilities » TKPROF-Cannot open trace file (ORACLE--10.2.0.4.0-UNIX)
TKPROF-Cannot open trace file [message #488367] Thu, 06 January 2011 12:20 Go to next message
brendaivett
Messages: 3
Registered: January 2011
Junior Member
Hello,

I am trying to get a readable version of a .trc file generated by Oracle

10.2.0.4.0 with tkprof, but I still have been unable to get this done...and

this is what I have already tried:

tkprof /u00/app/oracle/admin/DB/udump/*BITN1234.trc

/batch/salidas/student/BITNTRACE.txt

And whether I run this from my PL/SQL process (PRO*C) or from a command

line, it returns:

TKPROF: Release 10.2.0.4.0 - Production on Thu Jan 6 11:04:38 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.


could not open trace file /u00/app/oracle/admin/DB/udump/BITN1234.trc

I have already (from my PRO*C code and from command line)...

- made sure that the file is in the directory.

- run this from the udump directory, where the .trc file is...didn't work.

- run this from the udump directory, and specifying explicitely the

complete path anyway in the tkprof line (redundant...I know)...didn't work.

- tried to copy the file to another directory in order to run the tkprof,

and it returns:

cp: BITN1234.trc: The file access permissions do not allow the specified

action.

- tried changing privileges with:
chmod a+r BITN1234.trc

and it returns:
chmod: BITN1234.trc: Operation not permitted.

- tried to run tkprof01 instead of tkprof and it returns:

We trust you have received the usual lecture from the local System
Administrator. It usually boils down to these two things:

#1) Respect the privacy of others.
#2) Think before you type.

Password:


Can somebody please help me with this???

Thanks in advance,

Best regards!!!

Brenda I
brendaivett@yahoo.com
Re: TKPROF-Cannot open trace file [message #488368 is a reply to message #488367] Thu, 06 January 2011 12:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Post the filesystem permissions on the file.
ls -lart /u00/app/oracle/admin/DB/udump/BITN1234.trc
Re: TKPROF-Cannot open trace file [message #488371 is a reply to message #488367] Thu, 06 January 2011 12:43 Go to previous messageGo to next message
brendaivett
Messages: 3
Registered: January 2011
Junior Member
-rw-rw---- 1 oracle dba 223914 Jan 06 11:04 BITN1234.trc
Re: TKPROF-Cannot open trace file [message #488381 is a reply to message #488371] Thu, 06 January 2011 17:36 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
You don't have read permissions on the file. You need to get someone to give you permissions or run the tkprof for you.
Previous Topic: SQL Loader REG - Number values
Next Topic: is it safe to kill full db export?
Goto Forum:
  


Current Time: Fri Mar 29 05:21:49 CDT 2024