Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Upgrade to 12.2.10 fails on fpamain.sql with ORA-37002 and ORA-36777

Hi

I'm trying to apply 30399999 ORACLE E-BUSINESS SUITE 12.2.10 RELEASE UPDATE PACK

EBS version: 12.2.9

OS: OEL 7 64 bit

Database: 19.8


It fails on the following script:

$FPA_TOP/patch/115/sql/fpamain.sql


ERROR at line 1:

ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP

technical support.

ORA-06512: at line 13692

ORA-36777: Unable to allocate 4194304 bytes for the OLAP page pool.

ORA-06512: at "SYS.DBMS_AW", line 127

ORA-06512: at "SYS.DBMS_AW", line 156

ORA-06512: at line 1

ORA-06512: at line 190


I tried to dig into the contents of the script and found that it fails on the following statement:


SQL> begin DBMS_AW.execute('aw attach FPA.fpapjp rw'); end;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center