Installing and configuring OracleDB
Learn how to install and configure OracleDB for Edge Flow Manager (EFM).
For supported database versions, see System Requirements for EFM.
If you want to use MySQL, PostgreSQL, or MariaDB instead of OracleDB, you may skip these steps. See the relevant installation instructions in the respective sections.
Installing OracleDB
To install OracleDB, make sure you have a running Oracle database. If you do not have OracleDB installed yet, install it. See the Oracle Get Started Guide to get familiar with OracleDB. For step-by-step installation instructions, see the Oracle Installation Guide.
Configuring OracleDB for EFM
- Open Oracle SQL*Plus or SQLcl using OS-level
authentication.
sqlplus / as sysdba
- Create a user/schema for
EFM.
CREATE USER efm IDENTIFIED BY efmPassword;
- Grant the necessary privileges to the efm
user.
GRANT CONNECT, RESOURCE, CREATE VIEW TO efm; COMMIT;
- Use the following link to download the OracleDb JDBC Connector.
https://download.oracle.com/otn-pub/otn_software/jdbc/233/ojdbc11.jar
- Once downloaded, move the downloaded file (ojdbc11.jar) to the EFM lib
directory.
/path/to/efm/lib/
Configuring EFM database properties
Configure the database properties in the efm.properties
file:
efm.db.url=jdbc:oracle:thin:@localhost:33051/efm
efm.db.driverClass=oracle.jdbc.OracleDriver
efm.db.username=efm
efm.db.password=efmPassword
The URL should match the host and port of the machine running OracleDB. The password should
match the value that you set using the following
command:
CREATE USER efm IDENTIFIED BY efmPassword;