This discussion is archived
2 Replies Latest reply: Nov 30, 2012 4:18 AM by user11262980 RSS

Oracle Xe 10g Service dies using P6 V7

user11262980 Newbie
Currently Being Moderated
Anyone can help please.....

We are using Oracle XE 10g on a Windows 2003 SP2 server with Primavera P6 V7.0 (no service packs)

All installed OK and successfully connected to the database.

Overnight, it appears that the service died. Restarting both the listener and Oracle XE services enabled us to log back in OK. However, the service still just dies at seemingly random times. When we look at services it says they both running.

This is an extract from the listener.log (host name changed to protect the innocent!)

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip address)(PORT=8080))(Presentation=HTTP)(Session=RAW))
24-OCT-2012 10:59:26 * service_update * xe * 0
24-OCT-2012 10:59:32 * service_update * xe * 0
24-OCT-2012 10:59:38 * service_update * xe * 0
24-OCT-2012 10:59:39 * service_update * xe * 0
24-OCT-2012 10:59:45 * service_update * xe * 0
24-OCT-2012 10:59:51 * service_update * xe * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
24-OCT-2012 10:59:54 * service_update * xe * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=8080))(Presentation=HTTP)(Session=RAW))
24-OCT-2012 10:59:55 * service_update * xe * 0
24-OCT-2012 11:00:01 * service_update * xe * 0
24-OCT-2012 11:00:03 * service_update * xe * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=8080))(Presentation=HTTP)(Session=RAW))
24-OCT-2012 11:00:07 * service_died * xe * 12537
24-OCT-2012 11:00:10 * service_register * xe * 0
24-OCT-2012 11:00:12 * service_update * xe * 0
24-OCT-2012 11:00:18 * service_update * xe * 0

This is an extract from alert_xe.log

Mon Nov 12 22:13:35 2012
Errors in file d:\data\p6\db\app\oracle\admin\xe\bdump\xe_ckpt_5856.trc:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'D:\DATA\P6\DB\ORADATA\XE\CONTROL.DBF'
ORA-27072: File I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.

Mon Nov 12 22:13:35 2012
CKPT: terminating instance due to error 221
Mon Nov 12 22:13:35 2012
Errors in file d:\data\p6\db\app\oracle\admin\xe\bdump\xe_q001_10032.trc:
ORA-00221: error on write to control file

Mon Nov 12 22:13:35 2012
Errors in file d:\data\p6\db\app\oracle\admin\xe\bdump\xe_pmon_7696.trc:
ORA-00221: error on write to control file

Mon Nov 12 22:13:36 2012
Errors in file d:\data\p6\db\app\oracle\admin\xe\bdump\xe_j000_8760.trc:
ORA-00221: error on write to control file

Mon Nov 12 22:13:36 2012
Errors in file d:\data\p6\db\app\oracle\admin\xe\bdump\xe_dbw0_7404.trc:
ORA-00221: error on write to control file

Mon Nov 12 22:13:37 2012
Errors in file d:\data\p6\db\app\oracle\admin\xe\bdump\xe_mman_4844.trc:
ORA-00221: error on write to control file

Mon Nov 12 22:13:37 2012
Errors in file d:\data\p6\db\app\oracle\admin\xe\bdump\xe_reco_8956.trc:
ORA-00221: error on write to control file

Mon Nov 12 22:13:37 2012
Errors in file d:\data\p6\db\app\oracle\admin\xe\bdump\xe_smon_9532.trc:
ORA-00221: error on write to control file

Mon Nov 12 22:13:37 2012
Errors in file d:\data\p6\db\app\oracle\admin\xe\bdump\xe_lgwr_1072.trc:
ORA-00221: error on write to control file

Mon Nov 12 22:13:38 2012
Errors in file d:\data\p6\db\app\oracle\admin\xe\bdump\xe_psp0_6528.trc:
ORA-00221: error on write to control file

Instance terminated by CKPT, pid = 5856
Dump file d:\data\p6\db\app\oracle\admin\xe\bdump\alert_xe.log

Any help much appreciated.

Peter
  • 1. Re: Oracle Xe 10g Service dies using P6 V7
    orafad Oracle ACE
    Currently Being Moderated
    user11262980 wrote:
    This is an extract from alert_xe.log

    Mon Nov 12 22:13:35 2012
    Errors in file d:\data\p6\db\app\oracle\admin\xe\bdump\xe_ckpt_5856.trc:
    ORA-00221: error on write to control file
    ORA-00206: error in writing (block 3, # blocks 1) of control file
    ORA-00202: control file: 'D:\DATA\P6\DB\ORADATA\XE\CONTROL.DBF'
    ORA-27072: File I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
    You have a backup or other process running that tries to access (and lock) database files while db instance is up.

    Possibly solutions may include: Shutdown database during/before backup, or exclude oradata folder (the whole file tree).

    Mon Nov 12 22:13:35 2012
    CKPT: terminating instance due to error 221
    Because control file could not be written to, CKPT has no alternative but to shut down to protect the database.
  • 2. Re: Oracle Xe 10g Service dies using P6 V7
    user11262980 Newbie
    Currently Being Moderated
    Thank you. I will investigate further.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points