Home » Other » General » Unable to generate trace files in Oracle installation 8.1.6
Unable to generate trace files in Oracle installation 8.1.6 [message #102257] Fri, 05 April 2002 10:36 Go to next message
Hector M. Villarreal
Messages: 8
Registered: January 2002
Junior Member
I have rebuilt a test database and cannot generate trace files. Is there a known bug with Oracle 8.1.6? This is the only installation that I am unable to find any errors when I run :
ALTER SESSION SET SQL_TRACE=TRUE.

or
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

The Alert log file shows following:

Thu Mar 28 10:22:08 2002
alter database backup controlfile to trace
Completed: alter database backup controlfile to trace

I have checked for file permissions and I can spool files to my backgroung_dump_dest as specified on init.ora file.
This problem has got me stumped. I have recycled the database and nothing seems to work. Appreciate it if anyone can resolve this one or point me to why I am unable to create a trace file.
Re: Unable to generate trace files in Oracle installation 8.1.6 [message #102258 is a reply to message #102257] Fri, 05 April 2002 11:31 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
It goes into user_dump_dest.
Previous Topic: Re: Require : Question papers on OCP DBA 8i
Next Topic: Oracle PL/SQL
Goto Forum:
  


Current Time: Fri Dec 27 22:48:40 CST 2024