This chapter describes how to upgrade an Oracle In-Memory Database (IMDB) Cache Manager from version 1 to version 2. It is recommended that you review the entire chapter before performing the steps detailed in it.
IMDB Cache Manager version 2 is certified with Oracle Communications Billing and Revenue Management (BRM) 7.5 and Oracle TimesTen In-Memory Database (TimesTen) version 11.2.2.1.0.
BRM 7.5 systems with IMDB Cache Data Manager version 2 require Oracle Clusterware for Oracle Database 11g.
Note:
BRM 7.5 systems in High-Availability architecture with IMDB Cache Data Manager version 2 require Oracle Clusterware for Oracle Database 11g Release 2.For information on installing or upgrading to this software, see the installation or upgrade guide at Oracle Database Documentation Library 11g R2 documentation website.
The procedures in this chapter are designed for the following two scenarios:
Correcting IMDB Cache Manager Issues in BRM 7.5 Installations: You have BRM 7.5 installed. You are attempting to correct issues in IMDB Cache Manager, version 2 environment only.
In this case, complete the steps in this chapter as they are listed.
Upgrading from BRM 7.4 to BRM 7.5: You have BRM 7.4 (patch set 10 or above) installed. You are upgrading your IMDB Cache Manager as part of the general upgrade from BRM 7.4 to BRM 7.5.
In this case, you must start with and complete the procedure listed in "Upgrading BRM and Pipeline Manager". The procedure outlined in that chapter incorporates the procedures in this chapter at the appropriate points.
Complete the instructions as appropriate for your current requirement.
This chapter provides a list of upgrade tasks. Some tasks might need to be performed in a specific sequence (for example, first on the primary/secondary system and then on the secondary/primary system).
If your BRM installation is a high-availability system, multidatabase system, or multischema system, perform each task on the system as appropriate for your BRM environment.
Before you upgrade an Oracle In-Memory Database (IMDB) Cache Manager from version 1 to version 2, you must do a graceful shutdown and an uninstall of all elements associated with IMDB Cache Manager, version 1.
The tasks involved in preparing for this upgrade are:
Store any customizations of cache groups that you require for use in IMDB Cache Manager, version 2. This is an optional step. See "Storing Any Customizations of Cache Groups".
Unload all cache groups. See "Unloading All Cache Groups".
Detach all IMDB nodes from the cache grid. See "Detaching All IMDB Nodes from the Cache Grid".
Stop the replication agent on each database. See "Stopping the Replication Agent".
Drop all cache groups. See "Dropping All Cache Groups".
Stop the TimesTen cache agent. See "Stopping the TimesTen Cache Agent".
Stop and restart the TimesTen main daemon and destroy the data store. See "Destroying the Data Store".
Stop all components associated with IMDB Cache Manager, version 1. See "Stopping All Components Associated with IMDB Cache Manager Version 1".
Uninstall IDMDB Cache Manager, version 1. See "Uninstalling IMDB Cache Manager Version 1".
Uninstall IMDB Cache. See "Uninstalling IMDB Cache".
Select the appropriate next step based on your current scenario. See "What's Next?".
If you have created any customizations in the cache groups in your current BRM 7.4 environment, save the pin_tt_schema_gen.values file at a different location. Record this location and the name of this file (if you saved it under a different name).
Note:
In a BRM system with multiple database schemas, save the BRM_Home/bin/pin_tt_schema_gen.values file for each schema.Important:
All cache groups must be unloaded before you attempt the upgrade.To unload each cache group, enter the following command at the ttIsql command prompt:
Command> UNLOAD CACHE GROUP CacheGroupName
where CacheGroupName is the name of the cache group to be unloaded. When you issue this command, all cache instances from all cache tables in the CacheGroupName cache group will be deleted.
For example, the following command unloads a cache group called Customer_Orders:
UNLOAD CACHE GROUP Customer_Orders
For information on unloading a cache group, see the description for cache group operations in Oracle In-Memory Database Cache User's Guide.
To detach all IMDB nodes from the cache grid, use the method that fits your environment:
High-Availability (HA) Systems: If the grid member is an active standby pair, the active master and standby master databases must both be detached.
Important:
The active master and standby master databases must be detached separately.Detach the node on the active standby pair from the grid in an HA environment with the use of the stop and drop parameters for the ttCWAdmin command.
To do so, issue the commands on any one node of the active-standby pair in the following order:
ttCWAdmin –stop –dsn <DataStoreName> ttCWAdmin –drop –dsn <DataStoreName>
where DataStoreName is the name of the data store you created. (The terms "data store" and "database" are equivalent. Both terms refer to the TimesTen database, unless otherwise noted.)
For more information on detaching grid members in an HA environment, see Oracle In-Memory Database Cache User's Guide.
Non-HA systems: Detach every IMDB node using the ttGridDetach() command. This command detaches the current node from the cache grid:
call ttGridDetach();
For information on the ttGridDetach() command, see the discussion on cleaning up the caching environment in Oracle In-Memory Database Cache User's Guide.
To stop the replication agent on each database, enter the following command at the ttIsql command prompt:
Command> CALL ttRepStop;
For more information on stopping the replication agent, see the discussion on managing the replication agent in Oracle In-Memory Database Cache User's Guide.
Drop all the default cache groups and any custom cache groups you may have created.
Use the tt_drop.sql script to drop all default cache groups. The tt_drop.sql script drops all the default cache groups that were created when you installed IMDB version 1. This file resides in the BRM_Home/bin directory.
To run the tt_drop.sql script and drop all the default cache groups, enter the following command at the ttIsql command prompt.
Command> BRM_Home/bin/tt_drop.sql
where BRM_Home is the path to the directory in which BRM is installed.
For information on tt_drop.sql, see BRM System Administrator's Guide.
Use the DROP CACHE GROUP command to drop each custom cache group you created in IMDB version 1.
To drop a custom cache group, enter the following command at the ttIsql command prompt.
Command> DROP CACHE GROUP <CacheGroupName>
where CacheGroupName is the name of the cache group you created.
For information on dropping cache groups, see Oracle In-Memory Database Cache User's Guide.
To stop the cache agent on the TimesTen database, enter the following command at the ttIsql command prompt:
Command> call ttCacheStop;
For information on stopping the TimesTen cache agent, see Oracle In-Memory Database Cache User's Guide.
Destroying the data store requires a shutdown and restart of the TimesTen main daemon process. To destroy the data store:
Stop the TimesTen main daemon process with the following command:
ttdaemonadmin -stop
Note:
The TimesTen main daemon process manages all databases under the same TimesTen installation. Therefor, be sure to disconnect from all databases before running the above command.For information on stopping the TimesTen main daemon process, see Oracle In-Memory Database Operations Guide.
Restart the TimesTen main daemon process with the following command.
ttdaemonadmin -start
For information on starting the TimesTen main daemon process, see Oracle In-Memory Database Operations Guide.
Destroy the data store by entering the ttDestroy command at the ttIsql command prompt:
Command> ttDestroy <DataStoreName>
where DataStoreName is the name of the data store you want to destroy.
For information on ttDestroy, see the discussion on cleaning up the caching environment in Oracle In-Memory Database Cache User's Guide.
Use the pin_ctl utility to stop all the components (such as Connection Manager (CM), IMDB Cache DM, and so on) associated with IMDB Cache Manager version 1.
For example, the following command stops the IMDB Cache DM component:
pin_ctl stop dm_tt
For more information, see "Stopping a BRM Component using the pin_ctl Utility" and "pin_ctl" in BRM System Administrator's Guide.
To uninstall IMDB Cache Manager version 1, run unistaller.bin from the BRM_Home/uninstaller/TimesTen_Manager directory, where BRM_Home is the directory in which BRM 7.4 is installed.
For information on IMDB Cache Manager version 1, see BRM System Administrator's Guide.
To uninstall Oracle IMDB Cache, complete the steps provided for uninstalling TimesTen in Oracle TimesTen In-Memory Database Installation Guide. Use the commands provided in that document to verify that all TimesTen processes have terminated and that TimesTen has been successfully uninstalled.
When you uninstall Oracle IMDB Cache, the Oracle IMDB Cache associated with BRM 7.4 has been destroyed.
Do one of the following based on your current scenario at this point.
Correcting IMDB Cache Manager Issues in BRM 7.5 Installations: You have BRM 7.5 installed. You are attempting to correct issues in IMDB Cache Manager version 2 only.
In this case, proceed to "Upgrading the Oracle Schema for IMDB Cache Manager Version 2".
Upgrading from BRM 7.4 to BRM 7.5: You do not have BRM 7.5 installed. You are upgrading IMDB Cache Manager as part of the general upgrade from BRM 7.4 to BRM 7.5.
In this case, return to "Upgrading BRM and Pipeline Manager" and proceed to the "Backing Up Files" step in that chapter.
You now must update the Oracle schema for use with IMDB Cache Manager version 2.
Important:
On multischema or multidatabase systems, first perform this task on the primary system and then on the secondary systems.At this point you have BRM 7.5 installed on your system and are now completing the upgrade of IMDB to version 2. The tasks are:
Install IMDB Cache. See "Installing IMDB Cache".
Install IMDB Cache Manager version 2. See "Installing IMDB Cache Manager Version 2".
Re-create the data store in IMDB Cache Manager version 2. See "Re-creating the Data Store in IMDB Cache Manager Version 2".
Generate the scripts necessary set up the cache group schema. See "Generating the BRM Cache Group Schema".
Initialize your data store. See "Initializing Your Data Store in Oracle IMDB Cache".
Reestablish connections to BRM. See "Reestablishing Connections to BRM".
Configure Connection Manager (CM) connections to IMDB Cache Data Manager (DM). See "Configuring the CM Connections to IMDB Cache DM".
For information on how to install Oracle IMDB Cache, see the description for installing TimesTen in Oracle TimesTen In-Memory Database Installation Guide.
Install the Oracle IMDB Cache Data Manager (DM). See "Installing IMDB Cache Manager" in BRM System Administrator's Guide.
Complete the steps as described in "Creating the Data Store in Oracle IMDB Cache" in BRM System Administrator's Guide.
In order to generate the required cache group schema, the pin_tt_schema_gen.values file needs to be configured appropriately. This is because the pin_tt_schema_gen utility uses the contents of the pin_tt_schema_gen.values file to generate your schema and load SQL scripts.
Complete the following steps:
Note:
In a BRM system with multiple database schemas, complete these steps for each schema.Configure the pin_tt_schema_gen.values file with the required values associated with the BRM database, the database number, and so on.
For information on configuring pin_tt_schema_gen.values, see "Configuring the pin_tt_schema_gen.values File" in BRM System Administrator's Guide.
(Optional) Complete this step only if you want to restore the customizations to the cache groups in your BRM 7.4 environment (saved in step0 in "Preparing for the Upgrade to IMDB Cache Manager Version 2"). To do so:
Edit the pin_tt_schema_gen.values file (BRM_Home/bin/pin_tt_schema_gen.values) and modify the existing cache group definitions as needed using the appropriate pin_tt_schema_gen.values file saved from your BRM 7.4 environment.
Note:
Update the pin_tt_schema_gen.values file manually.Save the updated pin_tt_schema_gen.values file.
Generate your schema and load scripts by running the pin_tt_schema_gen utility.
For more information, see "Generating Your Schema and Load SQL Scripts" in BRM System Administrator's Guide.
The procedure to re-create the data stores is similar to the procedure to create the data stores. Complete the steps as described in "Initializing Your Data Stores in Oracle IMDB Cache" in BRM System Administrator's Guide.
To reestablish connections to your BRM system:
Connect your data stores to the BRM Database. See "Connecting Your Data Stores to the BRM Database" in BRM System Administrator's Guide.
Connect the IMDB Cache DM to your data stores. See "Connecting IMDB Cache DM to Your Data Stores" in BRM System Administrator's Guide.
This step is required if you completed the above procedure to fix issues in IMDB Cache Manager version 2, and you already have BRM 7.5 installed.
Configure the Connection Manager (CM) to connect to IMDB Cache Data Manager (DM). To do so, complete the steps (appropriate to your installation) described in "Connecting the CM to IMDB Cache DM" in BRM System Administrator's Guide.