Configuring the Oracle Database for PSC-EBX

To configure the Oracle database for PSC-EBX, perform the following steps:

Note: If you want to connect with the Oracle database, then ojdbc8.jar must be downloaded and placed in the $PSC_HOME/apache-tomcat/lib folder.
    Procedure
  1. Navigate to $PSC_HOME/db/oracle/configure and modify the oracle_pscebx_db.properties file.

  2. Run the $PSC_HOME/db/oracle/configure/doall.sh to run all the database scripts in one go.

  3. Uncomment and update the database details such as database url, username, password, and dataspace to the following section in the $PSC_HOME/ebx.properties file under ##Case EBX® persistence system is Oracle database:

    • ebx.persistence.factory=oracle

    • ebx.persistence.url

    • ebx.persistence.driver

    • ebx.persistence.user

    • ebx.persistence.password

    Note: There are multiple occurrences of each of the property mentioned above. Comment all the other properties and there must be a single ebx.persistence.factory property, which points to the PostgreSQL database.