It is quite common, even recommended, that one runs the Razuna application and the Oracle database on two separate machines. Of course this can also be done with Razuna. Following are some things you need to take care off before you will succeed with this setup.
Installation of Razuna, ColdFusion and Oracle
Please follow the Installation Guide and install Razuna and ColdFusion on one machine and the Oracle database and HTTP server on the other machine. Make a note of the URLs and ports you are using. We recommend to have DNS records assigned to each server instead of IP addresses.
Razuna Settings
Since Razuna and the Oracle database transfer files over the HTTP protocol you need to supply the correct URL and if needed the correct port to the Oracle server. These URLs can be set within the General settings and should also have been applied during the initial setup of a host. But if you need to change them afterwards you can do it within the General settings. Caution: Changing any of these settings apply immediately!
By default some accounts are locked and cannot be used within sqlplus. This especially is the case with the ordsys schema. We therefore need to unlock the schema first before we can log in with that schema. Unlocking a account can be done trough the Enterprise Manager. You can access the Enterprise Manager within your browser at http://localhost:1158/em/.
There should be a URL shortcut in your Start Menue in Windows called "Oracle Database - Orcl" which will take you to this URL. Also, make sure that the Enterprise Manager Service is running. If not, go into your "Services" and start up the "OracleDBConsoleORCL" service.
Log in to the Enterprise Manager with "sys" and your password. Make sure, that you connect as "sysdba".
If this is your first time you login in to the Enterprise Manager you will have to agree to the license information. Else you will see the main page of the Enterprise Manager.
On top you will see the main navigation. Click on the "Administration" link. You will then get to a list of options.
In the "Users & Privileges" click on "Users". You will then see a list of all the users.
Select the radio button of the user "ORDSYS" and click on "Edit" above the user list. In the detail page you then will be able to modify this user.
Change the password to something secure. Change the status to "Unlocked". If done, click on "Apply" to save the changes.
You can now log out of the Enterprise Manager. Again, to save resources we recommend stopping the Enterprise Manager Service.
Even if you want to keep the password you will need to re-enter here. If you do not change the password and only unlock the user the account will be set to "Expired"!