Model Build is Failing With ORA Errors in MBDBService Log (ORA-03113, ORA-03114l)

(Doc ID 2333617.1)

Last updated on NOVEMBER 29, 2017

Applies to:

Oracle Utilities Network Management System - Version 2.3.0.0.0 and later
Oracle Network Management for Utilities - DMS - Version 2.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Water build is failing, the MBService log indicates there is a Database SQL error.
However ces_setup.ces includes running SQL commands and it ran without errors.

MBDBService log has the following errors:

ERROR

11/15/17 16:09:13: dbrdwr:6947
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'CREATE INDEX diagram_objects_geo_idx ON diagram_objects(geo_geometry) indextype is MDSYS.SPATIAL_INDEX;'
ORA-03113: end-of-file on communication channel
Process ID: 17818
Session ID: 625 Serial number: 6541
parse offset = 12[ diagram_objects_ge]
11/15/17 16:09:13: dbrdwr:6947
-- ORACLE ERROR -- OCI return code from OCITransRollback is OCI_ERROR
while processing command 'CREATE INDEX diagram_objects_geo_idx ON diagram_objects(geo_geometry) indextype is MDSYS.SPATIAL_INDEX;'
ORA-03114: not connected to ORACLE
parse offset = 12[ diagram_objects_ge]
11/15/17 16:09:13: dbrdwr:6947 oci connection is dead, reopening...
11/15/17 16:09:13: dbrdwr:6947 Connection info: service=<service> hostname=<hostname> instance=<instance>
11/15/17 16:09:13: dbrdwr:6947 oci connection reopen returned 0


STEPS
1. Attempt to build the Oracle Water environment (or OPAL environment).

Changes

This is a new environment setup.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms