OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » TKPROF error (oracle 10G on windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TKPROF error [message #345837]

Fri, 05 September 2008 00:41

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

Report message to a moderator

Re: TKPROF error [message #345839 is a reply to message #345837]

Fri, 05 September 2008 00:59

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Does the file exist?
Do you have permission to access it?

Regards
Michel

Report message to a moderator

Re: TKPROF error [message #345843 is a reply to message #345839]

Fri, 05 September 2008 01:08

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

Report message to a moderator

Re: TKPROF error [message #345863 is a reply to message #345843]

Fri, 05 September 2008 02:43

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: TKPROF error [message #345904 is a reply to message #345863]

Fri, 05 September 2008 04:18

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

Report message to a moderator

Re: TKPROF error [message #345911 is a reply to message #345904]

Fri, 05 September 2008 04:26

Michel Cadot
Messages: 68648
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

Report message to a moderator

Re: TKPROF error [message #345919 is a reply to message #345911]

Fri, 05 September 2008 04:54

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

Report message to a moderator

Re: TKPROF error [message #345951 is a reply to message #345904]

Fri, 05 September 2008 07:00

Littlefoot
Messages: 21808
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.

Report message to a moderator

Previous Topic:	import from client 9.2.0.1, it always hang
Next Topic:	exporting stored outline

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 12:19:29 CDT 2024