Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: What is the Difference Between Local Inventory and Global Inventory?

  1. #1
    Oracle Administrator
    Join Date
    Feb 2012
    Location
    New Delhi, India
    Posts
    53

    What is the Difference Between Local Inventory and Global Inventory?

    What is ora Inventory ?

    oraInventory is repository (directory) which store/records oracle software products & their oracle_homes location on a machine. This Inventory now a days in XML format and called as XML Inventory where as in past it used to be in binary format & called as binary Inventory.
    There are basically two kind of inventories,
    One is Local Inventory (also called as Oracle Home Inventory) and other is Global Inventory (also called as Central Inventory).

    What is Global Inventory ?

    Global Inventory holds information about Oracle Products on a Machine. These products can be various oracle components like database, oracle application server, collaboration suite, soa suite, forms & reports or discoverer server . This global Inventory location will be determined by file oraInst.loc in /etc (on Linux) or /var/opt/oracle (solaris). If you want to see list of oracle products on machine check for file inventory.xml under ContentsXML in oraInventory Please note if you have multiple global Inventory on machine check all oraInventory directories)
    You will see entry like
    HOME NAME=”ORA10g_HOME” LOC=”/u01/oracle/10.2.0/db” TYPE=”O” IDX=”1?/
    What is Local Inventory ?
    Inventory inside each Oracle Home is called as local Inventory or oracle_home Inventory. This Inventory holds information to that oracle_home only.

    What is Oracle Home Inventory?


    Oracle home inventory or local inventory is present inside each Oracle home. It only contains information relevant to a particular Oracle home. This file is located in the following location:
    $ORACLE_HOME/inventory
    It contains the following files and folders:
    • Components File
    • Home Properties File
    • Other Folders

    Can I have multiple Global Inventory on a machine ?
    Quite common questions is that can you have multiple global Inventory and answer is YES you can have multiple global Inventory but if your upgrading or applying patch then change Inventory Pointer oraInst.loc to respective location. If you are following single global Inventory and if you wish to uninstall any software then remove it from Global Inventory as well.
    What to do if my Global Inventory is corrupted ?
    No need to worry if your global Inventory is corrupted, you can recreate global Inventory on machine using Universal Installer and attach already Installed oracle home by option
    -attachHome
    ./runInstaller -silent -attachHome -invPtrLoc $location_to_oraInst.loc
    ORACLE_HOME=”Oracle_Home_Location” ORACLE_HOME_NAME=”Oracle_Home_Name”
    CLUSTER_NODES=”{}”
    Last edited by devesh_ocp; 11-30-2013 at 09:51 PM.
    Regards_____
    D
    evesh Chaurasia

    Oracle Administrator

  2. #2
    Oracle Administrator
    Join Date
    Feb 2012
    Location
    New Delhi, India
    Posts
    53

    Lightbulb How can you track the password change for a user in oracle?

    Oracle only tracks the date that the password will expire based on when it was latest changed. Thus listing the view DBA_USERS.EXPIRY_DATE and subtracting PASSWORD_LIFE_TIME you can determine when password was last changed. You can also check the last password change time directly from the PTIME column in USER$ table (on which DBA_USERS view is based). But If you have PASSWORD_REUSE_TIME and/or PASSWORD_REUSE_MAX set in a profile assigned to a user account then you can reference dictionary table USER_HISTORY$ for when the password was changed for this account.
    SELECT user$.NAME, user$.PASSWORD, user$.ptime, user_history$.password_date
    FROM SYS.user_history$, SYS.user$
    WHERE user_history$.user# = user$.user#;
    Regards_____
    D
    evesh Chaurasia

    Oracle Administrator

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics