Home » RDBMS Server » Server Administration » enable auditing ,startup hang (10.2.0.1,RHEL 4)
enable auditing ,startup hang [message #308771] Tue, 25 March 2008 07:01 Go to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
I tried to enable auditing with the command:

SQL>alter system set audit_trail=db scope=spfile;
SQL>shutdown immediate
SQL>startup
Oracle Instance started.
-

Now it is hanged at this level.

In alertlog MMON,MMNL process have listed to be started.

Where should i look for more information?
Re: enable auditing ,startup hang[RESOLVED] [message #308789 is a reply to message #308771] Tue, 25 March 2008 08:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the problem was?

Regards
Michel
Re: enable auditing ,startup hang [message #308804 is a reply to message #308771] Tue, 25 March 2008 08:47 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
The problem was my ignorance.
Re: enable auditing ,startup hang [message #308808 is a reply to message #308804] Tue, 25 March 2008 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe it is also ours.
It maybe worths to post it.
If you don't think so, I insist no more.

Regards
Michel
Re: enable auditing ,startup hang [message #308945 is a reply to message #308771] Wed, 26 March 2008 00:56 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
From other session i issued shutdown immediate and restarted it.
Previous Topic: Which method should I choose?
Next Topic: Is it safe to query X$ ?
Goto Forum:
  


Current Time: Tue Sep 17 19:25:38 CDT 2024