Oracle® Thesaurus Management System Installation Guide Release 5.0.1 E37007-02 |
|
|
PDF · Mobi · ePub |
This chapter describes the recommended approach to upgrading an existing Oracle Thesaurus Management System installation to Release 5.0.1.
Be sure you are using the latest documentation:
Check My Oracle Support Article ID 1572864.1 for any known installation issues; see "Finding Information on My Oracle Support".
Check the Health Sciences Clinical documentation page at http://www.oracle.com/technetwork/documentation/hsgbu-clinical-407519.html
to be sure you have the latest version of this guide.
Check My Oracle Support Article ID 1590927.1 for the latest release of the Oracle Thesaurus Management System 5.0.1 Release Notes
Review Chapter 1, "Preparing to Install Oracle Thesaurus Management System" for system requirements and planning information.
This chapter includes the following topics:
Section 7.5, "Upgrade Slave TMS Databases (Distributed Environments Only)"
Section 7.7, "Run Scripts to Gather Schema Statistics for the 11g Optimizer"
Section 7.8, "Install the Application Tier Technology Stack"
If you are currently using a release prior to Release 4.6.2, you must first upgrade Oracle Database, the TMS Database Server and TMS databases to Release 4.6.2.
Note:
You do NOT need to install the 4.6.2 application tier because the technology stack is new in Release 5.0.x and you must do a fresh install of the whole application tier.Open a Service Request (SR) on My Oracle Support at https://support.oracle.com
to download the Release 4.6.2 media, which are no longer publicly available.
Download the most recent version of the 4.6.2 Installation Guide from http://www.oracle.com/technetwork/documentation/hsgbu-clinical-407519.html
.
Read Chapter 1 of the Release 4.6.2 and Release 5.0.1 versions of the Oracle Thesaurus Management System Installation Guide to plan your installation.
In the upgrade chapter of the Release 4.6.2 Oracle Thesaurus Management System Installation Guide follow all database-related sections that apply to your installation.
Note:
Do NOT follow Section 6.3, "Upgrading the Application Tier."Note:
Where the TMS 4.6.2 installation guide mentions patch 4.6.0.32, it should say 4.6.0.31. The information is correct except for the patch number.Follow the instructions below.
You must upgrade Oracle Database to 11.2.0.4.
Follow instructions in Section 5.2, "Installing the TMS Database Server Code".
Follow the instructions in this section when you are upgrading a single TMS database or, if you have a distributed environment, to upgrade the master TMS database. You must perform the tasks described in previous sections first.
Note:
Even if you have Oracle Clinical integrated with TMS, re-registering databases is not required during an upgrade.To upgrade the TMS databases, complete the following tasks:
Section 7.4.1, "Suspend Symmetric Replication (Distributed Environment Only)"
Section 7.4.2, "Upgrade the Database to Oracle Database 11.2.0.4"
Section 7.4.4, "Stop PSUB Process (If Integrated with Oracle Clinical)"
Section 7.4.6, "Attend to the TMS Database Upgrade Installer Screens"
Section 7.4.10, "Create an Export File (Distributed Environments Only)"
If you are running in a distributed environment, suspend symmetric replication and drop the replication group before you patch the Oracle Database 11g or the TMS databases by following the instructions in this section. Ensure that you use the suspend scripts that are in your TMS server code area.
Table 7-1 Symmetric Replication Suspend Scripts and Instructions
Run Script | Where? | For Where? | Parameters | Purpose and Comments |
---|---|---|---|---|
tmsmupgsrsuspend.sql |
Master instance |
Master instance |
None |
Purpose: Suspends replication activity for all sites. Comment: Wait until the dba_repgroup view has a status of QUIESCED on the master instance and all slave instances. |
tmsmupgsrdrop.sql |
Master instance |
Master instance |
None |
Purpose: Drops replication group for all sites. Comment: Wait until the dba_repcatlog view is empty on the master instance and on all slave instances. |
To suspend replication:
Log in to the server using an account with system administrator privileges.
Open a MS-DOS command window.
Change to the OPA_HOME directory where the install scripts are located, for example:
cd c:\opapps50\tms\install
Set the local name for your master site:
set local=
Master_Site
Note:
Ensure that you explicitly set the local name so that the system does not use the Oracle local registry variable by mistake. For this reason, it is best to run the upgrade scripts from the Command window, rather than from SQL*Plus.Issue these commands:
sqlplus repsys/
password
start tmsmupgsrsuspend
Unschedule the push operation from each slave site to the master site and from the master to each slave. Unschedule as many jobs as necessary to ensure that no scheduled push jobs remain.
Connect to each site as REPSYS and issue this command:
exec dbms_defer_sys.unschedule_push('
remote_site
')
;
Connect as REPSYS at each slave site and run the following script. On each updateable snapshot site (slave site), this script drops the TMS Snapshot Replication and Refresh Groups.
start tmsssrdrop
Connect as TMS at each slave site and run the following script. This step drops the TMS replicated tables on all sites.
start tmsssrdroptables
Connect as TMS at the master site and run the following script, which drops the TMS Snapshot Logs at the master site.
start tmsmsrdropmvlog
Connect as REPSYS on the master site and issue the following command, which drops the TMS Master Replication Group.
start tmsmupgsrdrop
Note:
You must follow steps in Section 7.4 to upgrade the master database before proceeding to the next step.Upgrade the database to 11.2.0.4 following instructions in the patch readme file and Oracle Database 11g Release 2 (11.2) Installation Guide for your operating system at http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=
Before you start the installer, be sure you have the information it prompts for; see Section 7.4.6, "Attend to the TMS Database Upgrade Installer Screens".
If your TMS installation is integrated with TMS, you must stop the PSUB process before upgrading the database. See the TMS Administrator's Guide for instructions.
To upgrade a TMS database:
Log in as a user with system administrator privileges.
In the staging area, locate the directory where you downloaded and extracted Oracle Thesaurus Management System (see Section 1.4, "Downloading and Extracting the Software").
Run the following file:
Disk1\install\setup.exe
The Installer opens to the Welcome screen.
Note:
See Section 1.5, "Using the Silent Installer" for instructions for running the Installer as a file with pre-entered parameter values.Note:
Although there is a button for deinstalling products on the Welcome screen, Oracle does not support using the Installer to deinstall Oracle Thesaurus Management System.In the Select a Product to Install page, select TMS Database Upgrade.
The Installer guides you through the database upgrade.
Product to install: TMS Database Upgrade.
What type of installation do you want?
Select Master if you are planning to use only one database or if you have a distributed environment (using data replication) and this is the master database.
Select Slave only if you have a distributed environment and this is a slave,or local, database.
Home Details: The full path to the Oracle Forms/Reports Home location on your application server; by default:
C:\app\oracle\Middleware\Oracle_FRHome1
TMS Server Code Home Directory: The system detects the location and enters the value for you. By default, it is C:\opapps50\tms.
Database Connect String: Enter the database name. It must be a valid TNS entry in your tnsnames.ora file.
NLS Settings: Enter the NLS settings for the database; see Section 1.7, "Choosing a Character Set". Oracle strongly recommends that you use UTF8. The default values are:
American_America.UTF8
DD-MON_RRRR
Directory for data tablespace data files: Enter the path to the directory on the database server where the data tablespace datafiles for the application should be created during the installation. The Installer does not validate the value and you must use the following syntax, including a trailing slash, depending on your operating system; for example:
UNIX: /u01/oradata/dbname/
Windows: drive:\oradata\dbname\
Enter and confirm passwords for the following accounts:
SYS
SYSTEM
CTXSYS
OPA
TMS
RXC
Ignore tablespace creation errors:
Select Yes if the database already has the TMS tablespaces created.
Select No if the TMS tablespaces do not exist.
The Installer gives you information that you should make a note of.
When you are ready, install.
When you upgrade from TMS 4.6.1 to TMS 4.6.2, the installation log file may report the following error:
"..... Connected. BEGIN tms_dsi_xml_schema.InstallSchemas; END * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 3 ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 14 ORA-06512: at "TMS.TMS_DSI_XML_SCHEMA", line 35 ORA-06512: at line 1 finished TMSUPG TMS will now attempt to validate any invalidate objects... ...."
This error occurs because the tmsupg.sql upgrade script executes tms_dsi_xml_schema.InstallSchemas before attempting to validate any invalid objects. Execution of tms_dsi_xml_schema.InstallSchemas fails if the database has invalid objects.
If this error occurs, you need to:
Run compile invalid until all database objects have been made valid.
Run tms_dsi_xml_schema.InstallSchemas manually. See Section 7.4.8, "Configure DSI Import" for details.
If you plan to use disconnected system integration (DSI), enter following commands:
set LOCAL=databasename sqlplus tms/password exec tms_dsi_xml_schema.InstallSchemas;
If you need to upgrade any dictionaries or load new dictionaries and are installing a distributed environment, this is a good time to do it since you have suspended replication and will next do an export/import. However, you can load dictionaries at any time.
If you are installing TMS with AERS in a distributed environment, you must load the AERS-TMS dictionaries onto the master database before creating an export file and importing it to the slave databases.
See the Oracle Thesaurus Management System User's Guide for information about loading dictionaries.
If you are upgrading a distributed environment, follow instructions in Section 5.8.1, "Export Data from the Master Database."
Follow the instructions in this section to upgrade existing TMS 4.6.2 slave databases to Release 5.0.1 in a distributed environment.
To upgrade each slave instance to TMS Release 4.6.2:
Start the Oracle Universal Installer on the TMS application server. (See Section 7.4, "Upgrade a Single or Master TMS Database" for details.) Choose the Slave Installation type from the Product Installer screen.
Import data from the master instance. Perform this task on the database server. At every slave database, import the export file you created in the previous task .
See Section 5.8.2, "Import Data to the Slave Database" for more information.
Note:
You must first create an export file of the master database; see Section 5.8.1, "Export Data from the Master Database."On the TMS application server, set the LOCAL variable and run the tmsupgslave.sql script by entering the following commands in a MS-DOS window:
cd OPA_HOME\tms\install sqlplus system/password start tmsupgslave.sql
The script generates a log file in the install directory named tmsupgslave_database_name.log.
Note:
When upgrading a slave database to Release 5.0.1, the following types of errors occur in the tmsupg_database_name.sql log file:
Warning: Package created with compilation errors. (and appended PLSQL errors with line numbers)
Warning: Package Body created with compilation errors. (and appended PLSQL errors with line numbers) ORA-00942: table or view does not exist
ORA-01775: looping chain of synonyms
ORA-04063: view "TMS.view_name" has errors
As long as there are no errors in the log file, tmsupgslave_database_name.sql, and there are no invalid OPA/TMS objects in the database after the ugprade, the upgrade can be considered successful and these errors can be ignored.
If you plan to use disconnected system integration (DSI), enter following commands:
set LOCAL=databasename sqlplus tms/password exec tms_dsi_xml_schema.InstallSchemas;
Start replication, following instructions in Section 5.8.6.2, "Start Replication on the Master Database" and Section 5.8.6.3, "Start Replication on Each Slave Instance."
If you have cloned a database, access the following document on My Oracle Support:
Cloning Oracle Clinical and TMS 4.6.x DatabasesArticle ID: 883213.1
Be sure to follow all the instructions in the document, including running the tmschown.sql script, the opachown.sql script, and if you are using Oracle Clinical with TMS, the chown.sql script, before doing the upgrade.
After upgrading to TMS 5.0.1 and setting initialization parameter optimizer_features_enable to 11.2.0.4 (see Section 5.3.7, "Set Initialization Parameters"), you must gather statistics required for the Oracle 11g Optimizer to be effective for accounts used internally by TMS.
Failure to execute these scripts can negatively impact performance.
Scripts opastats.sql and tmsstats.sql, are available for this purpose. If your database contains large amounts of data, the scripts may take a long time to run. You may want to edit the scripts; for information on opastat.sql and tmsstats.sql parameters see the following documentation of the DBMS_STATS package that they call: http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_stats.htm#i1036456
.
tmsstats.sql Since TMS already has a procedure, AnalyzeTable in tmspb_user_analyze.sql, that runs as part of every activation job, you may prefer to edit it if required and call it from tmsstats.sql to keep the two synchronized.
The tmsstats.sql script prompts for the password of the account it processes: TMS.
To change how TMS analyzes tables and ensure that tmsstats and AnalyzeTable remain in synch:
Modify the Analyze procedure in tmspb_user_analyze.sql.
Edit tmsstats.sql to call tms_user_analyze.AnalyzeTable. Replace the section that analyzes tables with:
exec tms_user_analyze.AnalyzeTables
Run tmsstats.sql.
opastats.sql captures new statistics in the OPA application account used by TMS. It is also used by Oracle Clinical and RDC Onsite.
Install and configure the required application tier technology stack. Follow instructions in Chapter 4, "Installing and Configuring the Application Tier."
Install the TMS front end following instructions in Chapter 6, "Installing Oracle Thesaurus Management System Application Components" to install the TMS Front End and Reports Server.