JDEDB configuration－史特林研究室

To work around this issue when installing JD Edwards EnterpriseOne Platform Packs prior to Application Release 9.0 issue the following command prior to running any Platform Pack software:

SQL> alter system set sec_case_sensitive_logon = FALSE;

Be sure to read . Requirements for Client Communications when installing Oracle 11g R2, EnterpriseOne server requires a 32 bit client on 64 bit platforms.

1. create database name: JDEDB

2. set password will not expired: ALTER PROFILE default LIMIT password_life_time UNLIMITED;

3. set case sensitive false: alter system set sec_case_sensitive_logon = FALSE;

4. NLS_CHARACTERSET=AL32UTF8

5. NLS_NCHAR_CHARACTERSET=AL16UTF16

6. install oracle client 32-bit: JDEDPY(windows 2008 64-bit), JDEAP(Red Hat Linux 5.5)
7. 設定 Cursor :800 / Process :1000 / Sessions: 1000

E9 required Oracle database to set national characterset to "AL16UTF16"

1. verify code page setting: select value from NLS_DATABASE_PARAMETERS where parameter='NLS_CHARACTERSET';

2. verify Unicode code page setting: select value from NLS_DATABASE_PARAMETERS where parameter='NLS_NCHAR_CHARACTERSET';

show parameter
show parameter spfile;
show parameter cursor;
show parameter process;

alter parameter
alter system set open_cursors=800
alter system set session_cahed_cursors=80 scope=spfile;
alter system set job_queue_processes=20;
alter system set processes=1000 scope=spfiles;