Home » RDBMS Server » Server Administration » unable to open oracle database
unable to open oracle database [message #51249] Thu, 09 May 2002 02:06 Go to next message
Linda
Messages: 22
Registered: July 2000
Junior Member
this is the message i get when i startup database:
>startup
.....
ORA-00704:bootstrap process failture
ORA-00604:error occured at recurise SQL level 1
ORA-01555:snapshot too old:rollback segment number 3 with name '???' too small

Can anyone help me?
Re: unable to open oracle database [message #51252 is a reply to message #51249] Thu, 09 May 2002 05:16 Go to previous messageGo to next message
NB
Messages: 4
Registered: February 2002
Junior Member
What platform-O/S and version of Oracle are you using?
Re: unable to open oracle database [message #51255 is a reply to message #51252] Thu, 09 May 2002 16:02 Go to previous messageGo to next message
linda_121
Messages: 1
Registered: May 2002
Junior Member
Thanks,NB
I am using UNIX os.
Re: unable to open oracle database [message #51295 is a reply to message #51249] Tue, 14 May 2002 05:44 Go to previous messageGo to next message
oraboyy
Messages: 2
Registered: May 2002
Junior Member
Hi,

Check the roll back segment optimal space.
oraboyy
Re: unable to open oracle database [message #53580 is a reply to message #51249] Mon, 30 September 2002 05:26 Go to previous message
arizuddin
Messages: 11
Registered: February 2002
Junior Member
you try this
1.increase minextents value.
2. make all extents larger.
3. increase Optimal value also.

arizuddin
ocp dba
Previous Topic: Rollback segment error
Next Topic: ora-12801 ORA-04030 -ORA-06512
Goto Forum:
  


Current Time: Fri Dec 27 00:40:13 CST 2024