Home » RDBMS Server » Server Administration » MY DATABASE CAN NOT START
MY DATABASE CAN NOT START [message #251341] Fri, 13 July 2007 01:27 Go to next message
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
Re: MY DATABASE CAN NOT START [message #251345 is a reply to message #251341] Fri, 13 July 2007 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
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
Re: MY DATABASE CAN NOT START [message #251378 is a reply to message #251341] Fri, 13 July 2007 06:53 Go to previous messageGo to next message
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.
Re: MY DATABASE CAN NOT START [message #251400 is a reply to message #251378] Fri, 13 July 2007 08:09 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
What is an ur file?
Re: MY DATABASE CAN NOT START [message #251405 is a reply to message #251378] Fri, 13 July 2007 08:16 Go to previous messageGo to next message
ThomasG
Messages: 3189
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.
Re: MY DATABASE CAN NOT START [message #251406 is a reply to message #251400] Fri, 13 July 2007 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
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 Go to previous messageGo to next message
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 .
icon10.gif  oracle is started when you restart the computer [message #253266 is a reply to message #251341] Mon, 23 July 2007 05:45 Go to previous messageGo to next message
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
Re: oracle is started when you restart the computer [message #253288 is a reply to message #253266] Mon, 23 July 2007 07:10 Go to previous message
Michel Cadot
Messages: 64153
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
Previous Topic: Test and development environment Oracle AS
Next Topic: Oracle 10g-Unix - Reliability Problem
Goto Forum:
  


Current Time: Sun Dec 11 06:33:40 CST 2016

Total time taken to generate the page: 0.08095 seconds