If you are using an real application cluster (RAC), see Using Oracle Application Clusters.
To setup up Oracle:
Install the Oracle client on the Strategic Finance server.
In the Oracle server, create the server name, database user name, and database password.
Using the user name and password, access the Oracle Service Name and create the schema. Specify a custom schema name or accept the default.
Run Pre_installation.sql to create the database and add the base HSFDBUser.
From %EPM_ORACLE_HOME%\products\hsf\cfg run these scripts:
Step1_tables_views.sql
Contains the base and ancillary Strategic Finance database schema including tables, sequences, indexes, and keys
Step2_defaultspcreate.sql
Contains defaults and substitution procedures.
Step3_pkgcreate.sql
Contains package definitions and bodies for the base Strategic Finance database export and the customer interface table.
Step4a_optionalauditcreate.sql
Contains optional audit table for defaults and substitutions.
Step4b_optionalaudittrigger
Contains optional trigger for defaults and substitutions.
Note: | The first two scripts assume a clean database schema. You can only use these scripts once per schema. |
Log in to the schema using HSFDBUser and password.
Change the password for HSFDBUser.
In %EPM_ORACLE_HOME%\products\hsf\cfg run these scripts in this order:
Step1_tables_views.sql
Contains the base and ancillary Strategic Finance database schema including tables, sequences, indexes, and keys
Step2_defaultspcreate.sql
Contains defaults and substitution procedures.
Step3_pkgcreate.sql
Contains package definitions and bodies for the base Strategic Finance database export and the customer interface table.
Step4_optionalauditcreate.sql
Contains optional audit table for defaults and substitutions.
Step4a_optionalaudittrigger
Contains optional trigger for defaults and substitutions.
See Creating SQL Server Export Databases and then Configuring the External Database Connection