Skip Headers
Oracle® Real User Experience Insight Installation Guide
12c Release 2 (12.1.0.3) for Linux x86-64

Part Number E37265-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3 Upgrading to RUEI 12.1.0.3

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.

KPI Values

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.

XPath Support

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.

Increased Database Space Requirements

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.

Default Tablspace Modes

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.

Upgrading From RUEI 11.1 to 12.1.0.3

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.

Upgrading the Reporter System

The Reporter upgrade procedure described in this section applies to both single server installations as well as dedicated Reporter systems.

Do the following:

  1. 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
    
  2. Install the php-soap module by issuing the following commands:

    cd /mnt/dvd/Server
    rpm -Uhv php-soap-5.1.6-*.x86_64.rpm
    
  3. 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
    
  4. Insert an additional line in the /etc/ruei.conf file:

    export RUEI_DB_TNSNAME_CFG=$RUEI_DB_TNSNAME
    
  5. 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.

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

  7. For each required Collector system, perform the steps indicated in the following section. Upon completion, proceed to step 8.

  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
    
  9. 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
    
  10. 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:

  11. ./ruei-upgrade-12.1.0.3.sh kpi_convert_percent
    

    Note that the above command must be executed before starting step 11.

  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.

Upgrading the Remote Collector System(s)

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:

  1. Unzip the RUEI distribution package using the following commands:

    cd /root
    unzip Vxxxx.zip
    
  2. Upgrade the Collector RPMs using the following commands:

    cd /root/RUEI/121
    chmod +x ruei-install.sh
    ./ruei-install.sh collector
    
  3. 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
    
  4. 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).

Rolling Back to Version 11.1

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.

  1. 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
    
  2. Stop all processing on the Reporter system by issuing the following commands:

    cd /root/RUEI/extra
    ./ruei-rollback-11.1.sh stop_ruei
    
  3. 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
    
  4. Execute the RPM pre-installation phase by issuing the following command:

    ./ruei-rollback-11.1.sh rpm_pre_install
    
  5. 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
    
  6. Restore the previous RPMs by issuing the following commands:

    cd /root/old/RUEI/111
    chmod +x ruei-install.sh
    ./ruei-install.sh *.rpm
    
  7. Execute the post-installation script by executing the following command:

    cd /root/RUEI/extra
    ./ruei-rollback-11.1.sh rpm_post_install
    
  8. 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.

  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
    
  10. Restore the backup file by issuing the following command as the RUEI_USER user:

    project -restore --all /tmp/backup_file_name.tar.gz
    
  11. Stop processing by issue the following command as the RUEI_USER user:

    project -stop wg 
    
  12. As the root user, issue the following commands:

    cd /root/RUEI/extra
    ruei_rollback-11.1.sh restore_cubes
    
  13. Restart processing by issuing the following command as the root user:

    ./ruei-rollback-11.1.sh start_ruei
    

Rolling Back Remote Collector Systems

Do the following:

  1. 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
    
  2. 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
    
  3. 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.

Upgrading From RUEI 12.1.0.x to 12.1.0.3

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.

Upgrading the Reporter System

The Reporter upgrade procedure described in this section applies to both single server installations as well as dedicated Reporter systems.

Do the following:

  1. 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
    
  2. Install the php-soap module by issuing the following commands:

    cd /mnt/dvd/Server
    rpm -Uhv php-soap-5.1.6-*.x86_64.rpm
    
  3. 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
    
  4. 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.

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

  6. For each required Collector system, perform the steps indicated in Upgrading the Remote Collector System(s). Upon completion, proceed to step 7.

  7. For each required Processing Engine system, perform the steps described in Upgrading the Processing Engine System(s). Upon completion, proceed to step 8.

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

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

  12. ./ruei-upgrade-12.1.0.3.sh kpi_convert_percent
    

    Note that the above command must be executed before starting step 12.

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

Upgrading the Remote Collector System(s)

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:

  1. Unzip the RUEI distribution package using the following commands:

    cd /root
    unzip Vxxxx.zip
    
  2. Upgrade the Collector RPMs using the following commands:

    cd /root/RUEI/121
    chmod +x ruei-install.sh
    ./ruei-install.sh collector
    
  3. 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).

Upgrading the Processing Engine System(s)

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:

  1. 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
    
  2. 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
    
  3. 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.

  4. Install the new versions of the RPMs using the following commands:

    cd /root/RUEI/121
    chmod +x ruei-install.sh
    ./ruei-install.sh processor
    
  5. 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).

Rolling Back to Version 12.1.0.x

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.

  1. 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
    
  2. 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
    
  3. Execute the RPM pre-installation phase by issuing the following command:

    ./ruei-rollback-12.1.0.x.sh rpm_pre_install
    
  4. 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
    
  5. Restore the previous RPMs by issuing the following commands:

    cd /root/old/RUEI/121
    chmod +x ruei-install.sh
    ./ruei-install.sh *.rpm
    
  6. Execute the post-installation script by executing the following command:

    cd /root/RUEI/extra
    ./ruei-rollback-12.1.0.x.sh rpm_post_install
    
  7. 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.

  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.

  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
    
  10. Restore the backup file by issuing the following command as the RUEI_USER user:

    project -restore --collectors /tmp/backup_file_name.tar.gz
    
  11. Stop processing by issue the following command as the RUEI_USER user:

    project -stop wg
    
  12. As the root user, issue the following commands:

    cd /root/RUEI/extra
    ruei_rollback-12.1.0.x.sh restore_cubes
    
  13. Restart processing by issuing the following command as the root user:

    ./ruei-rollback-12.1.0.x.sh start_ruei
    

Rolling Back Remote Collector Systems

Do the following:

  1. 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
    
  2. 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
    
  3. 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.

Rolling Back Processing Engine Systems

Do the following:

  1. 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
    
  2. Execute the RPM pre-installation phase by issuing the following command:

    ./ruei-rollback-12.1.0.x.sh rpm_pre_install
    
  3. 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
    
  4. Restore the previous RPMs by issuing the following commands:

    cd /root/old/RUEI/121
    chmod +x ruei-install.sh
    ./ruei-install.sh processor
    
  5. 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.
Footnote 2: This line requires customization based on your database version and installation path.
Footnote 3: This line requires customization based on your database version and installation path.