OraFAQ Forum: Server Administration » sql

Home » RDBMS Server » Server Administration » sql_trace with Oracle 9.2.0.1.0

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

sql_trace with Oracle 9.2.0.1.0 [message #54925]

Mon, 16 December 2002 14:12

S. Gray
Messages: 2
Registered: December 2002

Junior Member

I recently started using 9i version 9.2.0.1.0 instead of 8i.
In 8i I was able to modify my init.ora inside the "pfile" folder to turn on sql_trace and set the dump directories.

I have modified the init.ora in the pfile directory for my 9i instance, but it is not writing to the dump directories I specified, and it is not tracing.

Is there something different you must do in 9i to turn on sql_trace?

Report message to a moderator

Re: sql_trace with Oracle 9.2.0.1.0 [message #54926 is a reply to message #54925]

Mon, 16 December 2002 15:07

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

it is becuase u might changed /updated only in spfile.
spfile is new concept with 9i.
Make sure u edit ur init< sid >.ora and 
startup the database using that init< sid >.ora

Startup open pfile=$ORACLE_HOME/dbs/init< sid >.ora

Report message to a moderator

Re: sql_trace with Oracle 9.2.0.1.0 [message #54940 is a reply to message #54925]

Tue, 17 December 2002 11:45

S. Gray
Messages: 2
Registered: December 2002

Junior Member

I have modified the init<sid>.ora, it was in

oracleadmin<db namepfile

The only file I have in the $ORACLE_HOME/dbs directory is
initdw.ora

Report message to a moderator

Previous Topic:	connecting problem
Next Topic:	Re: Oracle Character Sets

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:56:25 CDT 2024