Manually Running the Database Creation Scripts - UNIX with Oracle

Once the Platform Pack install has successfully completed on your UNIX-based Enterprise Server, the Oracle database creation scripts and dump files are located in the EnterpriseOne install location on the Enterprise Server. For example:

/u01/jdedwardsppack/e920/ORCL

As it runs, the Platform Pack installer edits the script that sets the environment variables. You can review this script for accuracy:

ORCL_set.sh

Note: If you are manually running the ORCL_set.sh script without having it edited by the Platform Pack, you must manually edit it as follows:From:To:Depending on whether you are using ASM, you must also edit this line to change the variable ~ASM~ to YES or NO:

To manually run the Oracle database installation scripts:

1. Sign on to the Enterprise Server as the Oracle owner. For example, oracle.

2. Change directory to the EnterpriseOne install location. For example:

   cd /u01/jdedwardsppack/e920

3. You can review and change the tablespace scripts if desired. Do not change the tablespace names.

   The tablespace creation scripts are called:

   crtabsp_xxx.unx

   crtabsp_xxx.sql

   where xxx is the variable portion of the tablespace name.

4. Navigate to the ORCL folder under the install path. For example:

   /u01/jdedwards/e920/ORCL

5. Verify the settings in the InstallOracleDatabase.sh script:

   export DATABASE_INSTALL_PATH=/u01/jdedwardsppack/e920/ORCL

6. Run the InstallOracleDatabase.sh script.

7. Check the logs in the logs directory.