Connect to an Oracle Database

You can add Oracle as a data source, but to do so you must first enable it in the chorus.properties file. You might need to add oracle.enabled=true. You must also copy the ojdbc6.jar file to your /shared/libraries folder.

1. Follow the steps in Enable Oracle Data Sources. Supported Oracle versions can be found in System Requirements.
   
   
2. Fill in the required fields and, if you like, the optional Description.
   • Data Source Name: Set a user-facing name for data source. You can choose anything you like.
   • Database Name: Enter the actual name of your Oracle database.
   • Database Account and Database Password: Provide your credentials for that database.
   • If you check the Set database credentials as a shared account box, all users can access the data source without providing their own credentials - they are accessing the database with your credentials as the data source owner. If you do not check this box, each user must enter his or her own credentials for that data source in order to access it. You can change this setting later if you change your mind.

• Enable Oracle Databases
  This topic describes how to enable an Oracle database prior to adding Oracle as a data source.