Pluggable Databases in Oracle 12cR1 and Higher

In order to install JD Edwards EnterpriseOne into pluggable databases in Oracle 12cR1 and higher, the tnsnames.ora file used by the JD Edwards EnterpriseOne Platform Pack installer must be configured to run against the PDB (pluggable database) instead of the CDB root (container database). Consider these factors:

  • The tnsnames.ora file must include a connection to a PDB, which includes the PDB-unique Service Name and the Connect String.

  • The PDB connection can exist alone or alongside a CDB connection within the tnsnames.ora file.

If you do not make this configuration change, the Platform Pack installer will fail if it runs against the container database, because the root (container database) is not designed for use as the production database.

Caution: For a fully functional JD Edwards EnterpriseOne system, in addition to configuring the Oracle database client on the Enterprise Server to connect to the PDB, you must also ensure the same configuration is made for the Oracle database client on the Deployment Server.