Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error during 5.2 patch installation

myluismJul 25 2017 — edited Jul 25 2017

Hi all.

I have a 5.1 installation and hit this unexpected error during patch upgrade:

ERROR en linea 1:

ORA-22289: no se puede realizar la operacion  en un archivo o LOB no abierto

ORA-06512: en "SYS.DBMS_LOB", linea 644

ORA-06512: en "APEX_050100.WWV_FLOW_API", linea 26629

ORA-01652: no se ha podido ampliar el segmento temporal con 128 en el

tablespace TEMP

ORA-06512: en linea 2

I did not take a backup of my database. I see no apexremov on unzipped directory:

[oracle@Tarkus patch]$ ls

apex_rest_config_cdb.sql    apxldimg_core.sql   apxpatch_nocdb.sql  patches

apex_rest_config_core.sql   apxldimg_nocdb.sql  apxpatch.sql        utilities

apex_rest_config_nocdb.sql  apxldimg.sql        apxpreins.sql

apex_rest_config.sql        apxpatch_cdb.sql    core

apxldimg_cdb.sql            apxpatch.log        images

What options do i have?????

I solved it:

- adding tempfile

- retry installation

This post has been answered by myluism on Jul 25 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2017
Added on Jul 25 2017
1 comment
69 views