| Database down often [message #460172] |
Thu, 10 June 2010 01:04  |
goracle9
Messages: 136
Registered: December 2006
|
Senior Member |
|
|
Please some one help me!!!!!!!!!!!!!!!
see as i said keep on my database down in the night time around 9 pm. the OS redhat linux 5 restarting morning around 6.45 am.
when i check alert_log there is no indication.
when i check OS log , OS restarting around 6.45 am
checked in the log file in OS level
location: /var/log
i found this
Jun 7 06:45:33 Alraya syslogd 1.4.1: restart.
Jun 8 06:42:22 Alraya syslogd 1.4.1: restart.
Jun 9 06:47:12 Alraya syslogd 1.4.1: restart.
what is this mean, system restarting around 6:45 daily i think
now i m posting listener.log for reference
<b>06-JUN-2010 21:04:52 *</b> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=Alraya)(USER=alrayaora))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADD
RESS=(PROTOCOL=TCP)(HOST=Alraya)(PORT=1521)))(VERSION=169869568)) * status * 0
06-JUN-2010 21:05:05 * (CONNECT_DATA=(SID=alraya)(CID=(PROGRAM=perl@Alraya)(HOST=Alraya)(USER=alrayaora))) * (ADDRESS=(PROTOC
OL=tcp)(HOST=127.0.0.1)(PORT=6186)) * establish * alraya * 0
06-JUN-2010 21:05:17 * service_update * alraya * 0
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 07-JUN-2010 08:02:09
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /u01/app/oracle/product/10.2.0/alraya/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/alraya/network/log/listener.log
Trace information written to /u01/app/oracle/product/10.2.0/alraya/network/trace/listener.trc
Trace level is currently 0
Started with pid=3357
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Alraya)(PORT=1521)))
Listener completed notification to CRS on start
------------------------------------------------
<b> 07-JUN-2010 21:07:54</b> * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=Alraya)(USER=alrayaora))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADD
RESS=(PROTOCOL=TCP)(HOST=Alraya)(PORT=1521)))(VERSION=169869568)) * status * 0
07-JUN-2010 21:08:07 * (CONNECT_DATA=(SID=alraya)(CID=(PROGRAM=perl@Alraya)(HOST=Alraya)(USER=alrayaora))) * (ADDRESS=(PROTOC
OL=tcp)(HOST=127.0.0.1)(PORT=21128)) * establish * alraya * 0
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2010 08:07:44
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /u01/app/oracle/product/10.2.0/alraya/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/alraya/network/log/listener.log
Trace information written to /u01/app/oracle/product/10.2.0/alraya/network/trace/listener.trc
Trace level is currently 0
------------------------------------------------
<b>08-JUN-2010 21:24:35</b> * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=Alraya)(USER=alrayaora))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADD
RESS=(PROTOCOL=TCP)(HOST=Alraya)(PORT=1521)))(VERSION=169869568)) * status * 0
08-JUN-2010 21:24:48 * (CONNECT_DATA=(SID=alraya)(CID=(PROGRAM=perl@Alraya)(HOST=Alraya)(USER=alrayaora))) * (ADDRESS=(PROTOC
OL=tcp)(HOST=127.0.0.1)(PORT=63312)) * establish * alraya * 0
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 09-JUN-2010 07:57:59
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /u01/app/oracle/product/10.2.0/alraya/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/alraya/network/log/listener.log
Trace information written to /u01/app/oracle/product/10.2.0/alraya/network/trace/listener.trc
Trace level is currently 0
Started with pid=3355
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Alraya)(PORT=1521)))
Listener completed notification to CRS on start
-------------------------------------------------
<b>09-JUN-2010 21:04:47 </b>* (CONNECT_DATA=(CID=(PROGRAM=)(HOST=Alraya)(USER=alrayaora))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADD
RESS=(PROTOCOL=TCP)(HOST=Alraya)(PORT=1521)))(VERSION=169869568)) * status * 0
09-JUN-2010 21:05:00 * (CONNECT_DATA=(SID=alraya)(CID=(PROGRAM=perl@Alraya)(HOST=Alraya)(USER=alrayaora))) * (ADDRESS=(PROTOC
OL=tcp)(HOST=127.0.0.1)(PORT=23480)) * establish * alraya * 0
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 10-JUN-2010 08:01:25
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /u01/app/oracle/product/10.2.0/alraya/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/alraya/network/log/listener.log
Trace information written to /u01/app/oracle/product/10.2.0/alraya/network/trace/listener.trc
Trace level is currently 0
Started with pid=3354
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Alraya)(PORT=1521)))
Listener completed notification to CRS on start
what is the problem.
OS is restarting around 6.45 in the morning, but database getting down night around 9 pm itself why
then in the morning if i bounce the database it starting with no problem
please help me.
Thanks
|
|
|
|
|
|
| Re: Database down often [message #460180 is a reply to message #460174] |
Thu, 10 June 2010 01:41  |
goracle9
Messages: 136
Registered: December 2006
|
Senior Member |
|
|
i m DBA, i m maintaining the database. this server newly configured and installed oracle.
it was fine only. we shift the server from one place to another
but ip is same
after shift only this problem coming.
database down daily around 9 pm
OS rebooting around 6.45 am
anyway the database should not down, it may down when OS reboot.
thanks
|
|
|
|
| Re: Database down often [message #460192 is a reply to message #460180] |
Thu, 10 June 2010 02:09 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I don't think that Oracle shuts down because someone moved a server from one room to another. There *must* be something else that changed in between.
Did you, perhaps, start to backup? If so, how does that procedure look like? Perhaps it (the procedure) shuts the database down while performing backup?
[Updated on: Thu, 10 June 2010 02:11] Report message to a moderator |
|
|
|
| Re: Database down often [message #460197 is a reply to message #460192] |
Thu, 10 June 2010 02:21 |
goracle9
Messages: 136
Registered: December 2006
|
Senior Member |
|
|
i discussed with my system admin,
this is happening bcause of some power suppy cut in the night
he has not pluged the server with UPS
so we need to do needy things
thanks anyway
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
