Upgrade Guide › Upgrade Procedures › Database Upgrade

Database Upgrade

If you continue to use Oracle for CA CloudMinder, Oracle requires an upgrade for Workpoint.

Follow these steps:

1. 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;
   

   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;
   

2. Restart the database by using the following commands. To avoid downtime in an Oracle RAC installation, restart one database at a time.

   shutdown immediate;
   startup;