Oracle Xe 10g Service dies using P6 V7
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