OraFAQ Forum: Server Administration » MY DATABASE CAN NOT START

Home » RDBMS Server » Server Administration » MY DATABASE CAN NOT START

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

MY DATABASE CAN NOT START [message #251341]

Fri, 13 July 2007 01:27

MELAKU
Messages: 32
Registered: April 2007
Location: ETHIOPIA

Member

Dear experts
We were trying to start our databse and gives us error as :

SQL> startup
ORACLE instance started.

Total System Global Area 2902458368 bytes
Fixed Size 1300152 bytes
Variable Size 949758280 bytes
Database Buffers 1946157056 bytes
Redo Buffers 5242880 bytes
ORA-00600: internal error code, arguments: [kccrbl_stale], [0], [484173],
[484158], [], [], [], []

Please any help. I am in a problem. I have also attached the alert log file

Attachment: alert_HIBRETDB.zip
(Size: 267.32KB, Downloaded 1062 times)

Report message to a moderator

Re: MY DATABASE CAN NOT START [message #251345 is a reply to message #251341]

Fri, 13 July 2007 01:33

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-00600 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel

Report message to a moderator

Re: MY DATABASE CAN NOT START [message #251378 is a reply to message #251341]

Fri, 13 July 2007 06:53

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

Melaku, errors starting with ORA-600 are internal errors. As Michel said, u can check metalink.

Also see ur file

/u01/app/oracle/admin/HIBRETDB/udump/hibretdb_ora_4094.trc

may be u can get a hint.

Report message to a moderator

Re: MY DATABASE CAN NOT START [message #251400 is a reply to message #251378]

Fri, 13 July 2007 08:09

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

What is an ur file?

Report message to a moderator

Re: MY DATABASE CAN NOT START [message #251405 is a reply to message #251378]

Fri, 13 July 2007 08:16

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

We had that once, If I remember correctly, It might be a corrupted control file because of an OS or disk error.

Did the OS or the machine have a crash?

If your case is the same as ours, then 484173 is the controlfile sequence number in the controlfile block, the 484158 is the one in the controlfile header, and they don't match.

Then you would either have to restore a backup of the controlfiles and recover the database, or re-create the controlfiles manually.

Report message to a moderator

Re: MY DATABASE CAN NOT START [message #251406 is a reply to message #251400]

Fri, 13 July 2007 08:16

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

What is an ur file?

Something from Mesopotamia. Laughing

[Updated on: Fri, 13 July 2007 08:17]

Report message to a moderator

Re: MY DATABASE CAN NOT START [message #251499 is a reply to message #251341]

Fri, 13 July 2007 17:47

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

Please any help. I am in a problem. I have also attached the alert log file

post last 100 lines from alertlog most of guys unable to download file .

Report message to a moderator

oracle is started when you restart the computer [message #253266 is a reply to message #251341]

Mon, 23 July 2007 05:45

iasial
Messages: 2
Registered: July 2007
Location: Islamabad pakistan

Junior Member

if your oracle is not started when you restart the computer,
1. first you login through this user and password.
username=internal
password=oracle
2. then you type startup of command line
3. after some configuration you able to connect through scott and tigar
ok
Iftikhar Ahmad

Report message to a moderator

Re: oracle is started when you restart the computer [message #253288 is a reply to message #253266]

Mon, 23 July 2007 07:10

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1. internal no more exists since version 9.0 released 2001. It's time to update your knowledge.

Moreover, I think either he solved his problem during the past 9 days or he recreated his database.

Regards
Michel

Report message to a moderator

Previous Topic:	Test and development environment Oracle AS
Next Topic:	Oracle 10g-Unix - Reliability Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:54:48 CDT 2024