ORA-02097: parameter cannot be modified because specified value is invalid
Hi,
we are facing error during the first full package at JD Edwards 9.2 fresh installation. This is error some database pga and sga size issue on 12c OEE.
As per JDE following log file.
740/6048 WRK:Starting jdeCallObject Wed Dec 23 18:13:25.302000 oradbapi.c2304
ORADB0029 - oradbSetParam2 failed for (param sga_target value 2097152000) (param pga_aggregate_target value 115343360)
5740/6048 WRK:Starting jdeCallObject Wed Dec 23 18:13:25.302001 oradbapi.c2307
ALTER SYSTEM SET sga_target = 2097152000 SCOPE = MEMORY
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00839: SGA_TARGET cannot be modified to the specified value
=============================================
I already tried that oracle referred this document E1: PKG: Packages Built on Deployment Server with OEE End in Error: ORADB0029 - oradbSetParam2 Failed for (param sga_target value 1073741824) (param pga_aggregate_target value 115343360) and PKGRDB0016 / PKGMSC0039 ERRORS (