Skip Headers

Oracle® Collaboration Suite Installation and Configuration Guide
Release 2 (9.0.4.1.1) for Windows

Part Number B12239-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

3 Upgrading to Oracle Collaboration Suite Release 2 (9.0.4.1.1)

This chapter contains procedural information for upgrading existing Oracle Collaboration Suite Release 1 (9.0.3) installations and associated components to Oracle Collaboration Suite Release 2 (9.0.4.1.1).

The sequence of events for a successful upgrade is as follows:

  1. Back up important information

  2. Globalization requirements

  3. Upgrade the infrastructure

  4. Upgrade the information store

  5. Install the Oracle Collaboration Suite Release 2 (9.0.4.1.1) middle tier

  6. Perform pre-upgrade tasks

  7. Upgrade the middle tier

  8. Perform post-upgrade tasks

This chapter contains these topics:

Backing Up Oracle Installations


Note:

Oracle Corporation recommends backing up the software in the Oracle home directory, database files, and the Oracle Inventory prior to upgrading the software.


See Also:

Oracle9i Application Server 9.0.2 documentation is available on Oracle Technology Network at
http://otn.oracle.com/

Back up your Oracle installations.

  1. Back up the Oracle Collaboration Suite Release 1 (9.0.3) information storage database.

  2. Back up the Oracle Collaboration Suite Release 1 (9.0.3) infrastructure.

  3. Back up the Oracle Collaboration Suite Release 1 (9.0.3) middle tier.

  4. Back up the directory (or directories) listed for your platform in Table 9-1.

  5. Back up Oracle Calendar by logging in as the user unison and backing up the \users\unison directory.

  6. Back up the Oracle Universal Installer inventory located in the oraInventory directory.

    1. Copy the oraInventory subdirectory and all of its contents to another directory.

Enabling Multiple Language Support in Oracle Collaboration Suite Release 2 (9.0.4.1.1)

Oracle Collaboration Suite Release 2 (9.0.4.1.1) provides translation support for 9 additional languages to that of Release 1 (9.0.3), as shown in Table 3-1.

To enable multiple language support in Oracle Collaboration Suite Release 2 (9.0.4.1.1), execute the ptlasst.bat script from the Release 1 (9.0.3) middle tier, located in the following directory, before going through the upgrade process:


Notes:

  • You must run the script for each language you want to enable.

  • You cannot enable a language that is already enabled or it corrupts the Oracle9iAS Single Sign-On and Oracle9iAS Portal repositories. If you have all 9 languages of Release 1 (9.0.3) enabled, ensure that you do not enable them again. Generally, in a typical Release 1 (9.0.3) installation, either English only, is enabled, or all 9 languages are.


%ORACLE_HOME%\ora9ias\assistants\opca

The usage of the ptlasst.bat file is as follows:

%ORACLE_HOME%\ora9ias\assistants\opca\ptlasst.bat -mode LANGUAGE -s portal -sp
portal -o orasso -op orasso -c myhost.domain.com:1521:mySID -lang lang
-available -silent- verbose -sso_c myhost.domain.com:1521:mySID

-available: Determines whether the language is available for user translation

-c: Connect string to the target database. The format should be hostname:port:SID

-o: Oracle9iAS Single Sign-On schema name. The default is orasso.

-op: Oracle9iAS Single Sign-On password. The default is orasso.

-lang: Language code for the language to install. Table 3-1 lists the various languages and their associated codes.

-silent: Runs the Oracle9iAS Portal configuration assistant in silent mode. Default is TRUE.

-sp: Oracle9iAS Portal schema password. The default is portal.

-sso_c: Connect string to the target database where Oracle9iAS Single Sign-On is installed. The format should be hostname:port:SID.

-verbose: Enables detailed logging mode. Even if there are errors in the log file, Oracle9iAS Portal configuration assistant install will continue. If this parameter is not set, logging information is brief and Oracle9iAS Portal configuration assistant aborts the install if it encounters any ORA-, PLS-, or SP2 errors. The default is TRUE.

You can retrieve Oracle9iAS Portal and Oracle9iAS Single Sign-On randomized passwords from Oracle Internet Directory with the following distinguished name:

OrclResourceName=PORTAL,orclReferenceName=sid.myhost.domain.com,cn=IAS
Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext

OrclResourceName=ORASSO,orclReferenceName=sid.myhost.domain.com,cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext

Table 3-1 lists the 18 languages supported by Oracle Collaboration Suite Release 2 (9.0.4.1.1) along with their associated language codes.

Table 3-1 Languages Supported in Oracle Collaboration Suite Release 2 (9.0.4.1.1)

Language Code Supported in Release 1 (9.0.3)
Arabic ar no
Brazilian Portuguese ptb yes
Danish dk no
Dutch nl no
Finnish sf no
French f yes
German d yes
Greek el no
Italian i yes
Japanese ja yes
Korean ko yes
Norwegian n no
Portuguese pt no
Simplified Chinese zhs yes
Spanish e yes
Swedish s no
Traditional Chinese zht yes
Turkish tr no


See Also:

Oracle9i Globalization Support Guide for more information about language codes

Upgrading Oracle9iAS Infrastructure

In addition to upgrading the Oracle9iAS infrastructure at the Oracle Collaboration Suite level, the infrastructure must also be upgraded at the component level for Oracle Email and Oracle9iAS Wireless.

This section contains the following topics:

Upgrading the Oracle9iAS Infrastructure at the Suite Level

Perform the following procedures to upgrade the Oracle9iAS Infrastructure 9.0.2.0.1, Oracle9iAS Infrastructure 9.0.2.0.0, or the Oracle Collaboration Suite Release 1 (9.0.3) Infrastructure to Oracle9iAS Infrastructure 9.0.2.3:

  1. Apply the Oracle9iAS Infrastructure 9.0.2.3 patch 3038037 to the infrastucture.


    Note:

    Contained in the README for patch 3038037 are instructions for applying the Oracle9i 9.0.1.4 database server patch 2517300. You must apply patch 2517300 before patch 3038037. Both of these patches are available at:
    http://metalink.oracle.com/
    

  2. Copy the files listed in Table 3-2 from the CDROM_ROOT\tools \upgrade directory on the Oracle9iAS Infrastructure Installation CD-ROM for Release 2 (9.0.4.1.1) to the specified target directory in the infrastructure Oracle home directory that you are upgrading:

    Table 3-2 Files to be Copied to Specified Target Directories

    File Target Directory
    modDirectiveMS.xsd
    
    %ORACLE_HOME%\dcm\config\plugins\apache
    
    opca.jar
    
    %ORACLE_HOME%\sysman\webapps\emd\WEB-INF\lib
    
    portalSMI.jar
    
    %ORACLE_HOME%\sysman\webapps\emd\WEB-INF\lib
    
    repository.jar
    
    %ORACLE_HOME%\jlib
    
    ApacheModuleFastCGI.dll
    
    %ORACLE_HOME%\Apache\Apache\modules
    
    ApacheModuleOSSO.dll
    
    %ORACLE_HOME%\Apache\Apache\modules
    
    FastCGI.dll
    
    %ORACLE_HOME%\Apache\fastcgi
    
    FastCGI.lib
    
    %ORACLE_HOME%\Apache\fastcgi
    
    fcgi.jar
    
    %ORACLE_HOME%\Apache\fastcgi
    

  3. Download Oracle9iAS Portal patch 2513540 available at:

    http://metalink.oracle.com/
    
    

    To apply this patch:

    1. Unzip the contents of the file into a temporary directory. The file contains the following files:

      • secapi.pks

      • secapi.pkb

      • secapip.pks

      • secapip.pkb

      • secoid.pks

      • secoid.pkb

      • secoidd.pkb

      • secrmoid.sql

      • recompile.sql

      • ssooidd.sql

    2. Schedule system downtime to apply the patch (shut down all the infrastructure processes except the infrastructure repository database), because no users should be accessing Oracle9iAS Portal while the patch is being applied.

    3. Log in as the Oracle9iAS Portal schema owner using SQL*Plus, as in the following example:

      c:\>sqlplus portal/portal_schema_password
      
      
    4. In the SQL*Plus shell, execute the following:

      set define off
      
      
    5. Compile the files in the following order:

      • @secapi.pks

      • @secapip.pks

      • @secoid.pks

      • @secapi.pkb

      • @secapip.pkb

      • @secoid.pkb

      • @secoidd.pkb

    6. Compilation of the preceding files will invalidate some dependent schema objects. Recompile those objects using the following script:


      Note:

      This script takes several minutes to execute.

      @recompile.sql
      
      
    7. Restart all the infrastructure processes that were shutdown in step b of this procedure.

  4. Create an orclguest user using Oracle Delegated Administration Services.


    Note:

    You must have sufficient privilege to create new users in the default subscriber.

    1. Log in to Oracle Delegated Administration Services as a user with privilege to create users.

    2. Select the Directory tab.

    3. In the Search Results section, click Create.

    4. Depending on the configuration, the Create User page prompts for different values. The User Name value in this case should be orclguest. The rest of the values should be filled in, accordingly. Ensure that all of the required fields are filled in.

    5. Click Submit.

  5. Complete the following steps to complete the provisioning of the orclguest user using Oracle Directory Manager.

    1. Locate the DN of the default realm.

      Using Oracle Directory Manager, log in as cn=orcladmin. In the Entry Management section, navigate to the cn=common,cn=products, cn=oraclecontext entry. The value of the orcldefaultsubscriber attribute is the DN of the default realm.

    2. Locate the DN of the orclguest user entry.

      Using Oracle Directory Manager, navigate to the cn=common,cn=products,cn=oraclecontext,default_realm_DN entry under the default realm DN. The value of the orclcommonusersearchbase attribute is the DN of the user search base.

      Navigate to this DN. The orclguest user entry resides in the subtree under this DN—most likely one level under the user search base. Make note of the complete DN of this user.

    3. Set the orclguest user's default profile group to OCS_PORTAL_USERS.

      In the entry of the orclguest user, select All from View Properties in the DN of the orclguest user. Populate the orcldefaultprofilegroup attribute with the value cn=ocs_portal_users,cn=groups,default_realm_DN. Substitute default_realm_DN with the DN obtained in step a of this procedure.

    4. Add orclguest to the OCS_PORTAL_USERS group.

      Using Oracle Directory Manager, navigate to the cn=ocs_portal_users,cn=groups,default_realm_DN entry. Add the orclguest DN obtained in step b to the uniquemember attribute. Do not remove any existing values of the attribute. Make note of the DN of the ocs_portal_users entry.


      Note:

      When you create a new user, the Oracle Collaboration Suite Home page is not set by default.


      See Also:

      "Troubleshooting Oracle Collaboration Suite Web Client Configuration" for information on how to set the Oracle Collaboration Suite Home page

Upgrading Oracle Email on the Oracle9iAS Infrastructure

To upgrade Oracle Email on the Oracle9iAS infrastructure:

  1. Make Access Control List (ACL) changes that allow e-mail administrators to modify e-mail attributes of base users.

    1. Run oidadmin and connect as cn=orcladmin.

    2. Go to the entry cn=Common,cn=Products,cn=OracleContext.

    3. Get the value of attribute orclsubscribersearchbase from the common container.

    4. Back up emailaci.ldif under %ORACLE_HOME%\oes\bin and re-create it with the following text:


      Note:

      The last two lines of this text must be entered as a single line.

      dn: %SUBSCRIBER_SEARCHBASE%
      changetype: modify
      add: orclaci
      orclaci: access to attr=(mail) by group="cn=EmailAdminsGroup,
      cn=EMailServerContainer,cn=Products,cn=OracleContext"(write)
      
      
    5. Substitute %SUBSCRIBER_SEARCHBASE% in the script emailaci.ldif with the value for orclsubscribersearchbase retrieved in step c of this procedure.

    6. Load emailaci.ldif:

      ldapmodify -v -a -Dcn=orcladmin -w orcladmin_password -h ldap_host -p
      ldap_port -f emailaci.ldif
      
      
  2. Index attribute targetdn. This allows the attribute to be searched, which is required by Oracle Email.

    1. Log in to the computer that has the Oracle9iAS infrastructure Oracle Internet Directory as the owner of the database.

    2. Shut down the Oracle Internet Directory server.

    3. Run catalog.bat for the targetdn:

      %ORACLE_HOME%\ldap\bin/catalog.bat -connect infrastructure_connectstr
      -add -attr targetdn
      
      
    4. Restart the Oracle Internet Directory server.

Upgrading Oracle9iAS Wireless on the Oracle9iAS Infrastructure

The Oracle9iAS Wireless schema in the Oracle Collaboration Suite Metadata Repository is automatically upgraded during installation of the Oracle Collaboration Suite Release 2 (9.0.4.1.1) middle tier against the existing metadata repository. You do not have to perform any additional upgrade steps on the Oracle Collaboration Suite Infrastructure.


See Also:

"Upgrading Oracle9iAS Wireless" for further Oracle9iAS Wireless upgrade instructions

Upgrading the Oracle Collaboration Suite Information Storage Database

Both the Oracle Email and Oracle Files information stores from Oracle Collaboration Suite Release 1 (9.0.3) must be upgraded to Oracle9i 9.2.0.3.

To update the information storage database to Oracle9i 9.2.0.3, download the patch 2761332 for the Oracle9i Database Server from OracleMetaLink at:

http://metalink.oracle.com/

Notes:

After you apply patch 2761332, you must run the catldap.sql configuration script as the database SYS user on the database host system from \rdbms\admin.

Upgrading the Oracle Collaboration Suite Middle Tier

This section describes how to upgrade the Oracle Collaboration Suite middle tier from Release 1 (9.0.3) to Release 2 (9.0.4.1.1).

This section contains these topics:


Important:

To enable multiple language support, you must follow the procedures in "Enabling Multiple Language Support in Oracle Collaboration Suite Release 2 (9.0.4.1.1)" before performing the upgrade tasks in this section.

Installing Oracle Collaboration Suite Release 2 (9.0.4.1.1) Middle Tier

Before upgrading the middle tier, you must install the Oracle Collaboration Suite Release 2 (9.0.4.1.1) middle tier into a different Oracle home on the same computer as the Release 1 (9.0.3) middle tier, as follows:

  1. Shut down all Release 1 (9.0.3) processes.

  2. Follow the middle tier installation instructions in "Installing the Oracle Collaboration Suite Middle Tier", with the following exception:

    When installing Oracle Collaboration Suite Release 2 (9.0.4.1.1), deselect the Oracle Files check box in the Oracle Universal Installer, so that the Oracle Files configuration assistant is not launched automatically.

    If the Oracle Files configuration assistant does launch, click Cancel to exit.


Notes:

  • During the middle tier configuration phase, the Web client installation will NOT succeed, but this step is still required as it configures what would otherwise require manual configuration.

  • The upgrade assistant requires that the inventory location for Release 1 (9.0.3) and Release 2 (9.0.4.1.1) should be same during a Release 2 (9.0.4.1.1) middle tier installation.


Component Pre-Upgrade Tasks

This section lists the pre-upgrade tasks that you must perform before beginning the upgrade process.

This section contains these topics:

Oracle Calendar Pre-Upgrade Tasks

Before upgrading Oracle Calendar, run ocalPreUpg.cmd from %ORACLE_HOME%\ocal\upgrade. This creates a virtual drive that will be used during the upgrade process and automatically deleted when the upgrade has been successfully completed.


Note:

Before performing an upgrade, you are advised to re-evaluate your sizing calculations based on the requirements provided for the new software. See Appendix A, "Disk Space and Memory" in the Oracle Calendar Administrator's Guide for more information. (Although this appendix is UNIX-specific, the requirements for Windows are similar.) For CPU usage, the hardware requirements have changed as a result of added functionality. If in your current calendar installation you track regular peaks in CPU usage at 60% or greater several times a day, you may require additional CPU for a new installation. You will also notice increased CPU usage if your deployment contains previous versions of the calendar clients working against a new calendar server.

Oracle Email Pre-Upgrade Tasks

Before upgrading Oracle Email, you must perform the following tasks:

  • Apply patch 2868153 to the Oracle Collaboration Suite Release 1 (9.0.3) ORACLE_HOME to upgrade the existing permissions on shared folders to a format that is required by Release 2 (9.0.4.1.1).

  • If you are planning on running multiple middle tiers that include installations of both Oracle Collaboration Suite Release 1 (9.0.3) and Oracle Collaboration Suite Release 2 (9.0.4.1.1), then you must apply patch 2979341 to the Oracle Collaboration Suite Release 1 (9.0.3) installations. This is necessary in order for the Oracle Collaboration Suite Release 1 (9.0.3) installations to access shared folders created by Oracle Collaboration Suite Release 2 (9.0.4.1.1) clients.


Note:

The required patches are available on OracleMetaLink at
http://metalink.oracle.com/

Oracle Ultra Search Pre-Upgrade Tasks

Before upgrading Oracle Ultra Search, you must perform the following tasks:

  • Log in to the Oracle Collaboration Suite Release 1 (9.0.3) Oracle Ultra Search administration tool to stop and disable all crawler synchronization schedules in every Oracle Ultra Search instance. You can enable all crawler synchronization schedules after upgrading to Oracle Collaboration Suite Release 2 (9.0.4.1.1).

  • Use the Oracle Net configuration assistant to set up the network service name for the Oracle Collaboration Suite infrastructure database.


    See Also:

    Oracle9i Net Services Administrator's Guide for details on using the Oracle Net configuration assistant

  • In case of any failure during the upgrade, back up all the files in the database host %ORACLE_HOME%\ultrasearch directory

Oracle Voicemail & Fax Pre-Upgrade Tasks

Before upgrading Oracle Voicemail & Fax, you must perform the following tasks:

  • Shut down the advanced queue message waiting indicator (AQMWI) processes on the Oracle Collaboration Suite Release 1 (9.0.3) middle tier.

  • In case of any failure during the upgrade, back up the following trees in Oracle Internet Directory:

    cn=midtier_hostname, cn=computers, cn=oraclecontext 
    cn=telephony_server_host_name, cn=computers, cn=oraclecontext 
    cn=umontainer,cn=products,cn=oraclecontext 
    
    
  • Back up the Oracle Collaboration Suite Release 1 (9.0.3) targets.xml file located in the %ORACLE_HOME%\sysman\emd directory.

  • On the Windows 2000 system, stop all running Oracle Voicemail & Fax Release 1 (9.0.3) processes. Also, delete all existing Oracle Voicemail & Fax Release 1 (9.0.3), including rmid, rmiregistry, and all services that begin with UM.

    On the Windows 2000 system, remove the Oracle Voicemail & Fax container part from the sc_vsto.cfg file and restart the CT server.


    See Also:

    "Adding an Additional Information Storage Database to Oracle Collaboration Suite" for information about configuring the sc_vsto.cfg file

Oracle9iAS Wireless Pre-Upgrade Tasks

If you are upgrading multiple Oracle Collaboration Suite Wireless middle tiers, you must perform the following steps before starting the Oracle Collaboration Suite Upgrade Assistant:

  1. Stop all Oracle Collaboration Suite Release 1 (9.0.3) Wireless middle tiers in the farm, including any Oracle9iAS middle tiers that are configured to run Oracle9iAS Wireless.


    Caution:

    Ensure that you have a backup of the Oracle Collaboration Suite Release 1 (9.0.3) Wireless schema in the infrastructure before you perform the installation of the first Oracle Collaboration Suite Release 2 (9.0.4.1.1) Wireless middle tier, because that schema is upgraded during the installation of the first Oracle Collaboration Suite Release 2 (9.0.4.1.1) Wireless middle tier.


  2. Select the first Oracle Collaboration Suite Release 1 (9.0.3) Wireless middle tier to be upgraded.

  3. Install the first Oracle Collaboration Suite Release 2 (9.0.4.1.1) Wireless middle tier on the same computer as the Oracle Collaboration Suite Release 1 (9.0.3) Wireless identified in the previous step.

Oracle Collaboration Suite Upgrade Assistant

The Oracle Collaboration Suite upgrade assistant is a command-line tool that automates the process of upgrading Oracle Collaboration Suite Release 1 (9.0.3) to Oracle Collaboration Suite Release 2 (9.0.4.1.1). During the upgrade process, you choose which Oracle Collaboration Suite components you want to upgrade. The Oracle Collaboration Suite upgrade assistant then runs separate plug-ins for each component you are upgrading to complete the upgrade process.

The Oracle Collaboration Suite upgrade assistant is located in the following directory:

%ORACLE_HOME%\upgrade

The preceding directory contains three primary files that are used in the upgrade process: ocsua.xml, ocsua.properties, and ocsua.bat. Each of these files is described later in this section. The Oracle Collaboration Suite upgrade assistant also contains the following two directories:

%ORACLE_HOME%\upgrade\log
%ORACLE_HOME%\upgrade\lib

The log directory contains log files generated during the upgrade process. The lib directory contains .jar files that are required by the Oracle Collaboration Suite upgrade assistant framework.

This section contains these topics:

The ocsua.xml File

The ocsua.xml file lists the component plug-ins along with variables that require user input. The Oracle Collaboration Suite upgrade assistant framework reads this file in order to read the plug-ins that perform the individual component ugprades. Do not modify this file.

The ocsua.properties File

The ocsua.properties files contains optional properties that are used by the Oracle Collaboration Suite upgrade assistant framework. If a property does not exist in the file, then the upgrade process uses the default values in the Java classes that are required by the Oracle Collaboration Suite upgrade assistant framework. The contents of the ocsua.properties are as follows:

# 
# Global properties
# 
# These properties apply to all components of Upgrade Assistant.
# 
# Default global log level is NOTIFICATION 
log.level=NOTIFICATION 
# 
# Utilities component 
# 
# Default log level for CopyFile class is NOTIFICATION 
CopyFile.log.level=NOTICATION 
# 
# Component plug-in specific properties 
# 
#   For log level, the property name is plugin-name as a prefix 
#   with ".log.level". Plug-ins can define any names for 
#   other properties as long as they are prefixed with the 
#   plug-in name 
# 
# Example: setting Ultra Search plug-in log level to TRACE to overide default 
#          log level of NOTIFICATION 
#UltraSearch.log.level=TRACE

Running the Oracle Collaboration Suite Upgrade Assistant


Notes:

  • All Oracle Collaboration Suite components must be upgraded at the same time.

  • If the Oracle Collaboration Suite Release 1 (9.0.3) directory you are upgrading is also an active Oracle Enterprise Manager directory, the Oracle Enterprise Manager directory will be changed to the new Oracle Collaboration Suite Release 2 (9.0.4.1.1) directory. If the active Oracle Enterprise Manager directory is not the same as the Oracle Collaboration Suite Release 1 (9.0.3) home directory, it will not be changed.

  • The ocsua.bat script upgrades one information store at a time and must be run each time for multiple information stores.

  • Upgrading a middle tier does not create outages for other middle tiers in your system.

  • Coexistence of multiple Oracle Email middle tiers on one computer is not supported in this release of Oracle Collaboration Suite.

  • If you are upgrading Oracle Ultra Search from an existing Oracle9i database, refer to the Oracle Ultra Search User's Guide.

  • If you are upgrading Oracle Ultra Search from an existing Oracle9iAS infrastructure, refer to the Oracle Ultra Search Release Notes.

  • You must set the TNS connect string for Oracle9iAS Metadata Repository before running the upgrade assistant.

  • The Oracle Collaboration Suite Web client is upgraded using the Web client configuration assistant. Before invoking the Web client configuration assistant, manually ensure that the Oracle9iAS Portal middle tier has been installed or upgraded, and configured. See "Upgrading the Oracle Collaboration Suite Web Client".


The Oracle Collaboration Suite upgrade assistant automatically performs the following steps:

  • Verifies the existing and version number of the source Oracle Collaboration Suite directory that is being upgraded

  • Identifies the plug-ins to executed, based on the components you select to upgrade

  • Identifies the configuration files to update in the Oracle Collaboration Suite Release 1 (9.0.3) source directory for each component that is being upgraded

  • Displays a prompt for the values of common and plug-in specific variables for the components that are being upgraded

    Table 3-3 lists information you will need to provide to the Oracle Collaboration Suite upgrade assistant for Oracle Files.

    Table 3-3 Required Oracle Files Information for Oracle Collaboration Suite Upgrade Assistant

    Information Description
    Host The database host where the existing Oracle Collaboration Suite Release 1 (9.0.3) Oracle Files schema resides
    Port The database listener port
    SID The database service name

    Table 3-4 lists information you will need to provide to the Oracle Collaboration Suite upgrade assistant for Oracle Files if your existing Oracle Collaboration Suite Release 1 (9.0.3) Oracle Files schema is integrated with Oracle Workflow.


    Note:

    The schema upgrade process should be performed only for the first middle tier, not for any additional middle tiers.

    Table 3-4 Required Oracle Files Information for Oracle Collaboration Suite Upgrade Assistant if Oracle Files is Integrated with Oracle Workflow

    Information Description
    Oracle Files Schema The name of the Oracle Files schema to integrate with the Oracle Workflow schema
    Oracle Files Schema Password The password for the Oracle Files schema
    Oracle Workflow Schema The name of the Oracle Workflow schema that is integrated with Oracle Files schema
    Oracle Workflow Schema Password The password for the Oracle Workflow schema

    If an error occurs while upgrading an Oracle Collaboration Suite Release 1 (9.0.3) Oracle Files schema, check the following log file for more information:

    %ORACLE_HOME%\upgrade\log\FilesUpgrade.log
    
    

    Table 3-5 lists information you will need to provide to the Oracle Collaboration Suite upgrade assistant for Oracle Ultra Search.

    Table 3-5 Required Oracle Ultra Search Information for Oracle Collaboration Suite Upgrade Assistant

    Information Description
    SYS password Database SYS password
    WKSYS password Database WKSYS password
    TNS connect string Database TNS connect string

  • Displays a summary of files that need to be upgraded for each component

  • Displays a list of pre-upgrade tasks that need to be performed, along with any warnings

To run the Oracle Collaboration Suite upgrade assistant, perform the following steps on the Oracle Collaboration Suite Release 2 (9.0.4.1.1) middle tier:

  1. Change directory to %ORACLE_HOME%\upgrade.

  2. Execute the ocsua.bat script to start the Oracle Collaboration Suite upgrade assistant and begin the upgrade process. The usage of the ocsua.bat file is as follows:

    bash-2.05$ ocsua.bat -help 
    ocsua -sourcehome sourcehome [-config input XML] [-all] 
    Upgrade configuration files to the Oracle Collaboration Suite 
    Release 2 (9.0.4.1.1) Oracle home: -sourcehome ORACLE_HOME for 
    Oracle Collaboration Suite Release 1 (9.0.3) -config Input XML file that 
    lists all the plug-ins [-all] Run all the component plug-ins without prompt
    
    

The first time you perform an upgrade by executing the ocsua.bat file, the upgrade process automatically upgrades the Oracle9iAS components that are required by Oracle Collaboration Suite, including Oracle9iAS Portal, Oracle9iAS Web Cache, and Oracle Enterprise Manager.


ocsua.bat Script Example

Example 3-1 shows the log transcript of a sample upgrade session. It shows both input and output.

Example 3-1 ocsua.bat Script

C:\OCSV2Home> ocsua.bat -sourcehome C:\OCSV1Home
Validating Oracle homes
-------------------
These are the components that can be upgraded
1. Oracle9iAS Portal
2. Oracle Ultra Search
3. Oracle9iAS Wireless
4. Oracle Calendar Server
5. Oracle Calendar Application System
6. Oracle Email
7. Oracle Email Store
8. Oracle Voicemail & Fax
9. Oracle Files
Enter component numbers and/or ranges(example:1-3,5)[all]:
--------------------------------------------------------------
Validating component plug-ins
-------------------
Examining "Oracle9iAS Portal"
Upgrade items found:
Oracle_Collaboration_Suite_Release_1_ORACLE_HOME/assistants/opca/ptlasst.csh
-------------------
Examining "Oracle Ultra Search"
Upgrade items found:
Oracle_Collaboration_Suite_Release_1_ORACLE_HOME/j2ee/OC4J_Portal/config/dat
a-sources.xml
-------------------
Examining "Oracle9iAS Wireless"
Upgrade items found:
Oracle_Collaboration_Suite_Release_1_ORACLE_HOME/wireless/server/classes/ora
cle/panama/marconi/marconi.config
Upgrading the Oracle Collaboration Suite Middle Tier
Upgrading to Oracle Collaboration Suite Release 2 (9.0.4.1.1) 3-21
Oracle9iAS Wireless Repository
-------------------
Examining "Oracle Calendar Server"
Upgrade items found:
Oracle Calendar Server configuration files
Oracle Calendar Server database files
Oracle Calendar Server Oracle Internet Directory entries
Oracle Calendar Server administrator administration files
-------------------
Examining "Oracle Calendar Application System"
Upgrade items found:
Oracle Calendar applications configuration file
Oracle Calendar Web Client files
-------------------
Examining "Oracle Email"
Upgrade items found:
Oracle Email Oracle Internet Directory entries
Webmail configuration
listener.ora
oc4j.properties
-------------------
Examining "Oracle Email Store"
Upgrade items found:
Oracle Email Store
-------------------
Examining "Oracle Voicemail & Fax"
Upgrade items found:
Oracle Voicemail & Fax Oracle Internet Directory product tree
Oracle Voicemail & Fax mid-tier Oracle Internet Directory entry
-------------------
Examining "Oracle Files"
Upgrade items found:
Oracle Files Schema
--------------------------------------------------------------
Validate pre-upgrade requirements:
The destination Oracle home has not been modified since it was installed.
The source and destination instances of Oracle Collaboration Suite are not
running.
The Oracle Enterprise Manager Web Site is not running.
The source Oracle home is based on Oracle9iAS 9.0.2.0.1 version with interim
patches.
[Oracle Ultra Search] A tnsnames.ora file has been created in the destination
Oracle home and contains an entry for the Oracle9iAS Metadata Repository
Upgrading the Oracle Collaboration Suite Middle Tier
3-22 Oracle Collaboration Suite Installation and Configuration Guide
containing the Oracle Ultra Search schema.
[Oracle Calendar Server] The ocalPreUpg.bat script has been run in the
destination Oracle home.
Have you verified all pre-upgrade requirements?[No]Y
--------------------------------------------------------------
Specify the TNS connect string for the Oracle9iAS Metadata Repository used
by Oracle Ultra Search, as well as passwords for the following users: 
TNS Connect: TNS_connect_string
SYS Password: password
WKSYS Password: password
-------------------
Specify connection information (host:port:SID) and associated passwords
for the Oracle Email Store to be upgraded:
Oracle Email Store Connect: host_name:port_number:SID
SYS Password: password
ESMail Password: password
CTXSYS Password: password
-------------------
Specify connection information for the Oracle Files Store to be upgraded:
Host: database_host_name
Port: port_number
SID: service_name
-------------------
Specify the Oracle Files schema and password in the Oracle Files Store to be
upgraded:
Oracle Files Schema: IFSSYS
Oracle Files Schema Password: password
-------------------
If Oracle Workflow was integrated with Oracle Files in the source installation,
specify the Oracle Workflow schema and password. If Oracle Workflow was not
integrated with Oracle Files, leave both fields blank:
Oracle Workflow Schema: OWF_MGR
Oracle Workflow Schema Password: password
--------------------------------------------------------------
Upgrading "Oracle Portal"
Executing the script
Oracle_Collaboration_Suite_Release_1_ORACLE_HOME/assistants/opca/ptlasst.csh
to upgrade Oracle Portal
Script terminated with exit value 0
Upgrade finished with status: Success.
-------------------
Upgrading "Oracle Ultra Search"
Upgrading the metadata schema (this will take approximately 5 to 10 minutes)
The schema upgrade log file is XXXXX
Finished upgrading metadata schema
Upgrading the Oracle Collaboration Suite Middle Tier
Upgrading to Oracle Collaboration Suite Release 2 (9.0.4.1.1) 3-23
Getting JDBC connection
Loading Java stored packages (this will take approximately about 3 to 5
minutes)
Finished loading Java stored packages
Creating the file materialization table
Upgrading database files (this will take approximately about 15 to 30
seconds)
Processing XXXXX
Finished upgrading database files
Dropping the file materialization table
Upgrading mid-tier configuration files...
Processing XXXXX
Finished upgrading mid-tier configuration files
Upgrade finished with status: Success.
-------------------
Upgrading "Oracle9iAS Wireless"
Copying Oracle9iAS Wireless customization files.
Upgrading Oracle9iAS Wireless repository.
Upgrade finished with status: Success.
-------------------
Upgrading "Oracle Calendar Server"
Upgrading configuration files.
Upgrading database files.....
Upgrading Oracle Internet Directory entries...
Upgrading administration files.
Upgrade finished with status: Success.
--------------------
Upgrading "Oracle Calendar application system"
Upgrading configuration files
Upgrading Web Client files
Upgrade finished with status: Success.
-------------------
Upgrading "Oracle Email"
Upgrading Oracle Internet Directory entries...
Upgrading configuration files/205
Upgrading Oracle Webmail configuration files/205
Upgrading listener.ora...
Upgrading oc4j.properties...
Upgrade finished with status: Success.
-------------------
Upgrading "Oracle Email Store"
Upgrading database content. (this will take approximately 20 minutes)
Upgrade finished with status: Success.
-------------------
Upgrading "Oracle Voicemail & Fax"
Upgrading product tree in Oracle Internet Directory.
Upgrading process tree in Oracle Internet Directory.
Post-Upgrade Tasks
3-24 Oracle Collaboration Suite Installation and Configuration Guide
Upgrade finished with status: Success.
-------------------
Upgrading "Oracle Files"
Upgrading the Oracle Files schema (this will take roughly approximately 15
to
20 minutes)
Upgrade finished with status: Success.
--------------------------------------------------------------
>>>>>>>>>>>>>>> The upgrade completed successfully <<<<<<<<<<<<<<<<<<
You must now complete the following post-upgrade tasks:
[Oracle Files] Run the following script manually to complete the Oracle Files
upgrade:
Oracle_Collaboration_Suite_Release_2_ORACLE_HOME/ifs/files/bin/ifsca
[Oracle9iAS Web Cache] The following files may need to be upgraded manually
if they were customized in the old Oracle home:
Oracle_Collaboration_Suite_Release_2_ORACLE_HOME/XXX
Oracle_Collaboration_Suite_Release_2_ORACLE_HOME/XXX
[Oracle Enterprise Manager] The
Oracle_Collaboration_Suite_Release_2_ORACLE_HOME/sysman/emd/targets.xml file
may contain duplicate target entries from both the old Oracle home and the new
Oracle home. If you want to remove the old targets, edit this file.
--------------------------------------------------------------
Log files containing details of the upgrade process can be found in the
following location:
Oracle_Collaboration_Suite_Release_2_ORACLE_HOME/upgrade/log
A transcript of this upgrade session can be found at:
Oracle_Collaboration_Suite_Release_2_ORACLE_HOME/log/ocsua.log

Post-Upgrade Tasks

This section contains these topics:

Oracle Calendar Coexistence

Coexistence can be useful for a large organization that is upgrading its current installation of Oracle Calendar to Release 2 (9.0.4.1.1). The ability to have nodes and servers of different versions connected and running at the same time can help reduce the down time required to achieve the upgrade.


Note:

Coexistence between Oracle Calendar server 5.5 and Oracle Calendar server 9.0.4 is viewed as a migration step toward having a uniform (same version) network of calendar servers. It is not recommended that a mix of the two versions be sustained for a long period of time or permanently.

This section contains the following topics:


Oracle Calendar Server Parameters

Coexistence will only work after the following parameters are added to %ORACLE_HOME%\ocal\misc\unison.ini on the 9.0.4 calendar server.

Section: [ENG]

Parameter: coexist_cwsbasicauth

Value: TRUE

Section: [ACE_PLUGINS_SERVER]

Parameter: cs-standard_coexistence

Value: TRUE


Important:

As a security precaution, you must remove the preceding parameters from %ORACLE_HOME%\ocal\misc \unison.ini immediately after all calendar servers are upgraded to 9.0.4.


The following parameters will be reset to the default values listed here. If you used different values in your Oracle Calendar server 5.x installation, reset them to your desired values after completing the upgrade.

Parameter: resourcemailmap

Value: "O"

Parameter: usermailmap

Value: "O"

Parameter: usersmcprefmap

Value: "OU3"

Parameter: usermobiletypemap

Value: "N"

Parameter: usermobilemap

Value: "R"

Parameter: itemuidmap

Value: "P"


Coexistence Limitations

There are limitations in having two servers of different versions coexist.

  • Web services 9.0.4 will only work when all connected servers are upgraded to version 9.0.4

  • Event calendars are not supported in coexistence scenarios

  • Passwords longer than 15 characters are not supported by the 5.5 calendar server or pre-9.0.4 Oracle Calendar clients. Consequently, users with passwords longer than 15 characters will not be able to log in to older clients.

  • Do not use 9.0.4 utilities to administer a 5.x Oracle Calendar server. The only exception to this is when moving users; the moveuser utility must be from the latest server version (9.0.4), even if moving a user between two nodes that are both on old server nodes (5.x).

  • Do not use 5.x utilities to administer a 9.0.4 Oracle Calendar server.

  • If you need to create a node network, the nodes.ini and the use of uninode commands must be done on the most recent version (9.0.4) of the server within the network.

  • Coexistence may cause odd error messages on an old Oracle Calendar server (5.x). This is because the old server may not understand the features introduced by the new server.

  • Mapping parameters have been added to the 9.0.4 server unison.ini for coexistence and upgrades. 5.x servers map O for EMAIL and P for UID. However, 9.0.4 servers do not need this mapping anymore. Parameters added to a 9.0.4 server do not affect it.

    The new parameters include:

    [ENG]
    usermailmap = O
    itemuidmap = P
    resourcemailmap = O
    usersmscprefmap = OU3
    usermobiletypemap = N
    usermobilemap = R
    
    
  • Unidbfix -c may report "Minor inconsistencies" on an Oracle Calendar 9.0.4 server when events are created by an Oracle Calendar 9.0.4 user using Oracle Connector for Outlook 9.0.4 and accepted or declined by an Oracle Calendar 5.4 user using the Windows Native client 9.0.4. These inconsistencies do not impact the integrity of the database.

  • Users of previous versions of Oracle Calendar will not generate e-mail messages when using resource scheduling

  • Attachment names may change to Mime-Encoded-attachment.txt when using a mix of Oracle Calendar 9.0.4 and 5.4 users with Oracle Connector for Outlook. The attachments will still be readable.

  • Oracle Calendar desktop clients for Macintosh (V5.2.3) users may not be able to download offline files while connecting to a 9.0.4 standalone installation

  • The current versions of Oracle Calendar clients work with Oracle Calendar server 9.0.4, including:

    • Oracle Calendar desktop client for Windows 6.0.5

    • Oracle Calendar desktop client for Macintosh version 5.2.3

    • Oracle Calendar desktop client for Linux/Solaris version 5.0.2

    • Oracle Connector for Outlook version 3.3 and later

    It is best to use these client versions; if you are using an older client, please upgrade before proceeding with testing. The latest versions of the clients are available at:

    http://metalink.oracle.com
    
    
  • The Oracle Calendar portlet of Oracle Collaboration Suite Web Client Release 1 (9.0.3) is not compatible with Oracle Calendar Release 2 (9.0.4.1.1). To avoid this problem, upgrade both components to Release 2 (9.0.4.1.1), as described in "Installing the Oracle Collaboration Suite Middle Tier".

    If you have already upgraded Oracle Calendar but not the Oracle Collaboration Suite Web Client, see "Upgrading the Oracle Collaboration Suite Web Client".


Oracle Calendar Application System Upgrades

The upgrade assistant only migrates the following keys. Unless otherwise mentioned, they are migrated to ocwc.conf. Your installation will still work, but you may need to make changes to your parameters to get the look and feel you want. For information on editing parameters, see the Oracle Calendar Reference Manual.

[system]
connection

[servers]
(All keys migrated to "connection" section of ocas.conf. If the old installation 
was a masternode, 'mnode' will be the only entry.)

[ACE_PLUGINS_CLIENT]
(All keys into ocas.conf)

[admin]
sso_user_env_key

[modules]
hide_eventcal
hide_global
hide_taskview
hide_managegroups
hide_suggesttime
hide_show_unconfirmed
hide_updateall
enable_designate
hide_viewpub

[file_attachment]
download_enable
upload_enable

[taskview]
quickCreateStartTime
quickCreateEndTime
showQCCompletion

[calendar_view]
default_view
default_dayview_mode
default_weekview_mode

hide_dayview_toggle
hide_weekview_toggle
pdv_notes_top_task_bottom
default_color_mgt_by

[cookies]
domain

[sched]
showicalvcal (becomes same key in "modules" section in ocwc.conf).

Oracle Email Post-Upgrade Tasks

The Oracle Email information storage database is upgraded when you run the Oracle Collaboration Suite upgrade assistant, as explained in "Running the Oracle Collaboration Suite Upgrade Assistant ".

Additionally, perform the following steps to install required files and libraries on the Release 2 (9.0.4.1.1) information storage database:

  1. Copy the umbackend.tar file located in the Oracle Collaboration Suite Release 2 (9.0.4.1.1) middle tier %ORACLE_HOME%\oes directory to the information storage database.

  2. Untar umbackend.tar to create the backend directory.

  3. Go to the backend\Disk1\install\win32 directory and enter the following command:

    setup.exe
    

Upgrading Oracle Email Jar Files

Run the following commands to upgrade the Oracle Email jar files from the Release 2 (9.0.4.1.1) middle tier Oracle home. These commands must be run once for each mail store.

cd %ORACLE_HOME%\oes\bin
esupgv2_lj.bat password connect_string Release 2 (9.0.4.1.1)_middle_tier_
%ORACLE_HOME%

where password is the es_mail user password and connect_string is the connect string for the information storage database.


Note:

The ORA-29521 error from the preceding script should be ignored.

Moving Current E-mail Text Index into New Tablespace

To move the current e-mail text index to a new tablespace, you must do it manually, as follows:

  1. Log in to the information storage database as the es_mail user.

  2. From a command prompt, log in to SQL*Plus, as follows:

    c:\> sqlplus es_mail/es
    

    Note:

    es is the default password for the es_mail user.

  3. Execute the following commands:

    1. drop es_ot_ix_search index

    2. drop ctx_ddl.drop_preference('oratextstore')

    3. ctx_ddl.create_preference('oratextstore', 'BASIC_STORAGE');

    4. ctx_ddl.set_attribute('oratextstore', 'I_TABLE_CLAUSE',
      'tablespace my_new_text_tblspc');

    5. ctx_ddl.set_attribute('oratextstore', 'K_TABLE_CLAUSE',
      'tablespace my_new_text_tblspc');

    6. ctx_ddl.set_attribute('oratextstore', 'R_TABLE_CLAUSE',
      'tablespace my_new_text_tblspc lob (data) store as (cache)');

    7. ctx_ddl.set_attribute('oratextstore', 'N_TABLE_CLAUSE',
      'tablespace my_new_text_tblspc');

    8. ctx_ddl.set_attribute('oratextstore', 'I_INDEX_CLAUSE',
      'tablespace my_new_text_tblspc');

    9. ctx_ddl.set_attribute('oratextstore', 'P_TABLE_CLAUSE',
      'tablespace my_new_text_tblspc');

    where my_new_text_tblspc is the name of the tablespace where the e-mail text index will be created.

  4. Execute the following command to create the e-mail text index in the new tablespace:

    CREATE INDEX es_ot_ix_search ON es_imt_msgbody(text) indextype IS
    ctxsys.context parameters ('DATASTORE es_search_dspref FILTER
    CTXSYS.NULL_FILTER SECTION GROUP es_search_sec_group STORAGE
    oratextstore);
    

Upgrading Oracle Webmail 9.0.3.1 to 9.0.4

There are two manual steps required to complete the installation of Oracle Webmail on the Windows platform:

Configuring the Oracle Webmail Application

Perform the following steps to maintain the application 9.0.3.1 settings:

  1. Backup the default Oracle Webmail 9.0.4 application configuration.

    cp %NEW_ORACLE_HOME%\j2ee\OC4J_UM\config\oc4j.properties NEW_ORACLE
    _HOME\j2ee\OC4J_UM\config\oc4j.properties.bak
    
    
  2. Copy the old Oracle Webmail 9.0.3.1 application configuration to the 9.0.4 location

    cp %OLD_ORACLE_HOME%\j2ee\OC4J_UM\config\oc4j.properties 
    NEW_ORACLE_HOME\j2ee\OC4J_UM\config\oc4j.properties
    
    
  3. Remove the obsolete properties from the new properties file. This can be done by editing %NEW_ORACLE_HOME%\j2ee\OC4J_UM\config\oc4j.properties and removing the lines with the following attributes:

    • client.image.help

    • client.image.login

    • client.image.logout

    • client.image.portal

    • client.image.preferences

    • voicemailLanguages

  4. If you are still using the old defaults for the following values, you should change them to point to the new defaults:


    Note:

    Old defaults are shown in parentheses.

    • client.image.corporate=/um/images/ocs_brand_header.gif (/um/images/corporateBrand_oracle.gif)

    • client.image.product=/um/images/mail_subbrand.gif (/um/images/branding_collaborationsuite.gif)

    • mail.host.qualifiedname=(oracle.com - This new default is empty)

    • maxTelephonePinDigits=12 (8)

    • minTelephonePinDigits=7 (4)

    • toolkit.statefile=%NEW_ORACLE_HOME%\\um\\client\\config\\statefile_webmail.xml (%OLD_ORACLE_HOME%\\um\\client\\config\\statefile.xml)

  5. The following properties should be added to the new oc4j.properties file, if they are not already present:

    client.esdsconnpoolparam.incrementsize=1
    client.esdsconnpoolparam.initialsize=5
    client.esdsconnpoolparam.maxsize=10
    client.esdsconnpoolparam.minsize=5
    client.esdsconnpoolparam.shrinkingtimeoutinterval=1800
    client.esdsconnpoolparam.timeoutinterval=30
     
    client.ldapsearch.maxresult=500
     
    client.mail.defaultsort=true
    client.mail.enforcenestedHTMLfonts=true
    client.mail.messagetransport=SMTP
     
    jdbc.connection.debug=false
    mail.debug=false
     
    oracle.mail.admin.ui.ojmaDebug=false
    oracle.mail.admin.ldapDebug=false
    oracle.mail.admin.policy.virus.parallelism.high=8
    oracle.mail.admin.policy.virus.parallelism.low=1
    oracle.mail.admin.policy.virus.parallelism.medium=4
     
    oracle.mail.client.prefs.autoreply.echo=true 
    oracle.mail.client.prefs.autoreply.reject=true 
    oracle.mail.client.prefs.autoreply.reply=true
    oracle.mail.client.prefs.autoreply.vacation=true
    oracle.mail.client.prefs.autoreply=true
    oracle.mail.client.prefs.autoreplymimesizelimit=-1
     
    oracle.mail.sdk.esmail.cache_inactivity_timeout=300
    oracle.mail.sdk.esmail.connpool_max_limit=10
    oracle.mail.sdk.esmail.connpool_min_limit=1
    oracle.mail.sdk.esmail.ldap_debug=true
    

Updating the Java Libraries

Execute the following Perl script to update the set of java library settings used by the client:

%NEW_ORACLE_HOME%\perl\5.6.1\bin\MSWin32-x86\perl.exe %NEW_ORACLE
_HOME%\oes\bin\webmail_library_mods.pl

Here is the Perl script that updates the Java libraries:

#!%ORACLE_HOME%\perl\5.6.1\bin\MSWin32-x86\perl.exe
open oldxml, '<%ORACLE_HOME%\j2ee\OC4J_UM\config\application.xml.pre_libmod';
open newxml, '>%ORACLE_HOME%\j2ee\OC4J_UM\config\application.xml';
while (<oldxml>)
{
 
  $_ =~ s|<library path="../../../jlib/uix2.jar"/>||g;
        s|<library path="../../../jlib/share.jar"/>||g;
        s|<library path="../../../jlib/regexp.jar"/>||g;
        s|<library path="%long_oracle_home%\\jlib/esadmin.jar"/>||g;
        s|<library path="%long_oracle_home%\\jlib/esportlet.jar"/>||g;
        s|<library path="%long_oracle_home%\\portal/jlib/ptlshare.jar"/>||g;
        s|<library path="%long_oracle_home%\\portal/jlib/pdkjava.jar"/>||g;
  print newxml $_;
}
 
close oldxml;
close newxml;

open oldxml, '<%ORACLE_HOME%\j2ee\OC4J_UM\application-deployments\UMClientApp
\orion-application.xml.pre_libmod';
open newxml, '>%ORACLE_HOME%\j2ee\OC4J_UM\application-deployments\UMClientApp
\orion-application.xml';
while (<oldxml>)
{

  $_ =~ s|<principals|<library path="%long_oracle_home%\\j2ee/OC4J_UM
/applications/UMClientApp/um_client/WEB-INF/webmail_lib/uix2.jar"/><principals|;
        s|<principals|<library path="%long_oracle_home%\\j2ee/OC4J_UM
/applications/UMClientApp/um_client/WEB-INF/webmail_lib/share.jar"
/><principals|;
        s|<principals|<library path="%long_oracle_home%\\j2ee/OC4J_UM/
applications/UMClientApp/um_client/WEB-INF/webmail_lib/regexp.jar"
/><principals|;
        s|<principals|<library path="%long_oracle_home%\\jlib/esadmin.jar"
/><principals|;
        s|<principals|<library path="%long_oracle_home%\\jlib/esportlet.jar"
/><principals|;
        s|<principals|<library path="%long_oracle_home%\\portal/jlib
/ptlshare.jar"/><principals|;
        s|<principals|<library path="%long_oracle_home%\\portal/jlib
/pdkjava.jar"/><principals|;
  print newxml $_;
}

close oldxml;
close newxml;
 
open oldxml, '<%ORACLE_HOME%\j2ee\OC4J_UM\application-deployments\VMAdminApp
\orion-application.xml.pre_libmod';
open newxml, '>%ORACLE_HOME%\j2ee\OC4J_UM\application-deployments\VMAdminApp
\orion-application.xml';
while (<oldxml>)
{

  $_ =~ s|<principals|<library path="%long_oracle_home%\\jlib/esadmin.jar"
/><principals|;
        s|WEB-INF/vmailadmin_lib|WEB-INF/vmadmin_lib|g;
  print newxml $_;
}

close oldxml;
close newxml;

Oracle Files Post-Upgrade Tasks

Perform the following after the Oracle Collaboration Suite upgrade assistant finishes:

  1. Restart the Oracle Files configuration assistant by executing ifsca.bat from the following location:

  2. On the Domain Operation screen, select Set up this computer to use an existing Oracle Files domain.

  3. On the Schema Name screen, select the upgraded Oracle Files schema.

  4. Click Next and follow the remaining Oracle Files configuration assistant screens.


    See Also:

    "Setting Up a Computer to Use an Existing Domain" for more information about these screens

  5. On the Summary screen, click Configure.

    A progress window appears. If an error occurs, check the following log file for more information:

    %ORACLE_HOME%\ifs\files\log\FilesConfig.log
    
    

    When the process is complete, a message informs you that the configuration was successful. Click OK to close the message. Oracle Files and the Oracle Enterprise Manager Web Site are integrated automatically.


    Note:

    You must run ifsca.bat on all middle tiers.

Updating Oracle Workflow Parameters

If the Oracle Files schema that you are upgrading has been integrated with Oracle Workflow, follow the post-configuration instructions in the following sections:


Note:

You do not have to follow the steps in "Configuring Net Service Names" unless you want to change the existing Oracle Workflow configuration parameters.

Manually Synchronize the IFS_TEXT Index

After upgrading an existing Oracle Files domain, you must manually sync the existing IFS_TEXT index. For more information, see Appendix A, "Oracle Text Reference", in the Oracle Files Administrator's Guide.

Oracle Ultra Search Post-Upgrade Tasks

The following sections describe the recovery steps for common errors:


Error upgrading middle tier configuration files

Check that the data-sources.xml configuration file is available in the following Oracle Collaboration Suite Release 1 (9.0.3) directory:

%ORACLE_HOME%\j2ee\OC4J_Portal\config

Re-run the Oracle Ultra Search upgrade plug-in after you confirm the availability of the data-sources.xml file.


Failed to upgrade database file: file_name

Confirm that you have write permission to the %ORACLE_HOME%\ultrasearch directory in the database file system. Then re-run the Oracle Ultra Search upgrade plug-in.


Error upgrading metadata schema

See the schema upgrade log file for error details. Fix the problem, and then re-run the Oracle Ultra Search upgrade plug-in.


Error loading Java stored packages and upgrading database files

Check that the file %ORACLE_HOME%\ultrasearch\lib\ultrasearch_db.jar is in place. Then re-run the Oracle Ultra Search upgrade plug-in.

Upgrading Oracle Voicemail & Fax

Upgrading Oracle Voicemail & Fax is not done through the Oracle Collaboration Suite upgrade assistant.

To upgrade Oracle Voicemail & Fax:

  1. Install Oracle Voicemail & Fax Release 2 (9.0.4.1.1) on the Windows 2000 telephony server.


    Note:

    If you installed CT Media 2.1 or 2.1.1 for Oracle Voicemail & Fax Release 1 (9.0.3), you must download the latest version of ITMedia.jars with NTLMAuthentication.dll into the Program Files\Dialogic\CT Media\Client directory before you install Oracle Voicemail & Fax.

  2. Execute the following command to upgrade Oracle Voicemail & Fax:

    %ORACLE_HOME%\um\scripts\UpgradeTelephonyServerfromV1.bat host_name 
    903_ORACLE_HOME 9041_ORACLE_HOME
    

Upgrading Oracle9iAS Wireless

Upgrading Oracle9iAS Wireless involves two tasks. First, runtime customization classes and configuration files must be copied into the new Oracle home. Second, existing processes and their configurations must be moved to the new middle tier.

To upgrade Oracle9iAS Wireless:

  1. Stop all Oracle9iAS Wireless Release 1 (9.0.3) middle tiers in the farms, including any Oracle9iAS middle tiers that are configured to run Oracle9iAS Wireless.

  2. Select the first Oracle9iAS Wireless Release 1 (9.0.3) middle tier for upgrade.

  3. Install the first Oracle9iAS Wireless Release 2 (9.0.4.1.1) middle tier on the same computer as the Oracle9iAS Wireless middle tier identified in step 2. During installation, the Oracle9iAS Wireless configuration assistant upgrades the Oracle9iAS Wireless schema in the Oracle9iAS Metadata Repository (see "Oracle9iAS Wireless Upgrade Items").

    The Oracle Collaboration Suite upgrade assistant:

    1. Copies runtime customization classes (such as listener hooks and customized folder renderers) as well as suite-level configuration files from Oracle home 1 to Oracle home 2 (See "Oracle9iAS Wireless Upgrade Items").

    2. Copies the process configuration information for the Oracle9iAS Wireless standalone processes from the Oracle9iAS Wireless Release 1 (9.0.3) middle tier to the Oracle9iAS Wireless Release 2 (9.0.4.1.1) middle tier, and configures the Release 2 (9.0.4.1.1) middle tier accordingly.

At this time, all Oracle9iAS Wireless Release 2 (9.0.4.1.1) middle tiers can be restarted to reduce downtime.

The configuration information for the Oracle9iAS Wireless standalone processes is stored in the Oracle9iAS Wireless schema in the Oracle9iAS Metadata Repository. During upgrade from Release 1 (9.0.3) to Release 2 (9.0.4.1.1), the Oracle Collaboration Suite upgrade assistant copies the process configuration information from the Release 1 (9.0.3) middle tier to the Release 2 (9.0.4.1.1) middle tier by creating additional entries in the Oracle9iAS Wireless schema.

In the Oracle9iAS Wireless schema upgrade during the first middle tier installation, the Oracle9iAS Wireless configuration assistant pre-populates default standalone processes for each process type. When the Oracle9iAS Wireless upgrade assistant copies Release 1 (9.0.3) process information to a Release 2 (9.0.4.1.1) middle tier, it deletes the redundant process (if one is found in the Release 1 (9.0.3) middle tier). In addition, the Oracle9iAS Wireless upgrade assistant ensures that each process has a unique process name.


Oracle9iAS Wireless Upgrade Items

The following files are changed in the first phase of the Oracle9iAS Wireless upgrade process:

  • ORACLE_HOME_2\wireless\server\classes\*.class

  • ORACLE_HOME_2\wireless\server\classes\*.properties

  • ORACLE_HOME_2\wireless\server\classes\marconi.config

Upgrading the Oracle Collaboration Suite Web Client

The Web client can be selected to be installed and configured using the Oracle Universal Installer during installation of the Oracle Collaboration Suite middle tier.

Deleting Instances of Oracle Collaboration Suite Release 1 (9.0.3)

After you successfully upgrade to Oracle Collaboration Suite Release 2 (9.0.4.1.1), you can delete any instances of Release 1 (9.0.3) by doing the following:

  1. Remove all Release 1 (9.0.3) targets from the targets.xml file located in the %ORACLE_HOME%\sysman\emd directory in the active Enterprise Manager Daemon.

  2. Execute the following command from the Oracle Collaboration Suite Release 2 (9.0.4.1.1) ORACLE_HOME:

    cd %ORACLE_HOME%\dcm\bin
    dcmctl destroyInstance -i Release_1_instance_name
    

    Note:

    Use the following command to list all instances by name to help identify the instances to be removed:
    dcmctl listInstances
    

  3. Deinstall the old middle tier (optional).

Upgrading CorporateTime Server 5.4 to Oracle Collaboration Suite

CorporateTime Server 5.4, internal or external, can be upgraded to Oracle Collaboration Suite Release 2 (9.0.4.1.1). While this is a supported upgrade path, the process involves manual steps.

To upgrade CorporateTime Server 5.4 to Oracle Collaboration Suite:

  1. Upgrade CorporateTime Server 5.4 to Release 2 (9.0.4.1) of Oracle Calendar, standalone, as described in "Server Upgrade".

  2. Install the Oracle Collaboration Suite infrastructure and middle tier as described in Chapter 6, " Installing Oracle Collaboration Suite".


    Note:

    Ensure that you do not install into the Oracle home you used in step 1 of this section. Also, if you install Oracle Calendar Release 2 (9.0.4) on a Windows computer that has an earlier version of Oracle Calendar installed, the earlier version will become unusable. If you want to try a test installation of Oracle Calendar standalone first, install it on a different Windows computer.

  3. Migrate the user information to the Oracle Internet Directory component of your new Oracle Collaboration Suite infrastructure.

  4. Import your CorporateTime Calendar attributes, including the ctCalXitem ID, into the Oracle Internet Directory component of your new Oracle Collaboration Suite infrastructure.

  5. Copy the Oracle Calendar database files, upgraded in step 1, over to the Oracle Calendar component of your new Oracle Collaboration Suite installation.

Performing a Non-Oracle Collaboration Suite Upgrade

  1. Upgrade the Oracle9iAS infrastructure 9.0.2.0.1, or Oracle9iAS infrastructure 9.0.2.0.0 to Oracle9iAS infrastructure 9.0.2.3.

    1. Apply the Oracle9iAS Infrastructure 9.0.2.3 patch 3038037 to the infrastructure.


      Note:

      Contained in the README for patch 3038037 are instructions for applying the Oracle9i 9.0.1.4 database server patch 2517300. You must apply patch 2517300 before patch 3038037. Both of these patches are available at
      http://metalink.oracle.com/
      

    2. Copy the files listed in Table 3-6 from the CDROM_ROOT/tools/upgrade directory on the Oracle9iAS Infrastructure Installation CD-ROM for Release 2 (9.0.4.1.1) to the specified target directory in the infrastructure Oracle home directory that you are upgrading:

      Table 3-6 Files to be Copied to Specified Target Directories

      File Target Directory
      modDirectiveMS.xsd
      
      %ORACLE_HOME%\dcm\config\plugins\apache
      
      opca.jar
      
      %ORACLE_HOME%\sysman\webapps\emd\WEB-INF\lib
      
      portalSMI.jar
      
      %ORACLE_HOME%\sysman\webapps\emd\WEB-INF\lib
      
      repository.jar
      
      %ORACLE_HOME%\jlib
      
      ApacheModuleFastCGI.dll
      
      %ORACLE_HOME%\Apache\Apache\modules
      
      ApacheModuleOSSO.dll
      
      %ORACLE_HOME%\Apache\Apache\modules
      
      FastCGI.dll
      
      %ORACLE_HOME%\Apache\fastcgi
      
      FastCGI.lib
      
      %ORACLE_HOME%\Apache\fastcgi
      
      fcgi.jar
      
      %ORACLE_HOME%\Apache\fastcgi
      

    3. Create an orclguest user using Oracle Delegated Administration Services, as instructed in "Upgrading the Oracle9iAS Infrastructure at the Suite Level", step 4.


      Note:

      You must have sufficient privilege to create new users in the default subscriber.

      • Log in to Oracle Delegated Administration Services as a user with privilege to create users.

      • Select the Directory tab.

      • In the Search Results section, click Create.

      • Depending on the configuration, the Create User page prompts for different values. The User Name value in this case should be orclguest. The rest of the values should be filled in, accordingly. Ensure that all of the required fields are filled in.

      • Click Submit.

  2. Install the Oracle Collaboration Suite Release 2 (9.0.4.1.1) information storage database, as instructed in "Installing the Oracle Collaboration Suite Information Storage Database".


    Note:

    While registering the information storage database, point to the Oracle Internet Directory of the infrastructure upgraded to 9.0.2.3 in step 1a.

  3. Install the Oracle Collaboration Suite Release 2 (9.0.4.1.1) middle tier, as instructed in "Installing the Oracle Collaboration Suite Middle Tier".

  4. Apply the Oracle9iAS Portal patch (2758529) on the middle tier computer.

  5. Recompile all the invalid objects.

  6. Re-run the Web Client Installer from the command line, as follows:

    $ORACLE_HOME/webclient/bin/webclient_installer.sh OID Administrator pwd 
    -complete
    
    
  7. Perform the following SQL commands to re-compile the Oracle Ultra Search PL/SQL package wk_crw in the infrastructure database:

    sqlplus /nolog
    connect / as sysdba
    grant select on sys.dbms_lock_allocated to wksys;
    alter package wksys.wk_crw compile body;
    
    
  8. Complete the Oracle Collaboration Suite Release 2 (9.0.4.1.1) middle tier post-installation steps.