Prepare database schemas in Linux

This section describes how to configure the Oracle database for use with the DSUB optional component.:

To configure the Oracle database:

1. Copy the file from <install_dir>/ohim_hrl__ installer/addons/recordlocator/dsub/oracle_db/dsub_oracle_db_scripts.zip to the host where the SQL Plus client is present in the PATH and the Bash or Sh shell is available.
2. Unzip the contents.
3. Log in to the host with SQL Plus and change to the directory where you copied or extracted the files.
4. Update the SQL script create_tblspc_users.sql with your Oracle database-specific Tablespace information.
5. Ensure that SQL Plus is available in the PATH, then run the script:

   > bash create_tblspc_users.sh

6. When prompted, enter information for:
   • Registry database host
   • SID or Service Name
   • Port
   • Admin user ID and password
   • DSUB user password