[chrisplough]

All,

When applying the RU02 (Roll Up 02) patch to OTM v5.5 CU3, I noticed that there are some very important post-installation steps that are displayed by the installer, but not included in the README documentation. Just to ensure that no one misses these steps (because they are important!!), I've included them below.

- On Unix
- cd to <gc3_install_dir>/glog/oracle/script8 directory
- Run "sqlplus glogowner/<glogowner password>@<db connection>"
- Type the following:

@../insert_security_roles.sql
@@create_index_package
exec create_index.all_indexes('Y');

select count(*) from user_indexes where index_name in ('IX_CAU_CCA_GID','IX_SAJ_CAUD_GID')

- The query should return a result of 2. If not, contact tech support.

- Type the following

exec DBMS_STATS.GATHER_INDEX_STATS('GLOGOWNER','IX_SAJ_ CAUD_GID');
exec DBMS_STATS.GATHER_INDEX_STATS('GLOGOWNER','IX_CAU_ CCA_GID');

- Run "./update_onecsv.sh FINDER_SET <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh ACTION_DEF <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh ACTION <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh ACTION_ARG <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh ACTION_DEF_STATE <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh PREFERENCE_VALUE <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh TOPIC_ALIAS <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh TRANSLATION_ERR <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh TRANSLATION_D_ERR_en <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh TRANSLATION <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh TRANSLATION_D_en <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh TRANSLATION_QUERY <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh OUT_XML_PROFILE_XPATH <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh PLANNING_PARAMETER_QUALIFIER <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh PLANNING_PARAMETER <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh RATE_GEO_COST_OPERAND <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh AUTO_ASSIGN_CRITERIA <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh AUTO_ASSIGN_TYPE_CRIT_MAP <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).

Hope this helps!

Thanks!
--Chris