[chrisplough]

All,

When applying the RU03 (Roll Up 03) 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.

Special Instructions. (Please Read And Follow)
==============================================
- On Win32:
- 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');

- Type the following

@create_dbpatch_55.sql
exec dbpatch_55.apply_patch('patch6615772');
drop package dbpatch_55;

select count(*) from planning_parameter where planning_param_qualifier_gid = 'IGNORE SAW CAPACITY AND COMMITMENT';

- The query should return a result greater or equal to 1. If not, contact tech support.

- Type the following

select count(*) from planning_parameter_qualifier where PLANNING_PARAM_QUAL_GID = 'IGNORE SAW CAPACITY AND COMMITMENT';

- The query should return a result greater or equal to 1. If not, contact tech support.

- Type the following

select count(*) from planning_parameter where planning_param_qualifier_gid = 'IGNORE SAW CAPACITY';
select count(*) from planning_parameter_qualifier WHERE planning_param_qual_gid = 'IGNORE SAW CAPACITY';

- Both queries should return a result of 0. If not, contact tech support.

- Run "update_onecsv.cmd FINDER_SET <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd ACTION_DEF <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd ACTION <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd ACTION_ARG <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd ACTION_DEF_STATE <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd PREFERENCE_VALUE <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd TOPIC_ALIAS <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd TRANSLATION_ERR <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd TRANSLATION_D_ERR_en <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd TRANSLATION <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd TRANSLATION_D_en <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd TRANSLATION_QUERY <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd OUT_XML_PROFILE_XPATH <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd PLANNING_PARAMETER_QUALIFIER <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd PLANNING_PARAMETER <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd RATE_GEO_COST_OPERAND <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd AUTO_ASSIGN_CRITERIA <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd AUTO_ASSIGN_TYPE_CRIT_MAP <gc3_install_dir>\glog\config dbaglogowner" (without the quotes)
.
- 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');

- Type the following

@create_dbpatch_55.sql
exec dbpatch_55.apply_patch('patch6615772');
drop package dbpatch_55;

select count(*) from planning_parameter where planning_param_qualifier_gid = 'IGNORE SAW CAPACITY AND COMMITMENT';

- The query should return a result greater or equal to 1. If not, contact tech support.

- Type the following

select count(*) from planning_parameter_qualifier where PLANNING_PARAM_QUAL_GID = 'IGNORE SAW CAPACITY AND COMMITMENT';

- The query should return a result greater or equal to 1. If not, contact tech support.

- Type the following

select count(*) from planning_parameter where planning_param_qualifier_gid = 'IGNORE SAW CAPACITY';
select count(*) from planning_parameter_qualifier WHERE planning_param_qual_gid = 'IGNORE SAW CAPACITY';

- Both queries should return a result of 0. If not, contact tech support.

- 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).

- Start the OTM/GC3 web (Apache and Tomcat) and application (WebLogic/WebSphere/OC4J) servers as described in the Administration guide.

- Test your OTM/GC3 instance using the test script in Chapter 5 of the OTM/GC3 Admin Guide ignore the "Report Server" section if you have not integrated with Oracle Reports.

Contact Oracle Technical Support if you have any questions or problems during the patch process.

Hope this helps!

Thanks!
--Chris

[miks]

Chris,

Here's our dillema. We have 5.5 CU2 installed in production and test. We have CU3 installed in development. We have a cloning exercise that works, but only when on the same release. So, we can clone from production to test, but not production to DEV.

We would like to "refresh" the DEV environment with production data. So, first question is, is there a way we can rollback (or uninstall) development from CU3 back to CU2?

If we can accomplish this, we going to install CU4 in DEV. But our goal is to get some good production data down to DEV.

Any tips would be greatly appreciated.

- Mike

[chrisplough]

Mike,

There isn't a way to roll-back an OTM patch at the DB level, without having a full backup pre-patch and restoring to it. If you don't have one, then I'd recommend taking a full DB backup from PROD and restoring it to the DEV DB server, overwriting the existing DB. You can then re-apply the OTM DB patch script (dbpatch_55.sql) to bring it up to the CU3 level. From that point, you can continue to run CU3 or upgrade to CU4.

Just realize that you'll lose all data currently in your DEV environment.

--Chris

[miks]

Thanks for the feedback!