6 Pre-installation Tasks

List of pre-installation tasks to be completed before installing OFSAA.

  1. Install all the prerequisite hardware and software as per the OFS Analytical Applications 8.1.2.0.0 Technology Matrix.
  2. Verify the system environment using the Environment Check Utility.
  3. Configure the database instance settings.
  4. Install and configure the Web application server.
  5. Configure the HTTP settings on the Web server.
  6. (Optional) Install and configure for Big Data/Hive.
  7. Create the installation, download, and metadata repository directories.
  8. Configure the OS file system settings in the .profile file.
  9. Configure the environment settings in the .profile file.
  10. Install Oracle R distribution and Oracle R Enterprise (ORE).
  11. Download the OFSAAAI Applications Pack installer and mandatory patches.
  12. Download the OFSAAAI Applications Pack installer and mandatory patches.
  13. Download the OFSSTA Application Pack installer and mandatory patches.
  14. Install the Linux libraries.
  15. Install MySQL version 8.0.3.2
  16. Install JDK version 17
  17. Install Phython version 3.8 or greater
  18. Create the following databases:

    CREATE DATABASE openmetadata_db; CREATE DATABASE airflow_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE USER 'openmetadata_user'@'%' IDENTIFIED BY 'openmetadata_password'; CREATE USER 'airflow_user'@'%' IDENTIFIED BY 'airflow_pass'; CREATE USER 'airflow_user'@'localhost' IDENTIFIED BY 'airflow_pass'; GRANT ALL PRIVILEGES ON openmetadata_db.* TO 'openmetadata_user'@'%' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON airflow_db.* TO 'airflow_user'@'%' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON airflow_db.* TO 'airflow_user'@'localhost' WITH GRANT OPTION; commit;

  19. Update the environment variables file (set_env.env) with the locations of the variables: OMD_INS_DIR=/scratch/openmetadata-ins-dir LOCAL_REPO_DIR=/scratch/openmetadata-ins-dir/local_repo AIRFLOW_HOME=/scratch/openmetadata-ins-dir/airflow PYTHON_INS_DIR=/scratch/openmetadata-ins-dir/python39 HTTP_PROXY_URL=http://www-proxy-adcq7.us.oracle.com:80 HTTPS_PROXY_URL=http://www-proxy-adcq7.us.oracle.com:80
  20. Extract the installation software.