The following section provides information on configuring an Oracle database.
Configuring an Oracle Database:
A warning will appear:
After saving the database configuration you can no longer switch to a different database type. To change the selected database type, you must reset your Software Appliance.
After choosing your external database, complete the required information.
The following configuration options are displayed:
Database Host
Database IP Address / FQDN (required): Enter the IP address or the FQDN (Fully Qualified Domain Name) of the external Oracle database.
Database Port: The default Port 1521 is displayed, if applicable adjust the port used by the database host.
If you mark the checkbox Use SID to connect to database instance: you are requested to enter the Site identifier of the database in Database SID.
If you don't mark the checkbox Use SID to connect to database instance you are requested to enter a Service Name of your database instance in Database Service Name.
Database Authentication
Database Username (required): Enter the username used to connect to the database.
Database Password (required): Enter the password used to connect to the database.
Additional Settings
Here you can define additional properties. These will be passed to the JDBC connector via connection URL. These properties allow you to have more control over the database connection.
Connector Properties:
Name: Enter a property name
Value: Enter a value
Confirm your entries by clicking Add Property in the column Actions.
Connectivity Check
WithTest Connection you can check, whether the connection to the external database server can be established with the given configuration data.
In case the connection test fails an Error Message will appear for further information.
The connection test could fail if you enter incorrect settings like: IP Address, Database Name or Wrong Password.
If the connection test was successful your settings with information like: Hostname, Server Version and Driver Version will be displayed in a table. You can save the configuration with Save Configuration anytime.