E Upgrading from Oracle9iAS CC Release 9.0.2 to Release 9.0.2.3 on Solaris

Use this appendix for upgrading the Oracle9i Application Server Certified Configuration (Oracle9iAS CC) from release 9.0.2 to release 9.0.2.3 on Solaris Operating Environment (SPARC 64-bit).

Upgrading in a Single Tier Environment

To upgrade Oracle9iAS CC, you must patch the Infrastructure and the Mid-Tier in the following sections.

Note:

Before applying the various patches, stop all processes from the Infrastructure and Oracle9iAS mid-tier instance.

Infrastructure

Use the following instructions to patch the Infrastructure:

Apply 9014 patch (patch number: 2517300). Follow the instructions in the Post Install Actions section of the patch README file to upgrade the Infrastructure database (associated with the Infrastructure ORACLE_HOME) to 9014.

The following are some tips:
1. Make sure that you download the 9014 patch (patch number: 2517300) for Sun Solaris OS (SPARC) and not Sun Solaris OS (SPARC) 64-bit.
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
3. In the Post Install Action section, you will encounter the following in several places:
```
ALTER USER <user name> IDENTIFIED BY <passwd> ACCOUNT UNLOCK; 
```
  Replace this command with the following command (so you do not change the schema password):
```
ALTER USER <user name> ACCOUNT UNLOCK;
```
Apply patch for bug 2563444.
Apply patch for bug 2282201.
Apply 9023 patch (patch number: 3038037) for Infrastructure (follow the Patch Set Single Instance Installation Procedure for Infrastructure steps in the README file). Make sure to follow the Postinstallation Procedures for Infrastructure in the README file, which also includes applying the patch for bug 2988414.

The following are some tips:
1. Make sure to download the 9023 patch (patch number: 3038037) for Sun Solaris OS (SPARC).
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
3. Ensure that the database, listener, and Oracle Internet Directory services are running in the Infrastructure before starting the runInstaller.
4. In the process of applying the patch, stop all the processes when the installer prompts for the patch.
Do a basic (bring up all processes if required) check by trying to log into sso (http://hostname:port/pls/orasso).

Oracle9iAS CC Mid-Tier

Use the following instructions to upgrade the mid-tier:

Apply 9014 patch (patch number: 2517300). Do NOT follow the Post Install Actions sections of the patch README file.

The following are some tips:
1. Make sure that you download the 9014 patch (patch number: 2517300) for Sun Solaris OS (SPARC) and not Sun Solaris OS (SPARC) 64-bit.
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
Apply patch for bug 2563444.
Apply patch for bug 2282201.
Apply 9022 patch (patch number: 2703110). Follow the Installation Instructions for Single Instance Configurations steps in the README file. Make sure to also follow the Post Single Instance Install Instructions steps.

The following are some tips:
1. Make sure to download the 9022 patch (patch number: 2703110) for Sun Solaris OS (SPARC).
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
Apply ORACLE DEVELOPER : RELEASE 9I : PATCH 2 (patch number: 2842923).

The following are some tips:
1. Make sure to download the ORACLE DEVELOPER : RELEASE 9I : PATCH 2 (patch number: 2842923) for Sun Solaris OS (SPARC).
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
3. If the 2 configuration assistants (forms configuration assistant and reports configuration assistant) fail, cut and paste the command spawned for the forms configuration assistant in a shell script and run the shell script after setting the LD_LIBRARY_PATH parameter to $ORACLE_HOME/lib.
  
  Then, cut and paste the command spawned for the reports configuration assistant in a shell script and run the shell script after setting the LD_LIBRARY_PATH parameter to $ORACLE_HOME/lib.
Apply 9023 patch (patch number: 3038037) for the mid-tier (follow the Patch Set Installation Procedure for Middle Tier steps in the README file). Make sure to follow the Postinstallation Procedures for the mid-tier in the README file.

The following are some tips:
1. Make sure to download the 9023 patch (patch number: 3038037) for Sun Solaris OS (SPARC).
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
3. Shutdown all the processes in the Oracle9iAS CC mid-tier.
4. Ensure that the database, listener, and Oracle Internet Directory services are running in the Infrastructure before starting the runInstaller.
5. Shutdown all the processes in the Oracle9iAS CC mid-tier before starting the runInstaller.
Perform basic checks (bring up all processes if required) by trying to log into sso (http://hostname:port/pls/portal).

Upgrading in a Two Tier Environment

To upgrade Oracle9iAS CC, you must patch the Infrastructure Database Tier, the Infrastructure Mid-Tier, and the Oracle9iAS CC Mid-Tier in the following sections.

Note:

Before applying the various patches, stop all processes from the Infrastructure Database Tier, the Infrastructure Mid-Tier, and the Oracle9iAS CC Mid-Tier instance.

Infrastructure Database Tier

Use the following instructions to patch the Infrastructure Database Tier:

Apply 9014 patch (patch number: 2517300). Follow the instructions in the Post Install Actions section of the patch README file to upgrade the Infrastructure database (associated with the Infrastructure ORACLE_HOME) to 9014.

The following are some tips:
1. Make sure that you download the 9014 patch (patch number: 2517300) for Sun Solaris OS (SPARC) and not Sun Solaris OS (SPARC) 64-bit.
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
3. In the Post Install Action section, you will encounter the following in several places:
```
ALTER USER <user name> IDENTIFIED BY <passwd> ACCOUNT UNLOCK; 
```
  Replace this command with the following command (so you do not change the schema password):
```
ALTER USER <user name> ACCOUNT UNLOCK;
```
Apply patch for bug 2563444.
Apply patch for Bug2282201.
Apply 9023 patch (patch number: 3038037) for Infrastructure (follow the Patch Set Single Instance Installation Procedure for Infrastructure steps in the README file). Make sure to follow the Postinstallation Procedures for Infrastructure in the README file, which also includes applying the patch for bug 2988414.

The following are some tips:
1. Make sure you download the 9023 patch (patch number: 3038037) for Sun Solaris OS (SPARC).
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
3. Before starting the runInstaller, ensure that the database and listener services are running in the Infrastructure.
4. Modify $ORACLE_HOME/config/ias.properties file so that the SSOhost and OIDhost point to the Infrastructure Database Tier hostname, which likely changed to point to the Infrastructure mid-tier.
  
  After you apply the 9023 patch, make sure that you revert the file back so that SSOhost and OIDhost point to Infrastructure mid-tier and that you stop Oracle Internet Directory processes.
5. Start Oracle Internet Directory.
6. In the process of applying the patch, stop all the processes when the installer prompts for the patch.
7. OIDDAS redeployment configuration assistant will fail, since there are no previous deployments of OC4J instances. Ignore this error. All other configuration assistants (OID patchCA, DCM CA, and SSO patch CA) should succeed.
Do a basic (bring up all processes if required) check by trying to log into sso (http://hostname:port/pls/orasso).
Stop Oracle Internet Directory (oidldapd and oidmon processes).

Infrastructure Mid-Tier

Use the following instructions to upgrade the Infrastructure mid-tier:

Apply 9014 patch (patch number: 2517300). Do NOT follow the Post Install Actions sections of the patch README file.

The following are some tips:
1. Make sure that you download the 9014 patch (patch number: 2517300) for Sun Solaris OS (SPARC) and not Sun Solaris OS (SPARC) 64-bit.
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
Apply patch for bug 2563444.
Apply patch for bug 2282201.
Apply 9023 patch (patch number: 3038037) for Infrastructure (follow the Patch Set Single Instance Installation Procedure for Infrastructure steps in the README file). Do NOT follow the Postinstallation Procedures in the README file.

The following are some tips:
1. Make sure to download the 9023 patch (patch number: 3038037) for Sun Solaris OS (SPARC).
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
3. Before starting the runInstaller, ensure that the database and listener services are running in the Infrastructure Database Tier.
4. Before starting the runInstaller, modify the $ORACLE_HOME/config/ias.properties file so that the SSOhost and OIDhost point to the Infrastructure Database Tier hostname.
  
  After you apply the 9023 patch, make sure that you revert the file back so that SSOhost and OIDhost point to Infrastructure mid-tier.
5. Before starting runInstaller, start Oracle Internet Directory.
6. In the process of applying the patch, stop all the processes when the installer prompts for the patch.
7. Before running runInstaller, at the root.sh prompt (just after running root.sh script and before clicking the OK button, cut and paste the oidmon and oidldapd relink command from $ORACLE_HOME/install/make.log file in a shell script and run this script from the $ORACLE_HOME/ldap/lib directory. This will relink oidmon and oidldapd in the $ORACLE_HOME/ldap/lib directory.
8. Move $ORACLE_HOME/bin/oidmon to $ORACLE_HOME/bin/oidmon.prebug3038037.Move $ORACLE_HOME/bin/oidldapd to $ORACLE_HOME/bin/oidldapd.prebug3038037.Move $ORACLE_HOME/ldap/lib/oidmon to $ORACLE_HOME/bin.Move $ORACLE_HOME/ldap/lib/oidldapd to $ORACLE_HOME/bin. Run the following commands:
```
chmod 4710 $ORACLE_HOME/bin/oidmon
chown root $ORACLE_HOME/bin/oidldapd
chmod 4710 $ORACLE_HOME/bin/oidldapd
```
9. Click OK at the root.sh prompt.
10. From the install logs of Infrastructure Database Tier, cut and paste the command spawned for OIDDAS redeployment CA in a shell script and run this script from the command line. All deployments should succeed.
  
  OiD Patch configuration assistant did not perform any actions, but the system will show that the deployment was successful, since it ran in the database tier.
  
  DCM configuration assistant should succeed.
Perform basic checks (bring up all processes if required) by trying to log into sso (http://hostname:port/pls/portal).

Oracle9iAS CC Mid-Tier

Use the following instructions to upgrade the mid-tier:

Apply 9014 patch (patch number: 2517300). Do NOT follow the Post Install Actions sections of the patch README file.

The following are some tips:
1. Make sure that you download the 9014 patch (patch number: 2517300) for Sun Solaris OS (SPARC) and not Sun Solaris OS (SPARC) 64-bit.
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
Apply patch for bug 2563444.
Apply patch for bug 2282201.
Apply 9022 patch (patch number: 2703110). Follow the Installation Instructions for Single Instance Configurations steps in the README file. Make sure to also follow the Post Single Instance Install Instructions steps.

The following are some tips:
1. Make sure to download the 9022 patch (patch number: 2703110) for Sun Solaris OS (SPARC).
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
Apply ORACLE DEVELOPER : RELEASE 9I : PATCH 2 (patch number: 2842923).

The following are some tips:
1. Make sure to download the ORACLE DEVELOPER : RELEASE 9I : PATCH 2 (patch number: 2842923) for Sun Solaris OS (SPARC).
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
3. If the 2 configuration assistants (forms configuration assistant and reports configuration assistant) fail, cut and paste the command spawned for the forms configuration assistant in a shell script and run the shell script after setting the LD_LIBRARY_PATH parameter to $ORACLE_HOME/lib.
  
  Then, cut and paste the command spawned for the reports configuration assistant in a shell script and run the shell script after setting the LD_LIBRARY_PATH parameter to $ORACLE_HOME/lib.
Apply 9023 patch (patch number: 3038037) for the mid-tier (follow the Patch Set Installation Procedure for Middle Tier steps in the README file). Make sure to follow the Postinstallation Procedures for the mid-tier in the README file.

The following are some tips:
1. Make sure to download the 9023 patch (patch number: 3038037) for Sun Solaris OS (SPARC).
2. Before running the runInstaller for the patch make sure the /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory.
3. Shutdown all the processes in the Oracle9iAS CC mid-tier.
4. Ensure that the database, listener, and Oracle Internet Directory services are running in the Infrastructure before starting the runInstaller.
5. Shutdown all the processes in the Oracle9iAS CC mid-tier before starting the runInstaller.
Perform basic checks (bring up all processes if required) by trying to log into sso (http://hostname:port/pls/portal).