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 (Doc ID 1528202.1)

Last updated on JULY 17, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to build client update or full packages on the deployment server with OEE, errors occur. The R9621 UBE PDF shows status : Build Ended in Error.

The issue can be reproduced at will with the following steps:
1. Build update or full packages on the deployment server

The jde.log file shows the following error:

4512/4840 WRK:Starting jdeCallObject Tue Jan 29 12:22:33.499000 oradbapi.c2076
ORADB0029 - oradbSetParam2 failed for (param sga_target value 1073741824) (param pga_aggregate_target value 115343360)

4512/4840 WRK:Starting jdeCallObject Tue Jan 29 12:22:33.499001 oradbapi.c2079
Enter password: ALTER SYSTEM SET sga_target = 1073741824 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 System altered.
4512/4840 WRK:Starting jdeCallObject Tue Jan 29 12:22:34.981000 spkgutil.c527
[PKGBLD] - Tue Jan 29 12:22:34 - spkgrdbutil.c:227 PKGRDB0016 ERROR: Failed to export local oracle database(tablespace) SPEC__DR30127F3.

4512/4840 WRK:Starting jdeCallObject Tue Jan 29 12:22:34.981001 spkgutil.c527
[PKGBLD] - Tue Jan 29 12:22:34 - PkgMisc.cpp:1224 PKGMSC0039 ERROR: Failed to export spec repository.

The issue has the following business impact:
Due to this issue, users cannot build update or full packages on the deployment server. There is no issue building the update or full packages on the fat client.

Cause

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