Set the following fields: Database Name : This setting depends on how you want to connect to the Oracle database; i.e., either using the Oracle service name or Oracle SID name.
Set this value to the value of curam.db.oracle.servicename in <SERVER_DIR>/project/properties/Bootstrap.properties to connect to database using the Oracle service name, e.g..
If you want to connect to an Oracle database using the SID name, then set this value to the value of curam.db.name in <SERVER_DIR>/project/properties/Bootstrap.properties e.g. "yourhost".
Hostname : Set this value to the value of curam.db.servername in <SERVER_DIR>/project/properties/Bootstrap.properties, e.g. "gonzo.<host_name>".
Port : Set this value to the value of curam.db.serverport in <SERVER_DIR>/project/properties/Bootstrap.properties, e.g. "1521".
Database Username: Set this value to the value of curam.db.username in <SERVER_DIR>/project/properties/Bootstrap.properties, e.g. "curam".
Password: Set this value to the value of curam.db.password in <SERVER_DIR>/project/properties/Bootstrap.properties. Note that password in the Bootstrap.properties property file is encrypted, and you need to set the unencrypted, plain-text version of this password here.
Confirm Password : confirm the entered password.
Here if you are connecting using Oracle service name, then change the URL value as shown below before testing the configuration: jdbc:oracle:thin:/@//serverName:port/databaseServiceName
Where serverName is the name of the server hosting the database.
Where port is the port number the database is listening on.
Where databaseServiceName is the service name of the database.
Leave all other fields untouched unless a specific change is required.
Click the Test Configuration button to test settings.