| Strange database crash (no info. in alert log) [message #377049] |
Fri, 19 December 2008 11:13  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
Hi,
I have a dev. database which is oracle 10.2.0.3 on solaris 8. It was up and running and then it got crashed in a strage way..at about 4 pm when users said it is not accesssible I started it up again, but it was already started earlier at 12.40 , so I don't know how it became unavailable later...here is the fragment from alert log:
Fri Dec 19 12:40:32 2008
Successfully onlined Undo Tablespace 1.
Fri Dec 19 12:40:32 2008
SMON: enabling tx recovery
Fri Dec 19 12:40:32 2008
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN--I had started it at 12.40
Fri Dec 19 16:15:38 2008
Starting ORACLE instance (normal)
What could be the reason that there is no entry in the alert log for the cause of database being shutdown sometime between 12.40 and before 16.15?
We had lots of network issues today but I guess that should affect only the connectivity not the database on the server. could it be that server got rebooted? (by the way between this period today the team was not actively using it!). Are there any os level log files where I should check?
Thanks
Nirav
[Updated on: Fri, 19 December 2008 11:21] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Strange database crash (no info. in alert log) [message #377170 is a reply to message #377169] |
Sun, 21 December 2008 03:31  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
thanks Frank! This file has the following content:
Dec 21 03:10:04 host1 syslogd: line 24: WARNING: loghost could not be resolved
Dec 21 03:10:04 host1 syslogd: /var/adm/suwlog: No such file or directory
Dec 21 03:10:04 host1 syslogd: /var/adm/london1.log: No such file or directory
Dec 21 12:44:11 host1 bge: [ID 801593 kern.notice] NOTICE: bge0: link down
Dec 21 12:44:32 host1 bge: [ID 801593 kern.notice] NOTICE: bge0: link up 1000Mbps Full-Duplex
dont' know what this means...also can u suggest some documents to get the basics on solaris administration? all my databases are on solaris 8.
Thanks again,
Nirav
[Updated on: Sun, 21 December 2008 03:32] Report message to a moderator |
|
|
|
| Re: Strange database crash (no info. in alert log) [message #377173 is a reply to message #377170] |
Sun, 21 December 2008 04:27 |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Well, the last two lines indicate that the network went down and came back up again.
The first line worries me a bit. I'm not a OS person, but it looks as if you log entries should go to a remote server, but it couldn't at some stage (possibly due to the network issues). Some of the log entries may be on that remote loghost server. Unfortunately I cannot help you with this, please ask your sysadmin and let us know what he makes of it.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
