ORA-12805 error while running Siebel Production Upgrade from 8.1.1.11 to IP2016 (Doc ID 2269910.1)

Last updated on MAY 24, 2017

Applies to:

Siebel CRM - Version 8.1.1.11.13 [IP2013] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.11.13 [IP2013] version, Upgrade

When attempting to run PROD upgrade from 8.1.1.11 to IP 2016, the upgrep/upgphys runs as single option and the create index fails with the following error:

ERROR
-----------------------
2017-04-26 19:21:39 [1076673536][ODBC 20101 driver][20101]ORA-12805: parallel query server died unexpectedly

STEPS
-----------------------
The issue can be reproduced ONLY in customer environment at will with the following steps:
1. Perform DEV upgrade successfully from 8.1.1.11 to IP2016 with upgrep/IRM/upgphys
2. Perform PROD upgrade from 8.1.1.11 to IP2016 which runs upgrep+upgphys as single option.
3. Check to see if the PROD upgrade runs successfully.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run PROD upgrade and this was causing a setback.

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