The following sections describe how to replace the default H2 databases with Oracle:
Setting up the database and users
Follow the steps below to set up an Oracle database.
Create a new database manually or by using the Oracle database configuration assistant (dbca).
Make the necessary changes in the Oracle
listner.orafiles in order to define addresses of the databases for establishing connections to the newly created database.
After configuring the
.orafiles, start the Oracle instance using the following command:
Connect to Oracle using SQL*Plus as SYSDBA as follows:
Connect to the instance with the username and password using the following command:
As SYSDBA, create a database user and grant privileges to the user as shown below:
- Exit from the SQL*Plus session by executing the
Setting up the JDBC driver
- Copy the Oracle JDBC libraries (for example, <
ORACLE_HOME/jdbc/lib/ojdbc14.jar)to the <
- Remove the old database driver from the
If you get a
timezone region not found error when using the
ojdbc6.jar with WSO2 servers, set the Java property as follows:
The value of this property should be the GMT difference of the country. If it is necessary to set this property permanently, define it inside the
wso2server.sh as a new
By default, all WSO2 products are configured to use the embedded H2 database. To configure WSO2 IoTS with Oracle, see Changing to Oracle.