4 Additional/Optional Oracle Collaboration Suite Upgrade Scenarios

Oracle Collaboration Suite Release 2 Patch Set 1 (9.0.4.2.1) provides certification with Oracle Database 10g and the Identity Management components of Oracle Application Server 10g. You have the option of upgrading the Oracle Collaboration Suite information storage database to Oracle Database 10g and upgrading the Identity Management components of the Oracle Collaboration Suite infrastructure Oracle9i Application Server 9.0.2.3 to Oracle Application Server 10g. This chapter provides information on how to perform these upgrades and to use Oracle Collaboration Suite with Oracle Application Server 10g (9.0.4) and Oracle Database 10g.

Note: For this release, you cannot upgrade the Metadata Repository components of the infrastructure. You can, however, complete pre-upgrade tasks in preparation for this upgrade. For pre-upgrade tasks required for the upgrade of the Metadata Repository components, see Section 4.1.3, "Preparing to Upgrade the Metadata Repository".

• Section 4.1, "Upgrading the Identity Management Components of the Infrastructure"

• Section 4.2, "Upgrading the Oracle Collaboration Suite Information Storage Database to Oracle Database 10g"

• Section 4.3, "Using Oracle Collaboration Suite with Oracle Application Server 10g Identity Management and Oracle Database 10g"

4.1 Upgrading the Identity Management Components of the Infrastructure

You can (optionally) upgrade the Identity Management portion of the Oracle Collaboration Suite infrastructure Oracle9i Application Server 9.0.2.3 to Oracle Application Server 10g. This section contains the procedures required to perform the upgrade.

The Oracle Collaboration Suite Release 2 Patch Set 1 (9.0.4.2.1) must be installed prior to upgrading the infrastructure to Oracle Application Server 10g. See Chapter 2, "Installing the Patch Set" and Chapter 3, "Patch Set Postinstallation Instructions" for information on installation and postinstallation instructions, respectively.

Notes: Note the following points: You must upgrade the Identity Management portion of the infrastructure if you plan to upgrade the information storage database to Oracle Database 10g. Oracle provides a patch to facilitate the infrastructure upgrade procedure described in this section. Check OracleMetaLink for the availability of this patch under bug number 3541554 at http://metalink.oracle.com. You can use the manual upgrade steps described in this section as an alternative to applying the patch.

This section includes the following topics:

• Section 4.1.1, "Oracle Internet Directory-Specific Preupgrade Tasks"

• Section 4.1.2, "Back Up Oracle Internet Directory"

• Section 4.1.3, "Preparing to Upgrade the Metadata Repository"

• Section 4.1.4, "Upgrading Oracle Identity Management"

4.1.1 Oracle Internet Directory-Specific Preupgrade Tasks

Before upgrading the Identity Management components of the Oracle Collaboration Suite infrastructure Oracle9i Application Server 9.0.2.3 to Oracle Application Server 10g, complete the following pre-upgrade tasks for the Oracle Internet Directory.

1. Verify that the orcladmin user exists in the default identity management realm, as follows:

   1. Get the default subscriber DN by entering the following command as one continuous line:

      %ORACLE_HOME%\bin\ldapsearch -h OID_host -p non-SSL_port -D OID_
      superuser -w OID_superuser_password -b
      "cn=common,cn=products,cn=oraclecontext" -s base "objectclass=*"
      orcldefaultsubscriber
      
      

   2. Get the user nickname and user search base attribute by entering the following command as one continuous line:

      %ORACLE_HOME%\bin\ldapsearch -h OID_host -p non-SSL_port -D OID_
      superuser -w OID_superuser_password -b 
      "cn=common,cn=products,cn=oraclecontext,default_subscriber_DN" -s 
      base "objectclass=*" orclcommonnicknameattribute  
      orclcommonusersearchbase
      
      

   3. Search for the orcladmin user by entering the following command as one continuous line:

      %ORACLE_HOME%\bin\ldapsearch -h OID_host -p non-SSL_port -D OID_
      superuser -w OID_superuser_password -b "user_search_base_DN" -s sub 
      "user_nickname_attribute=orcladmin"
      
      

   If the last LDAP search does not return anything, create the orcladmin user in Oracle Internet Directory, as follows:

   1. Create an ldif file called orcl.ldif that includes the following content:

      dn: cn=orcladmin, User_Search_Base
      changetype: add
      uid: orcladmin
      mail: orcladmin
      givenName: orcladmin
      cn: orcladmin
      sn: orclAdmin
      description: Seed administrative user for subscriber.
      objectClass: top
      objectClass: person
      objectClass: organizationalPerson
      objectClass: inetorgperson
      objectClass: orcluser
      objectClass: orcluserV2
      
      

   2. Enter the following command as one continuous line:

      %ORACLE_HOME%\bin\ldapadd -h OID_host -p non-SSL_port -D OID_
      superuser -w OID_superuser_password -v -f orcl.ldif
      
      

2. Verify that the Oracle Internet Directory superuser password conforms to the same restrictions as defined for the Oracle Application Server 10g ias_admin user.

   
   

   See Also: Oracle Application Server 10g Installation Guide for more details.

   
   

   If the password does not conform to the restrictions, reset the password so that it conforms to the restrictions, as follows:

   1. Create an ldif file called supwd.ldif that includes the following content:

      dn:
      changetype: modify
      replace: orclsupassword
      orclsupassword: new_password
      
      

   2. Enter the following command as one continuous line:

      %ORACLE_HOME%\bin\ldapmodify -h OID_host -p non-SSL_port -D OID_
      superuser_DN -w OID_superuser_password -v -f supwd.ldif
      
      

3. Follow the workaround in Note 263073.1 available on OracleMetaLink at:

   http://metalink.oracle.com
   

4.1.2 Back Up Oracle Internet Directory

Back up the Oracle Internet Directory database and software as instructed in Chapter 11, "Backup and Restoration of a Directory" of the Oracle Internet Directory Administrator's Guide.

4.1.3 Preparing to Upgrade the Metadata Repository

This section outlines some of the tasks required in preparing to upgrade the Metadata Repository components of Oracle Collaboration Suite infrastructure Oracle9i Application Server 9.0.2.3 to Oracle Application Server 10g. Perform the steps listed in Section 4.2, "Preparing to Upgrade Metadata Repository" in the document, Oracle Application Server 10g Upgrading to 10g (9.0.4).

These steps include:

• Applying the 9.0.1.5 database patch

  
  

  Note: Do not change the wksys password during the patch installation.

  
  

• Installing the DBMS_IAS_UPGRADE package

• Upgrading the metadata repository container

  
  

  Note: While performing the metadata repository container upgrade, you may get a "New Schema Creation failed" error because some of the new tablespaces and schemas being created by the mrc.pl script in the metadata repository may already exist. If you get this error, check if the following entries exist in Oracle Internet Directory: oca oraoca_public wcrsys ip If these entries exist in Oracle Internet Directory, the metadata repository container upgrade is complete, despite the preceding error.

  
  

• Ensuring that there are no invalid objects in the database

4.1.4 Upgrading Oracle Identity Management

Refer to "Upgrading Identity Management Services" in Oracle Application Server 10g Upgrading to 10g (9.0.4) to upgrade Oracle Identity Management.

Note: If you upgrade to Oracle Identity Management (9.0.4), you lose the ability to select languages on the Oracle9iAS Single Sign-On login page (Bug number 3536982).

4.2 Upgrading the Oracle Collaboration Suite Information Storage Database to Oracle Database 10g

This section contains the necessary procedures to upgrade the Oracle Collaboration Suite information storage database to Oracle Database 10g.

This section includes the following topics:

• Section 4.2.1, "Upgrading the Information Storage Database to Oracle Database 10g"

• Section 4.2.2, "Oracle Database 10g Post-Upgrade Tasks for Oracle Files"

• Section 4.2.3, "Installing the Oracle Email Information Store Patch"

4.2.1 Upgrading the Information Storage Database to Oracle Database 10g

This section provides instructions on the (optional) upgrade of the information storage database to Oracle Database 10g.

The Oracle Collaboration Suite Release 2 Patch Set 1 (9.0.4.2.1) must be installed prior to upgrading the information storage database to Oracle Database 10g. See Chapter 2, "Installing the Patch Set" and Chapter 3, "Patch Set Postinstallation Instructions" for information on installation and postinstallation instructions, respectively.

Important: Using Oracle Database 10g with Oracle Email requires patch 3493339 on the Email Information Store 9.0.4.2.1. See Section 4.2.3, "Installing the Oracle Email Information Store Patch" for complete instructions.

Upgrade the information storage database, as follows:

1. Verify that you have installed the Oracle Collaboration Suite Release 2 Patch Set 1 (9.0.4.2.1). If you have not installed the patch set, do so now before continuing on to the next step. See Chapter 2, "Installing the Patch Set" and Chapter 3, "Patch Set Postinstallation Instructions" for information on installation and postinstallation instructions, respectively.

2. Verify that you have upgraded the Identity Management components of the infrastructure to Oracle Application Server 10g (9.0.4), as described in Section 4.1, "Upgrading the Identity Management Components of the Infrastructure". If you have not upgraded the infrastructure, do so now before continuing on to the next step.

3. Upgrade the information storage database to Oracle Database 10g, as explained in the Oracle Database Upgrade Guide 10g Release 1 (10.1).

4.2.2 Oracle Database 10g Post-Upgrade Tasks for Oracle Files

After you upgrade your database to Oracle Database 10g and complete the steps listed in Section 3.5, "Oracle Files Postinstallation Tasks", you must perform the following tasks.

Note: Steps 1 and 2 in the following procedure require a tnsnames entry in tnsnames.ora.

1. From the Oracle Files middle tier computer, connect to Oracle Database 10g as the user who owns the Oracle Files schema (for example, IFSSYS) and execute the following commands:

   cd %ORACLE_HOME%\ifs\files\admin\sql
   sqlplus files_schema/schema_password@tnsnames_entry
   @Upgrade9iTo10g_part1.sql files_schema
   
   

2. Connect to Oracle Database 10g as the SYS user and execute the following commands:

   sqlplus 'sys/sys_password@tnsnames_entry as sysdba'
   @Upgrade9iTo10g_part2.sql files_schema
   
   

3. On the database computer, restart the database and the database listener.

4. Perform the Oracle Files postinstallation tasks.

   
   

   See Also: Section 3.5, "Oracle Files Postinstallation Tasks" for more information.

   
   

4.2.3 Installing the Oracle Email Information Store Patch

This section explains how to install the Oracle Email Information Store Patch Release 9.0.4.2.1 on the Oracle Collaboration Suite information storage database that has been upgraded to Oracle Database 10g.

1. Go to http://metalink.oracle.com and navigate to the Patches web page.

2. Download the Oracle Email Information Store Patch Release 9.0.4.2.1 (for Windows), listed under Patch Number 3493339, to the information store system.

3. For details on installing the patch, follow the details provided in the Email Information Store Patch readme that accompanies the Email Information Store Patch.

4.3 Using Oracle Collaboration Suite with Oracle Application Server 10g Identity Management and Oracle Database 10g

This section contains procedures for setting up Oracle Collaboration Suite 9.0.4.2.1 with a new installation of Oracle Application Server 10g (9.0.4) Identity Management and a new installation of Oracle Database 10g (10.1.0.2.0).

This section includes the following topics:

• Section 4.3.1, "Installing Oracle Application Server 10g Infrastructure"

• Section 4.3.2, "Configuring Oracle Identity Management 10g"

• Section 4.3.3, "Installing the Metadata Repository"

• Section 4.3.4, "Installing Oracle Database 10g"

• Section 4.3.5, "Installing the Oracle Collaboration Suite Middle Tier"

• Section 4.3.6, "Installing the Oracle Collaboration Suite Patch Set"

4.3.1 Installing Oracle Application Server 10g Infrastructure

Install Oracle Application Server 10g Infrastructure (including Identity Management and Oracle Application Server metadata repository). For detailed instructions on installing Oracle Application Server 10g Infrastructure, see section 6.18, "Installing Oracle Application Server Infrastructure 10g," in the Oracle Application Server 10g Installation Guide.

4.3.2 Configuring Oracle Identity Management 10g

This section describes how to configure Oracle Identity Management 10g components to work with 9.0.4.2.1 middle tiers.

1. Ensure that the following requirements are met:

   • The ORACLE_HOME environment variable points to the Oracle Application Server 10g (9.0.4) infrastructure home directory used by OracleAS Single Sign-On

   • The Oracle Application Server 10g (9.0.4) Oracle Internet Directory server is running

   • The Oracle Application Server 10g (9.0.4) infrastructure database and listener are running

2. Locate the imconfig.bat script in the utilities\imconfig directory on the "OracleAS RepCA and Utilities" CD-ROM. You use this script to update the 10g Identity Management components to work with 9.0.4.2.1 middle tiers.

3. Run the imconfig.bat script on the machine where the OracleAS 10g (9.0.4) Single Sign-On is installed. Use the following command:

   imconfig.bat -10g -h ldaphost -p ldapPort -D ldapDN -w ldapPwd -oh oracleHome

   Provide the following values:

   Table 4-1 Required script values

   Value	Description	Example
   ldaphost	Name of the computer running the OracleAS 10g (9.0.4) Oracle Internet Directory	dbmachine.mydomain.com
   ldapPort	Port number on which the OracleAS 10g (9.0.4) Oracle Internet Directory is listening	Port number: 389
   ldapDN	DN of the Oracle Internet Directory user	cn=orcladmin
   ldapPwd	Password for the Oracle Internet Directory user
   oracleHome	Oracle home directory for the 10g (9.0.4) infrastructure database used by OracleAS Single Sign-On

   
   

Optional Parameter

Specify the -ssl parameter if ldapPort is an SSL port.

Example command:

[oracle@collabpc]$ imconfig.bat -10g -h collabpc.us.oracle.com -p 389 -D
"cn=orcladmin" -w welcome1 -oh C:\OraHome

Output:

CLASSPATH=C:\OraHome\jlib\jssl-11.jar;C:\OraHome\jlib\javax-ssl-11.jar;C:\OraHome\
jdbc\lib\classes12.jar;.\imcomp.jar;.\..\..\repCA\jlib\ldapjclnt9.jar
Check C:\OraHome\sso\log\IMComp.log for results
-> LOADING: C:\OraHome\sso\log\changeiASAdmins.ldif
-> LOADING: C:\OraHome\sso\log\changeAccess.ldif

The Oracle Identity Management version 10g has been
updated successfully. Version 9.0.2 middle tier installations
can now be associated with this Infrastructure.

4.3.3 Installing the Metadata Repository

This section contains procedures for installing the metadata repository portion of the Oracle 9i Application Server (9.0.2.3) Infrastructure. During this procedure you point the metadata repository to Oracle Application Server 10g (9.0.4) Identity Management for the Oracle Application Server 10g Single Sign-On and Oracle Internet Directory components.

Note: If the Oracle Application Server 10g and Oracle 9i Application Server (9.0.2.3) metadata repositories are on the same computer, the Oracle Enterprise Managers have to be configured to listen on different ports. In Oracle Collaboration Suite 9.0.4.1.1, the installer assigns port 1810 to the Oracle Enterprise Manager Web Site, regardless of whether or not the port is already in use. You can change the port used by the Oracle Application Server 10g (9.0.4) Oracle Enterprise Manager to a different port. You can then run both Oracle Enterprise Managers at the same time. To change the port on the Oracle Application Server 10g (9.0.4) Oracle Enterprise Manager, perform these steps: In the OracleAS 10g (9.0.4) home, edit the ORACLE_HOME\sysman\j2ee\config\emd-web-site.xml file and change the port value from 1810 to an unused port. The following example sets the port to 1814: web-site host="[ALL]" port="1814" display-name="Oracle Enterprise Manager iAS Console Website" secure="false" If the Oracle Collaboration Suite 9.0.4.1 instance is using 1810, it is also likely that the instance is using port 1811 for RMI operations. With the 9.0.2 Oracle Enterprise Manager running, check which port in the 1810-1829 range is unused, and use this value. You can run the netstat command to determine which ports are in use. The following example checks if port 1814 is in use. netstat -n | grep 1814 In the OracleAS 10g (9.0.4) home, enter the same port number in the ORACLE_HOME\sysman\emd\targets.xml file. The port number is specified in the StandaloneConsoleURL property of the oracle_ias target: <Target TYPE="oracle_ias" NAME="infra.myhost.oracle.com" VERSION="1.0"> ... lines not shown ... <Property NAME="StandaloneConsoleURL" VALUE="http://myhost.oracle.com:1814/emd/console"/> Once you have updated these two files, you can run both Oracle Enterprise Manager (9.0.2) and Oracle Enterprise Manager 10g (9.0.4) at the same time.

To start the Oracle 9i Application Server (9.0.2.3) metadata repository installation, first follow the instructions in Chapter 5, "Getting Started with Installation" in the Oracle Collaboration Suite Installation and Configuration Guide Release 2 (9.0.4.1.1). Then, instead of continuing on to Chapter 6, "Installing Oracle9iAS Infrastructure," use the following Steps 1 through 13.

1. The Confirm Pre-Installation Requirements screen appears after you click Next on the Language Selection screen.

2. Click Next to display the Select Configuration Options screen. Do not accept the default selection but select specify your choice and deselect the Oracle Internet Directory and Oracle iAS Single Sign-On components.

3. Click Next to configure the OracleAS 10g Single Sign-On with the Oracle9iAS (9.0.2.3) metadata repository. Enter the OracleAS 10g Single Sign-On host and port of the OracleAS 10g installation in step 1.

4. Click Next and specify the OracleAS 10g Oracle Internet Directory administrator username and password.

5. Click Next to display the create instance name and ias_admin password screen. Choose an Instance Name and choose and confirm the ias_admin Password.

6. Click Next to display the Guest Account Password screen.

   
   

   Note: The Oracle Universal Installer creates the orclguest account during running the Oracle directory configuration assistant. Because the Oracle Internet Directory is in the OracleAS 10g infrastructure environment, the OUI will not create the orclguest account because it does not run the Oracle Internet Directory configuration assistant. If you want the orclguest account to be configured you have to create an orclguest user using the OIDDAS application of the OracleAS 10g Infrastructure. If you do not create this account the Oracle Collaboration Suite 9.0.4.1.1 middle tier installer will give a warning for some configuration assistants that this account does not exist. You can ignore those errors if you do not need this account.

   
   

7. Click Next. If you are a member of the DBA group, the Summary screen displays. Proceed to Step 9. If you are not a member of the DBA group, the Privileged Operating System Groups screen displays.

8. Enter Database Administrator (OSDBA) Group and Database Operator (OSOPER) Group names.

9. Click Next to display the Summary screen.

10. Review the information and click Install. The location of the log files for the installation displays. After you click Install, files are copied and linked. This process can run for more than an hour.

11. The Oracle Universal Installer executes a configuration assistant for each component selected previously in the Select Configuration Options screen.

    
    

    Note: If you install the OracleAS 10g Infrastructure and the Oracle 9i Application Server (9.0.2.3) metadata repository on the same computer, it is possible that the network listener for the Oracle Application Server 10g metadata repository is already listening on IPC protocol with key=EXTPROC and TCP protocol on port 1521. In this case, the Oracle Net Configuration Assistant may suspend. You can find the following errors in the listener.log file in the iAS_9.0.2.3_Metadata_Repository_home\network\log directory: Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use In this case: Click Stop to stop the network configuration assistant. Go to an operating system shell and stop the listener from the OracleAS 10g environment using $ lsnrctl stop Return to the Oracle Universal Installer window and click Retry. The Oracle Net Configuration Assistant will now run successfully. The Oracle Application Server 10g metadata repository database registers itself with the Oracle 9i Application Server (9.0.2.3) listener so the subsequent configuration assistants can reach it on port 1521. When the Oracle 9i Application Server (9.0.2.3) metadata repository installation is finished, you can stop its network listener and copy the SID-specific information from its listener.ora file to the Oracle Application Server 10g listener.ora file, for example: (SID_DESC = (GLOBAL_DBNAME = iasdb1.collabtng10.us.oracle.com) (ORACLE_HOME = \u01\app\oracle\product\ocsinfra) (SID_NAME = iasdb1) ) Then start the listener from the Oracle Application Server 10g Oracle home.

    
    

12. The End Of Installation screen displays the port numbers for installation and confirms success.

13. Check the installation log files for any installation errors. The installation log files are located in the oraInventory directory. The default installation log file directory is orInventory_directory\logs. Each installation log takes the form InstallActionsYYYY-MM-DD_HH-MM-SSAM.log.

4.3.4 Installing Oracle Database 10g

This section contains procedures for installing Oracle Database 10g and explains how to set the required database parameters.

1. Follow the instructions in Oracle Database 10g Installation Guide to install Oracle 10g Database.

2. Ensure that the following database parameters are set for the Oracle Database 10g.

   The values listed in Table 4-2 are minimum values for these parameters. You may want to increase these values as appropriate for your deployment.

   Table 4-2 Oracle Database 10g Database Parameters

   Parameter Name	Minimum Value
   aq_tm_processes	1
   java_pool_size	30 MB
   job_queue_processes	10
   open_cursors	300
   processes	100
   session_max_open_files	50
   shared_pool_size	50 MB (52428800 bytes)

   
   

3. On the computer on which the Oracle 10g Database is installed, restart the database and the database listener.

4. Register the Oracle Database 10g with Oracle Internet Directory, as follows:

   Running the Oracle Net Configuration Assistant

   1. Start the Oracle Net configuration assistant by selecting Start, Programs, Oracle - HOME_NAME, Configuration and Migration Tools, followed by Net Configuration Assistant to display the Welcome screen.

   2. In the Welcome window, select Directory Usage Configuration and click Next.

   3. Select the directory server you want to use. The directory server must already be configured for Oracle usage.

   4. Click Next.

   5. Select Oracle Internet Directory as the directory server type you want to use and click Next.

   6. Enter the Oracle Internet Directory host name, port, and SSL port and click Next.

      
      

      Note: The dbca may prompt a message to set higher values for the Database parameters, if any of the parameters in Table 4-2 are below the minimum value required. User must select Yes to enable those values to be updated.

      
      

   7. Select cn=OracleContext as the default Oracle Context in the directory server.

      
      

      Note: Do not select cn=OracleContext,subscriber_specific_DN.

      
      

   8. Click Next.

   9. Proceed to the end of the Oracle Net Configuration Assistant configuration.

      This creates an ldap.ora file that specifies the Oracle Internet Directory server and port number in the %ORACLE_HOME%\network\admin directory.

   10. Exit the Oracle Net Configuration Assistant.

   Running the Database Configuration Assistant

   1. Start the database configuration assistant by selecting Start, Programs, Oracle - HOME_NAME, Configuration and Migration Tools, followed by Database Configuration Assistant.

   2. Click Next.

   3. Select Configure database options in a database and click Next.

   4. Select the SID of the Oracle Email database to configure and click Next.

   5. Select Yes and register the database.

      Enter cn=orcladmin in the User DN field.

      Enter the password for the name entered in the User DN field.

   6. Click Finish.

   7. In the Restart Database screen click Yes.

   8. In the Summary screen click OK.

      The progress of database configuration displays in the Database Configuration Assistant screen.

   9. Enter new passwords for the SYS and SYSTEM users of the Collaboration Suite Database database.

   10. Click Password Management.

       Select all checkboxes on the screen after verifying that your computer meets the minimum pre-installation requirements.

   11. Locate the CTXSYS account and unlock it by clicking the box in the Lock Account column.

   12. Enter and confirm a new CTXSYS password.

   13. Click OK to display the Confirm Pre-Install Requirements screen.

   14. Click Next to display the Create Instance Name and ias_admin Password screen.

   15. Exit the Database Configuration Assistant when the configuration completes.

       
       

       See Also: Oracle Database Advanced Security Administrator's Guide 10g Release 1 (10.1), chapters 2 and 12 for more information about using the database configuration assistant and registering the database

       
       

4.3.5 Installing the Oracle Collaboration Suite Middle Tier

This section contains procedures for installing the Oracle Collaboration Suite 9.0.4.1.1 middle tier.

1. Before installing the middle tier, apply the following patches on the Oracle 9i Application Server (9.0.2.3) infrastructure metadata repository installation:

   • Patch 3238095

   • Patch 2563444

   • Patch 2802414

2. Install the Oracle Collaboration Suite 9.0.4.1.1 middle tier, as instructed in Chapter 6 of the Oracle Collaboration Suite Installation and Configuration Guide Release 2 (9.0.4.1.1).

   
   

   Caution: Before running umconfig.bat to configure Email during Oracle Collaboration Suite 9.0.4.1.1 middle tier installation, you must apply the Oracle Email patch for bug 3854947 for Oracle Application Server 10g (9.0.4) compatibility patch on the middle tier. You can find this patch on http://metalink.oracle.com.

   
   
   
   

   Note: Note the following points: During the middle tier installation, deselect Oracle Files from the Component Configuration screen, or cancel the Oracle Files configuration assistant during the configuration phase. In the OracleAS 10g Single Sign-On and Oracle Internet Directory registration dialog windows, provide the OracleAS 10g Identity Management information. After you specify the iAS instance name and administrator password, the Oracle9iAS Metadata Repository selection window will appear because you have two metadata repository registered in the Oracle Internet Directory. Select the Oracle 9i Application Server (9.0.2.3) metadata repository. Real-Time Collaboration Configuration Assistants will fail during this installation. This will be fixed when you apply the Oracle Collaboration Suite 9.0.4.2.1 to this middle tier.

   
   

3. Once the Oracle Collaboration Suite middle tier is installed, configure Oracle Email on the Oracle Database 10g Release 1 (10.1.0.2) information store by executing umconfig.bat in the middle tier system as follows:

   %ORACLE_HOME%\oes\bin\umconfig.bat

   When running umconfig.bat, select MailStore Configuration. You only need to run umconfig.bat against the information store.

   
   

   See Also: Oracle Collaboration Suite Installation and Configuration Guide Release 2 (9.0.4.1.1)

   
   
   
   

   Note: The following Oracle Database 10g errors can be ignored: Errors from dropping non-existent database objects: ORA-00942: table or view does not exist ORA-04043: object does not exist Errors when compiling the following PL/SQL packages and procedures: MAIL_RECOVERY MAIL_RECOVERY_FQ ES_DOC_DATASTORE ES_SEARCH_DATASTORE Errors when creating a text index: ORA-20000: Oracle Text Error DRG-10761: procedure does not exist

   
   

4.3.6 Installing the Oracle Collaboration Suite Patch Set

This section contains procedures for applying the Oracle Collaboration Suite Release 2 Patch Set 1 (9.0.4.2.1) to the Oracle9i Application Server (9.0.2.3) metadata repository and the Oracle Collaboration Suite 9.0.4.1.1 middle tier.

Caution: Before running umconfig.bat to configure Email during Oracle Collaboration Suite 9.0.4.1.1 middle tier installation, you must apply the Oracle Email patch for bug 3854947 for Oracle Application Server 10g (9.0.4) compatibility patch on the middle tier. You can find this patch on http://metalink.oracle.com.

1. Configure the middle tiers to start using the new custom Oracle Database 10g Release 1 (10.1.0.2) as the information store by executing umconfig.bat in the middle tier system as follows:

   %ORACLE_HOME%\oes\bin\umconfig.bat
   
   

   When running umconfig.bat, select Middle Tier Configuration only.

   
   

   See Also: Oracle Collaboration Suite Installation and Configuration Guide Release 2 (9.0.4.1.1)

   
   

2. Install the Oracle Collaboration Suite Release 2 Patch Set 1 (9.0.4.2.1) on the Oracle9i Application Server (9.0.2.3) metadata repository ORACLE_HOME. See Chapter 2, "Installing the Patch Set" for details. Refer also to Section 4.3.3, "Installing the Metadata Repository" for the ORACLE_HOME.

3. Install the Oracle Collaboration Suite Release 2 Patch Set 1 (9.0.4.2.1) on the Oracle Collaboration Suite middle tiers as instructed in Section 4.3.5, "Installing the Oracle Collaboration Suite Middle Tier".

4. Install and configure Oracle Voicemail & Fax, as instructed in Chapter 8 of the Oracle Collaboration Suite Installation and Configuration Guide Release 2 (9.0.4.1.1).

5. Proceed to Chapter 3, "Patch Set Postinstallation Instructions" and follow all instructions except those for Oracle Files.

6. Configure Oracle Files, including the optional Oracle Workflow integration, as instructed in Chapter 14 of the Oracle Collaboration Suite Installation and Configuration Guide Release 2 (9.0.4.1.1).

7. Configure Oracle9iAS Wireless as instructed in the Oracle9iAS Wireless Administrator's Guide.

8. Configure the rest of the middle tier components according to their respective chapters in the Oracle Collaboration Suite Installation and Configuration Guide Release 2 (9.0.4.1.1).