Configuring the Oracle Database for PSC-EBX
To configure the Oracle database for PSC-EBX, perform the following steps:
ojdbc8.jar
must be downloaded and placed in the $PSC_HOME/apache-tomcat/lib
folder.- Procedure
-
Navigate to
$PSC_HOME/db/oracle/configure
and modify theoracle_pscebx_db.properties
file. -
Run the
$PSC_HOME/db/oracle/configure/doall.sh
to run all the database scripts in one go. -
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 singleebx.persistence.factory
property, which points to the PostgreSQL database. -