OraFAQ Forum: Server Administration » unable to open oracle database

Home » RDBMS Server » Server Administration » unable to open oracle database

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

unable to open oracle database [message #51249]

Thu, 09 May 2002 02:06

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?

Report message to a moderator

Re: unable to open oracle database [message #51252 is a reply to message #51249]

Thu, 09 May 2002 05:16

NB
Messages: 4
Registered: February 2002

Junior Member

What platform-O/S and version of Oracle are you using?

Report message to a moderator

Re: unable to open oracle database [message #51255 is a reply to message #51252]

Thu, 09 May 2002 16:02

linda_121
Messages: 1
Registered: May 2002

Junior Member

Thanks,NB
I am using UNIX os.

Report message to a moderator

Re: unable to open oracle database [message #51295 is a reply to message #51249]

Tue, 14 May 2002 05:44

oraboyy
Messages: 2
Registered: May 2002

Junior Member

Hi,

Check the roll back segment optimal space.
oraboyy

Report message to a moderator

Re: unable to open oracle database [message #53580 is a reply to message #51249]

Mon, 30 September 2002 05:26

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

Report message to a moderator

Previous Topic:	Rollback segment error
Next Topic:	ora-12801 ORA-04030 -ORA-06512

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 19:51:17 CDT 2024