Prepare database schemas in Windows

This section describes how to configure the Oracle database in Windows.

To configure Oracle database for use with 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 you have a SQL Plus client is present in the path.
2. Log in to the host where you copied rls_oracle_db_scripts.zip and extract its contents.
3. Change the directory to the path where you extracted the files.
4. Update create_tblspc_users.sql with the Oracle DB specific Tablespace information and new passwords for the users ADT (&adtpswd), HRLCORE (&hrlcorepswd), and LOG (&logpswd).
5. Also, update scripts createadtddl.sql, createlogddl.sql, createhrlcoreddl.sql, and create_hrlcore_indexes.sql based on your environments and requirements. Consider recommendations in Oracle recommendations and optional configuration while updating these scripts.
6. Through SQL Plus, use admin or an ID in the Oracle DB with access to create table spaces and users to execute create_tblspc_users.sql.
7. Execute the following scripts through SQL Plus using the IDs created in step 5.

   createadtddl.sql using ADT 
   createlogddl.sql using LOG 
   createhrlcoreddl.sql using HRLCORE 
   create_hrlcore_indexes.sql using HRLCORE

8. After creating schemas successfully, remove create_tblspc_users.sql.