 | As of Razuna 1.4 you don't need to apply these steps anymore. Razuna configures itself for your database! |
Configure a datasource for Oracle
Razuna is based on the OpenBD CFML (ColdFusion) open source engine. The engine itself comes with a administration section of its own, which lets you configure different parts of the engine itself.
WARNING: Any changes to the engine, other then the ones shown here, and resulting in failure of Razuna do not entitle you for any free support of alike. This is meant for people who know what they do! If you are not sure, please contact us or get your administrator to help you!
Access the Administration
The OpenBD Administration can be found at http://localhost:8080/bluedragon/administrator/ (of course enter here the domain you use to access Razuna). You will then see a login screen. Enter "admin" (unless you have changed the password, which you should have!).
Modifying or adding a new datasource
The datasource settings can be found in the left navigation. Click on it and you should get a list of datasources (the embedded one (H2), the Oracle one and the MySQL one should be listed). Click on the "pencil" icon to edit the MySQL one.
If there is no Oracle datasource then add one by using the name "oracle" and then choosing the Oracle Driver from the drop down menu. Then click on "Add Datasource".
Changing the Oracle datasource
When you add or edit a datasource you will be taken to the "Configure Datasource" screen (as shown in the screen shot). Change the values according to your setup:
OpenBD Datasource Name: This is the name you give to the datasource. This is the same name as you should use in the config file.
Database Name: This should be "razuna".
Database Server: The address to your Oracle Server.
Server Port: Unless you changed it from the default Oracle installation port, you should change this value.
User Name: Enter your username.
Password: Enter your password.
(Please consult the below screen shot also)
There is nothing else you need to change here, except clicking on "Submit" to save your changes. The Administration will now check your values and if it can connect successfully to the Oracle database and server you will get notified of the successful connect. If your connection fails, please check that all values have been entered correctly (especially the FireWall, if any in place, lets you connect to the Oracle server). Don't go any further unless you successfully connected to your Oracle Server!
If all done, continue at 3. Change System Settings for Oracle