Stay at Home!! Be Safe!! Take Care!!

For Any queries, please mail us at support@funoracleapps.com

Changing the ORACLE BASE Location

8 comments
Recently I faced an issue in my new environment where ORACLE_BASE was pointing to wrong location in a particular environment.

To correct this we have two options:

1. Either change the environment variable ORACLE_BASE on server  to the new location.
    export ORACLE_BASE=/newlocation

2. We can also change the ORACLE_BASE variable using the ‘orabase’ utility. It can be done in 11g and above version. 

Steps to change using orabase

a) Check the current value of the ORACLE_BASE using below command:

$ORACLE_HOME/bin/orabase

/oracle/apps


The value can be verified from  oraclehomeproperties.xml file. File is located at $ORACLE_HOME/inventory/ContentsXML/

oracle@test :/oracle/app/TEST/product/11.2.0.3/inventory/ContentsXML]
$ cat oraclehomeproperties.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2013, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<ORACLEHOME_INFO>
   <GUID>252246286.7539233482</GUID>
   <HOME/>
   <ARU_PLATFORM_INFO>
      <ARU_ID>123</ARU_ID>
      <ARU_ID_DESCRIPTION>Linux</ARU_ID_DESCRIPTION>
   </ARU_PLATFORM_INFO>
   <PROPERTY_LIST>
      <PROPERTY NAME="ARCHITECTURE" VAL="64"/>
      <PROPERTY NAME="ORACLE_BASE" VAL="/oracle/apps"/>
   </PROPERTY_LIST>
</ORACLEHOME_INFO>

b) Backup the oraclehomeproperties.xml

oracle@test :/oracle/app/TEST/product/11.2.0.3/inventory/ContentsXML]
$ cp -ip oraclehomeproperties.xml oraclehomeproperties.xml_him

c) Change ORACLE_BASE to new location using orabase utility

oracle@test :/oracle/app/TEST/product/11.2.0.3/inventory/ContentsXML]
$ $ORACLE_HOME/bin/orabase -s /u01/TEST

Once the command is executed successfully oraclehomeproperties.xml value is updated.

We can verify the new value in oraclehomeproperties.xml file as well.

oracle@test :/oracle/app/TEST/product/11.2.0.3/inventory/ContentsXML]

$  cat oraclehomeproperties.xml
<?xml version="1.0" encoding="UTF-8"?>
<!-- Copyright (c) 1999, 2013, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<ORACLEHOME_INFO>
    <GUID>252246286.7539233482</GUID>
    <HOME/>
    <ARU_PLATFORM_INFO>
        <ARU_ID>123</ARU_ID>
        <ARU_ID_DESCRIPTION>Linux</ARU_ID_DESCRIPTION>
    </ARU_PLATFORM_INFO>
    <PROPERTY_LIST>
        <PROPERTY NAME="ARCHITECTURE" VAL="64"/>
        <PROPERTY NAME="ORACLE_BASE" VAL="/u01/TEST"/>
    </PROPERTY_LIST>
</ORACLEHOME_INFO>

This is only applicable for 11g version. For version 12.1 and later it will not work.

For any incorrect path of Oracle Base , Please also check below file:

/oracle/app/product/12.1.0.2/install/orabasetab

8 comments :

  1. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.

    oracle training in bangalore

    ReplyDelete
  2. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.
    Oracle course in chennai

    ReplyDelete
  3. Your info is really amazing with impressive content..Excellent blog with informative concept. Really I feel happy to see this useful blog, Thanks for sharing such a nice blog..
    If you are looking for any python Related information please visit our website Python classes in pune page!

    ReplyDelete
  4. Your info is really amazing with impressive content..Excellent blog with informative concept. Really I feel happy to see this useful blog, Thanks for sharing such a nice blog..
    If you are looking for any python Related information please visit our website Python classes in pune page!


    ReplyDelete
  5. Thanks for sharing your innovative ideas to our vision. I have read your blog and I gathered some new information through your blog. Your blog is really very informative and unique. Keep posting like this. Awaiting for your further update.If you are looking for any Hadoop admin related information, please visit our website Hadoop administration training institute in Bangalore

    ReplyDelete
  6. Best post..
    Thanks for sharing with us,
    We are again come on your website,
    Thanks and good day,
    If you need any logo then,
    Please visit our site,
    buylogo

    ReplyDelete
  7. Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites!

    angular js training in chennai

    angular js training in velachery

    full stack training in chennai

    full stack training in velachery

    php training in chennai

    php training in velachery

    photoshop training in chennai

    photoshop training in velachery

    ReplyDelete