Home » RDBMS Server » Server Utilities » TKPROF error (oracle 10G on windows)
TKPROF error [message #345837] Fri, 05 September 2008 00:41 Go to next message
saagar
Messages: 79
Registered: December 2007
Member
Dear all
i am getting error in tkprof ....

i am doing this on the hr sachema...

error is mentioned below
D:\oracle\product\10.2.0\db_1\BIN>tkprof google_ora_1464.trc output.txt explain=hr/hr SYS=NO

TKPROF: Release 10.2.0.1.0 - Production on Fri Sep 5 10:42:38 2008

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


could not open trace file google_ora_1464.trc

D:\oracle\product\10.2.0\db_1\BIN>


well im am trying to find out root cause but no luck

CHeers
Re: TKPROF error [message #345839 is a reply to message #345837] Fri, 05 September 2008 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does the file exist?
Do you have permission to access it?

Regards
Michel
Re: TKPROF error [message #345843 is a reply to message #345839] Fri, 05 September 2008 01:08 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
Dear Micheal
but i can acccess it and view the file ...
how could i solve this problem.......then

CHeers
Re: TKPROF error [message #345863 is a reply to message #345843] Fri, 05 September 2008 02:43 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Currently, you are in
D:\oracle\product\10.2.0\db_1\BIN>
and running the TKPROF. As there's no path to the TRC file, TKPROF thinks that it is in the current directory (the one listed above).

So, is it in "D:\oracle\product\10.2.0\db_1\BIN>"? If not (and I'd bet it is not), either go into that directory and run TKPROF (because your ORACLE_HOME\BIN is in the path so you'll (very) probably be able to run it), or add path to the TRC file here, where you are now.
Re: TKPROF error [message #345904 is a reply to message #345863] Fri, 05 September 2008 04:18 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
hi
it is in that path only
where would be trc file then ...it is present in this bin directory only...

Still getting the above error......

CHeers
Re: TKPROF error [message #345911 is a reply to message #345904] Fri, 05 September 2008 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post
dir D:\oracle\product\10.2.0\db_1\BIN\google_ora_1464.trc

Regards
Michel
Re: TKPROF error [message #345919 is a reply to message #345911] Fri, 05 September 2008 04:54 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
Dear all

thank you for your assistance ...
my problem got solved it was issue of local rights in the system
thank you littlefoot, thank you michel , thank you ross


CHeers
Re: TKPROF error [message #345951 is a reply to message #345904] Fri, 05 September 2008 07:00 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
saagar wrote on Fri, 05 September 2008 11:18
it is in that path only
where would be trc file then

Trace file destination directory can be set by
ALTER SYSTEM SET user_dump_dest = <some_directory>
and its current value can be found by issuing the following query:
select value 
from v$parameter 
where name = 'user_dump_dest';

On my system (MS Windowx XP, Oracle 10g) it is set to C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORA10G\UDUMP directory (i.e. different from the \BIN directory, which - in my opinion - is a badly chosen place to store such files. I'd rather not mess up with this directory).

By the way, Ross who? Leishman? Thanks to him by all means, always, but he didn't participate in this discussion.
Previous Topic: import from client 9.2.0.1, it always hang
Next Topic: exporting stored outline
Goto Forum:
  


Current Time: Thu Dec 08 23:51:13 CST 2016

Total time taken to generate the page: 0.18343 seconds