• Find us:
    +1 415 655 1723   |   +91-844-844-8901
  • Free Newsletter


  • Archive

  • Categories

  • How to find schema version of fusion middleware components OIM, OAM, SOA, WebCenter, OPSS etc

    Posted by "" in "FMW, OAAM, oid, ovd" on 2014-06-24

    Fusion Middleware (FMW) products like Oracle SOA, WebCenter, Identity Management (OIM, OAM) etc , you must create schema using Repository Creation Utility (RCU). This schema version and status in maintained in registry table ( schema_version_registry ) under sys schema.


    You can use the below method to find schema version of fusion middleware components from schema_version_registry

    Login to the database with sys user follow the below steps :


    1. Login to host where database is running

    2. Set environment variable

    .  dbiam.env

    3. Connect to database as sysdba

    sqlplus “/as sysdba”

    SQL>Select * from schema_version_registry;

    SQL>select COMP_ID, COMP_NAME, version, status from schema_version_registry;


    how to check version of fusion middleware component2


    Leave a comment if you need more information or need any other information.

    Leave a Reply

    Your email address will not be published. Required fields are marked *

  • K21 Technologies is among the most experienced Oracle Gold Partner for Identity Access Management service providers. We work with application development companies and in-house technology division to help achieve significant returns on their IT security investment. Our clientele includes some of the globally renowned corporate, which speaks of our expertise in our field.

    We have the most talented and experienced team that can swiftly deploy security solutions even in complex IT ecosystem. Our clients highly appreciate our timely implementation, interactive training, on-demand support and community resources.

    K21 Technologies
    128 Uxbridge Road, Hatchend,,
    London, HA5 4DS

    US: +1 415 655 1723
    India: +91-844-844-8901

  • Copyright 2019, K21 Technologies. All rights reserved
  • TOP