Prepare database schemas in Linux

To configure Oracle database for use with the Health Record Locator:

1. Copy the file from <install_dir>/ohim_hrl_installer/addons/recordlocator/oracle_db/rls_oracle_db_scripts.zip to the host where the SQL Plus client 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 the directory to where you have copied or extracted the files in.
4. Update the SQL script create_tblspc_users.sql with your Oracle DB specific Tablespace information. Also, update these scripts: based on your environments and requirements. Consider recommendations in Oracle recommendations and optional configuration while updating these scripts.
   • createadtddl.sql
   • createlogddl.sql
   • createhrlcoreddl.sql
   • create_hrlcore_indexes.sql
5. Ensure that SQL Plus is available in the PATH, then run the script create_tblspc_users.sh:

   > bash create_tblspc_users.sh 

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