2 Known Issues and Workarounds
Here are the known issues and workarounds for Release 14c (14.1.2.0.0) of Oracle Enterprise Scheduler:
ESS Schema Upgrade from 12.2.1.4.0 to 14.1.2.0.0 Fails if User has References in ESS Schemas with Noneditioned Dependent Objects
Issue
Bug Number: 36743549
Impacted Releases: 14.1.2.0.0
Impacted Platforms: All
When the customer has created references to non-editionable objects from editionable objects in ESS schema, upgrade from 12.2.1.4.0 to 14.1.2.0.0 fails with the below mentioned error. This issue occurs since the upgrade is trying to enable schemas for Edition based redefinition (EBR). In 14.1.2.0.0, all the schemas are EBR-enabled by default to support ZDT upgrade during upcoming releases. This issue does not occur if user has not modified default ESS schemas by adding custom references which are not compatible with EBR upgrade.
[2024-06-18T00:11:09.810-07:00] [Framework] [NOTIFICATION] [upgrade.Framework]
upgradeScript=C:\ESS14c\mw\oracle_common\common\sql\ess\oracle\upg_122150_122160.sql ESS43_ESS
[2024-06-18T00:11:10.147-07:00] [RCU] [ERROR] [upgrade.RCU.jdbcEngine] SQLException:
ORA-38819: user ESS43_ESS owns one or more objects whose type is editionable and that have
noneditioned dependent objects ORA-06512: at line 2 https://docs.oracle.com/error-help/db/ora-38819/ ]] [2024-06-18T00:11:10.147-07:00] [RCU] [ERROR] [upgrade.RCU.jdbcEngine]
java.sql.SQLException: ORA-38819: user ESS43_ESS owns one or more objects whose type is
editionable and that have noneditioned dependent objects ORA-06512: at line 2 https://docs.oracle.com/error-help/db/ora-38819/ at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:709) at
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:609) at
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1347) at
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:1101) at
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:409) at
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:499) at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:274) at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1469) at
oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1995) at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1608) at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3953)
at oracle.jdbc.driver.OraclePreparedStatement.doExecute(OraclePreparedStatement.java:4420) at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4406)
Workaround
Remove the incompatible references with EBR (for example, non-editionable objects from editionable objects) and try upgrade again.