Upgrade a TMS Database
Follow the instructions in this section to upgrade each TMS database as mentioned below:
- Back Up Database Objects
- Prevent Access to Oracle Thesaurus Management System Databases
- Gather Required Information to Upgrade TMS Database
- Stop PSUB Process (If Integrated with Oracle Clinical)
- Start the Installer
- Attend to the TMS Database Upgrade Installer Screens
- Set Initialization Parameters
- Check Installation Log for Errors
- Configure DSI Import
- Load Dictionaries
- Integration with Oracle Clinical
Back Up Database Objects
Back up the following packages if you have customized them:
-
tms_ud_activation_rules
-
tms_sup_srchobj
Parent topic: Upgrade a TMS Database
Prevent Access to Oracle Thesaurus Management System Databases
You must ensure that no data entry is performed, and no jobs that update data (such as batch validation) run during the upgrade process.
To prevent users from accessing the data, place the database in restricted mode. Provide restricted session access to the following accounts:
-
SYSTEM
-
SYS
-
OPA
-
RXC
-
TMS
-
CTXSYS
-
OPS$TMSBROWSER
-
TDX
After you complete the upgrade, remove the restricted access from the databases and user accounts.
Note:
The OPS$TMSBROWSER account is replaced by the account TMSPROXY from TMS 5.2.1.You do not need to remove restricted access for the TMSPROXY account.
Parent topic: Upgrade a TMS Database
Gather Required Information to Upgrade TMS Database
Before you start the Installer, be sure you have the information it prompts for:
Parent topic: Upgrade a TMS Database
Stop PSUB Process (If Integrated with Oracle Clinical)
If your TMS installation is integrated with Oracle Clinical, you must stop the PSUB process before upgrading the database. See the Oracle Clinical Administrator's Guide for instructions.
Parent topic: Upgrade a TMS Database
Attend to the TMS Database Upgrade Installer Screens
The Oracle Universal Installer guides you through the database upgrade. Provide the information you assembled in Gather Required Information to Upgrade TMS Database.
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.
Parent topic: Upgrade a TMS Database
Set Initialization Parameters
After the upgrade completes, set the init.ora parameters according to the instructions in Install and Configure Oracle Database.
You must stop and then start the database to activate the changed init.ora parameters.
Note:
Do NOT SET the DB_DOMAIN parameter. In Release 5.1 and above this causes problems.
If you set up the EVENT parameter in the init.ora file to trace unique key constraints before upgrading, you should set the event parameter back to its required value.
Parent topic: Upgrade a TMS Database
Check Installation Log for Errors
When you upgrade, 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 Configure DSI Import for details.
Parent topic: Upgrade a TMS Database
Configure DSI Import
If you plan to use disconnected system integration (DSI), enter following commands:
set LOCAL=databasename
sqlplus tms/password
exec tms_dsi_xml_schema.InstallSchemas;
Parent topic: Upgrade a TMS Database
Load Dictionaries
You can load dictionaries at any time. See the Oracle Thesaurus Management System User's Guide for information about loading dictionaries.
Parent topic: Upgrade a TMS Database
Integration with Oracle Clinical
When a TMS database is cloned and TMS is integrated with Oracle Clinical, force rederivation must be executed for all Oracle Clinical studies.
Parent topic: Upgrade a TMS Database