Oracle Configuration

1. Download Connect Daily using the Installer
2. Using the Database Configuration Assistant, create a new database named "calendar.yourdomain.com" with a SID of "calendar"
3. Using DBA Studio (or Enterprise Manager Console for Oracle 9), 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 "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. Close DBA Studio (or Enterprise Manager Console), and start SQL*Plus Worksheet.
6. Connect to the calendar service with the User ID and password selected in step 4.
7. Run the calschema.sql script from the cdaily-3.4.16/WEB-INF\SQL\Oracle directory.
8. Copy the ojdbc14.jar from the Oracle jdbc\lib directory to "cdaily-3.4.16\WEB-INF\LIB". If your installation does not have this file, you can download it from Oracle.
9. 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
   
10. Start the Connect Daily service and login.
11. 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=bit)(FAILOVER_MODE=(TYPE=session)(METHOD=basic))))

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