Home » RDBMS Server » Server Administration » Strange database crash (no info. in alert log) (oracle 10.2.0.3 on solaris 8)
Strange database crash (no info. in alert log) [message #377049] Fri, 19 December 2008 11:13 Go to next message
orausern
Messages: 817
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)
-- actually I had to start it still I had to start it again!

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 #377130 is a reply to message #377049] Sat, 20 December 2008 10:56 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


I think server re-started.

Check OS level log also

Babu
Re: Strange database crash (no info. in alert log) [message #377166 is a reply to message #377130] Sun, 21 December 2008 02:27 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Thank you. I will check with my sysadmin for the OS level logs of Solaris (I don't know where the OS logs are located).

REgards
Nirav

[Updated on: Sun, 21 December 2008 02:28]

Report message to a moderator

Re: Strange database crash (no info. in alert log) [message #377169 is a reply to message #377166] Sun, 21 December 2008 02:54 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Solaris logs to the /var/adm/messages file.
Re: Strange database crash (no info. in alert log) [message #377170 is a reply to message #377169] Sun, 21 December 2008 03:31 Go to previous messageGo to next message
orausern
Messages: 817
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 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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.
Re: Strange database crash (no info. in alert log) [message #377174 is a reply to message #377173] Sun, 21 December 2008 04:46 Go to previous message
orausern
Messages: 817
Registered: December 2005
Senior Member
Thank you Frank , you know so much more than me and its most helpful!! I will check with the sys admin to know in details.

Regards
Nirav

Previous Topic: Oracle Client Installation
Next Topic: importing stats from 9i to 10g database
Goto Forum:
  


Current Time: Mon Dec 05 02:35:20 CST 2016

Total time taken to generate the page: 0.11092 seconds