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-00245 on alert_log.

mgaspereyraDec 23 2010 — edited Dec 27 2010
Hi all,
I/m working with Oracle 11.2.0.2 on RAC.
Following this note 1268725.1 I change my controlfile autobackup destination to an ASM dg.
But I'm stil facing the error of the subject on one of the nodes.
Below, the entry on alert_log and an excerpt of the trace file:

Alert_log:
Thu Dec 23 18:27:55 2010
Control file backup creation failed.
Backup target file size found to be zero.
Errors in file /u01/app/oracle/diag/rdbms/wdm/wdm2/trace/wdm2_ckpt_29748.trc:
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

Trace:
*** 2010-12-16 15:16:52.790
*** SESSION ID:(162.1) 2010-12-16 15:16:52.790
*** CLIENT ID:() 2010-12-16 15:16:52.790
*** SERVICE NAME:(SYS$BACKGROUND) 2010-12-16 15:16:52.790
*** MODULE NAME:() 2010-12-16 15:16:52.790
*** ACTION NAME:() 2010-12-16 15:16:52.790

Control file enqueue hold time tracking dump at time: 587905
1: 1118ms (rw) file: kct.c line: 1008 count: 1 total: 1118ms time: 587304
Control file enqueue hold time tracking dump at time: 595158

*** 2010-12-16 17:17:45.988
1: 1495ms (rw) file: kcrf.c line: 10003 count: 1 total: 1495ms time: 595150
2: 1118ms (rw) file: kct.c line: 1008 count: 1 total: 1118ms time: 587304
Control file enqueue hold time tracking dump at time: 596978

*** 2010-12-16 17:48:05.834
1: 1495ms (rw) file: kcrf.c line: 10003 count: 1 total: 1495ms time: 595150
2: 1118ms (rw) file: kct.c line: 1008 count: 1 total: 1118ms time: 587304
3: 510ms (rw) file: kcrf.c line: 9950 count: 1 total: 510ms time: 596549
Control file enqueue hold time tracking dump at time: 598838

*** 2010-12-16 18:19:05.303
1: 1962ms (rw) file: kcrf.c line: 9950 count: 9 total: 8612ms time: 597823
2: 1951ms (rw) file: kct.c line: 7782 count: 7 total: 6336ms time: 598538
3: 1495ms (rw) file: kcrf.c line: 10003 count: 1 total: 1495ms time: 595150
4: 1200ms (rw) file: kra.c line: 2298 count: 4 total: 3278ms time: 597956
5: 1129ms (ro) file: kcrr.c line: 3525 count: 2 total: 1828ms time: 597954
6: 1118ms (rw) file: kct.c line: 1008 count: 1 total: 1118ms time: 587304
7: 1017ms (rw) file: kcv.c line: 12293 count: 7 total: 4990ms time: 598355
8: 939ms (rw) file: kcffo.c line: 8340 count: 1 total: 939ms time: 598043
9: 550ms (rw) file: krse.c line: 1797 count: 1 total: 550ms time: 597960
10: 543ms (rw) file: kcv.c line: 12291 count: 1 total: 543ms time: 598477
Control file enqueue hold time tracking dump at time: 600723

Any suggestions?
(In order to be honest, I don't have a clue about where to start to understand this issue)

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 24 2011
Added on Dec 23 2010
11 comments
4,170 views