OraFAQ Forum: Server Administration » ORA-03113: end-of-file on communication channel

Home » RDBMS Server » Server Administration » ORA-03113: end-of-file on communication channel (oracle 11g on windows 7 home)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-03113: end-of-file on communication channel [message #490785]

Thu, 27 January 2011 06:11

rishi_raj
Messages: 4
Registered: January 2011

Junior Member

I start sql*plus and start working.
after 2-3 minutes i get error -

ORA-03113: end-of-file on communication channel.

I googled and found to see alert.log.(but i found no such file on my system)

but in my system i found some info at C:\\app\rishi\product\11.1.0\db_1\log\rishi-pc\client\clsc42.txt

the content of the file is ;

********************************************
Oracle Database 11g CRS Release 11.1.0.6.0 - Production Copyright 1996, 2007 Oracle. All rights reserved.
2011-01-27 12:35:03.512: [ OCROSD][3332]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.

2011-01-27 12:35:03.512: [ OCRRAW][3332]proprinit: Could not open raw device
2011-01-27 12:35:03.512: [ default][3332]a_init:7!: Backend init unsuccessful : [33]
2011-01-27 12:35:04.617: [ CSSCLNT][3332]clsssinit: error(32 PROC-32: Cluster Ready Services on the local node is not running Messaging error [9]) in OCR initialization

*************************************************

Please help. I am getting the same error evert time i login.
Tried to stop/start oracle services but problem persists...

Attachment: clsc42.log
(Size: 0.61KB, Downloaded 1380 times)

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #490896 is a reply to message #490785]

Fri, 28 January 2011 01:48

mmee
Messages: 38
Registered: July 2007

Member

hi,

can i get more details on this ..

1)init parameter file
2)profile os level
3)just check and give the output inittab
4)OS details

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #490900 is a reply to message #490896]

Fri, 28 January 2011 02:09

rishi_raj
Messages: 4
Registered: January 2011

Junior Member

details of init.ora
******************
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

###########################################
# Cache and I/O
###########################################
db_block_size=8192

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Database Identification
###########################################
db_domain=""
db_name=orcl

###########################################
# File Configuration
###########################################
control_files=("C:\app\rishi\oradata\orcl\control01.ctl", "C:\app\rishi\oradata\orcl\control02.ctl", "C:\app\rishi\oradata\orcl\control03.ctl")
db_recovery_file_dest=C:\app\rishi\flash_recovery_area
db_recovery_file_dest_size=2147483648

###########################################
# Miscellaneous
###########################################
compatible=11.1.0.0.0
diagnostic_dest=C:\app\rishi
memory_target=1176502272

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# Security and Auditing
###########################################
audit_file_dest=C:\app\rishi\admin\orcl\adump
audit_trail=db
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=orclXDB)"

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_tablespace=UNDOTBS1

*****************

os details: windows 7 home edition/oracle 11g 11.1.0.6.0

i dont know your inittab question and how to check that.I searched my C: drive but no such file named inittab.

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #490903 is a reply to message #490785]

Fri, 28 January 2011 02:21

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

You said
Quote:

I googled and found to see alert.log.(but i found no such file on my system)

Your alert log is
C:\app\rishi\diag\rdbms\orcl\orcl\trace\alert_orcl.log

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #490920 is a reply to message #490903]

Fri, 28 January 2011 03:06

rishi_raj
Messages: 4
Registered: January 2011

Junior Member

My alert log says -

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Fri Jan 28 12:34:24 2011
Using parameter settings in server-side spfile C:\APP\RISHI\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes = 150
memory_target = 1128M
control_files = "C:\APP\RISHI\ORADATA\ORCL\CONTROL01.CTL"
control_files = "C:\APP\RISHI\ORADATA\ORCL\CONTROL02.CTL"
control_files = "C:\APP\RISHI\ORADATA\ORCL\CONTROL03.CTL"
db_block_size = 8192
compatible = "11.1.0.0.0"
db_recovery_file_dest = "C:\app\rishi\flash_recovery_area"
db_recovery_file_dest_size= 2G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
Fri Jan 28 12:34:34 2011
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
audit_file_dest = "C:\APP\RISHI\ADMIN\ORCL\ADUMP"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 300
diagnostic_dest = "C:\APP\RISHI"
Fri Jan 28 12:34:40 2011
PMON started with pid=2, OS id=5900
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
Fri Jan 28 12:34:40 2011
VKTM started with pid=3, OS id=1832 at elevated priority
VKTM running at (20)ms precision
Fri Jan 28 12:34:40 2011
DIAG started with pid=4, OS id=3780
Fri Jan 28 12:34:40 2011
DBRM started with pid=5, OS id=2960
Fri Jan 28 12:34:40 2011
PSP0 started with pid=6, OS id=5944
Fri Jan 28 12:34:40 2011
DSKM started with pid=7, OS id=2156
Fri Jan 28 12:34:40 2011
DIA0 started with pid=8, OS id=5332
Fri Jan 28 12:34:40 2011
MMAN started with pid=9, OS id=4364
Fri Jan 28 12:34:49 2011
DBW0 started with pid=7, OS id=1448
Fri Jan 28 12:34:49 2011
LGWR started with pid=10, OS id=4380
Fri Jan 28 12:34:49 2011
CKPT started with pid=11, OS id=4432
Fri Jan 28 12:34:49 2011
SMON started with pid=12, OS id=4900
Fri Jan 28 12:34:49 2011
RECO started with pid=13, OS id=2696
Fri Jan 28 12:34:49 2011
MMON started with pid=14, OS id=2936
Fri Jan 28 12:34:49 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = C:\app\rishi
Fri Jan 28 12:34:58 2011
alter database mount exclusive
Fri Jan 28 12:34:59 2011
Sweep Incident[60257]: completed
Sweep Incident[60256]: completed
Setting recovery target incarnation to 2
Fri Jan 28 12:35:04 2011
Successful mount of redo thread 1, with mount id 1269427699
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Fri Jan 28 12:35:09 2011
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Started redo scan
Completed redo scan
73257 redo blocks read, 910 data blocks need recovery
Started redo application at
Thread 1: logseq 793, block 58877
Recovery of Online Redo Log: Thread 1 Group 1 Seq 793 Reading mem 0
Mem# 0: C:\APP\RISHI\ORADATA\ORCL\REDO01.LOG
Fri Jan 28 12:35:20 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 794 Reading mem 0
Mem# 0: C:\APP\RISHI\ORADATA\ORCL\REDO02.LOG
Completed redo application
Completed crash recovery at
Thread 1: logseq 794, block 36446, scn 26923921
910 data blocks read, 885 data blocks written, 73257 redo blocks read
Fri Jan 28 12:35:27 2011
Thread 1 advanced to log sequence 795
Thread 1 opened at log sequence 795
Current log# 3 seq# 795 mem# 0: C:\APP\RISHI\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jan 28 12:35:31 2011
SMON: enabling cache recovery
Fri Jan 28 12:35:31 2011
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Fri Jan 28 12:35:35 2011
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_p004_2956.trc (incident=61546):
ORA-00600: internal error code, arguments: [25026], [18433], [8471410], [], [], [], [], []
Incident details in: c:\app\rishi\diag\rdbms\orcl\orcl\incident\incdir_61546\orcl_p004_2956_i61546.trc
Database Characterset is WE8MSWIN1252
Opening with internal Resource Manager plan
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_smon_4900.trc (incident=61458):
ORA-00600: internal error code, arguments: [25026], [18433], [8471410], [], [], [], [], []
Incident details in: c:\app\rishi\diag\rdbms\orcl\orcl\incident\incdir_61458\orcl_smon_4900_i61458.trc
Fri Jan 28 12:35:37 2011
Trace dumping is performing id=[cdmp_20110128123537]
Fri Jan 28 12:35:41 2011
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
System State dumped to trace file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_smon_4900.trc
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_smon_4900.trc (incident=61459):
ORA-00600: internal error code, arguments: [4142], [18433], [], [], [], [], [], []
Incident details in: c:\app\rishi\diag\rdbms\orcl\orcl\incident\incdir_61459\orcl_smon_4900_i61459.trc
Starting background process FBDA
Fri Jan 28 12:35:47 2011
Starting background process SMCO
Fri Jan 28 12:35:47 2011
SMCO started with pid=28, OS id=4188
ORACLE Instance orcl (pid = 12) - Error 600 encountered while recovering transaction (8, 2) on object 65168.
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_smon_4900.trc:
ORA-00600: internal error code, arguments: [4142], [18433], [], [], [], [], [], []
Trace dumping is performing id=[cdmp_20110128123546]
Fri Jan 28 12:35:47 2011
FBDA started with pid=27, OS id=2512
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Fri Jan 28 12:35:56 2011
QMNC started with pid=30, OS id=3892
Fri Jan 28 12:36:06 2011
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Fri Jan 28 12:36:13 2011
Sweep Incident[61546]: completed
Sweep Incident[61459]: completed
Sweep Incident[61458]: completed
Fri Jan 28 12:36:24 2011
Completed: alter database open
Fri Jan 28 12:39:59 2011
Starting background process CJQ0
Fri Jan 28 12:39:59 2011
CJQ0 started with pid=39, OS id=5220
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified !
Fri Jan 28 12:40:10 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:40:24 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:40:37 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:40:50 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:40:58 2011
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_p004_3636.trc (incident=61547):
ORA-00600: internal error code, arguments: [25026], [18433], [8471410], [], [], [], [], []
Incident details in: c:\app\rishi\diag\rdbms\orcl\orcl\incident\incdir_61547\orcl_p004_3636_i61547.trc
Fri Jan 28 12:41:01 2011
Trace dumping is performing id=[cdmp_20110128124101]
Fri Jan 28 12:41:02 2011
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_smon_4900.trc (incident=61460):
ORA-00600: internal error code, arguments: [25026], [18433], [8471410], [], [], [], [], []
Incident details in: c:\app\rishi\diag\rdbms\orcl\orcl\incident\incdir_61460\orcl_smon_4900_i61460.trc
Fri Jan 28 12:41:04 2011
Sweep Incident[61547]: completed
Fri Jan 28 12:41:04 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Trace dumping is performing id=[cdmp_20110128124107]
Sweep Incident[61460]: completed
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
System State dumped to trace file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_smon_4900.trc
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:41:15 2011
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_smon_4900.trc (incident=61461):
ORA-00600: internal error code, arguments: [4142], [18433], [], [], [], [], [], []
Incident details in: c:\app\rishi\diag\rdbms\orcl\orcl\incident\incdir_61461\orcl_smon_4900_i61461.trc
ORACLE Instance orcl (pid = 12) - Error 600 encountered while recovering transaction (8, 2) on object 65168.
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_smon_4900.trc:
ORA-00600: internal error code, arguments: [4142], [18433], [], [], [], [], [], []
Fri Jan 28 12:41:20 2011
Trace dumping is performing id=[cdmp_20110128124120]
Fri Jan 28 12:41:21 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:41:36 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:41:50 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:42:03 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:42:04 2011
Sweep Incident[61461]: completed
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:42:16 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:42:30 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:42:43 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:42:56 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:43:09 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:43:23 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:43:36 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:43:49 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:44:02 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:44:15 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:44:29 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:44:42 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:44:55 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:45:08 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:45:22 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:45:35 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:45:48 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:46:01 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:46:10 2011
Thread 1 advanced to log sequence 796
Current log# 1 seq# 796 mem# 0: C:\APP\RISHI\ORADATA\ORCL\REDO01.LOG
Fri Jan 28 12:46:14 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:46:24 2011
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_p004_3428.trc (incident=61548):
ORA-00600: internal error code, arguments: [25026], [18433], [8471410], [], [], [], [], []
Incident details in: c:\app\rishi\diag\rdbms\orcl\orcl\incident\incdir_61548\orcl_p004_3428_i61548.trc
Fri Jan 28 12:46:27 2011
Trace dumping is performing id=[cdmp_20110128124627]
Fri Jan 28 12:46:28 2011
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:46:29 2011
Sweep Incident[61548]: completed
Fri Jan 28 12:46:28 2011
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_smon_4900.trc (incident=61462):
ORA-00600: internal error code, arguments: [25026], [18433], [8471410], [], [], [], [], []
Incident details in: c:\app\rishi\diag\rdbms\orcl\orcl\incident\incdir_61462\orcl_smon_4900_i61462.trc
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
System State dumped to trace file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_smon_4900.trc
Trace dumping is performing id=[cdmp_20110128124634]
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_smon_4900.trc (incident=61463):
ORA-00600: internal error code, arguments: [4142], [18433], [], [], [], [], [], []
Incident details in: c:\app\rishi\diag\rdbms\orcl\orcl\incident\incdir_61463\orcl_smon_4900_i61463.trc
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
Fri Jan 28 12:46:40 2011
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:46:40 2011
Trace dumping is performing id=[cdmp_20110128124640]
ORACLE Instance orcl (pid = 12) - Error 600 encountered while recovering transaction (8, 2) on object 65168.
Fri Jan 28 12:46:44 2011
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_smon_4900.trc:
ORA-00600: internal error code, arguments: [4142], [18433], [], [], [], [], [], []
Process debug not enabled via parameter _debug_enable
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
Fri Jan 28 12:46:52 2011
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_pmon_5900.trc:
ORA-00474: SMON process terminated with error
PMON (ospid: 5900): terminating the instance due to error 474
Fri Jan 28 12:46:53 2011
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_j000_4056.trc:
ORA-00474: SMON process terminated with error
ORA-1092 : opidrv aborting process J000 ospid (3452_4056)
Fri Jan 28 12:46:54 2011
Errors in file c:\app\rishi\diag\rdbms\orcl\orcl\trace\orcl_q001_2116.trc:
ORA-00474: SMON process terminated with error
ORA-1092 : opidrv aborting process Q001 ospid (3452_2116)
Fri Jan 28 12:46:54 2011
ORA-1092 : opidrv aborting process W000 ospid (3452_5912)
Fri Jan 28 12:46:55 2011
ORA-474 : opidrv aborting process S000 ospid (3452_4328)
Fri Jan 28 12:46:54 2011
ORA-1092 : opiodr aborting process unknown ospid (3452_5412)
Fri Jan 28 12:46:59 2011
ORA-1092 : opitsk aborting process
Fri Jan 28 12:46:55 2011
ORA-1092 : opiodr aborting process unknown ospid (3452_3948)
Fri Jan 28 12:47:01 2011
ORA-1092 : opitsk aborting process
Fri Jan 28 12:47:00 2011
ORA-1092 : opiodr aborting process unknown ospid (3452_4324)
Fri Jan 28 12:47:03 2011
ORA-1092 : opitsk aborting process
Fri Jan 28 12:46:58 2011
ORA-1092 : opiodr aborting process unknown ospid (3452_5076)
Fri Jan 28 12:47:04 2011
ORA-1092 : opitsk aborting process
Fri Jan 28 12:47:07 2011
Instance terminated by PMON, pid = 5900

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

I cant figure out why it is happening.I am new to oracle so dont know much details..please help me out someone.

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #490928 is a reply to message #490920]

Fri, 28 January 2011 03:27

mmee
Messages: 38
Registered: July 2007

Member

Install 32-bit Oracle database software only on 32-bit MS Windows OS.Installed 32-bit Oracle database software on a 64-bit MS Windows OS which is not supported.

give me output

select * from v$version where banner like 'Oracle%';

and run sqlplus in command hit enter button then show me the output..

-----------
better u have to check OS and DB version

[Updated on: Fri, 28 January 2011 03:43]

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #490933 is a reply to message #490920]

Fri, 28 January 2011 03:44

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #490946 is a reply to message #490928]

Fri, 28 January 2011 04:24

rishi_raj
Messages: 4
Registered: January 2011

Junior Member

this is whati get..

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Jan 28 15:46:03 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Enter user-name: scott
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL> select * from v$version where banner like 'Oracle%';

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

SQL>
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

SQL>

*************************************
my windows 7 home is 64-bit.....

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #490966 is a reply to message #490946]

Fri, 28 January 2011 05:17

mmee
Messages: 38
Registered: July 2007

Member

i guees your db version 32 bit ..

so installed correct version oracle DB....it will work

Report message to a moderator

Previous Topic:	Need to configure watchdog for Oracle DB 11g on Redhat linux
Next Topic:	What happens when UNDO space is full? Transaction takes more time to ERROR?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 13:16:38 CST 2024