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;