Prepare the database schemas in Linux

This section describes how to set up the Oracle database for use with the optional XPID component in Linux.

To configure the schemas:

1. Copy the file from <install_dir>/ohim_hrl__ installer/addons/recordlocator/xpid/oracle_db/xpid_oracle_db_scripts.zip to the host where the SQL Plus client is present in the PATH and 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. Ensure that SQL Plus is available in the PATH, then run the script create_tblspc_users.sh:

   > bash create_tblspc_users.sh

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