Oracle® Thesaurus Management System Installation Guide Release 4.6.1 Part Number A83780-11 |
|
|
View PDF |
You can upgrade Oracle Thesaurus Management System (TMS) from Release 4.5.2 or Release 4.6 to Release 4.6.1.
This chapter includes the following topics:
Upgrade the database to Oracle Database 11g; see Oracle 11g documentation. Install all the Enterprise Edition options.
To upgrade the application tier, complete the following tasks in the order given:
Upgrade the TMS Forms Server (Front End)
Upgrade the TMS Database Server Code
Install Oracle Application Server 10g Forms and Reports Services; see Installing Oracle AS10gR2.
Follow instructions in Installing the TMS Front End.
Follow instructions in Installing the TMS Database Server Code.
To upgrade the TMS databases, complete the following tasks:
To begin the installation:
Log in as a user with system administrator privileges.
Insert Disk V17174-01 of the Oracle Clinical 4.6 and Oracle Thesaurus Management System 4.6.1 Media Pack.
Locate and execute the following file:
tms\install\setup.exe
The Installer opens to the Welcome screen.
Follow the instructions on the installation screens. The following section describes each screen and the required action
Attend to the Installer screens:
Click Next.
Enter values:
Source By default, the Installer displays the location in which you extracted the TMS patch. Accept this default value.
Destination Enter values for the Oracle Home you created when you installed Oracle AS10gR2. If the computer has multiple Oracle Homes, the Installer displays them all in the drop-down lists.
Name: Select the name of the correct Oracle Home; for example, FRHome1.
Path: Browse for the path to the correct Oracle Home; for example, D:\Oracle\FRHome1.
Click Next.
Select TMS Database Upgrade and click Next.
Select Master and click Next.
TMS Server Code Home Directory
Accept the default value for the directory path of the server code; for example d:\opapps46\tms. Click Next.
Enter the database name. An alias must exist in tnsnames.ora for this database.
Note: The Installer sets the LOCAL registry setting to default all connections to this database. |
NLS_LANG Oracle recommends the setting: AMERICAN_AMERICA.UTF8
NLS_DATE_FORMAT Enter a valid date value. A four-digit year is required. Oracle recommends DD-MON-RRRR
.
Click Next.
If you are integrating TMS with Oracle Clinical, stop the PSUB process on this database at this point, restarting it only after you have completely installed TMS.
Directory for data tablespace datafiles
Enter the directory for TMS data tablespace files in the appropriate syntax for your operating system, including a trailing slash. Use the same database name you entered as the connect string. For example:
UNIX: /u01/oradata/
dbname/
Windows: Drive
:\oradata\
dbname
\
In a series of Installer screens, enter the passwords for SYS, SYSTEM, CTXSYS, OPA, TMS, RXC. You will need these passwords later.
Ignore Tablespace Creation Errors
You may want to ignore tablespace creation errors if you know that the necessary tablespaces already exist. Select Yes to ignore the errors; select No to view them if they occur.
This screen informs you that the installer will start a SQL*Plus session during the installation and provides the location of the log file.
The Installer displays information about the installation, including space requirements and space available. Click Install.
Enter following commands:
set LOCAL=databasename sqlplus tms/password exec tms_dsi_xml_schema.InstallSchemas;