common problem but do help | Oracle Community

15. Re: common problem but do help

AlexandarVu Dec 5, 2012 1:17 AM (in response to NickRobheart)

Currently Being Moderated

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 Dec 5, 2012 1:24 AM (in response to AlexandarVu)

Currently Being Moderated

is there any difference between this step and what i post before ;)

17. Re: common problem but do help

NickRobheart Dec 5, 2012 1:34 AM (in response to Osama_Mustafa)

Currently Being Moderated

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 Dec 5, 2012 1:46 AM (in response to NickRobheart)

Currently Being Moderated

Just Copy & past about 50-60 lines

19. Re: common problem but do help

NickRobheart Dec 5, 2012 1:48 AM (in response to NickRobheart)

Currently Being Moderated

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 Dec 5, 2012 1:55 AM (in response to NickRobheart)

Currently Being Moderated

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 Dec 5, 2012 2:02 AM (in response to Osama_Mustafa)

Currently Being Moderated

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 Dec 5, 2012 2:07 AM (in response to NickRobheart)

Currently Being Moderated

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 Dec 5, 2012 2:15 AM (in response to Fran)

Currently Being Moderated

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 Dec 5, 2012 2:20 AM (in response to NickRobheart)

Currently Being Moderated

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 Dec 5, 2012 2:24 AM (in response to Fran)

Currently Being Moderated

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 Dec 5, 2012 2:26 AM (in response to NickRobheart)

Currently Being Moderated

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 Dec 5, 2012 2:59 AM (in response to NickRobheart)

Currently Being Moderated

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

15. Re: common problem but do help

16. Re: common problem but do help

17. Re: common problem but do help

18. Re: common problem but do help

19. Re: common problem but do help

20. Re: common problem but do help

21. Re: common problem but do help

22. Re: common problem but do help

23. Re: common problem but do help

24. Re: common problem but do help

25. Re: common problem but do help

26. Re: common problem but do help

27. Re: common problem but do help

Actions

Legend