-
What is this error?
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [1403], [], [], [], [], [], [], []
How do I fix this?
-
ORA-00600 is an internal error, contact oracle support.
F.
-
I created a UNDO tablespace and added:
UNDO_MANGEMENT = AUTO
UNTO_TABLESPACE = UNDOTBS1
and restarted a 9.2 database and it won't start giving the above error. Luckily I have a cold backup at 11.26am this morning and I restored the cold backup and now even startup mount hangs like this:
ORA-00600: internal error code, arguments: [549], [], [], [], [], [], [], []
What could be wrong? I am on win2000 server. Is it a win2000 issue? I have 2- 9.2 databases running on this machine with about 512Meg. memory. The other database is working fine.
Last edited by newbie5; 02-05-2003 at 04:09 PM.
-
Originally posted by Mnemonical
ORA-00600 is an internal error, contact oracle support.
yes yeS yES YES
Not your fault at all, newbie5! (probably).
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
UNDO_MANGEMENT = AUTO
UNTO_TABLESPACE = UNDOTBS1
is that a typo or what
plus restoring old backup have you changed your init.ora to old setting?
-
Yes typo on Undo_Tablespace.
I restored the init.ora and the spfile.ora.
If there are two oracle9.2 instances on win2000 server, do I need to change any memory settings like unix semaphores?
-
What is UNDO_MANGEMENT? Did you mean UNDO_MANAGEMENT?
-
They are just typos in this post! Not actual init.ora entries! Had a rough day!!!
After battling four hours and offline dropping few datafiles I could bring the database up (without oracle support). However, it is very slow now. Shutdown takes 15 minutes!! startup another 15 minutes!!.
Can someone ignore my typos and gimme some hints are what is going on!!
Last edited by newbie5; 02-05-2003 at 07:04 PM.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|