Upgraded to12.2.8 with 19c, Engine Start Failing - ORA-60019: Creating initial extent of size 14 in tablespace of extent size 8; Unable to create AQ queue objects
(Doc ID 2706597.1)
Last updated on NOVEMBER 13, 2024
Applies to:
Oracle Demantra Predictive Trade Planning - Version 12.2.6 to 12.2.11 [Release 12.2]Oracle Demantra Demand Management - Version 12.2.6 to 12.2.11 [Release 12.2]
Information in this document applies to any platform.
Symptoms
Upgrade:12.2.8 Engine start failing
Customer upgraded Demantra from 12.2.4 to 12.2.8 and Database from 11.2.0.4 to 19c .
For Database 19c, the default value for db_secure is PREFERRED
DB_SECURE=PREFERRED (Default value)
starting the Engine
Engine starter failing.
db_exception log has error messages:
ERROR
--------
ERROR - Failed to create queue table : ENG_IRXVLD0939_STARTER_IN
FAILURE: -60019 ORA-60019: Creating initial extent of size 14 in tablespace of extent size 8
Error failed to create queue table : ENG_IRXVLD0939_STARTER_OUT
ERROR - Failed to create queue table : ENG_IRXVLD0939_STARTER_OUT_Q
Unable to create AQ queue objects
Installer error - Creating tables with LOB columns.
Application error in DB_EXCEPTION_LOG = Unable to create AQ queue object when starting Apps Server or Engine.
STEPS
-------
The issue can be reproduced at will with the following steps:
1. DB_SECURE=PREFERRED (Default value)
2. Run Engine
3. Error ,Unable to create AQ queue objects
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |