ORA-02156: Invalid TEMPORARY Tablespace Identifier While Patching

(Doc ID 1559255.1)

Last updated on DECEMBER 07, 2015

Applies to:

Oracle Application Install - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


During the  patch 7461070 application, following error occurs:



AutoPatch error:
The following ORACLE error:

ORA-02156: invalid TEMPORARY tablespace identifier

occurred while executing the SQL statement:

alter user JMF quota unlimited on 111

AutoPatch error:
Failed updating database

AutoPatch error:
Failed AutoSplicing new applprod.txt

AutoPatch error:
Failed applying new applprod.txt (if any)



 Upgrade from 11i to R12


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