PeopleSoft Seed Database Install

To install the PeopleSoft Seed Database we will be running many scripts. You can not run all of these scripts in the Oracle Linux environment. You will need a windows machine.


Prep Work:

  1. Make sure that you have installed oracle 11g R2 database software.
    • If you installed the sample database during the install you will make your life easier. 
  2. Make sure that the PS_HOME and ORACLE_HOME is in your PATH file.
  3. Verify that PeopleSoft is installed on your computer. All the needed scripts to make the seed database  are found in the PS_HOME directory. 
PeopleSoft Seed Database Install:
  1. Log in to Oracle Linux as the "oracle" user
  2. We need to make a init*.ora file. Open a new terminal and follow the commands below:
    • [oracle@localhost ~]# cd $ORACLE_HOME  --Oracle_Home = /apps/oracle/product/11.2.0
    • [oracle@localhost 11.2.0]# cd dbs
    • [oracle@localhost dbs]#  gedit initPS91DMO.ora --This will make a new file. This file will be used to create your database. It wall also be used to start your database later on.
  3. Now we are going to populate and save the initPS91DMO.ora file with following information:
      4. DB_NAME=PS91DMO DB_FILES=1021 CONTROL_FILES=/oradata/PS91DMO/ctlfile01.ctl,/oradata/PS91DMO/ctlfile02.ctl OPEN_CURSORS=1000 NLS_LENGTH_SEMANTICS=CHAR
  4. Currently the folders that will hold our "control files do not exist. We need to make these folders and make them accessible. Open a new terminal and follow the commands below:
    • [oracle@localhost ~]# cd /
    • [oracle@localhost  /]# su root
    • password:
    • [root@localhost  /]# mkdir oradata
    • [root@localhost  /]# chmod 777 oradata
    • [root@localhost  /]# cd oradata
    • [root@localhost  oradata]# mkdir PS91DMO
    • [root@localhost  oradata]# chmod 777 PS91DMO
  5. Copy the needed Scripts to a new folder
    1. Open a new terminal and follow the commands below:
      • [oracle@localhost ~]# cd $PS_HOME        -Note /apps/psoft/
      • [oracle@localhost psoft]# mkdir modifiedscripts
      • [oracle@localhost psoft]# cp -r /apps/psoft/scripts/unix/ /apps/psoft/modifiedscripts
  6. Modify the createdb10.sql script and run it.
    1. Modify the createdb10.sql script
      1. Open a new termianl and follow the commands below:
        • [oracle@localhost ~]# cd $PS_HOME       -Note: /apps/psoft
        • [oracle@localhost psoft]# cd modifiedscripts/unix
        • [oracle@localhost unix]# gedit createdb10.sql
      2. At this point a text editor should popup.
        1. Use the "Replace All" function of the editor to Replace "<SID>" with "PS91DMO"
        2. Use the "Replace All" function of the editor to Replace "/u01/" with "/"
        3. Save the File
    2. Run the script modified createdb10.sql script:
      • [oracle@localhost ~]# export ORACLE_SID=PS91DMO   --sqlplus uses this command as to point to a new database. Sqlplus will not start correctly if this is not set. Another safety tip is to check the user. Do not run sqlplus as the "root" user. This can be set in the PATH
      • [oracle@localhost ~]# sqlplus / AS SYSDBA
      • SQL> @/apps/psoft/modifiedscripts/createdb10.sql
  7. Create a spfile and bounce the database:
    1. From the same terminal that you used from step 6 enter in the following command:
      • SQL> create spfile='/apps/oracle/product/11.2.0/dbs/spfilePS91DMO.ora' from pfile='/apps/oracle/product/11.2.0/dbs/initPS91DMO.ora';
    2. SQL> shutdown immediate  -Note: This will shutdown the database service.
    3. With in the terminal enter the commands below:
      •  [oracle@localhost dbs]# sqlpus / AS SYSDBA
      • SQL> startup
  8. Modify and run the utlspace.sql script
    1. Open a new termianl and follow the commands below:
      • [oracle@localhost ~]# cd $PS_HOME       -Note: /apps/psoft
      • [oracle@localhost psoft]# cd modifiedscripts/unix
      • [oracle@localhost unix]# gedit utlspace.sql
    2. Again a text editor should popup and we can use the "Replace All" function to replace the two following fields and then save the file:
      1. Replace "/u03/" with "/"
      2. Replace "<SID>" with "PS91DMO"
      3. It is now time to run the utlspace.sql script -Note: When you run this script it will take a while.
        1. Open a terminal and follow the steps below:
          • [oracle@localhost ~]# export ORACLE_SID=PS91DMO
          • [oracle@localhost ~]# sqlplus / AS SYSDBA
          • SQL> @/apps/psoft/modifiedscripts/utlspace.sql
  9. Run the dbowner.sql script
    1. Open an new terminal and follow the steps below:
      • [oracle@localhost ~]# export ORACLE_SID=PS91DMO
      • [oracle@localhost ~]# sqlplus / AS SYSDBA
      • SQL> @/apps/psoft/modifiedscripts/dbowner.sql
  10. Modify and run the hcddl.sql script
    1. Modify the script:
      1. Open a new terminal and follow the commands below:
        • [oracle@localhost ~]: cd $PS_HOME/modifiedscripts/unix
        • [oracle@localhost unix]: gedit hcddl.sql
      2. At this time a text editor should appear and we will again use the "Replace All" for the following fields:
        1. Replace "/u04/" with "/"
        2. Replace "<SID>" with "PS91DMO"
    2. Open an new terminal and follow the steps below:
      • [oracle@localhost ~]# export ORACLE_SID=PS91DMO
      • [oracle@localhost ~]# sqlplus / AS SYSDBA
      • SQL> @/apps/psoft/modifiedscripts/hcddl.sql
  11. Run the psroles.sql script
    1. Open an new terminal and follow the steps below:
      • [oracle@localhost ~]# export ORACLE_SID=PS91DMO
      • [oracle@localhost ~]# sqlplus / AS SYSDBA
      • SQL> @/apps/psoft/modifiedscripts/psroles.sql
  12. Run the psadmin.sql script
    1. Open an new terminal and follow the steps below:
      • [oracle@localhost ~]# export ORACLE_SID=PS91DMO
      • [oracle@localhost ~]# sqlplus / AS SYSDBA
      • SQL> @/apps/psoft/modifiedscripts/psadmin.sql
        • When the script runs enter the following for the user name and password make sure it is all caps!:
          1. Username: SYSADM
          2. Password: SYSADM
        • Select PSDEFAULT as the file system.
  13. Run the connect.sql script. "It is easier to keep the defaults".
    1. Open an new terminal and follow the steps below:
      • [oracle@localhost ~]# export ORACLE_SID=PS91DMO
      • [oracle@localhost ~]# sqlplus / AS SYSDBA
      • SQL> @/apps/psoft/modifiedscripts/connect.sql
  14. Finally we are on the last step of the Seed Database Install. We need to modify the tnsnames.ora file and then start the listener. After this step we will need to configure the Seed Database with data.
    1. Edit the tnsnames.ora file.
      1. Open a new terminal and follow the commands below:
        • [oracle@localhost ~]# cd $ORACLE_HOME   --Note: ORACLE_HOME=/apps/oracle/product/11.2.0
        • [oracle@localhost 11.2.0]# cd network/admin
        • [oracle@localhost network]# gedit tnsnames.ora
      2. At this point a text editor should popup. Edit the tnsnames.ora file with the folowing fields:
          3. PS91DMO = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PS91DMO) ) )
    2. Start the lsnrctl:
      1. Open a new terminal and follow the commands below:
        • [oracle@localhost ~]# lsnrctl start
Subscribe to: Posts (Atom)