1 2 Previous Next 27 Replies Latest reply: Dec 5, 2012 4:59 AM by Osama_Mustafa Go to original post RSS
      • 15. Re: common problem but do help
        AlexandarVu
        You have installed Oracle XE if I'm right.

        Then go to C:\oraclexe\app\oracle\admin\XE\bdump directory.
        There is a file alert.log. ;)

        Edited by: AlexandarVu on Dec 5, 2012 1:17 AM
        • 16. Re: common problem but do help
          Osama_Mustafa
          is there any difference between this step and what i post before ;)
          • 17. Re: common problem but do help
            NickRobheart
            Osama_mustafa wrote:
            is there any difference between this step and what i post before ;)
            Well, you havent given me the exact directory path as Alex did so was confused sorry :)
            AlexandarVu wrote:
            You have installed Oracle XE if I'm right.

            Then go to C:\oraclexe\app\oracle\admin\XE\bdump directory.
            There is a file alert.log. ;)

            Edited by: AlexandarVu on Dec 5, 2012 1:17 AM
            Hope that was it AlexandarVu, I might have confused you guys in the first place.

            Finally, phewww....(Just a slight sigh of relief there)
            I found the alert log now in C:\oraclexe\app\oracle\admin\XE\bdump directory and it said as alert_xe log which is a text document actually.
            So opened it and found a huge data in this log.


            So now guys tell me what shall I post from this log??
            The one's that say with date Dec 4 or Dec 5 which are at the end of the log ?!

            Edited by: NickRobheart on Dec 5, 2012 3:03 PM
            • 18. Re: common problem but do help
              Osama_Mustafa
              Just Copy & past about 50-60 lines
              • 19. Re: common problem but do help
                NickRobheart
                Instance terminated by PMON, pid = 2312
                Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                Wed Dec 05 14:04:04 2012
                ORACLE V10.2.0.1.0 - Production vsnsta=0
                vsnsql=14 vsnxtr=3
                Windows NT Version V6.1
                CPU : 2 - type 586, 2 Physical Cores
                Process Affinity : 0x00000000
                Memory (Avail/Total): Ph:78M/447M, Ph+PgF:1093M/1471M, VA:1934M/2047M
                Wed Dec 05 14:04:04 2012
                Starting ORACLE instance (normal)
                LICENSE_MAX_SESSION = 0
                LICENSE_SESSIONS_WARNING = 0
                Picked latch-free SCN scheme 2
                Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                Autotune of undo retention is turned on.
                IMODE=BR
                ILAT =10
                LICENSE_MAX_USERS = 0
                SYS auditing is disabled
                ksdpec: called for event 13740 prior to event group initialization
                Starting up ORACLE RDBMS Version: 10.2.0.1.0.
                System parameters with non-default values:
                sessions = 49
                __shared_pool_size = 50331648
                __large_pool_size = 4194304
                __java_pool_size = 4194304
                __streams_pool_size = 0
                spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                sga_target = 146800640
                control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                __db_cache_size = 83886080
                compatible = 10.2.0.1.0
                db_recovery_file_dest = C:\oraclexe\app\oracle\flash_recovery_area
                db_recovery_file_dest_size= 10737418240
                undo_management = AUTO
                undo_tablespace = UNDO
                remote_login_passwordfile= EXCLUSIVE
                dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                shared_servers = 4
                job_queue_processes = 4
                audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                db_name = XE
                open_cursors = 300
                os_authent_prefix =
                pga_aggregate_target = 31457280
                PSP0 started with pid=3, OS id=2144
                PMON started with pid=2, OS id=2140
                MMAN started with pid=4, OS id=2148
                DBW0 started with pid=5, OS id=2168
                LGWR started with pid=6, OS id=2172
                CKPT started with pid=7, OS id=2176
                SMON started with pid=8, OS id=2180
                RECO started with pid=9, OS id=2184
                CJQ0 started with pid=10, OS id=2188
                MMON started with pid=11, OS id=2192
                MMNL started with pid=12, OS id=2196
                Wed Dec 05 14:04:26 2012
                starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                starting up 4 shared server(s) ...
                Oracle Data Guard is not available in this edition of Oracle.
                Wed Dec 05 14:04:28 2012
                alter database mount exclusive
                Wed Dec 05 14:04:33 2012
                Setting recovery target incarnation to 2
                Wed Dec 05 14:04:33 2012
                Successful mount of redo thread 1, with mount id 2682325037
                Wed Dec 05 14:04:33 2012
                Database mounted in Exclusive Mode
                Completed: alter database mount exclusive
                Wed Dec 05 14:04:34 2012
                alter database open
                Wed Dec 05 14:04:34 2012
                Beginning crash recovery of 1 threads
                Wed Dec 05 14:04:35 2012
                Started redo scan
                Wed Dec 05 14:04:35 2012
                Completed redo scan
                1310 redo blocks read, 323 data blocks need recovery
                Wed Dec 05 14:04:36 2012
                Started redo application at
                Thread 1: logseq 49, block 3
                Wed Dec 05 14:04:36 2012
                Recovery of Online Redo Log: Thread 1 Group 2 Seq 49 Reading mem 0
                Mem# 0 errs 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_8B9W59HK_.LOG
                Wed Dec 05 14:04:38 2012
                Completed redo application
                Wed Dec 05 14:04:38 2012
                Completed crash recovery at
                Thread 1: logseq 49, block 1313, scn 1223179
                323 data blocks read, 323 data blocks written, 1310 redo blocks read
                Wed Dec 05 14:04:40 2012
                Thread 1 advanced to log sequence 50
                Thread 1 opened at log sequence 50
                Current log# 1 seq# 50 mem# 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_8B9W587Z_.LOG
                Successful open of redo thread 1
                Wed Dec 05 14:04:41 2012
                SMON: enabling cache recovery
                Wed Dec 05 14:04:45 2012
                Successfully onlined Undo Tablespace 1.
                Wed Dec 05 14:04:45 2012
                SMON: enabling tx recovery
                Wed Dec 05 14:04:46 2012
                Database Characterset is WE8MSWIN1252
                replication_dependency_tracking turned off (no async multimaster replication found)
                Wed Dec 05 14:04:48 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_smon_2180.trc:
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []

                Starting background process QMNC
                QMNC started with pid=19, OS id=2276
                Wed Dec 05 14:04:58 2012
                Doing block recovery for file 2 block 5223
                Block recovery from logseq 50, block 75 to scn 1223448
                Wed Dec 05 14:04:58 2012
                Recovery of Online Redo Log: Thread 1 Group 1 Seq 50 Reading mem 0
                Mem# 0 errs 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_8B9W587Z_.LOG
                Block recovery stopped at EOT rba 50.85.16
                Block recovery completed at rba 50.85.16, scn 0.1223445
                Doing block recovery for file 2 block 89
                Wed Dec 05 14:05:00 2012
                Block recovery from logseq 50, block 75 to scn 1223431
                Wed Dec 05 14:05:00 2012
                Recovery of Online Redo Log: Thread 1 Group 1 Seq 50 Reading mem 0
                Mem# 0 errs 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_8B9W587Z_.LOG
                Wed Dec 05 14:05:01 2012
                Completed: alter database open
                Block recovery completed at rba 50.75.16, scn 0.1223432
                Wed Dec 05 14:05:02 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_smon_2180.trc:
                ORA-01595: error freeing extent (2) of rollback segment (6))
                ORA-00607: Internal error occurred while making a change to a data block
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []

                Wed Dec 05 14:05:04 2012
                db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
                user-specified limit on the amount of space that will be used by this
                database for recovery-related files, and does not reflect the amount of
                space available in the underlying filesystem or ASM diskgroup.
                Wed Dec 05 14:05:09 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_mmon_2192.trc:
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-24033: no recipients for message

                Flush retried for xcb 0x6b2a38f4, pmd 0x6b377688
                Wed Dec 05 14:05:15 2012
                Doing block recovery for file 2 block 5223
                Block recovery from logseq 50, block 75 to scn 1223448
                Wed Dec 05 14:05:15 2012
                Recovery of Online Redo Log: Thread 1 Group 1 Seq 50 Reading mem 0
                Mem# 0 errs 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_8B9W587Z_.LOG
                Block recovery completed at rba 50.85.16, scn 0.1223450
                Wed Dec 05 14:05:17 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_mmon_2192.trc:
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-24033: no recipients for message

                Wed Dec 05 14:05:27 2012
                Flush retried for xcb 0x6b2a38f4, pmd 0x6b377688
                Doing block recovery for file 2 block 5223
                Block recovery from logseq 50, block 75 to scn 1223448
                Wed Dec 05 14:05:27 2012
                Recovery of Online Redo Log: Thread 1 Group 1 Seq 50 Reading mem 0
                Mem# 0 errs 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_8B9W587Z_.LOG
                Block recovery completed at rba 50.85.16, scn 0.1223450
                Wed Dec 05 14:05:29 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_mmon_2192.trc:
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-24033: no recipients for message

                Flush retried for xcb 0x6b2a38f4, pmd 0x6b377688
                Doing block recovery for file 2 block 5223
                Block recovery from logseq 50, block 75 to scn 1223448
                Wed Dec 05 14:05:34 2012
                Recovery of Online Redo Log: Thread 1 Group 1 Seq 50 Reading mem 0
                Mem# 0 errs 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_8B9W587Z_.LOG
                Block recovery completed at rba 50.85.16, scn 0.1223450
                Wed Dec 05 14:05:39 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_mmon_2192.trc:
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-24033: no recipients for message

                Wed Dec 05 14:08:41 2012
                Flush retried for xcb 0x6b2a38f4, pmd 0x6b377688
                Doing block recovery for file 2 block 5223
                Block recovery from logseq 50, block 75 to scn 1223448
                Wed Dec 05 14:08:42 2012
                Recovery of Online Redo Log: Thread 1 Group 1 Seq 50 Reading mem 0
                Mem# 0 errs 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_8B9W587Z_.LOG
                Block recovery completed at rba 50.85.16, scn 0.1223450
                Wed Dec 05 14:08:44 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_mmon_2192.trc:
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-00001: unique constraint (SYS.RECENT_RESOURCE_INCARNATIONS$P) violated

                Flush retried for xcb 0x6b2a38f4, pmd 0x6b377688
                Doing block recovery for file 2 block 5223
                Block recovery from logseq 50, block 75 to scn 1223448
                Wed Dec 05 14:08:49 2012
                Recovery of Online Redo Log: Thread 1 Group 1 Seq 50 Reading mem 0
                Mem# 0 errs 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_8B9W587Z_.LOG
                Block recovery completed at rba 50.85.16, scn 0.1223450
                Wed Dec 05 14:08:50 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_mmon_2192.trc:
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                ORA-00001: unique constraint (SYS.RECENT_RESOURCE_INCARNATIONS$P) violated

                Wed Dec 05 14:10:04 2012
                Flush retried for xcb 0x6b2a38f4, pmd 0x6b377688
                Doing block recovery for file 2 block 5223
                Block recovery from logseq 50, block 75 to scn 1223448
                Wed Dec 05 14:10:07 2012
                Recovery of Online Redo Log: Thread 1 Group 1 Seq 50 Reading mem 0
                Mem# 0 errs 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_8B9W587Z_.LOG
                Block recovery completed at rba 50.85.16, scn 0.1223450
                Wed Dec 05 14:10:11 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_smon_2180.trc:
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []

                Wed Dec 05 14:10:19 2012
                Fatal internal error happened while SMON was doing active transaction recovery.
                Wed Dec 05 14:10:19 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_smon_2180.trc:
                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []

                SMON: terminating instance due to error 474
                Wed Dec 05 14:10:20 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_2172.trc:
                ORA-00474: SMON process terminated with error

                Wed Dec 05 14:10:21 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_q001_2320.trc:
                ORA-00474: SMON process terminated with error

                Wed Dec 05 14:10:21 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_dbw0_2168.trc:
                ORA-00474: SMON process terminated with error

                Wed Dec 05 14:10:22 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_psp0_2144.trc:
                ORA-00474: SMON process terminated with error

                Wed Dec 05 14:10:22 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_ckpt_2176.trc:
                ORA-00474: SMON process terminated with error

                Wed Dec 05 14:10:23 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_pmon_2140.trc:
                ORA-00474: SMON process terminated with error

                Wed Dec 05 14:10:24 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_mman_2148.trc:
                ORA-00474: SMON process terminated with error

                Wed Dec 05 14:10:30 2012
                Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_reco_2184.trc:
                ORA-00474: SMON process terminated with error

                Wed Dec 05 14:10:31 2012
                Instance terminated by SMON, pid = 2180
                • 20. Re: common problem but do help
                  Osama_Mustafa
                  ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                  you ORA-00600 Error which indicate to bug go to https://support.oracle.com and Open SR
                  • 21. Re: common problem but do help
                    NickRobheart
                    Osama_mustafa wrote:
                    ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                    you ORA-00600 Error which indicate to bug go to https://support.oracle.com and Open SR
                    Sure, but a Quick questin
                    Was trying to open an SR that but after I login, it was asking for some
                    Add Support Identifiers, How do I go about it?
                    • 22. Re: common problem but do help
                      Fran
                      it's a bug:
                      ORA-600 [4193] "seq# mismatch while adding undo record" [ID 39282.1]
                      Bug 8240762 Undo corruptions with ORA-600 [4193]/ORA-600 [4194] or ORA-600 [4137] / SMON may spin to recover transaction

                      a workaround (not tested):
                      Add ALLOWRESETLOGS_CORRUPTION=TRUE at init.ora.
                      http://practicalappsdba.wordpress.com/2008/04/01/how-to-recover-and-open-the-database-if-the-archive-log-required-for-recovery-is-missing/

                      you has installed version 10.2.0.1.0, you should install 11gR2 (bug is fixed):
                      http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

                      Edited by: Fran on 05-dic-2012 2:04
                      Sure, but a Quick questin
                      Was trying to open an SR that but after I login, it was asking for some 
                      Add Support Identifiers, How do I go about it?
                      You haven't licence for Oracle Support. You need to pay for Oracle Support.

                      Edited by: Fran on 05-dic-2012 2:06
                      • 23. Re: common problem but do help
                        NickRobheart
                        Thanks a ton Fran, Osama and Alex and every one else for your replies.
                        I'm really happy to be a part of this forum and have you guys helping me.
                        I will try that and will post back if I need anything else.
                        • 24. Re: common problem but do help
                          Fran
                          please, if you think your question is answered, mark this thread as answered to close it.

                          HTH
                          • 25. Re: common problem but do help
                            NickRobheart
                            Fran wrote:
                            please, if you think your question is answered, mark this thread as answered to close it.

                            HTH
                            Yes, Thanks and I know how important it is.
                            I'm a Certified Dell Social Media and Community Professional myself and know few courtesies and basics , Done that already.

                            Edited by: NickRobheart on Dec 5, 2012 3:53 PM
                            • 26. Re: common problem but do help
                              Girish Sharma
                              And if you have access to MOS notes then read below MOS note :
                              <<Note 39282.1>> ORA-600 [4193] "seq# mismatch while adding undo record"

                              A mismatch has been detected between Redo records and Rollback (Undo) records.
                              We are validating the Undo block sequence number in the undo block against the Redo block sequence number relating to the change being applied.
                              This error is reported when this validation fails.

                              Regards
                              Girish Sharma
                              • 27. Re: common problem but do help
                                Osama_Mustafa
                                NickRobheart wrote:
                                Osama_mustafa wrote:
                                ORA-00600: internal error code, arguments: [4193], [43], [84], [], [], [], [], []
                                you ORA-00600 Error which indicate to bug go to https://support.oracle.com and Open SR
                                Sure, but a Quick questin
                                Was trying to open an SR that but after I login, it was asking for some
                                Add Support Identifiers, How do I go about it?
                                Check wit Oracle local office in your country about that , you should have valid license
                                1 2 Previous Next