Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01114

729201Dec 29 2009 — edited Dec 29 2009
Hi,
I have this error many times on file 202 and file 3.
File 3 is the datafile for SYSAUX and 202 the tempfile

I have check my backup rman and i have not corrupted blocs.
I have dropped my tempfile and recreate but the problem is not solved.
My database is on AIX 5L in oracle version 10.2.0.4


Alert.log
Mon Dec 28 21:30:43 2009
Thread 2 advanced to log sequence 27429 (LGWR switch)
Current log# 3 seq# 27429 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_3.265.667479419
Current log# 3 seq# 27429 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_3.259.667479419
Mon Dec 28 21:31:22 2009
Thread 2 cannot allocate new log, sequence 27430
Checkpoint not complete
Current log# 3 seq# 27429 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_3.265.667479419
Current log# 3 seq# 27429 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_3.259.667479419
Mon Dec 28 21:31:25 2009
Thread 2 advanced to log sequence 27430 (LGWR switch)
Current log# 4 seq# 27430 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_4.266.667479421
Current log# 4 seq# 27430 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_4.260.667479421
Mon Dec 28 22:01:30 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:01:30 2009
GATHER_STATS_JOB encountered errors. Check the trace file.
Mon Dec 28 22:01:30 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:01:43 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:01:46 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:01:53 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:01:54 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:01:55 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:02:16 2009
Errors in file /opt/oracle/admin/SIEBELPR/bdump/siebelpr2_j001_332192.trc:
ORA-01114: IO error writing block to file 202 (block # 112032)
ORA-29701: unable to connect to Cluster Manager
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
Mon Dec 28 22:02:19 2009
Trace dumping is performing id=cdmp_20091228220219
Mon Dec 28 22:11:35 2009
Thread 2 advanced to log sequence 27431 (LGWR switch)
Current log# 3 seq# 27431 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_3.265.667479419
Current log# 3 seq# 27431 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_3.259.667479419
Mon Dec 28 22:26:10 2009
Thread 2 advanced to log sequence 27432 (LGWR switch)
Current log# 4 seq# 27432 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_4.266.667479421
Current log# 4 seq# 27432 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_4.260.667479421
Mon Dec 28 22:26:49 2009
Thread 2 cannot allocate new log, sequence 27433
Checkpoint not complete
Current log# 4 seq# 27432 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_4.266.667479421
Current log# 4 seq# 27432 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_4.260.667479421
Mon Dec 28 22:26:52 2009
Thread 2 advanced to log sequence 27433 (LGWR switch)
Current log# 3 seq# 27433 mem# 0: +SIEBELPR_DATA/siebelpr/onlinelog/group_3.265.667479419
Current log# 3 seq# 27433 mem# 1: +ORA_FRA/siebelpr/onlinelog/group_3.259.667479419


Trc

ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
*** 2009-12-28 22:01:30.575
GATHER_STATS_JOB: GATHER_TABLE_STATS('"SIEBEL"','"EIM_PROD_INT"','""', ...)
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager
clsc_connect: (113390e30) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_saxfrndc01sipr2_crsSIEBELPR))
2009-12-28 22:01:33.816: CSSCLNTclsssInitNative: connect failed, rc 9
kgxgncin: CLSS init failed with status 3
kjfmsgr: unable to connect to NM for reg in shared group
*** 2009-12-28 22:01:43.854
clsc_connect: (113390e30) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_saxfrndc01sipr2_crsSIEBELPR))
2009-12-28 22:01:43.854: CSSCLNTclsssInitNative: connect failed, rc 9
kgxgncin: CLSS init failed with status 3
kjfmsgr: unable to connect to NM for reg in shared group
ORA-01114: IO error writing block to file 202 (block # 112010)
ORA-29701: unable to connect to Cluster Manager

I don't know where is the problem.

Thanks for your help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2010
Added on Dec 29 2009
3 comments
2,003 views