Creating the Database

Use the following guidelines in setting up the Oracle RAC database:

• Follow the instructions in the PeopleTools installation guide for creating a database manually on either UNIX or Windows.

• Edit the following scripts as per the instructions in the manual database creation instructions:

  • CREATEDB18.SQL

    NN represents your Oracle database version.

  • UTLSPACE.SQL

  • XXDDL.SQL

    XX is a two-letter code for the PeopleSoft application.

• Create an ORACLE_SID for each Oracle instance.

  Each Oracle instance must have its own ORACLE_SID and its own Oracle initialization file. Within each specific Oracle initialization file, you must define the thread, instance_number, instance_thread, undo tablespaces, the name of a common initialization file, and service name. Within the common initialization file, you must specify the control files and the value cluster_database=true.