Skip to Main Content

Oracle Database Express Edition (XE)

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!

Oracle Xe 10g Service dies using P6 V7

Pete Gable RPCukNov 29 2012 — edited Nov 30 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2012
Added on Nov 29 2012
2 comments
543 views