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

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

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?

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.

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