IN ORACLE MILIEU …

Beyond Knowledge

Creating Oracle Home Inventory – Oracle Database 10g

Some times you clone an oracle home manually using OS level commands and this might cause problem in your existing inventory. Your new ORACLE_HOME will not be registered in your existing registry.

As far as running of database is concerned, we wont face any problem, trouble comes when in future you want to apply a patch to an oracle home which is not registered in inventory. The patch can be applied to an ORACLE_HOME with -no_inventory option, but then you wont have the record of patches applied to that ORACLE_HOME.

For such situation, you can register your new ORACLE_HOME manually to the existing inventory (or create a new inventory). Below is the command for the same.

cd $ORACLE_HOME/oui/bin 

./runInstaller -attachHome ORACLE_HOME=”/slot/ems1696/oracle/db/tech_st/11.1.0″ ORACLE_HOME_NAME=”Oracle11g_home1″ 

Here ORACLE_HOME will contain the complete path for ORACLE_HOME and  ORACLE_HOME_NAME will be the name you want to give for your ORACLE_HOME

Hope this helps !!

Advertisement

4 Responses to Creating Oracle Home Inventory – Oracle Database 10g

  1. Pingback: OPATCH Utility (Oracle RDBMS Patching) « IN ORACLE MILIEU …

  2. dbametrix October 8, 2009 at 8:55 pm

    Hi,

    Very interesting. Thanks for such great article.

    Thanks and regards,
    Gitesh
    http://www.dbametrix.com

  3. Pingback: OPATCH Utility (RDBMS Patching) « Jcprasad's Blog

  4. Sai September 23, 2011 at 1:32 pm

    Hi,

    I am getting this error.

    ./runInstaller -attachHome ORACLE_HOME=”/export/home/oracle/spbd” ORACLE_HOME_NAME=”SPBD”

    OUI-10197:Unable to create a new Oracle Home at /export/home/oracle/spbd. Oracle Home already exists at this location. Select another location.
    ‘AttachHome’ failed.

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 )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 136 other followers