Schema Upgrade Step Failed for index_drop.ddl Unavailability While Upgrading OAS (Doc ID 3033301.1)

Last updated on JULY 16, 2024

Applies to:

Symptoms

OAS upgrade failed at the schema upgrade step with below error:

[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Initialzing ConnectionManager...
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Setting derived constants
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] DAC domain home set to /scratch
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] DAC binary home set to /scratch
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] /scratch/conf-shared/jvm_system.properties not found!
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] CONNECTION_ISSUE "Repository" pool will try to create each connection up to 3 times
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] CONNECTION_ISSUE "Repository" pool will close connections open longer than 30 minutes
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Creating connection pool "Repository" with up to 1 connections.
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Application booting up...
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Connection established.
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] ==============================              
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Generic schema upgrade
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] ==============================              
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] reading upgrade stage...
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] nothing found - starting upgrade
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Verifying whether repository is unicode...
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] Verifying unicode
[oracle.dac] [tid: 94] [ecid: fxxxxxxxx,0] upgrading schema...
ANOMALY INFO::: Could not initialize ddl file
MESSAGE ::: /scratch/log/scripts/index_drop.ddl (No such file or directory)
EXCEPTION CLASS ::: java.io.FileNotFoundException
java.io.FileOutputStream.open0(Native Method)
java.io.FileOutputStream.open(FileOutputStream.java:270)
java.io .FileOutputStream.<init>(FileOutputStream.java:213)

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.