[INSTRUCTIONS] Applying OTM v5.5 CU2 RU02

[chrisplough]

All,

When applying the RU02 (Roll Up 02) patch to OTM v5.5 CU2, 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 directory
- Run "sqlplus glogowner/<glogowner password>@<db connection> @insert_security_roles.sql"
- cd to <gc3_install_dir>\glog\oracle\script8 directory
- Run "sqlplus glogowner/<glogowner password>@<db connection>"
- Type:

@create_cr_aggregator_package.sql
quit
- 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_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 OUT_XML_PROFILE_XPATH <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd NOTIFY_SUBJECT <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd AGENT_EVENT <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_DEF_STATE <gc3_install_dir>\glog\config dbaglogowner" (without the quotes).
- Run "update_onecsv.cmd APP_FUNCTION <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).

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

@create_cr_aggregator_package.sql
quit

- 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_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 OUT_XML_PROFILE_XPATH <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh NOTIFY_SUBJECT <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh AGENT_EVENT <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_DEF_STATE <gc3_install_dir>/glog/config dbaglogowner" (without the quotes).
- Run "./update_onecsv.sh APP_FUNCTION <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).

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

Hope this helps!

--Chris