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.
Hope this helps!
Thanks!
--Chris
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.
==============================================
- 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.
Thanks!
--Chris
Comment