Home » RDBMS Server » Server Administration » Database shutdown in the midnight (Oracle 10g, SLES9)
Database shutdown in the midnight [message #278914] Tue, 06 November 2007 05:00 Go to next message
manojkb
Messages: 16
Registered: March 2006
Location: Dubai
Junior Member
My database is getting shutdown in the midnight at 2 am. I have not scheduled any jobs and I don't find any problem in the Alert log too. Can any one point me where the problem arise from.
Re: Database shutdown in the midnight [message #278943 is a reply to message #278914] Tue, 06 November 2007 07:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Someone, you, another one, a job... executed a "shutdown immediate".

Regards
Michel
Re: Database shutdown in the midnight [message #278955 is a reply to message #278943] Tue, 06 November 2007 07:34 Go to previous messageGo to next message
manojkb
Messages: 16
Registered: March 2006
Location: Dubai
Junior Member
What I want to know is the reason for midnight shutdown. In the morning sometime I see the database is mounted but not opened. In that case, I would use alter database open or sometime I would use shutdown immediate and startup commands.
Re: Database shutdown in the midnight [message #278956 is a reply to message #278955] Tue, 06 November 2007 07:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

What I want to know is the reason for midnight shutdown

Quote:

Someone, you, another one, a job... executed a "shutdown immediate".

Regards
Michel
Re: Database shutdown in the midnight [message #278966 is a reply to message #278955] Tue, 06 November 2007 08:14 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Talk to you Unix Sys Admins. Probably part of a nightly system backup. Hot backup or cold backup of your database is in their shell scripts.
Re: Database shutdown in the midnight [message #279008 is a reply to message #278966] Tue, 06 November 2007 10:24 Go to previous messageGo to next message
manojkb
Messages: 16
Registered: March 2006
Location: Dubai
Junior Member
So,the conclusion is probably a night backup. There is no way anyone can shutdown the database manually except me. In this case how can I find which script shuts down the database. I searched the backup schedule in OEM, but nothing is scheduled there.
Re: Database shutdown in the midnight [message #279013 is a reply to message #279008] Tue, 06 November 2007 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
cron or other scheduler.

Regards
Michel
Re: Database shutdown in the midnight [message #279016 is a reply to message #279013] Tue, 06 November 2007 11:18 Go to previous messageGo to next message
manojkb
Messages: 16
Registered: March 2006
Location: Dubai
Junior Member
my crontab contain only one job.

0 5 * * 5 sqlplus system/mypass @home/oracle/stats.sql >> /home/oracle/stats.log

and the stats.sql scripts contains an execution script to gather schema statistics. Will this job affect the database daily.
Re: Database shutdown in the midnight [message #279026 is a reply to message #279016] Tue, 06 November 2007 11:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How can we answer to this question when we don't know what's inside the script.
Also, continue searching, maybe there is another job.

Regards
Michel
Re: Database shutdown in the midnight [message #279030 is a reply to message #279026] Tue, 06 November 2007 12:11 Go to previous messageGo to next message
manojkb
Messages: 16
Registered: March 2006
Location: Dubai
Junior Member
the script stats.sql contains

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(OWNNAME=>'SALE',METHOD_OPT=>'FOR ALL INDEXED COLUMNS',DEGREE=>8,CASCADE=>TRUE);

and I believe the second 5 in the contab will wake the job up on 5th day of every week. Please correct me if i am wrong.
Re: Database shutdown in the midnight [message #279047 is a reply to message #279016] Tue, 06 November 2007 13:22 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
manojkb wrote on Tue, 06 November 2007 12:18

my crontab contain only one job.



Fine, that's YOUR crontab. What about root? Or oracle? Or someone else?
Re: Database shutdown in the midnight [message #279048 is a reply to message #278914] Tue, 06 November 2007 13:26 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Oracle databases do NOT spontaneously shutdown.
What is in the listener.log file showing who connected to the DB just before the shutdown started at 2AM?
Re: Database shutdown in the midnight [message #279122 is a reply to message #278955] Wed, 07 November 2007 01:11 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

at Mid Night your Linux Server was restart ?

In the morning sometime I see the database is mounted but not opened.
That time did you check your alert<sid>.log file why which command is use for startup database "may be it was startup mount".
In that case, I would use alter database open or sometime I would use shutdown immediate and startup commands.
why you use "shutdown immediate + startup", did you try with "alter database open".

OP> there is no magic.
possible reason are: Any schedule job restart oracle server.
your system administrator restart linux server.


Regards
Mohammed Taj
Previous Topic: Unable to start oracle 10g instance on solaris
Next Topic: Problem with Special Symbol (£) - is it NLS_LANg Setting Problem?
Goto Forum:
  


Current Time: Sat Dec 10 22:43:22 CST 2016

Total time taken to generate the page: 0.04392 seconds