Thursday, July 14, 2011

How to Check Fusion Middleware and WebLogic Component Versions

Applies to:
Oracle Fusion Middleware - Version: 11.1.1.1.0 to 11.1.1.5.0 - Release: to Oracle11g
Information in this document applies to any platform.

Goal
This document describes how to determine the versions of installed Fusion Middleware Components and Weblogic Server.

Note:
Fusion Middleware components including WebLogic Server, RCU, and components such as SOA, Identity Management, Portal-Forms-Reports-Discover, and JDeveloper must have concordant versions. This affects configuration, but not installation, and can cause a variety of failures, including ClassDefNotFound exceptions when trying to configure a new domain or managed server.


1. To determine the WebLogic Server version. There are several ways to confirm the version:
  •  Enter this command with the weblogic environment enabled:
$ java weblogic.version

  • Look in the file Middleware Home/registry.xml, and note the component tag
  • The exact WLS version can be checked using the following commands:

    On Unix:
cat $MW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION

On Windows:
type %MW_HOME%\wlserver_10.3\.product.properties | findstr WLS_PRODUCT_VERSION
  • Use SmartUpdate to check the Product Version:

    On Unix:
$MW_HOME/utils/bsu/bsu.sh -view -status=applied -prod_dir=$MW_HOME/wlserver_10.3 | grep ProductVersion

On Windows:
%MW_HOME%\utils\bsu\bsu.sh -view -status=applied -prod_dir=$MW_HOME\wlserver_10.3 | findstr ProductVersion

You should see a result such as this:
ProductVersion: 10.3 MP5


2. For JDeveloper, look in the Middleware Home/registry.xml file for the following:


3. For Fusion Middleware products, use the command Oracle Home/Opatch/opatch lsinventory and note the output:
Installed Top-level Products (2):

Application Server 11g SOA Patchset 11.1.1.3.0
Oracle SOA Suite 11g 11.1.1.2.0
There are 2 products installed in this Oracle Home.


4. For the MDS version, look in the file RCU Home/rcu/log/logdir./mds.log:
REPOS_VERSION CONSTANT VARCHAR2(32) := '11.1.1.56.27' (this is for 11.1.1.3)

To get the schema version from the database, login to the database as sysdba and enter the command as shown (example here for 11.1.1.3):
SQL> select comp_id, comp_name, version from schema_version_registry;

COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
VERSION
------------------------------
IAU
Audit Service
11.1.1.3.0

MDS
Metadata Services
11.1.1.2.0

OID
Oracle Internet Directory
11.1.1.3.0

OIF
Oracle Identity Federation Database Schema
11.1.1.2.0

ORAESS
Enterprise Scheduler Service
11.1.1.2.0

ORASDPLS
SIP Infrastructure Location Service
11.1.1.2.0

ORASDPSDS
SIP Infrastructure Subscriber Data Service
11.1.1.2.0

ORASDPXDMS
Presence
11.1.1.2.0

8 rows selected.

You can also get the schema prefix from the database using the following command:
SQL> select username, created from dba_users order by 2;

USERNAME CREATED
------------------------------ ---------
OE 12-MAY-10
SH 12-MAY-10
BI 12-MAY-10
PM 12-MAY-10
TEST01_MDS 21-JAN-11
TEST01_IAU 21-JAN-11
TEST01_IAU_APPEND 21-JAN-11
TEST01_IAU_VIEWER 21-JAN-11
TEST01_ORAESS 21-JAN-11
ODS 21-JAN-11
ODSSM 21-JAN-11

USERNAME CREATED
------------------------------ ---------
TEST01_OIF 21-JAN-11
TEST01_ORASDPXDMS 21-JAN-11
TEST01_ORASDPLS 21-JAN-11
TEST01_ORASDPSDS 21-JAN-11

The prefix given in the Repository Creation Utility (RCU) dialog is TEST01.

37 comments:

  1. Hi,

    Thanks a lot.I found this site while surfing,this site had cleared my issues about Fusion Middleware and WebLogic Component Versions.

    Oracle Managed Services

    ReplyDelete
  2. How do you determine the Fusion Applications version from the database tables?
    Where does it indicate if HCM is on (RUP1) 11.1.2.0.0 or (RUP3) 11.1.4.0.0 ?


    For example, Human Capital Management product for Fusion
    I could only find the base version.

    select * from ad.product_installations
    where patch_level like '%HCM%';

    ReplyDelete
    Replies
    1. select release_name from fusion.ad_product_groups;

      Delete

  3. This is very important and imformative blog,thanks for good info Oracle SOA Online Training Bangalore

    ReplyDelete
  4. For 12c the method that works for me is:

    $MW_HOME/oui/bin/viewInventory.sh

    using $MW_HOME/Opatch/opatch lsinventory was not giving enough details but that's where give you the hint to use above command.

    ReplyDelete
  5. Pest control services Chennai is a dedicated service solution to all your pest and insect troubles in Chennai.
    Pest control services in chennai.
    Pest control in chennai.
    Pest control services near me.

    ReplyDelete
  6. Realme Mobile Service center in Chennai
    Realme Servicing by No. 1 Leaders Awesome Services On-time, Every time!
    Realme Mobile Service Center in Chennai

    ReplyDelete
  7. iPhone Service center in Bangalore No. 1 Leaders Awesome Services On-time, Every time!
    iPhone Service Center in Bangalore
    Apple Service center in Bangalore
    Apple Service Center in Bangalore

    ReplyDelete
  8. Mi Service Center in Chennai

    Mi Service Center in Chennai No. 1 Leaders Awesome Services On-time, Every time!
    Mi Service Center in Chennai
    Redmi Service Center in Chennai
    Mi Service Center in Chennai

    ReplyDelete
  9. This comment has been removed by the author.

    ReplyDelete
  10. Iphone service center in Chennai

    Iphone service Center in Chennai offers you best quality of Services On-time, Every time!
    IPhone Service Center in Chennai
    Apple Iphone Service center in Chennai
    Apple Service Center in Chennai
    Apple Service center in Chennai
    IPhone Service Center in Chennai

    ReplyDelete
  11. Sony Mobile Service Center In Chennai
    Sony Servicing by No. 1 Leaders Awesome Services On-time, Every time!
    Sony Mobile Service Center In Chennai

    ReplyDelete
  12. Nokia Mobile Service Center In Chennai
    Nokia Mobile Service Center In Chennai. Providing Fast, Honest, Reliable & Cost Effective Service Solutions to The Nokia Mobile Users.
    NOkia Mobile Service Center In Chennai

    ReplyDelete
  13. Honor service center in Chennai

    Honor Service Center in Chennai for the Best & Right Place to service your Honor mobile phone.
    Honor Service Center in Chennai

    ReplyDelete
  14. OPPO Service Center In Chennai
    OPPO Service Center Chennai is an end-to-end OPPO service and repair solutions Center.
    OPPO Service Center In Chennai

    ReplyDelete
  15. Ipad service center in Chennai

    Ipad service Center in Chennai offers you best quality of Services On-time, Every time!
    Ipad Service Center in Chennai

    ReplyDelete
  16. Apple Imacbook Service Center in Chennai

    Apple Laptop Service Center in Chennai offers you best quality of Services On-time, Every time!
    Apple Laptop Service Center in Chennai

    ReplyDelete
  17. Acer Service Center in Chennai

    Acer Service Center in Chennai Best service for all model acer laptop and desktop Services On-time, Every time!
    Acer Laptop Service Center in Chennai
    Acer Service Center in Chennai
    Acer Service Center in Chennai

    ReplyDelete
  18. Awesome Post!!!


    Redmi Service Center in Chennai

    Redmi Service Center in Chennai No. 1 Leaders Awesome Services On-time, Every time!
    Redmi Service center in chennai
    Mi Service Center in Chennai
    Mi Service Center in Chennai

    ReplyDelete
  19. WOW Great Post!!!

    Apple iPhone Service Center in Chennai

    Chennai No-1 Apple iPhone Service Center in Chennai
    Apple iPhone Service Center in Chennai
    Iphone Service Center in Chennai
    Iphone Service Center in Chennai
    Apple Service Center In Chennai
    Apple Service Center In Chennai

    ReplyDelete
  20. This comment has been removed by the author.

    ReplyDelete
  21. Oppo Service Center in Bangalore

    OPPO Service Center in Bangalore is the best OPPO Service Center in Bangalore. We can fix all OPPO devices at low cost with best quality.
    Oppo Repair Center in Bangalore- All our OPPO care technicians has 10+ years experience in the mobile care fix industry

    Oppo repair center in bangalore

    ReplyDelete