OraFAQ Forum: Server Administration » Database Down Automatically

Home » RDBMS Server » Server Administration » Database Down Automatically (Database, 10.1.0, RHEL 4.0)

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

Database Down Automatically [message #307615]

Wed, 19 March 2008 05:17

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

Report message to a moderator

Re: Database Down Automatically [message #307619 is a reply to message #307615]

Wed, 19 March 2008 05:20

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Database Down Automatically [message #307622 is a reply to message #307619]

Wed, 19 March 2008 05:24

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

Report message to a moderator

Re: Database Down Automatically [message #307640 is a reply to message #307622]

Wed, 19 March 2008 05:58

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Then someone (maybe a task/job) shut it down.

Regards
Michel

Report message to a moderator

Re: Database Down Automatically [message #307644 is a reply to message #307640]

Wed, 19 March 2008 06:06

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

Report message to a moderator

Re: Database Down Automatically [message #307646 is a reply to message #307644]

Wed, 19 March 2008 06:08

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

audit_sys_operations = TRUE
audit_file_dest = <your directory>

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 03:40:17 CST 2024