-
Hello everybody..
Hi guys, Hope you will help in this sometimes my database comme up and while working it will start giving an error sometimes while connecting to a specific user like eeiusr its shows a message like
ora-24327 need explicit attach before authenticating a user
so when it do shutdown abort, it hangs then through services I close all the oracle process and then restart the machine and do an explicit startup , it starts the database but sometimes get different types of errors so i checked the sidalert.log file.
Some part of sidALERT.log file is displayed below :-
Wed Mar 27 19:06:32 2002
Thread 1 advanced to log sequence 98
Thread 1 opened at log sequence 98
Current log# 2 seq# 98 mem# 0: E:\ORACLE\ORADATA\ORACLEDB\REDO03.LOG
Successful open of redo thread 1.
Wed Mar 27 19:06:33 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Mar 27 19:06:36 2002
Completed: alter database open
Wed Mar 27 19:06:42 2002
Errors in file E:\Oracle\admin\ORACLEDB\bdump\oracledbSMON.TRC:
ORA-00600: internal error code, arguments: [4193], [0], [28], [], [], [], [], []
Wed Mar 27 19:07:27 2002
Recovery of Online Redo Log: Thread 1 Group 2 Seq 98 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\ORACLEDB\REDO03.LOG
Wed Mar 27 19:07:28 2002
Errors in file E:\Oracle\admin\ORACLEDB\bdump\oracledbSMON.TRC:
ORA-01595: error freeing extent (2) of rollback segment (3))
ORA-00600: internal error code, arguments: [4193], [0], [28], [], [], [], [], []
and the sidSMON.trc contains this error
........
..........
Repeat 1 times
kgghst * kwqma_p [DDAC7E4, DDAC7E8) = 0DDAE3A0
Dump of memory from 0xDDAE3A0 to 0xDDAE3E0
DDAE3A0 0DDAE388 00000003 00000000 40000000 40400000 00801910 008019A0 00000000
DDAE3C0 00000000 00000000 00000058 00801C20 00801C60 00000000 00000019 0DDAE394
kwqjw * kwqjwh_p [DDAC7E8, DDAC7EC) = 00000000
Dump of memory from 0x0 to 0x40
00 ******** ******** ******** ******** ******** ******** ******** ********
Repeat 1 times
knceug * kncem_p [DDAC7EC, DDAC7F0) = 00000000
Dump of memory from 0x0 to 0x40
00 ******** ******** ******** ******** ******** ******** ******** ********
Repeat 1 times
hogxdef* hogcu_p [DDAC7F0, DDAC7F4) = 00000000
Dump of memory from 0x0 to 0x40
00 ******** ******** ******** ******** ******** ******** ******** ********
Repeat 1 times
ub4 ksmugmg2 [DDAC7F4, DDAC7F8) = 0000CDCD
*** 2002.03.27.19.07.28.252
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (3))
ORA-00600: internal error code, arguments: [4193], [0], [28], [], [], [], [], []
----
Please if you all can help in this it will be greatly appreciated..
Thanks in advance
Regards
BJ
-
Its always worth contacting oracle support over ORA-0600 messages.
-
check metalink for bugs related to ORA24327 , make sure the client and server
tnsnames.ora and listener.ora enteries match.
Ignore ORA 600 smon , smon wakes up every 12 hrs to coalesce rollback segments
and if the extents are used by active transactions it gets those errors.It will try again in next cycle.
-
Thanks for the reply...
Regards
BJ
