DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle Error reg SMON

  1. #1
    Join Date
    Aug 2001
    Location
    Dubai
    Posts
    41
    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

  2. #2
    Join Date
    Aug 2000
    Posts
    143
    Its always worth contacting oracle support over ORA-0600 messages.

  3. #3
    Join Date
    Feb 2001
    Posts
    389
    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.

  4. #4
    Join Date
    Aug 2001
    Location
    Dubai
    Posts
    41
    Thanks for the reply...

    Regards
    BJ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width