| Database shutdown in the midnight [message #278914] |
Tue, 06 November 2007 05:00  |
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 #278955 is a reply to message #278943] |
Tue, 06 November 2007 07:34  |
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 #279008 is a reply to message #278966] |
Tue, 06 November 2007 10:24 |
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 #279016 is a reply to message #279013] |
Tue, 06 November 2007 11:18 |
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 #279030 is a reply to message #279026] |
Tue, 06 November 2007 12:11 |
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 #279122 is a reply to message #278955] |
Wed, 07 November 2007 01:11 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
