Support
Oracle and Timesheet

 

NOTE: Oracle has a set of default administration passwords that should be changed. The default Oracle accounts / passwords in some versions of Oracle are sys / change_on_install and system / manager. Both of these passwords should be changed immediately after installation, and a separate account for Journyx Timesheet should be created as described below.

Oracle Setup Instructions

  1. Make sure you have read the general instructions here.
  2. Install Oracle if not already installed. Change the passwords for the administrator accounts sys and system if that has not been done yet.
  3. Launch the Oracle DBA Studio program. All of these management tasks can be accomplished through a SQL*Plus prompt, but these instructions refer to the DBA Studio program. Log into the database with the system account to create these objects.
  4. Make sure your Oracle database is set up to use the correct national language character set. Please consult the Oracle documentation for details about character sets in Oracle.
  5. Create a Data Tablespace for the Journyx Timesheet user. Normally you will want to create a separate tablespace for Journyx Timesheet, but it is possible to use the Oracle-supplied USERS tablespace (which is the default for new users) provided there is enough free space. If you plan to use the USERS tablespace, when you create the Journyx Timesheet user, be sure to leave his default tablespace as USERS
    • Open the Storage tab under your database.
    • Right-click on Tablespaces and then click Create...
    • Give the tablespace a name like JOURNYX_DATA.
    • Leave the default options: Status: Online and Type: Permanent.
    • Make the initial size at least 50 mb. The exact size is not important as long as the datafile is allowed to grow (as is the default.)
    • Note: if you choose not to make the tablespace auto-grow, you will be responsible for monitoring Timesheet's space usage and adjusting the tablespaces appropriately.
    • Under the Storage tab, set Extent Management to "Managed in the dictionary."
    • Make sure "Enable Logging" is set to "Yes."
    • Click "Create" to bring the tablespace online.
  6. (Optional) Create an Index Tablespace for the Journyx Timesheet user.
    • For performance reasons, you may opt to create a separate tablespaces for Journyx Timesheet indexes. Usually you will place this on a different Disk, and ideally on a different disk controller, to see the performance improvement. If you skip this step, the indexes will be stored in the data tablespace you just created.
    • If you do this, name the tablespace something like JOURNYX_INDEX. You will need to supply this same tablespace name in the Journyx Timesheet Database setup web page if you are using this feature. (see the note in "All Databases" below.) If you do not create an index tablespace, or do not supply the name in the Journyx Timesheet Database setup web page, then all indexes will created in the data tablespace.
    • Create the Index tablespace with the same options as the Data tablespace. You make the initial size only half that of the Data tablespace as long as the tablespace can grow.
  7. Create a Role for the Journyx Timesheet user.
    • In DBA Studio, expand the Security option under the database root.
    • Right click on "Roles" and click "Create."
    • Name the role something like TS_USER. Leave "Authentication" set to None.
    • Click on the Role tab.
    • Assign the CONNECT role, and no others.
    • Click on the "System Privileges" tab.
    • Assign only these privileges (without the Admin/Grant option):
      • CREATE SEQUENCE
      • CREATE TABLE
      • CREATE VIEW
    • Note: For Timesheet 5.5x, you must also grant this privilege or your database setup will fail:
      • CREATE TRIGGER
    • Click "Create" to finish creating the Role.
  8. Create a Journyx Timesheet user.
    • In DBA Studio, expand the Security option under the database root.
    • Right click on "Users" and click "Create."
    • Give the user a name like journyx and assign a password. You will need to supply this username and password on the Journyx Timesheet Database Setup web page.
    • Important: Change the default tablespace of the user to JOURNYX_DATA or whatever you called the Data Tablespace. Leave the Temporary tablespace "TEMP" unless your DBA has told you otherwise.
    • Click on the Role tab. Assign the user the Role you created above (TS_USER) and no other.
    • Click on the Quota tab. Give this user "unlimited" quota on the JOURNYX_DATA tablespace, and if you created one, also the JOURNYX_INDEX tablespace. If you do not give the user quota on his default tablespace, the Journyx Timesheet Database setup will fail because the user will be unable to create any objects. If you choose to set a quota, be prepared to manually monitor Timesheet's space usage and adjust the quota as needed.
    • Click "Create" to finish creating the user.
  9. Follow the rest of the general setup instructions here.