Skip Headers
Oracle® Collaboration Suite Readme
Release 2 Patch Set 1 (9.0.4.2.1) for Windows

Part Number B14386-02
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

1 Patch Set Preinstallation Requirements

This section contains preinstallation requirements for the various components of Oracle Collaboration Suite.


Note:

  • Oracle recommends backing up the environment prior to installing the patch set.

  • Oracle Collaboration Suite Release 2 (9.0.4.1.1) for Windows must be installed prior to installing the patch set. Users of Oracle Collaboration Suite Release 9.0.3 for Windows must upgrade to Oracle Collaboration Suite Release 2 (9.0.4.1.1) for Windows first, then install the patch set.

  • Oracle recommends upgrading the Oracle Collaboration Suite information storage database to Oracle Database Release 9.2.0.5, or later, to address the following bugs: 2643723, 2774862, 2919655, 2944866, 3017434, and 3019979.

  • Oracle Database patch set Release 9.2.0.5 requires that Oracle Universal Installer Release 10.1.0.2 be installed, and is included in the Oracle Database patch set 9.2.0.5 shiphome. Due to bug 3540563, the installation of this release of Oracle Universal Installer from the database patch set 9.2.0.5 shiphome may be suspended.

Search OracleMetaLink at http://metalink.oracle.com for:

  • Bug 3501955 to obtain the Oracle Database 9.2.0.5 patch set for your platform

  • Bug 3540563 to install Oracle Universal Installer 10.1.0.2 and proceed with the Oracle Database patch set 9.2.0.5 installation

  • OC4J patch 3535985 on Oracle iAS 9.0.2.3 in order to address bugs 3535985 and 3728421

  • Calendar patch 4002009. It is mandatory to install this patch prior to installing the patch set. Install the patch into the ORACLE_HOME on which you installed Oracle Calendar Release 2 (9.0.4.1.1)

Oracle recommends checking OracleMetaLink periodically for new patch sets and updates to Oracle Collaboration Suite.



See Also:

Oracle Collaboration Suite Installation and Configuration Guide Release 2 (9.0.4.1.1) for complete preinstallation instructions


This section includes the following topics:

1.1 Oracle Enterprise Manager Preinstallation Information

Oracle Universal Installer detects whether Oracle Enterprise Manager is running when you attempt to install the patch set on the infrastructure and the middle tier, and warns you to shut it down before proceeding.


Note:

For silent installations of the patch set, ensure that Oracle Enterprise Manager is shut down prior to installation. When installation is complete, restart Oracle Enterprise Manager.

1.2 Oracle Collaboration Suite Web Client Preinstallation Information

If you chose to configure the Oracle Collaboration Suite Web client when you installed Oracle Collaboration Suite, the patch set will upgrade the Web client.

1.3 Oracle Collaboration Suite Web Client Preinstallation Tasks

A port number must be explicitly defined for the URL associated with each of applications listed in the Web Client page. After installing the patch set, HTTP and HTTPS ports (port 80 and port 443, respectively) are not appended by default to the URL. Therefore, if a port number is not explicitly defined for the URL associated with each application in the Web Client page, no port number automatically appends to the server hostname for the application.

To define port numbers for the URL:

  1. Open the webclient.properties file located in:

    %ORACLE_HOME%\webclient\classes\oracle\collabsuite \webclient\resources

  2. Enter a port number for the URL for each of the portlet providers and application links.

If you have defined the port numbers correctly, the URL appear as in the following example for Web Conferencing:

http://imeetingserver.com:80

1.4 Oracle Collaboration Suite Information Store Preinstallation Tasks

Before installing the patch set, you must verify that SYS privileges have been granted to the logminer based e-mail recovery packages. If privileges have not been granted, logminer based e-mail recovery will not function. The following procedure explains how to check for SYS privileges and grant the missing privileges. The procedure must be performed from the mailstore ORACLE_HOME environment.

  1. To identify whether necessary privileges have been granted to the logminer recovery database objects, execute the following query from the SQLPLUS as SYS user.

    SQL> SELECT object_name , owner
    FROM dba_objects
    WHERE  object_name = 'LMMR_SETUP'
    AND object_type = 'PACKAGE';
    
    
  2. If the actions in Step 1 return no rows then do the following:

    cd %ORACLE_HOME%\oes\install\sql         
    

    From the SQLPLUS as SYS user:

    SQL>@install_backend_sys.sql
    
    

If the preceding procedure is not done, the patchset installation will display an error in the upgrade9042.log file as shown in the following example.

507/5    PL/SQL: SQL Statement ignored
509/14  PL/SQL: ORA-00942: table or view does not exist
creating package body MAIL_RECOVERY
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY MAIL_RECOVERY:

LINE/COL ERROR
108/21   PLS-00201: identifier 'SYS.V_$LOGMNR_CONTENTS' must be declared
108/21   PL/SQL: Item ignored
109/21   PLS-00201: identifier 'SYS.V_$LOGMNR_CONTENTS' must be declared
109/21   PL/SQL: Item ignored

1.5 Oracle Calendar Server Preinstallation Tasks

This section covers the following Oracle Calendar server preinstallation topics:


Note:

Prior to installing the patch set, it is mandatory to install Calendar patch 4002009 for 9.0.4.1.1. If you have not already done so, go to http://metalink.oracle.com , navigate to the Patches web page, and download the patch listed under Patch Number 4002009 onto the ORACLE_HOME on which you installed Oracle Calendar Release 2 (9.0.4.1.1)

1.5.1 Installing the Patch Set while the Oracle Calendar Server Is Running

It is not necessary to stop the Oracle Calendar server before installing the patch set. The installation program automatically stops and restarts the Oracle Calendar server.

1.5.2 Working with Oracle Calendar Server Configuration Files that Are Modified or Overwritten

If you previously made changes to the %Oracle_Home%\ocal\misc\unison.ini file, the installation program recognizes this and modifies the file with any necessary parameter changes.

The following files are not overwritten when installing the patch set:


user.ini
resource.ini
eventcal.ini

The following files are always overwritten when installing the patch set:


timezone.ini
timezone_os.ini

1.5.3 Upgrading Oracle Calendar from Version 9.0.3 to 9.0.4.2.1

Upgrade Oracle Calendar from version 9.0.3 to 9.0.4.2.1 as described in the following steps.

  1. Install Oracle Calendar Release 2 (9.0.4.1.1) into a different ORACLE_HOME from your existing installation, as described in the Oracle Collaboration Suite Installation and Configuration Guide Release 2 (9.0.4.1.1).

  2. If you have not already done so, go to http://metalink.oracle.com, navigate to the Patches web page, and download the patch listed under Patch Number 4002009 onto the ORACLE_HOME on which you installed Oracle Calendar Release 2 (9.0.4.1.1).

  3. Install Oracle Collaboration Suite Release 2 Patch Set 1 (9.0.4.2.1) over Release 2 (9.0.4.1.1).

  4. Verify that the 9.0.3 and the 9.0.4.2.1 Calendar servers are down.

  5. Run OcalPreUpg.cmd from the Calendar 9.0.4.2.1 %ORACLE_HOME%\ocal\upgrade directory.

  6. Run ocsua.bat from the 9.0.4.2.1 %ORACLE_HOME%\upgrade directory.

If you do not follow these steps, unexpected behavior may result. For instance, if you upgrade your data to Release 2 (9.0.4.1.1) and then install the patch set, users will no longer be able to log in as event calendars or resources because the corresponding passwords will be lost. The passwords can, however, be reset using the Oracle Calendar Administrator.

If you upgrade before applying the patch set, you must copy the [CONFERENCING] section of the backed up 9.0.4.1 unison.ini to the 9.0.4.2.1 unison.ini.

1.5.4 Changes in Hardware Requirements for Upgrades

Before you upgrade, Oracle recommends that you re-evaluate your sizing calculations based on the requirements provided for the new software. For CPU usage, the hardware requirements have changed as a result of added functionality, as follows:

  • If you are upgrading from Oracle Calendar 5.x or 9.0.3 to release 9.0.4.2.1, an increase in CPU usage is expected. If in your current Oracle Calendar 5.x or 9.0.3 installation you track regular peaks in CPU usage at 60% or greater, several times a day, additional CPU capacity might be required for this upgrade.

  • An upgrade to 9.0.4.2.1 from Calendar 5.x or 9.0.3 requires approximately four times the current disk space.


See Also:

Oracle Calendar Administrator's Guide Release 2 (9.0.4)

1.6 Oracle Calendar Application System Preinstallation Requirements

This section covers the following Oracle Calendar application system preinstallation topics:


Note:

Prior to installing the patch set, it is mandatory to install Calendar patch 4002009 for 9.0.4.1.1. If you have not already done so, go to http://metalink.oracle.com , navigate to the Patches web page, and download the patch listed under Patch Number 4002009 onto the ORACLE_HOME on which you installed Oracle Calendar Release 2 (9.0.4.1.1)

1.6.1 Configuring Time Zone Behavior for the Oracle Calendar Portlet

An issue resolved by this patch set is that of time zone behavior on the Oracle Calendar portlet (bug 3088332). For this particular fix to work, you must add the following xml text (if it is not already present) to the $ORACLE_HOME/config/jazn-data.xml%ORACLE_HOME%\config\jazn-data.xml file before the </jazn-policy> tag at the end of this file. This must be done on the Oracle9iAS Portal middle tier that runs the Oracle Calendar portlet before you install the patch set. Back up the file before making any changes. Replace the %ORACLE_HOME% with the physical Oracle home of the middle tier.


Note:

This is only necessary if you are running the Oracle Calendar portlet.

<grant>
     <grantee>
       <codesource>
         <url>file:%ORACLE_HOME%\webclient\lib\webclient_common.jar</url>
       </codesource>
     </grantee>
     <permissions>
       <permission>
    <class>oracle.ias.repository.schemaimpl.CheckRepositoryPermission</class>
         <name>connectAs</name>
       </permission>
     </permissions>
   </grant>

If you are running Oracle9iAS Portal on a different middle tier, you must copy two newly installed files over to that middle tier after installation, as described in Chapter 3, "Patch Set Postinstallation Instructions".

1.6.2 Working with Oracle Calendar Application System Configuration Files that Are Modified or Overwritten

The %ORACLE_HOME%\ocas\conf\ocst.conf file is updated during installation. The previous ocst.conf file is backed up as %ORACLE_HOME%\ocas\conf\ocst.conf.bck

1.7 Oracle Email Preinstallation Requirements

Oracle Internet Directory on the infrastructure server must be running prior to installing the patch set.


Note:

For silent installations of the patch set on the middle tier, ensure that Oracle Email servers are stopped prior to starting the patch set installation on the middle tier.


See Also:

Oracle Email Administrator's Guide for instructions on how to stop Oracle Email processes

1.7.1 Installing the Patchset on the Information Store

It is necessary to stop the e-mail servers before installing the patchset on the information store that the middle tier is serving. If the information store is being served by multiple middle tiers running e-mail servers, all e-mail servers on these middle tiers need to be shutdown prior to installing the patch set on the information store.

1.7.2 Installing the Patchset on the Middle Tier

It is normally not necessary to stop the Oracle Email servers on the middle tier before installing the patch set on that middle tier. Normally, the installation program automatically stops all Oracle Email servers at the beginning of the installation and restarts them when installation is complete. This will not be the case if the existing configuration uses non-qualified hostnames, for example, a hostname missing the domain suffix as part of an e-mail service target name. To check whether non-qualified hostnames exist, run the following command from a command prompt window:

oesctl show targets

If the output contains non-qualified hostnames, shutdown the server prior to performing the upgrade.

1.7.3 Installing the Patchset on a Windows NT 4.0 Middle Tier

On Windows NT 4.0 only, you must shut down e-mail server processes before installing the patchset on the middle tier. Restart e-mail server processes after installing the patchset on the middle tier. This procedure does not apply to Windows 2000 or Windows 2003 Enterprise Edition or Standard Edition.

1.8 Oracle Files Preinstallation Requirements

Ensure that the following requirements are met prior to installing the patch set:

To stop the Oracle Files domain and regular nodes, follow these steps:

  1. If it is not running already, start Oracle Enterprise Manager by executing the following command:

    %ORACLE_HOME%\bin\emctl start
    
    
  2. Using a Web browser, access the Oracle Enterprise Manager Web site at http://host_name:port, where host_name is the name of the Oracle Files middle-tier computer. The port is typically 1810.

  3. Enter the authentication information in the pop-up window. The user name is typically ias_admin.

  4. Click the name of the application server instance where Oracle Files is running. The Oracle9iAS Home Page appears.

  5. Click the Oracle Files domain link. The domain appears in the following format:

    iFS_db_host_name:port:db_service_name:files_schema
    
    
  6. Click Stop Domain.

  7. Click OK.

  8. Stop Oracle Enterprise Manager before installing the patch set. Use the following command to stop Oracle Enterprise Manager:

    %ORACLE_HOME%\bin\emctl stop
    
    

To stop Oracle Files HTTP nodes, follow these steps on each Oracle Files middle tier:

  1. From the Oracle9iAS Home Page on the Oracle Enterprise Manager Web site, select OC4J_iFS_files.

  2. Click Stop. On the Warning page, click Yes to stop the OC4J instance.

    Alternatively, you can use the following commands from the command line:

    %ORACLE_HOME%\ifs\files\bin\ifsctl stop
    %ORACLE_HOME%\dcm\bin\dcmctl stop -co OC4J_iFS_files -v -t 360
    
    

1.9 Oracle Web Conferencing Preinstallation Requirements

This section includes the following topics:

Ensure that the following requirements are met prior to installing the patch set:

In addition, you must perform the following tasks before installing the patch set:

1.9.1 Shut Down Oracle Real-Time Collaboration Services

Before installing the patch set, you must shut down all Oracle Real-Time Collaboration services and instances in your Oracle Collaboration Suite setup (that is, on each ORACLE_HOME with Oracle Real-Time Collaboration installed).

  1. Stop all Oracle Real-Time Collaboration servers, both core components and document and voice conversion servers (if used), as follows:

    %ORACLE_HOME%\imeeting\bin\imtctl stop

    Note:

    If you cannot shut down the processes and you know that there are no Oracle Real-Time Collaboration instances running, you may have to manually terminate the processes using your operating system tools.

  2. Stop the Oracle Real-Time Collaboration OC4J instance, as follows:

    %ORACLE_HOM%\dcm\bin\dcmctl stop -co OC4J_imeeting -t 360 -v

    See Also:

    Oracle9iAS Web Cache Administration and Deployment Guide for more details

1.9.2 Required Disk Space on Information Storage Database Server

During installation, the following tablespaces with the following initial sizes are created for Oracle Web Conferencing in the information storage database. You must have at least 1 GB of free space in the directory that you specify as the tablespace location while running the Oracle Universal Installer.

Table 1-1 Default Tablespace Sizes for Oracle Web Conferencing

Tablespace Name Default Size (MB)
rtc_lookup_data
16
rtc_lookup_index
8
rtc_transaction_data
256
rtc_transaction_index
64
rtc_archive_data
64
rtc_archive_index
16
rtc_document_data
64
rtc_document_index
8
rtc_recording_data
64
rtc_recording_index
8
rtc_transient_data
128
rtc_transient_index
32
rtc_transient_lob_data
64
rtc_transient_lob_index
8
rtc_report_data
64
rtc_report_index
8
rtc_temp
128
TOTAL SIZE REQUIRED 1000 MB (1 GB)

The preceding tablespaces are created with the AUTOEXTEND setting ON and a maximum file size of 2 GB. Make sure you have enough space available for future expansion. Depending upon your use of the system, you may want to increase the size of the tablespaces.

1.9.3 How Installation Interacts with Oracle Internet Directory

As the Oracle Real-Time Collaboration installation process runs, it uses the Oracle Internet Directory administrator account to do the following tasks in the Oracle Internet Directory installation. The files listed below are located in the following directory, %ORACLE_HOME%\imeeting\install\oid, on the Oracle Real-Time Collaboration core components installation.

  • rtccontainer.ldi (creates a container named RTC)

  • rtcentity.ldi (creates an entity named RTCApplication in the RTC container)

  • install_rtc_oid.cmd (sets up an Oracle Directory Integration and Provisioning process between the Oracle Internet Directory and Oracle Real-Time Collaboration services)

As noted previously, you must make sure the Oracle Directory Integration and Provisioning server is running on the Oracle Internet Directory system before running the installation, otherwise the installation process may suspend.

The Oracle Web Conferencing system stores the following data about Web conferencing users in its information store, to improve performance:


First Name
Middle Name
Last Name
User Name
E-mail address

The Oracle Real-Time Collaboration services use the Oracle Directory Integration and Provisioning service offered by Oracle Internet Directory to synchronize the data in the information store in case any of the data changes (for example, an e-mail address change).

1.10 Oracle9iAS Wireless Preinstallation Requirements

Access information is not automatically retrieved when the patch set is applied. Prior to applying the patch set, ensure that your information is correct and make a copy of the portal.properties file, found in the %ORACLE_HOME%\wireless\server\classes\messages directory.

Using Enterprise Manager, shut down OC4J_Wireless, all Messaging Server instances, and the PIM Notification Dispatcher process.