Oracle® Real User Experience Insight Installation Guide 12c Release 2 (12.1.0.3) for Linux x86-64 Part Number E37265-05 |
|
|
PDF · Mobi · ePub |
This chapter describes the procedure for upgrading an existing RUEI 11.1 or 12.1.0.x installation to release 12.1.0.3. The post-installation configuration procedure is described in Chapter 4, "Configuring RUEI".
Additional Installation Dependency
As of version 12.1.0.3, a new dependency has been introduced. This requires the installation of the php-soap
module (available in the Linux DVD) as part of the upgrade procedures described in Upgrading From RUEI 11.1 to 12.1.0.3 and Upgrading From RUEI 12.1.0.x to 12.1.0.3.
If the DVD is not automatically mounted, use the following commands to mount it:
mkdir -p /mnt/dvd mount /dev/dvd /mnt/dvd
Note that in the rest of this chapter it is assumed that the DVD is mounted on /mnt/dvd
.
Troubleshooting Upgrade or Rollback Problems
The upgrade and rollback scripts log their actions in the files /tmp/ruei-upgrade-x.log
and /tmp/ruei-rollback-x.log
. If you encountered any problems during the upgrade or rollback, please attach the relevant file to any request to Customer Support.
In previous versions before 12.1.0.0.1, KPI percentage values were sometimes incorrectly reported as a number between 0 and 1, rather than between 0 and 100. The upgrade script prompts you to confirm the correction of suspect KPI historical values and targets. This is described in Upgrading the Reporter System.
Note that while best effort has been made to ensure that historical data and target values are correctly transformed as necessary, it is recommended that you review KPI reporting and target configuration to ensure they meet your requirements.
As of version 11.1, support for the use of XPath queries has been extended to provide full XPath 1.0 functionality for content scanning. This has important implications when upgrading an existing RUEI installation.
The upgrade script reports all namespaces found in the current configuration. These must be explicitly defined upon completion of the upgrade process. Otherwise, your configuration will no longer work correctly.
In addition, be aware that XPath expressions executed against content that is not well-formed XHTML code can return different results than in previous versions. Therefore, it is strongly recommenced that you carefully review all XPath expressions used in your RUEI installation. For further information on XPath support, see the Oracle Real User Experience Insight User's Guide.
As of version 12.1.0.1, due to the addition of hourly information within Data Browser groups, the amount of required database space has significantly increased. It is recommended that you regularly review database utilization and your data retention policies in order to ensure that they meet your reporting requirements.
As of version 12.1.0.3, the USERS
and UXCONF
tablespaces within new installations are by default set to force
logging
mode. This mode is necessary for the creation of online database backups. Previously, the default mode was nologging
. The procedure for changing this configuration is described in the Oracle Real User Experience Insight Advanced Administrator's Guide.
Existing customers should be aware that database backups created without the force
logging
mode may be unusable. The upgrade procedure does not change your database's current setting. However, be aware that changing the tablespace mode to force
logging
can considerably increase disk I/O.
This section describes the procedure for upgrading from an existing RUEI 11.1 installation to release 12.1.0.3.
Important:
Before proceeding with the upgrade, make a backup of your configuration. Select System, then Maintenance, and then Backup and restore. The configuration backup is required in case of a rollback.The Reporter upgrade procedure described in this section applies to both single server installations as well as dedicated Reporter systems.
Do the following:
Login to the Reporter as root
. Within the /root
directory, unzip the RUEI zip file, and go to the directory containing the application files. Use the following commands:
cd /root
unzip Vxxxx.zip
Install the php-soap
module by issuing the following commands:
cd /mnt/dvd/Server rpm -Uhv php-soap-5.1.6-*.x86_64.rpm
Stop all processing on the Reporter and Collector system(s) using the following commands:
cd /root/RUEI/extra chmod +x ruei-upgrade-12.1.0.3.sh ./ruei-upgrade-12.1.0.3.sh stop_ruei
Insert an additional line in the /etc/ruei.conf
file:
export RUEI_DB_TNSNAME_CFG=$RUEI_DB_TNSNAME
Perform the necessary pre-upgrade actions by executing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.3.sh rpm_pre_install
Note that, depending on your deployment, the upgrade actions may take a couple of hours to complete.
Make the ruei-prepare-db.sh
script available to the Oracle user (for example, by extracting the RUEI distribution zip) on the system where the database resides. Update the RUEI database instance by issuing the following commands:
cd /root/RUEI/121 cp ruei-prepare-db.sh /home/oracle cp -r sql_scripts /home/oracle chmod +x /home/oracle/ruei-*.sh su - oracle export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1Foot 1 ./ruei-prepare-db.sh sql_packages ./ruei-prepare-db.sh user_grants
Upon completion, you should again become the root
user.
For each required Collector system, perform the steps indicated in the following section. Upon completion, proceed to step 8.
Install the new versions of the RPMs using the following commands:
cd /root/RUEI/121 chmod +x ruei-install.sh ./ruei-install.sh *.rpm
As the root
user, add the following lines to the .bash_profile
file of the RUEI_USER
user (RUEI_DATA
/.bash_profile
):
source /etc/ruei.conf source $RUEI_HOME/bin/env.sh
Perform the necessary post-upgrade actions by executing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.3.sh rpm_post_install
As explained in KPI Values, the upgrade script may prompt you to confirm the convertion of suspect KPI historical values and targets.
In case you want to alter any of the choices you made above, you can re-run this procedure by executing the following command:
./ruei-upgrade-12.1.0.3.sh kpi_convert_percent
Note that the above command must be executed before starting step 11.
Restart processing using the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.3.sh reinitialize ./ruei-upgrade-12.1.0.3.sh start_ruei
Note:
During and after the upgrade procedure, if error or information messages appear in the event log (select System, then Status, and then Event log), you should mark them as read after completing the upgrade procedure, and monitor whether new messages are reported. In the event of re-occurring error messages, you should contact Customer Support.For each required remote Collector system, login as root
. Within the /root
directory, unzip the RUEI zip file, go to the directory containing the application files, and install the new versions of the RPMs. Do the following:
Unzip the RUEI distribution package using the following commands:
cd /root
unzip Vxxxx.zip
Upgrade the Collector RPMs using the following commands:
cd /root/RUEI/121 chmod +x ruei-install.sh ./ruei-install.sh collector
As the root
user, add the following lines to the .bash_profile
file of the RUEI_USER
user (RUEI_DATA
/.bash_profile
):
source /etc/ruei.conf source $RUEI_HOME/bin/env.sh
Insert the following line in the /etc/ruei.conf
file:
export RUEI_DB_TNSNAME_CFG=$RUEI_DB_TNSNAME
After completing the above procedure for each required Collector system, you should continue with the upgrade of the Reporter system (as described in Upgrading the Reporter System).
This section describes the procedure to rollback to version 11.1 after upgrading to version 12.1.0.3. Note that the Collector included in the Reporter installation is automatically rolled back during the described procedure. However, remote Collector systems must be individually rolled back. The procedure to do this is described later in this section.
Important:
Be aware that it may not be possible to restore your system to its exact state prior to upgrading. It is strongly recommended that you contact Customer Support before rolling back an upgrade.Note that in the following instructions, it is assumed that the 11.1 distribution set is extracted to /root/old
, and the 12.1.0.3 distribution set is extracted to /root
.
Login to the Reporter system as root
. Within the /root/old
directory, unzip the RUEI 11.1 distribution zip file, and go to the directory containing the application files. Use the following commands:
mkdir /root/old cd /root/old unzip <path to distribution set>/Vxxx.zip
Stop all processing on the Reporter system by issuing the following commands:
cd /root/RUEI/extra ./ruei-rollback-11.1.sh stop_ruei
Remove the 12.1.0.3 RPMs for Oracle Fusion and the Japanese and Korean language support by issuing the following commands:
rpm -e ux-suites-fus rpm -e ux-lang-ja_jp rpm -e ux-lang-ko_kr
Execute the RPM pre-installation phase by issuing the following command:
./ruei-rollback-11.1.sh rpm_pre_install
As the root
user, remove the following lines from the .bash_profile
file of the RUEI_USER
user (RUEI_DATA
/.bash_profile
):
source /etc/ruei.conf source $RUEI_HOME/bin/env.sh
Restore the previous RPMs by issuing the following commands:
cd /root/old/RUEI/111 chmod +x ruei-install.sh ./ruei-install.sh *.rpm
Execute the post-installation script by executing the following command:
cd /root/RUEI/extra ./ruei-rollback-11.1.sh rpm_post_install
Rollback all required remote Collectors (using the procedure described in Rolling Back Remote Collector Systems). Upon completion, continue to step 9. If your installation does not make use of a remote Collector, proceed directly to step 9.
Ensure that the backup you created prior to upgrading (by selecting System, then Maintenance, then Backup and restore, and then select Backup system to file) is available to the Reporter system by coping it, for instance, to the /tmp
directory. Then issue the following command as the root
user to make the backup file readable to the RUEI_USER
user:
chmod 644 /tmp/backup_file_name.tar.gz
Restore the backup file by issuing the following command as the RUEI_USER
user:
project -restore --all /tmp/backup_file_name.tar.gz
Stop processing by issue the following command as the RUEI_USER
user:
project -stop wg
As the root
user, issue the following commands:
cd /root/RUEI/extra ruei_rollback-11.1.sh restore_cubes
Restart processing by issuing the following command as the root
user:
./ruei-rollback-11.1.sh start_ruei
Do the following:
Login to the remote Collector system as root
. Within the /root/old
directory, unzip the 11.1 distribution zip file, and go to the directory containing the application files. Issue the following commands:
mkdir /root/old cd /root/old unzip <path to distribution file>/Vxxx.zip
As the root
user, remove the following lines from the .bash_profile
file of the RUEI_USER
user (RUEI_DATA
/.bash_profile
):
source /etc/ruei.conf source $RUEI_HOME/bin/env.sh
Restore the previous RPMs by issuing the following commands:
cd /root/old/RUEI/111 chmod +x ruei-install.sh ./ruei-install.sh ux-collector-*.rpm
Upon completion for all required Collectors, return to step 8 in Rolling Back to Version 11.1.
This section describes the procedure for upgrading from an existing RUEI 12.1.0.x installation to release 12.1.0.3.
Important:
Before proceeding with the upgrade, make a backup of your configuration. Select System, then Maintenance, and then Backup and restore. The configuration backup is required in case of a rollback.The Reporter upgrade procedure described in this section applies to both single server installations as well as dedicated Reporter systems.
Do the following:
Login to the Reporter as root
. Within the /root
directory, unzip the RUEI zip file, and go to the directory containing the application files. Use the following commands:
cd /root
unzip Vxxxx.zip
Install the php-soap
module by issuing the following commands:
cd /mnt/dvd/Server rpm -Uhv php-soap-5.1.6-*.x86_64.rpm
Stop all processing on the Reporter and Collector system(s) using the following commands:
cd /root/RUEI/extra chmod +x ruei-upgrade-12.1.0.3.sh ./ruei-upgrade-12.1.0.3.sh stop_ruei
Perform the necessary pre-upgrade actions by executing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.3.sh rpm_pre_install
Note that, depending on your deployment, the upgrade actions may take a couple of hours to complete.
This step should be performed if you are upgrading from a version prior to 12.1.0.1.
Make the ruei-prepare-db.sh
script available to the Oracle user (for example, by extracting the RUEI distribution zip) on the system where the database resides. Update the RUEI database instance by issuing the following commands:
cd /root/RUEI/121 cp ruei-prepare-db.sh /home/oracle cp -r sql_scripts /home/oracle chmod +x /home/oracle/ruei-*.sh su - oracle export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1Foot 2 ./ruei-prepare-db.sh sql_packages ./ruei-prepare-db.sh user_grants
Upon completion, you should again become the root
user.
For each required Collector system, perform the steps indicated in Upgrading the Remote Collector System(s). Upon completion, proceed to step 7.
For each required Processing Engine system, perform the steps described in Upgrading the Processing Engine System(s). Upon completion, proceed to step 8.
Install the new versions of the RPMs using the following commands:
cd /root/RUEI/121 chmod +x ruei-install.sh ./ruei-install.sh *.rpm
As the root
user, add the following lines to the .bash_profile
file of the RUEI_USER
(RUEI_DATA
/.bash_profile
):
source /etc/ruei.conf source $RUEI_HOME/bin/env.sh
Perform the necessary post-upgrade actions by executing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.3.sh rpm_post_install
As explained in KPI Values, the upgrade script may prompt you to confirm the convertion of suspect KPI historical values and targets.
If you are upgrading from version 12.1.0.0.1 (or later), this step should not be performed.
In case you want to alter any of the choices you made in the previous step, you can re-run this procedure by executing the following command:
./ruei-upgrade-12.1.0.3.sh kpi_convert_percent
Note that the above command must be executed before starting step 12.
Restart processing using the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.3.sh reinitialize ./ruei-upgrade-12.1.0.3.sh start_ruei
Note:
During and after the upgrade procedure, if error or information messages appear in the event log (select System, then Status, and then Event log), you should mark them as read after completing the upgrade procedure, and monitor whether new messages are reported. In the event of re-occurring error messages, you should contact Customer Support.For each required remote Collector system, login as root
. Within the /root
directory, unzip the RUEI zip file, go to the directory containing the application files, and install the new versions of the RPMs. Do the following:
Unzip the RUEI distribution package using the following commands:
cd /root
unzip Vxxxx.zip
Upgrade the Collector RPMs using the following commands:
cd /root/RUEI/121 chmod +x ruei-install.sh ./ruei-install.sh collector
As the root
user, add the following lines to the .bash_profile
file of the RUEI_USER
user (RUEI_DATA
/.bash_profile
):
source /etc/ruei.conf source $RUEI_HOME/bin/env.sh
After completing the above procedure for each required Collector system, you should continue with the upgrade of the Reporter system (as described in Upgrading the Reporter System).
The upgrade procedure described in this section should be performed for each Processing Engine system. Note that Processing Engine systems should be upgraded sequentially. That is, do not start upgrading the next system until upgrade of the previous system is complete. Do the following:
Login to the Processing Engine as root
. Within the /root
directory, unzip the RUEI zip file, and go to the directory containing the application files. Use the following commands:
cd /root
unzip Vxxxx.zip
Perform the necessary pre-upgrade actions by executing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.3.sh rpm_pre_install
This step should only be performed if you are upgrading from a version prior to 12.1.0.1.
Make the ruei-prepare.sh
script available to the Oracle user (for example, by extracting the RUEI distribution zip) on the system where the database resides. Update the Processing Engine database instance by issuing the following commands:
cd /root/RUEI/121 cp ruei-prepare-db.sh /home/oracle cp -r sql_scripts /home/oracle chmod +x /home/oracle/ruei-*.sh su - oracle export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1Foot 3 ./ruei-prepare-db.sh sql_packages ./ruei-prepare-db.sh user_grants
Upon completion, you should again become the root
user.
Install the new versions of the RPMs using the following commands:
cd /root/RUEI/121 chmod +x ruei-install.sh ./ruei-install.sh processor
As the root
user, add the following lines to the .bash_profile
file of the RUEI_USER
(RUEI_DATA
/.bash_profile
):
source /etc/ruei.conf source $RUEI_HOME/bin/env.sh
After completing the above procedure for each required Processing Engine, you should continue with the upgrade of Reporter system (as described in Upgrading the Reporter System).
This section describes the procedure to rollback to version 12.1.0.x after upgrading to version 12.1.0.3. Note that the Collector included in the Reporter installation is automatically rolled back during the described procedure. However, remote Collector systems must be individually rolled back. The procedure to do this is described later in this section.
Important:
Be aware that it may not be possible to restore your system to its exact state prior to upgrading. It is strongly recommended that you contact Customer Support before rolling back an upgrade.Note that in the following instructions, it is assumed that 12.1.0.x distribution set is extracted to /root/old
, and the 12.1.0.3 distribution set is extracted to /root
.
Login to the Reporter system as root
. Within the /root/old
directory, unzip the RUEI 12.1.0.x distribution zip file, and go to the directory containing the application files. Use the following commands:
mkdir /root/old cd /root/old unzip <path to distribution set>/Vxxx.zip
Stop all processing on the Reporter system by issuing the following commands:
cd /root/RUEI/extra ./ruei-rollback-12.1.0.x.sh stop_ruei
Execute the RPM pre-installation phase by issuing the following command:
./ruei-rollback-12.1.0.x.sh rpm_pre_install
As the root
user, remove the following lines from the .bash_profile
file of the RUEI_USER
user (RUEI_DATA
/.bash_profile
):
source /etc/ruei.conf source $RUEI_HOME/bin/env.sh
Restore the previous RPMs by issuing the following commands:
cd /root/old/RUEI/121 chmod +x ruei-install.sh ./ruei-install.sh *.rpm
Execute the post-installation script by executing the following command:
cd /root/RUEI/extra ./ruei-rollback-12.1.0.x.sh rpm_post_install
Rollback all required remote Collectors (using the procedure described in Rolling Back Remote Collector Systems). Upon completion, continue to step 8. If your installation does not make use of a remote Collector, proceed directly to step 8.
Rollback all required Processing Engine systems (using the procedure described in Rolling Back Processing Engine Systems). Upon completion, continue to step 9. If your installation does not make use of a Processing Engine, proceed directly to step 9.
Ensure that the backup you created prior to upgrading (by selecting System, then Maintenance, then Backup and restore, and then select Backup system to file) is available to the Reporter system by coping it, for instance, to the /tmp
directory. Then issue the following command as the root
user to make the backup file readable to the RUEI_USER
user:
chmod 644 /tmp/backup_file_name.tar.gz
Restore the backup file by issuing the following command as the RUEI_USER
user:
project -restore --collectors /tmp/backup_file_name.tar.gz
Stop processing by issue the following command as the RUEI_USER
user:
project -stop wg
As the root
user, issue the following commands:
cd /root/RUEI/extra ruei_rollback-12.1.0.x.sh restore_cubes
Restart processing by issuing the following command as the root
user:
./ruei-rollback-12.1.0.x.sh start_ruei
Do the following:
Login to the remote Collector system as root
. Within the /root/old
directory, unzip the 12.1.0.x distribution zip file, and go to the directory containing the application files. Issue the following commands:
mkdir /root/old cd /root/old unzip <path to distribution file>/Vxxx.zip
As the root
user, remove the following lines from the .bash_profile
file of the RUEI_USER
user (RUEI_DATA
/.bash_profile
):
source /etc/ruei.conf source $RUEI_HOME/bin/env.sh
Restore the previous RPMs by issuing the following commands:
cd /root/old/RUEI/111 chmod +x ruei-install.sh ./ruei-install.sh ux-collector-*.rpm cd /root/old/RUEI/121
Upon completion for all required Collectors, return to step 8 of Rolling Back to Version 12.1.0.x.
Do the following:
Login to the Processing Engine system as root
. Within the /root/old
directory, unzip the RUEI 12.1.0.x distribution zip file, and go to the directory containing the application files. Use the following commands:
mkdir /root/old cd /root/old unzip <path to distribution set>/Vxxx.zip
Execute the RPM pre-installation phase by issuing the following command:
./ruei-rollback-12.1.0.x.sh rpm_pre_install
As the root
user, remove the following lines from the .bash_profile
file of the RUEI_USER
user (RUEI_DATA
/.bash_profile
):
source /etc/ruei.conf source $RUEI_HOME/bin/env.sh
Restore the previous RPMs by issuing the following commands:
cd /root/old/RUEI/121 chmod +x ruei-install.sh ./ruei-install.sh processor
Execute the post-installation script by executing the following command:
cd /root/RUEI/extra ./ruei-rollback-12.1.0.x.sh rpm_post_install
Upon completion for all required Processing Engines, return to step 9 of Rolling Back to Version 12.1.0.x.
Footnote Legend
Footnote 1: This line requires customization based on your database version and installation path.