OraFAQ Forum: Server Administration » Oracle Instance Termination

Home » RDBMS Server » Server Administration » Oracle Instance Termination

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Instance Termination [message #53248]

Fri, 06 September 2002 22:28

Murali Mohan
Messages: 8
Registered: March 2002

Junior Member

Sir,

In our site Oracle Instance is terminating Frequently.When i opened alert File it is showing
DBW0:Oracle Instance Terminated with Error code

ORA:000472

Please Find me a good solution to this problem.

Report message to a moderator

Re: Oracle Instance Termination [message #53256 is a reply to message #53248]

Mon, 09 September 2002 05:14

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i beleive it is becuase of PMON process termination.
look into the logs  and post more info, like
oraclversion (7.X ??), OS, exact sequence of errors etc.

Report message to a moderator

Re: Oracle Instance Termination [message #53280 is a reply to message #53256]

Tue, 10 September 2002 19:36

Murali Mohan
Messages: 8
Registered: March 2002

Junior Member

DBW0: terminating instance due to error 472.
Instance terminated by DBW0, pid=307

Following changes have done in init.ora

event = '10073 trace name contect level 1'
db_writer_process = 1
dbwr_io_slaves = 0
log_buffer = 4MB

we were having oracle version 8.1.0 in Win NT.
We have created database using customized option.

I need the following information.

creation of database using customized options and essential parameters required with values.

regards
Prabha Shankar

Report message to a moderator

Re: Oracle Instance Termination [message #53296 is a reply to message #53256]

Wed, 11 September 2002 05:09

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

can you post the part of alert file or trace?
Information provided is not enough for diagnosis

Report message to a moderator

Re: Oracle Instance Termination [message #53310 is a reply to message #53256]

Wed, 11 September 2002 23:48

Murali Mohan
Messages: 8
Registered: March 2002

Junior Member

Termination of Instance by following Backgound
Processes (CKPT,DBW0,LOGR) With Error No: 472.

This is due to Process Monitor Termination From SGA.

Our Oracle Version is 8.1.0
The Database is in Win NT
The Database is created Using Customized Option

Regards,
Prabhashankar

Report message to a moderator

Re: Oracle Instance Termination [message #53320 is a reply to message #53256]

Thu, 12 September 2002 06:08

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Okie.
the situtation is because, one of the background process terminiates
suddenly and causing the others to do fail.
eventaully PMON is also failing.
based on your posting, i believe, your logfiles are 
too small.(when logfiles are small, contention over CKPT and DBW may arise).
so, try to increase the logfile size..
and look specifically for the pmon trace files, lgwr trace files.
pls let me know the result~

Report message to a moderator

Re: Oracle Instance Termination [message #53386 is a reply to message #53256]

Tue, 17 September 2002 04:26

Murali Mohan
Messages: 8
Registered: March 2002

Junior Member

Report message to a moderator

Previous Topic:	exp tablespace
Next Topic:	Query with Slow Response

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 12:46:12 CDT 2024