This chapter describes the procedure for upgrading an existing RUEI 11.1 or 12.1.0.x installation to release 12.1.0.4. The post-installation configuration procedure is described in Chapter 5, "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 Section 3.9, "Upgrading From RUEI 11.1 to 12.1.0.4" and Section 3.11, "Upgrading From RUEI 12.1.0.x to 12.1.0.4".
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.
The following is a summary of the main changes to the way data is represented in RUEI 12.1.0.4 tables:
Parent level values are no longer prefixed to the current value.
In previous versions of RUEI, it was the convention to prefix the parent values to a value so that, for instance, the page name would be prefixed with the application and page group values to become "MyApp " Admin " Login.asp". This is no longer the case, and in RUEI 12.1.0.4 the page name is presented simply as "Login.asp".
Note that it is now possible in RUEI to enable a Hierarchical view of data, which will visually prefix the parent level values to each child value during display in the UI. This is just a visual tool and it is not related to the way data is stored in the tables.
Using NULL to represent empty values.
In the past, RUEI would rely on special values to represent values for which no information was found. For example, if a user could not be identified for a given session, the user would be set to "anonymous". Similarly, a page might be set to "none", or a missing cookie to "no-cookie".
In this release, special values are no longer required as all empty values will now be set to NULL. All references to special values in your existing configuration, such as filters on KPIs, reports, and dashboards, will automatically be converted to use NULL by the upgrade procedure during installation. If you also choose to convert all historic data, then all special values in your data will also be updated.
The page-group dimension can now become NULL.
In previous versions of RUEI, a page-group for which no value could be found was assigned the same value as the page name. This is no longer the case. A page-group with no value is now set to NULL. The upgrade procedure will convert such occurrences automatically.
The changes described in Section 3.1, "Changes to Data Representation in RUEI 12.1.0.4" are applicable to all RUEI tables, and will also be visible in any BI exports. This means that once you've upgraded to RUEI 12.1.0.4, the data in the BI export tables will look different.
Oracle recommends you verify that the new data representation will not be incompatible with any applications that use the RUEI BI export functionality.
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 Section 3.9.1, "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.
Upgrading the application.name and application.page-group filters of KPIs, reports, dashboards, user flows, and logout events does not work correctly when the application name is a sub-application containing a suite name in parentheses or when the page-group value is actually a page-name, rather than a group containing several page-names.
To check for items that may not work after the upgrade, run the upgrade_check step from the upgrade script:
cd /root/RUEI/extra chmod +x ruei-upgrade-12.1.0.4.sh ./ruei-upgrade-12.1.0.4.sh upgrade_check
Framework exception download zip files from earlier release versions are incompatible with 12.1.0.4. When the upgrade is completed, download the zip files again to get a version compatible with 12.1.0.4.
As of version 12.1.0.4, the RUEI_HOME, RUEI_DATA, RUEI_USER and RUEI_GROUP settings described in Table 2-2 must be specified in terms of literal values. Therefore, the following is not permitted:
RUEI_BASE=/my/ruei/dir
export RUEI_HOME=$RUEI_BASE/home
Furthermore, the TZ setting, described in Table 2-2, must be set to an appropriate time zone string, such as 'Europe/Amsterdam'. Run the tzselect program to select an appropriate time zone. You must also set the ORA_SDTZ (session default time zone) variable to be identical to $TZ. For example:
export TZ=Europe/Amsterdam export ORA_SDTZ=$TZ
This section describes the procedure for upgrading from an existing RUEI 11.1 installation to release 12.1.0.4.
Important:
Before proceeding with the upgrade, make a backup of your configuration, the main database, and the databases on each processor separately. Select System, then select Maintenance, and then click Backup and restore. The configuration backup is required in case of a rollback.For instructions on how to back up your database, refer to the Oracle Enterprise Manager Cloud Control Administrator's Guide.
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
Issue the following commands:
cd /usr/java tar xzf /root/RUEI/Java/jre-7u25-linux-x64.tar.gz
Note you are prompted to accept the Java licence agreement. You cannot continue until you have done so.
This installs the necessary Java software in the directory /usr/java/jre1.7.0_25. To make the install directory version independent, create a more generic symlink using the following command:
rm ./jre ln -s /usr/java/jre1.7.0_25 /usr/java/jre
Install the php-soap module by issuing the following command:
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.4.sh ./ruei-upgrade-12.1.0.4.sh stop_ruei
Insert an additional line in the /etc/ruei.conf file:
export RUEI_DB_TNSNAME_CFG=$RUEI_DB_TNSNAME
Furthermore, the TZ setting, described in Table 2-2, must be set to an appropriate time zone string, such as 'Europe/Amsterdam'. Run the tzselect program to select an appropriate time zone. You must also set the ORA_SDTZ (session default time zone) variable to be identical to $TZ. For example:
export TZ=Europe/Amsterdam export ORA_SDTZ=$TZ
Perform the necessary pre-upgrade actions by executing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.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 chmod +r /home/oracle/sql_scripts/* 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 ./ruei-prepare-db.sh set_incremental_stats
Upon completion, you should again become the root user.
For each required Collector system, perform the steps indicated in Section 3.9.2, "Upgrading the Remote Collector System(s)". Upon completion, proceed to step 10.
Install the new versions of the RPMs using the following commands:
cd /root/RUEI/121 chmod +x ruei-install.sh ./ruei-install.sh reporter
Existing installations (upgrades) need to copy the fonts after the RPMs have been installed using the following command:
cp RUEI_HOME/bi-publisher/fonts/* /usr/java/jre/lib/fonts/
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.4.sh rpm_post_install
As explained in Section 3.2, "KPI Values", the upgrade script may prompt you to confirm the conversion 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.4.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.4.sh reinitialize ./ruei-upgrade-12.1.0.4.sh start_ruei
The upgrade converts the RUEI configuration and current data to the new model. However, the old data has not yet been converted. For more information, see Section 3.9.3, "Upgrading Historical Data" .
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
Issue the following commands:
cd /usr/java tar xzf /root/RUEI/Java/jre-7u25-linux-x64.tar.gz
Note you are prompted to accept the Java licence agreement. You cannot continue until you have done so.
This installs the necessary Java software in the directory /usr/java/jre1.7.0_09. To make the install directory version independent, create a more generic symlink using the following command:
rm ./jre ln -s /usr/java/jre1.7.0_25 /usr/java/jre
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 Section 3.9.1, "Upgrading the Reporter System").
Because RUEI 12.1.0.4 uses a new data model for storing and querying data, you will need to upgrade your pre-12.1.0.4 data if you still want to be able to view it in the new RUEI version. Note that converting the data is not required for proper operation of your RUEI 12.1.0.4 system. This step is only required if you wish to be able to view data processed and stored before the installation of 12.1.0.4.
A description of what is new and what has changed in the way data is stored and presented in 12.1.0.4 can be found in Section 3.1, "Changes to Data Representation in RUEI 12.1.0.4".
The data upgrade must be performed on each individual processing engine and the reporter.
This is an optional step to free up space in the USERS tablespace for conversion of old data and collection of new data. It moves old data to a separate tablespace where it remains as a backup.
Create a tablespace to hold the old data, for instance UXBACKUP. Its size will be about the same as the USERS tablespace, but make sure to add enough database files:
sqlplus sys/<password>@$RUEI_DB_TNSNAME as sysdba SQL> create tablespace UXBACKUP datafile 'uxbackup01.dbf' size 5M reuse autoextend on default compress; SQL> alter user RUEI_DB_USER quota unlimited on UXBACKUP; SQL> alter tablespace UXBACKUP add datafile 'uxbackup02.dbf' size 5M reuse autoextend on;
Run the following step from the upgrade script after logging in as root:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.sh backup_data_cubes UXBACKUP
Note that data for applications that are no longer configured will not be converted. In order to retain this data, add it back in the Configuration > Applications/Services screen with the exact same name before running the conversion.
Run the following step from the upgrade script after logging in as root:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.sh convert_data_cubes
Note that depending on the amount of data in the system, this might take a long time to complete.
The original data cubes will be preserved as a backup in case a problem occurs during the upgrade. Once you are satisfied with the data upgrade, you can remove them permanently by logging in as root and executing the following:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.sh delete_old_data
This will permanently delete all pre-RUEI 12.1.0.4 data cubes.
This section describes the procedure to rollback to version 11.1 after upgrading to version 12.1.0.4. 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. For instructions on how to restore your database, refer to the Oracle Enterprise Manager Cloud Control Administrator's Guide.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.4 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 by issuing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.sh stop_ruei
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
Remove the 12.1.0.4 rpms by issuing the following commands as root:
L=$(rpm -qa | grep ^ux-) rpm -e $L
Restore the previous RPMs by issuing the following commands:
cd /root/old/RUEI/111 chmod +x ruei-install.sh ./ruei-install.sh reporter
Stop all processing by issuing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.sh stop_ruei
Restore the database backup you created during the upgrade
Rollback all required remote Collectors (using the procedure described in Section 3.10.1, "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
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 9 in Section 3.10, "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.4.
Important:
Before proceeding with the upgrade, make a backup of your configuration, the main database, and the databases on each processor separately. To perform a configuration backup, select System, then select Maintenance, and then click Backup and restore. The configuration backup is required in case of a rollback.For instructions on how to back up your database, refer to the Oracle Enterprise Manager Cloud Control Administrator's Guide.
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
Issue the following commands:
cd /usr/java tar xzf /root/RUEI/Java/jre-7u25-linux-x64.tar.gz
Note you are prompted to accept the Java licence agreement. You cannot continue until you have done so.
This installs the necessary Java software in the directory /usr/java/jre1.7.0_25. To make the install directory version independent, create a more generic symlink using the following command:
rm /usr/java/jre ln -s /usr/java/jre1.7.0_25 /usr/java/jre
Install the php-soap module by issuing the following command:
rpm -Uhv php-soap-5.1.6-*.x86_64.rpm
Note:
Perform this step only if you are upgrading from a version prior to 12.1.0.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.4.sh ./ruei-upgrade-12.1.0.4.sh stop_ruei
Perform the necessary pre-upgrade actions by executing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.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 chmod +r /home/oracle/sql_scripts/* 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 ./ruei-prepare-db.sh set_incremental_stats
Upon completion, you should again become the root user.
For each required Collector system, perform the steps indicated in Section 3.11.2, "Upgrading the Remote Collector System(s)". Upon completion, proceed to step 9.
For each required Processing Engine system, perform the steps described in Section 3.11.3, "Upgrading the Processing Engine System(s)". Upon completion, proceed to step 10.
Install the new versions of the RPMs using the following commands:
cd /root/RUEI/121 chmod +x ruei-install.sh ./ruei-install.sh reporter
Existing installations (upgrades) need to copy the fonts after the RPMs have been installed using the following command:
cp RUEI_HOME/bi-publisher/fonts/* /usr/java/jre/lib/fonts/
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
Note:
Skip this step if you are upgrading from 12.1.0.3.Set the TZ setting, described in Table 2-2, to an appropriate time zone string, such as 'Europe/Amsterdam'. Run the tzselect program to select an appropriate time zone. You must also set the ORA_SDTZ (session default time zone) variable to be identical to $TZ. For example:
export TZ=Europe/Amsterdam export ORA_SDTZ=$TZ
Perform the necessary post-upgrade actions by executing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.sh rpm_post_install
As explained in Section 3.2, "KPI Values", the upgrade script may prompt you to confirm the conversion of suspect KPI historical values and targets.
Only perform this step if you are upgrading from version 12.1.0.0.0, otherwise this step can be ommited.
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.4.sh kpi_convert_percent
Note that the above command must be executed before starting step 15.
Restart processing using the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.sh reinitialize ./ruei-upgrade-12.1.0.4.sh start_ruei
The upgrade has converted the RUEI configuration and current data to the new model. However, the old data has yet to be converted. For more information, see Section 3.11.4, "Upgrading Historical Data".
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
Issue the following commands:
cd /usr/java tar xzf /root/RUEI/Java/jre-7u25-linux-x64.tar.gz
Note you are prompted to accept the Java licence agreement. You cannot continue until you have done so.
This installs the necessary Java software in the directory /usr/java/jre1.7.0_25. To make the install directory version independent, create a more generic symlink using the following command:
rm jre ln -s /usr/java/jre1.7.0_25 /usr/java/jre
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
Skip this step if you are upgrading from 12.1.0.3.
After completing the above procedure for each required Collector system, you should continue with the upgrade of the Reporter system (as described in Section 3.11.1, "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
Issue the following commands:
cd /usr/java tar xzf /root/RUEI/Java/jre-7u25-linux-x64.tar.gz
Note you are prompted to accept the Java licence agreement. You cannot continue until you have done so.
This installs the necessary Java software in the directory /usr/java/jre1.7.0_25. To make the install directory version independent, create a more generic symlink using the following command:
rm /usr/java/jre ln -s /usr/java/jre1.7.0_25 /usr/java/jre
Perform the necessary pre-upgrade actions by executing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.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 chmod +r /home/oracle/sql_scripts/* 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
Skip this step if you are upgrading from 12.1.0.3.
After completing the above procedure for each required Processing Engine, you should continue with the upgrade of Reporter system (as described in Section 3.11.1, "Upgrading the Reporter System").
Because RUEI 12.1.0.4 uses a new data model for storing and querying data, you will need to upgrade your pre-12.1.0.4 data if you still want to be able to view it in the new RUEI version. Note that converting the data is not required for proper operation of your RUEI 12.1.0.4 system. This step is only required if you wish to be able to view data processed and stored before the installation of 12.1.0.4.
A description of what is new and what has changed in the way data is stored and presented in 12.1.0.4 can be found in Section 3.1, "Changes to Data Representation in RUEI 12.1.0.4".
The data upgrade must be performed on each individual processing engine and the reporter.
This is an optional step to free up space in the USERS tablespace for conversion of old data and collection of new data. It moves old data to a separate tablespace where it remains as a backup.
Create a tablespace to hold the old data, for instance UXBACKUP. Its size will be about the same as the USERS tablespace, but make sure to add enough database files:
sqlplus sys/<password>@$RUEI_DB_TNSNAME as sysdba SQL> create tablespace UXBACKUP datafile 'uxbackup01.dbf' size 5M reuse autoextend on default compress; SQL> alter user RUEI_DB_USER quota unlimited on UXBACKUP; SQL> alter tablespace UXBACKUP add datafile 'uxbackup02.dbf' size 5M reuse autoextend on;
Run the following step from the upgrade script after logging in as root:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.sh backup_data_cubes UXBACKUP
Note that data for applications that are no longer configured will not be converted. In order to retain this data, add it back in the Configuration > Applications/Services screen with the exact same name before running the conversion.
Run the following step from the upgrade script after logging in as root:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.sh convert_data_cubes
Note that depending on the amount of data in the system, this might take a long time to complete.
The original data cubes will be preserved as a backup in case a problem occurs during the upgrade. Once you are satisfied with the data upgrade, you can remove them permanently by logging in as root and executing the following:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.sh delete_old_data
This will permanently delete all pre-RUEI 12.1.0.4 data cubes.
This section describes the procedure to rollback to version 12.1.0.x after upgrading to version 12.1.0.4. 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. For instructions on how to restore your database, refer to the Oracle Enterprise Manager Cloud Control Administrator's Guide.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.4 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 by issuing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.sh stop_ruei
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
Skip this step if you are upgrading from 12.1.0.3.
Remove the 12.1.0.4 RPMs by issuing the following commands as root:
L=$(rpm -qa | grep ^ux-) rpm -e $L
Restore the previous RPMs by issuing the following commands:
cd /root/old/RUEI/121 chmod +x ruei-install.sh ./ruei-install.sh reporter
Stop all processing by issuing the following commands:
cd /root/RUEI/extra ./ruei-upgrade-12.1.0.4.sh stop_ruei
Restore the database backup you created during the upgrade
Rollback all required remote Collectors (using the procedure described in Section 3.12.1, "Rolling Back Remote Collector Systems"). If your installation does not make use of a remote Collector, proceed directly to step 9.
Rollback all required Processing Engine systems (using the procedure described in Section 3.12.2, "Rolling Back Processing Engine Systems"). If your installation does not make use of a Processing Engine, proceed directly to step 10.
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
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
Skip this step if you are upgrading from 12.1.0.3.
Restore the previous RPMs by issuing the following commands:
cd /root/old/RUEI/121 chmod +x ruei-install.sh ./ruei-install.sh ux-collector-*.rpm
Upon completion for all required Collectors, return to step 9 of Section 3.12, "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
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
Skip this step if you are upgrading from 12.1.0.3.
Restore the previous RPMs by issuing the following commands:
cd /root/old/RUEI/121 chmod +x ruei-install.sh ./ruei-install.sh processor
Upon completion for all required Processing Engines, return to step 10 of Section 3.12, "Rolling Back to Version 12.1.0.x".
Footnote Legend
Footnote 1: This line requires customization based on your database version and installation path.