Setting up Oracle connection
You can use an existing Oracle database to work with Lycia or you can create a new one. Here are the general instructions to be used for an Oracle database creation and connecting to it from Lycia.
Connect to Oracle on Windows
To connect to the Oracle database on Windows, please follow these steps.
Step
1. Install and
configure the Oracle RDBMS.
You must have the Oracle client installed regardless of whether you want to create a new database or to connect to an existing one.
Step
2. Create a user under Oracle
and provide the username and password by running the command sqlplus,
and connect as a user with DBA privileges.
Refer here for the details on creating and managing a database.
Step 3. Record the database connection details into database.cfg.
Step 4. Set these environment variables in inet.env – ORACLE_HOME, ORACLE_SID, and DBTEMP.
Step 5. Set the database driver to Oracle as described here.
Connect to Oracle on Linux
To connect to the Oracle database on Linux, please follow these steps.
Step
1. Install and
configure the Oracle RDBMS.
You must have the Oracle client installed regardless of whether you want to create a new database or to connect to an existing one.
Step 2. Create a user under Oracle and provide the username and password by running the command sqlplus, and connect as a user with DBA privileges.
Step
3. Set the Lycia
environment variables.
- ORACLE_HOME and ORACLE_SID in inet.env. You may also need to set DBTEMP. The values of the variables will be used only if the database will not be found in database.cfg;
- set ORACLE_HOME and ORACLE_SID in env.properties. The values of the variables will be used only if the database will not be found in database.cfg;
- record the database connection details into database.cfg.
Step 4. Set the database driver to Oracle as described here.