Home » RDBMS Server » Server Administration » trace location
trace location [message #55652] Thu, 06 February 2003 12:40 Go to next message
dennis
Messages: 31
Registered: June 1998
Member
When I issue the command:
alter database backup controlfile to trace;
the trace file gets written to the default directory, not the the directory I have set with user_dump_dest (at the end of) the initsid.ora file.
show parameter user_dump_dest verifies the correct directory, yet, the trace still gets written to the original default directory.
Any thoughts?
Thank you...
Re: trace location [message #55654 is a reply to message #55652] Thu, 06 February 2003 12:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Make sure you are using the correct parameter file(ie..oracle is using the correct paramter file).
and in 9i spfile was introduced and it is different from pfile.
Re: trace location [message #55659 is a reply to message #55654] Thu, 06 February 2003 14:42 Go to previous messageGo to next message
dennis
Messages: 31
Registered: June 1998
Member
I should have mentioned that I am running this on W2K. I confirmed in the registry that I am using the correct pfile. I also should have mentioned that I am running Oracle 8.1.7, so there is no spfile issue. I have not had this problem on NT or Unix. I am still at a loss.
Re: trace location [message #55671 is a reply to message #55652] Fri, 07 February 2003 02:35 Go to previous messageGo to next message
Raja
Messages: 57
Registered: March 2000
Member
Hi,
check out the dest directory is writeable.
Re: trace location [message #55682 is a reply to message #55671] Fri, 07 February 2003 09:05 Go to previous message
dennis
Messages: 31
Registered: June 1998
Member
That seems to be OK because...
alter database backup controlfile to 'D:destinationcontrolefile.bck' reuse;
works fine. I will probably have to go with this. It's a real puzzle to me why the other way does not work.
Previous Topic: Event Log Errors Oracle 734 on NT
Next Topic: Newbie Install
Goto Forum:
  


Current Time: Fri Sep 20 07:48:37 CDT 2024