Users Guide

2. Check the database version:
a. [PGSQLDRV]= postgresql-9.3-1102.jdbc4.jar if target version is above or equals to 3.1;
b. [PGSQLDRV]= postgresql-8.3-603.jdbc4.jar if target version below 3.1;
You can get the current database version by the DB_VERSION item in [InstDir]/dbinfor.tmp. Check
the availability of /etc/ompc/upgradeok:
If it exists, it means upgrade completed. If not, new OMPC installed but upgrading yet to be
completed.
Rollback to previous OMPC version
1. Launch roll back script: /etc/ompc/backup/ompcrollback.sh.
2. Use PGAdmin to login OMPC database dcmapp with OMPC database user.
3. Execute below SQL to clean old database: DROP DATABASE IF EXISTS dcm_old and DROP
DATABASE IF EXISTS dcmapp_old.
Completing OMPC upgrade
1. Restart OMPC daemons using [InstDir]/stop.sh and [InstDir]/startup.sh.
2. Use PGAdmin to login OMPC database dcmapp with OMPC database user.
3. Execute below SQL to clean old database: DROP DATABASE IF EXISTS dcm_old and DROP
DATABASE IF EXISTS dcmapp_old.
4. If an older version exists, run rpm –e OpenManage_PowerCenter-[OLDVER]-1 command.
Remove /etc/ompc if it exists.
136