Home » RDBMS Server » Server Administration » Database Down Automatically (Database, 10.1.0, RHEL 4.0)
Database Down Automatically [message #307615] Wed, 19 March 2008 05:17 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Dear M

From last two days my database is down auomatically.
==========================================
Env.

Oracle Database 10g R1
O/s RHEL 4.0
============================================

i am also geeting the entry in alert log

can you please suggest in what scenerio database down automatically



I m on production


Help

Regards
Re: Database Down Automatically [message #307619 is a reply to message #307615] Wed, 19 March 2008 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i am also geeting the entry in alert log

Which entry?

Oracle does not shut down the database unless it has to abort it due to a severe error which is logged in alert.log.

Regards
Michel
Re: Database Down Automatically [message #307622 is a reply to message #307619] Wed, 19 March 2008 05:24 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Thanks for quick reponse

In alert log i am not geeting any oracle error code.

I found the command shutdown database.

my database is down from last two approx on same time


Suggest

Regards
Re: Database Down Automatically [message #307640 is a reply to message #307622] Wed, 19 March 2008 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Then someone (maybe a task/job) shut it down.

Regards
Michel
Re: Database Down Automatically [message #307644 is a reply to message #307640] Wed, 19 March 2008 06:06 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Is oracle 10g R1 provide the feature of mandatory auditing.


if yes, how can we use
Re: Database Down Automatically [message #307646 is a reply to message #307644] Wed, 19 March 2008 06:08 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
audit_sys_operations = TRUE
audit_file_dest = <your directory>

Regards
Michel
Previous Topic: 10g and 9i Oracle on Windows 2003
Next Topic: SQL session hangs when quering a table
Goto Forum:
  


Current Time: Sun Dec 04 00:10:45 CST 2016

Total time taken to generate the page: 0.11995 seconds