4 Additional/Optional Oracle Collaboration Suite Upgrade Scenarios

This chapter provides information on using Oracle Collaboration Suite with Oracle Application Server 10g and Oracle Database 10g.

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

4.1 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 new installation of Oracle Application Server 10g (9.0.4) Identity Management and new installation of Oracle Database 10g (10.1.0.2.0).

This section includes the following topics:

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

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

• Section 4.1.3, "Installing the Metadata Repository"

• Section 4.1.4, "Installing Oracle Database 10g"

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

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

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

4.1.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.1.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 beenupdated successfully. Version 9.0.2 middle tier installationscan now be associated with this Infrastructure.

4.1.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.1.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 is 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.

      $Oracle_Home/bin/dbca
      

   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.1.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

   
   

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

   
   
   
   

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

   
   
   
   

   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.1.6 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 Database 10g Release 1 (10.1.0.2) information store.

Note: Because you ran the umconfig.bat script in the previous step, the custom Oracle Database 10g Release 1 (10.1.0.2) will have an Oracle Email 9.0.4.1.1 schema prior to installing the patch.

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.1.7 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 Oracle 9i Application Server (9.0.2.3) metadata repository and 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
   

   
   

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

   
   

   For more information, see 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 Oracle 9i Application Server (9.0.2.3) metadata repository ORACLE_HOME. See Chapter 2, "Installing the Patch Set" for details. Refer also to Section 4.1.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.1.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 Oracle9iAS Wireless as instructed in the Oracle9iAS Wireless Administrator's Guide.

7. 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).