Installation Guide › Prerequisite Installation › Database Configuration

Database Configuration

Follow these steps:

1. Perform the following steps on all Oracle and PostgreSQL servers:
   1. Edit the /etc/ntp.conf file

      Add "server <_ntp_server>" to the list of servers

      Where <_ntp_server> is the IP address of your NTP server.

   2. Restart the ntpd service as follows:

      service ntpd restart
      

   3. Enable the ntpd service as follows:

      chkconfig ntpd on

2. Increase the processes and sessions for the Oracle database servers as follows:
   1. Launch SQL Plus and connect as the Oracle system database administrator.
   2. Under SQL Plus, run the following commands:

      alter system set processes=500 scope=spfile;
      alter system set sessions=824 SCOPE=spfile;
      ALTER SYSTEM SET EVENT='44951 TRACE NAME CONTEXT FOREVER, LEVEL 1024' scope=spfile;
      shutdown immediate
      startup
      

3. To enable on the Oracle database transactions for Workpoint 3.5, execute the following commands, substituting an appropriate value for Identity Management user:

   ALTER SYSTEM SET JAVA_POOL_SIZE=120M scope=spfile;
   ALTER SYSTEM SET SHARED_POOL_SIZE=240M scope=spfile;
   create pfile from spfile;
   shutdown immediate;
   startup;
   @$ORACLE_HOME\javavm\install\initjvm.sql;
   @$ORACLE_HOME\javavm\install\initxa.sql;
   grant select,insert,update,delete on DBA_PENDING_TRANSACTIONS to Identity Management user;
   grant select,insert,update,delete on DBA_PENDING_TRANSACTIONS to system;
   shutdown immediate;
   startup;
   

   Note: You can ignore errors such as "ORA-29539: Java system classes already installed." However, you may receive a disconnect message from the database. This error is mostly observed while executing the following command:

   @$ORACLE_HOME\javavm\install\initjvm.sql;
   

   If you receive this error, continue with the next SQL command:

   @$ORACLE_HOME\javavm\install\initjvm.sql;
   

4. To enable on the PostgreSQL database transactions for Workpoint 3.5, follow these steps:
   1. Execute the following commands:

      export POSTGRES_HOME=PostgreSQL Installation directory
      cd $POSTGRES_HOME/data
      

   2. Set max_connections to a value based on the number of users to be updated with the bulk loader task. The value should be greater than the number of connections you enable in your connection pool.
   3. Update postgresql.conf to set max_prepared_transactions to the max_connections value or higher.

      If you set max_prepared_transactions to 0, you disable transactions.

   4. Restart the database as follows:

      cd $POSTGRES_HOME/bin
      ./pg_ctl restart -D $POSTGRES_HOME/data -m fast