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;