Error: Component upgrade failed PORTAL component version is: 10.1.2.0.2 INVALID

Connect to Portal schema and run the below PL/SQL

SQL>    set trimspool on
SQL>         set heading off
SQL>         set feedback off
SQL>         set serveroutput on size 1000000
set linesize 10000
SQL> SQL>         begin
2              — Check Version
3              dbms_output.put_line(wwc_version.get_portal_version);
4          exception
5          when OTHERS then
6              dbms_output.put_line(‘ERROR’);
7          end;
8
9  /
10.1.2.0.2 <== before upgrade

Backup Portal, portal_public, portal_demo and portal_app schemas before the upgrade. Stop all the middle tiers.

mpoojari:oracle # cat /oracle/product/10ginfra/config/ias.properties | grep OID                                      

OID.LaunchSuccess=true
Components=Apache,J2EE,JServ,SSO,OID,DAS,DIP,OCA
OIDhost=mpoojari 
OIDport=389
OIDsslport=636

MRUA script needs the following inputs

  1.   Need -oracle_home value
  2.   Need -oid_host value
  3.   Need -oid_ssl_port value

The upgrade is perfomed through OID using SSL port for security reasons. Make sure there are no invalids for Portal schema. Compile all invalids using $ORACLE_HOME/rdbms/admin/utlrp.sql script.

Perform the Portal component upgrade to 10.1.4.0

mpoojari:oracle # ./mrua.sh -oracle_home /oracle/product/10ginfra -oid_host mpoojari -oid_ssl_port 636

Executing mrua.pl
Running on UNIX

OracleAS Metadata Repository Upgrade Assistant 10.1.4.0.0

Enter the password for SYS:
Enter the password for cn=orcladmin:
Upgrading the OracleAS Metadata Repository to release 10.1.4.0.0
Calling upgrade plugin for MRUA
Component upgraded successfully MRUA
Calling upgrade plugin for PORTAL
Error: Component upgrade failed PORTAL
Error: PORTAL component version is: 10.1.2.0.2 INVALID
Calling upgrade plugin for MRC
Component upgraded successfully MRC
FAILURE: Some OracleAS plug-ins report failure during upgrade.
Log file: /oracle/product/10ginfra/upgrade/logs/mrua2011-07-02_10-50-20AM.log

Finished mrua.pl

Version status in the metadata repository during the upgrade is as below:

SQL> select comp_name, status, version from dba_registry where comp_name=’Oracle Application Server Portal’;

COMP_NAME
——————————————————————————–
STATUS      VERSION
———– ——————————
Oracle Application Server Portal
UPGRADING   10.1.2.0.2

The error complaining about portal version 10.1.2.0.2 is due to the other portal sessions in the metadata repository holding locks on Portal schema while trying to upgrade using MRUA.

Make sure all middle tiers are down. Use opmnctl stopall to stop all middle tier process and ensure no oracle processes are running.

Stop EM console using emctl stop iasconsole.

bounce the database to clean up all portal sessions and start only the OID.

mpoojari:oracle # opmnctl startproc process-type=OID
opmnctl: starting opmn managed processes…

mpoojari:oracle # ldapbind -h mpoojari -p 389

bind successful.

Then start the upgrade once again.
mpoojari:oracle # ./mrua.sh -oracle_home /oracle/product/10ginfra -oid_host mpoojari -oid_ssl_port 636

Executing mrua.pl
Running on UNIX

OracleAS Metadata Repository Upgrade Assistant 10.1.4.0.0

Enter the password for SYS:
Enter the password for cn=orcladmin:
Upgrading the OracleAS Metadata Repository to release 10.1.4.0.0
Calling upgrade plugin for MRUA
Component has already been upgraded MRUA
Calling upgrade plugin for PORTAL <===== This will take a while (5-10mins)
Component upgraded successfully PORTAL
Calling upgrade plugin for MRC
Component has already been upgraded MRC
SUCCESS: All OracleAS plug-ins report successful upgrade

Finished mrua.pl

Check the metadata to confirm if the version has been upated.
SQL> select comp_name, status, version from dba_registry where comp_name=’Oracle Application Server Portal’;

COMP_NAME
——————————————————————————–
STATUS      VERSION
———– ——————————
Oracle Application Server Portal
VALID       10.1.4.0.0

Finally startall the processes:

  • emctl start iasconsole
  • opmnctl startall

log file:

mpoojari:oracle # pwd
/oracle/product/10ginfra/upgrade/logsmpoojari:oracle # tail -20 mrua2011-07-02_11-09-42AM.out
### Upgrade completed successfully
>>> Running /oracle/product/10ginfra/upgrade/temp/portal/tmp/popinv.sql
Portal SQL script started at Sat Jul  2 11:21:42 2011
>>> Running sql/pofrpt.sql
Portal SQL script started at Sat Jul  2 11:21:43 2011
Upgrade Ended at Sat Jul  2 11:21:43 2011

### Upgrade ended with status: 0
### OracleAS Portal 10.1.4 upgrade completed successfully.
Status is: 0
 Component upgraded successfully PORTAL
Calling upgrade plugin for MRC
——— MrcVersionPlugin.doUpgrade called
Component has already been upgraded MRC
SUCCESS: All OracleAS plug-ins report successful upgrade
Connect to Portal schema and run the following SQL:
SQL>    set trimspool on
SQL>         set heading off
SQL>         set feedback off
SQL>         set serveroutput on size 1000000
set linesize 10000
SQL> SQL>         begin
2              — Check Version
3              dbms_output.put_line(wwc_version.get_portal_version);
4          exception
5          when OTHERS then
6              dbms_output.put_line(‘ERROR’);
7          end;
8
9  /
10.1.4.0.0 <=== upgrade done
Advertisements

About mpoojari
Oracle Database/Applications Administrator

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: