Oracle Configuration

1. Download connectDaily using the Installer
2. Using the Database Configuration Assistant, create a new database named "calendar.yourdomain.com" with a SID of "calendar"
3. Using SQL Developer, connect to the calendar database with Username SYSTEM, password MANAGER, and Connect as set to "SYSDBA" If you have changed your SYSTEM password, you will need to enter the correct password.
4. Expand out the calendar database and right click on the "Other Users" folder. Select CREATE from the right-click Menu. Enter the USER ID, and PASSWORD you would like to use. On the ROLE tab, select DBA.
5. Connect to the calendar service with the User ID and password selected in step 4.
6. Run the calschema.sql script from the cdaily-5.0.0\WEB-INF\sql\ORACLE directory.
7. Copy the ojdbc6.jar from the Oracle jdbc\lib directory to "cdaily-5.0.0\WEB-INF\lib". If your installation does not have this file, you can download it from Oracle.
8. Edit the configuration.properties file, putting in the configuration entries for your database.
   
   DBObjectClass=com.MHSoftware.db.support.OracleDB
JDBCConnectString=jdbc\:oracle\:thin\:@localhost\:1521\:calendar
JDBCDriver=oracle.jdbc.driver.OracleDriver
JDBCPassword=calendar
JDBCUserID=calendar
   
9. Start the connectDaily service and login.
10. Configure Backup of the newly created database.

If you're using clustering or multiple SIDs on your Oracle server you may need to configure your JDBCConnectString to something like:

JDBCConnectString=jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))
(LOAD_BALANCE=ON))
(CONNECT_DATA=(SERVICE_NAME=calendar)(FAILOVER_MODE=(TYPE=session)(METHOD=basic))))

Note that the connection information would be entered as one very long line.