Home » RDBMS Server » Server Administration » Database Shuts Down
Database Shuts Down [message #237133] Sat, 12 May 2007 09:57 Go to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Hi,

One of the Oracle databases shuts down once in every 2 or 3 days. It runs fine when it is issued the STARTUP command. When I had check the alert log prior to the startup I found these two lines

SMON offlining US=29
SMON offlining US=30

Not sure if it was shutdown for the above reason or someone had shutdown the db manually. Could you please help me in getting rid of this issue?

Note : I do not have the auditing enabled in the db.

Report message to a moderator

Re: Database Shuts Down [message #237134 is a reply to message #237133] Sat, 12 May 2007 10:11 Go to previous messageGo to next message
milindss
Messages: 5
Registered: May 2007
Junior Member
Can you post atleast 50 lines above and below these errors ? Or if possible upload the alert log file ?

Report message to a moderator

Re: Database Shuts Down [message #237137 is a reply to message #237133] Sat, 12 May 2007 10:51 Go to previous messageGo to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Hi,

The alert log is huge. Hence I am pasting some of its lines.

# 5923 mem# 1: F:\ORACLE\WEBDV\ORADATA\LOG\REDO03B.LOG
Private_strands 23 at log switch
Thread 1 advanced to log sequence 5924
Current log# 1 seq# 5924 mem# 0: F:\ORACLE\WEBDV\ORADATA\LOG\REDO01A.LOG
Current log# 1 seq# 5924 mem# 1: F:\ORACLE\WEBDV\ORADATA\LOG\REDO01B.LOG
Private_strands 23 at log switch
Thread 1 advanced to log sequence 5925
Current log# 2 seq# 5925 mem# 0: F:\ORACLE\WEBDV\ORADATA\LOG\REDO02A.LOG
Current log# 2 seq# 5925 mem# 1: F:\ORACLE\WEBDV\ORADATA\LOG\REDO02B.LOG
Private_strands 23 at log switch
Thread 1 advanced to log sequence 5926
Current log# 3 seq# 5926 mem# 0: F:\ORACLE\WEBDV\ORADATA\LOG\REDO03A.LOG
Current log# 3 seq# 5926 mem# 1: F:\ORACLE\WEBDV\ORADATA\LOG\REDO03B.LOG
Private_strands 23 at log switch
Thread 1 advanced to log sequence 5927
Current log# 1 seq# 5927 mem# 0: F:\ORACLE\WEBDV\ORADATA\LOG\REDO01A.LOG
Current log# 1 seq# 5927 mem# 1: F:\ORACLE\WEBDV\ORADATA\LOG\REDO01B.LOG
Private_strands 23 at log switch
Thread 1 advanced to log sequence 5928
Current log# 2 seq# 5928 mem# 0: F:\ORACLE\WEBDV\ORADATA\LOG\REDO02A.LOG
Current log# 2 seq# 5928 mem# 1: F:\ORACLE\WEBDV\ORADATA\LOG\REDO02B.LOG
Private_strands 23 at log switch
Thread 1 advanced to log sequence 5929
Current log# 3 seq# 5929 mem# 0: F:\ORACLE\WEBDV\ORADATA\LOG\REDO03A.LOG
Current log# 3 seq# 5929 mem# 1: F:\ORACLE\WEBDV\ORADATA\LOG\REDO03B.LOG
Fri May 11 12:55:27 2007
Private_strands 23 at log switch
Thread 1 advanced to log sequence 5930
Current log# 1 seq# 5930 mem# 0: F:\ORACLE\WEBDV\ORADATA\LOG\REDO01A.LOG
Current log# 1 seq# 5930 mem# 1: F:\ORACLE\WEBDV\ORADATA\LOG\REDO01B.LOG
Fri May 11 13:54:46 2007
Private_strands 23 at log switch
Thread 1 advanced to log sequence 5931
Current log# 2 seq# 5931 mem# 0: F:\ORACLE\WEBDV\ORADATA\LOG\REDO02A.LOG
Current log# 2 seq# 5931 mem# 1: F:\ORACLE\WEBDV\ORADATA\LOG\REDO02B.LOG
Fri May 11 15:35:44 2007
Private_strands 23 at log switch
Thread 1 advanced to log sequence 5932
Current log# 3 seq# 5932 mem# 0: F:\ORACLE\WEBDV\ORADATA\LOG\REDO03A.LOG
Current log# 3 seq# 5932 mem# 1: F:\ORACLE\WEBDV\ORADATA\LOG\REDO03B.LOG
Fri May 11 17:14:40 2007
Private_strands 23 at log switch
Thread 1 advanced to log sequence 5933
Current log# 1 seq# 5933 mem# 0: F:\ORACLE\WEBDV\ORADATA\LOG\REDO01A.LOG
Current log# 1 seq# 5933 mem# 1: F:\ORACLE\WEBDV\ORADATA\LOG\REDO01B.LOG
Fri May 11 22:00:37 2007
Private_strands 23 at log switch
Thread 1 advanced to log sequence 5934
Current log# 2 seq# 5934 mem# 0: F:\ORACLE\WEBDV\ORADATA\LOG\REDO02A.LOG
Current log# 2 seq# 5934 mem# 1: F:\ORACLE\WEBDV\ORADATA\LOG\REDO02B.LOG
Fri May 11 22:07:31 2007
SMON offlining US=29
SMON offlining US=30

Report message to a moderator

Re: Database Shuts Down [message #237154 is a reply to message #237137] Sat, 12 May 2007 14:12 Go to previous messageGo to next message
milindss
Messages: 5
Registered: May 2007
Junior Member
How about the next few lines below these errors. I want to see the messages after these errors and when the instance crashed.

You have Automatic Undo Management turned on in your database which would make the Undo segements online/offline based on the load on the database. What I am trying to look for is some ORA error which may show up in Alert file at the time of crash. If not check in backgorund_dump_dest location if any backgorund process created a tracefile ?

Need more info to understand the reason for failure of instance.

Report message to a moderator

Re: Database Shuts Down [message #237205 is a reply to message #237133] Sun, 13 May 2007 05:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just information messages telling that some undo segments are useless and SMON offline them.

Nothing to worry about.

Regards
Michel

Report message to a moderator

Re: Database Shuts Down [message #237223 is a reply to message #237133] Sun, 13 May 2007 10:50 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Hi,
someone had shutdown the db manually

Before shutdown your database are you restart your SERVER ( MACHINE) may be possible Oracle Database STARTUP TYPE IS MANUAL.
so you have to startup your database everytime when your restart your SERVER ( MACHINE)

check in services.msc << hit enter>>

or if startup is AUTO then please you have to post/upload your alert<sid>.log file.


Regards
Taj

Report message to a moderator

Re: Database Shuts Down [message #237757 is a reply to message #237133] Tue, 15 May 2007 11:21 Go to previous messageGo to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
The service is in automatic mode. Have uploaded the alert log file.

Report message to a moderator

Re: Database Shuts Down [message #238550 is a reply to message #237133] Fri, 18 May 2007 08:45 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
What were you (or someone using your database) running at or around Fri May 11 11:22:05 2007?

You can check that trace file that the error referenced for more info.

Likely you are using Oracle without paying for it (which may or may not be ok, depending on situation), so Oracle support is not an option for you. If I'm wrong, call them up, and/or patch your database. It is an internal Oracle error.

If I'm right, then avoid doing whatever you were doing at 11:22 and just live without doing it. And consider paying for Oracle.

Report message to a moderator

Previous Topic: blocking user
Next Topic: Unable to invoke Net Configuration Assistant
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:03:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.