asked on

DB Shutdown Automatically

Dear Gurus,

My DATABASE got SHUTDOWN and then START automatically only the DATABASE not the server its self.

Can someone help me to identify what will be the reason DB SHUTDOWN AND START automatically.

Your urgent reply will be highly appreciated.

I am attaching DB ALERT log for your investigation.

Thanks
For_Expert_Exchange.txt

Wayne88

Does shutdown/start randomly or always at a specified time? If the latter then there may be a shutdown schedule script running.

Qlemo

That looks like an intentional restart, maybe after parameter changes.

Netsol-NOS

ASKER

Dear Wayne88,

This occurs first and last time. It never happened before.

Dear Qlemo,

How can we know that this is intentional restart and how we know that parameter changes ?

SOLUTION

Wayne88

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Qlemo

Someone did it. There is no way for us to tell you how you can find out - who has access as a sysdba to Oracle or is admin on the server machine?

Geert G

on a complete side note:

why would you set max_parallel_servers so high when you only allow 800 sessions/processes ?

Adjusting the default value of parameter parallel_max_servers
from 1280 to 770 due to the value of parameter processes (800)

oracle fixes this implicitely

Netsol-NOS

ASKER

Thanks for the info.

My query and management question is , what are the possible reasons for DB to restart.

1) User has performed it . = How can we know which user and from where ?
2) Oracle has done this by its self. = How can we know Oracle did it by some proof ?
3) System (Operating System) has done this. = How can we know System has done this ?

We need to provide proof to management.

Thanks

SOLUTION

Qlemo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Netsol-NOS

ASKER

Dear All,

Thanks all for your expert solutions.

Details has been forwarded to DB expert to analysis the AUDIT_SYS_OPERATIONS..
And also request to enable the SYS auditing .

Thanks

Geert G

that's odd ...
i would have asked this to the db expert