Prepare database schemas in Linux

Database schemas in Linux are used in XCA.

To prepare the database schemas in Linux for the XCA gateway:

1. Copy and unzip script files. Ensure SQL Plus is present in PATH.
   Execute the following commands:

   cd <install_dir>/ohim_xca_installer/addons/xcagateway/oracle_db/
   unzip gateway_oracle_db_scripts.zip
   cd gateway_oracle_db_scripts

2. (Optional step) If SQL Plus is not available, copy the zip file gateway_oracle_db_scripts.zip to the host system where SQL Plus and Bash or Sh shell are available. For example:

   scp <install_dir>/ohim_xca_installer/addons/xcagateway/oracle_db/gateway_oracle_db_scripts.zip user@sql_plus_host:/tmp/

3. Log in to the host system where you copied the zip file. Execute the following commands to unzip the file:

   cd /tmp
   unzip gateway_oracle_db_scripts.zip
   cd gateway_oracle_db_scripts

   Note:

   Update the SQL script create_tblspc_users.sql with your Oracle Database (DB) specific Tablespace information.
4. Run the script:

   > bash ./create_tblspc_users.sh

5. Enter database connection information and password for GATEWAY user when prompted.
6. Return to the host system where you are installing the XCA Gateway.