Error while upgrading Oracle Portal from 10.1.2.0 to 10.1.4.0

I want to work on Oracle portal 10.1.4.0 instance. For this I have installed Oracle portal 10.1.2.0 and we need to execute a upgrade script which upgrade Oracle portal 10.1.2.0 to Oracle portal 10.1.4.0.

To execute the upgrade script, we need to run mrua.bat file.  The command syntax to execute is as follows –

<Command prompt>\mrua.bat -oracle_home <oracle_home location>

In my case, I have used the following command to execute the mrua.bat file –

D:\Softwares\Application Servers\OracleApplicationServer10.1.4Upgrade\as_windows_x86_portal_1014\
mrua_051020\mrua>mrua.bat -oracle_home D:\Installations\ApplicationServers\OracleApplicationServer10.1.2\OraInfra -oid_host localhost -oid_ssl_port 636

When I executed the above command, I got the below error message –

————————————————————————–
Executing mrua.pl
Running on Windows
OracleAS Metadata Repository Upgrade Assistant 10.1.4.0.0
Enter the password for SYS:
Enter the password for cn=orcladmin:
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: D:\Installations\ApplicationServers\OracleApplicationServer10.1.2\Ora
Infra\upgrade\logs\mrua2008-02-25_11-19-11AM.log
Finished mrua.pl
D:\Softwares\OracleApplicationServer10.1.4Upgrade\as_windows_x86_portal_1014\mru
a_051020\mrua>
————————————————————————————————————————–

After lot of searching and reading the Oracle portal documentation, I found the solution to the above error.

Reason for Error:

There are other sessions running on the OracleAS Portal schema.

This issue it is described within the Error Messages appendix of the OracleAS Upgrade & Compatibility guide.

WWU-00011: Concurrent sessions were running for the schema you are upgrading.
Cause: Other sessions are running on the OracleAS Portal schema.
Action: Make sure the OracleAS 10g middle-tier is shut down and there are
no other connections to the schema being upgraded. Look under “Open Sessions”
in the upgrade log for a list of open sessions for the schema.

Check also v$session table for open sessions on the database side.

To implement the solution, please execute the following steps:-
Note: Execute all the commands in Command Prompt.

1. Shutdown the midtier (Portal)
MID_TIER_ORACLE_HOME/opmn/bin/opmnctl stopall
MID_TIER_ORACLE_HOME/bin/emctl stop iasconsole

2. Shutdown the infrastructure. (Infra)
INFRA_ORACLE_HOME/opmn/bin/opmnctl stopall
INFRA_ORACLE_HOME/bin/emctl stop iasconsole

3. Restart the db. (Metadata Repository which is Infra)
%ORACLE_HOME%\bin\sqlplus /nolog
connect / as sysdba
shutdown immediate
startup
exit

4. Start the infrastructure. (Infra)
INFRA_ORACLE_HOME/opmn/bin/opmnctl startall
INFRA_ORACLE_HOME/bin/emctl start iasconsole

5. Perform the upgrade again. (execute the mrua.bat command)

6. Validate that there are no errors post-Upgrade.

By executing all the above steps the upgration of Oracle Portal from 10.1.2.0 to 10.1.4.0 is successful.

Advertisements
This entry was posted in Oracle Portal and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

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