X

Alejandro Vargas' Blog

  • January 8, 2020

How to add a new Database Home using OEDACLI on Exadata

Alejandro Vargas
Technical Leader, ACS Global Delivery, Infrastructure & BigData

OEDACLI is a powerful administration tool for Exadata, one of the actions more appreciated by customers is adding a new database home, this is a summary of the steps required:

  •     invoque oedacli (can be done on Windows or Linux)
    •     on windows is located on the same directory from where you run the graphic version of OEDA
    •     on Linux is located at /u01/install/linux-x64 on a physical installation
  •     load the xml file

         oedacli> load file name=test_Systems-x8m.xml
         SUCCESS - file loaded OK
         Customer : test Systems - 000

  •     run the add databasehome, save action and merge actions commands (will edit the xml in memory adding the new oracle home)

        oedacli> ADD DATABASEHOME OWNER='oracle' DBVERSION='12.1.0.2.170418' DBHOMENAME='dbhome_2' DBHOMELOC='/u01/app/oracle/product/12.1.0.2/dbhome_2' WHERE CLUSTERNUMBER=1
        oedacli> save action
        oedacli> merge actions
         processMerge
         processMergeActions
         Merging Action : ADD DATABASEHOME OWNER='oracle' DBVERSION='12.1.0.2.170418' DBHOMENAME='dbhome_2' DBHOMELOC='/u01/app/oracle/product/12.1.0.2/dbhome_2' WHERE CLUSTERNUMBER=1
         Merging ADD DATABASEHOME
         Action Validated and Merged OK

  •     run the list database homes command to see the patch numbers required by this version, look at the patch numbers of the version you choose to add, in this example 12.1.0.2.170418

        oedacli> list databasehomes
           version : "ZipInstall"
          cluster :
            id : "Cluster-cb3ad0db4-e22a-3be6-bf88-824a5a425df3_id"
          databaseHomeName : "DbHome_1"
          databaseSwOwner : "e9976514-060b-37a4-036c-2199cea027cf"
          databaseVersion : "19.5.0.0.191015"
          databaseHomeLoc : "/u01/app/oracle/product/19.0.0.0/dbhome_1"
          inventoryLocation : "/u01/app/oraInventory"
          installType : "rac_database"
          language : "all_langs"
          machines :
            machine :
              machine :
              id : "x8mcompute01_id"
              machine :
              id : "x8mcompute02_id"
          patches :
            patch :
              patchNumber : "30116789"
              patchNumber : "30128191"
              patchNumber : "30165493"
              patchNumber : "30165503"
          basedir : "/u01/app/oracle"
          id : "DbHome_4588acdc-e74a-a434-f81d-faa6b9c33a84_id"
          version : "ZipInstall"
          cluster :
            id : "Cluster-cb3ad0db4-e22a-3be6-bf88-824a5a425df3_id"
          databaseHomeName : "dbhome_2"
          databaseSwOwner : "e9976514-060b-37a4-036c-2199cea027cf"
          databaseVersion : "12.1.0.2.170418"
          databaseHomeLoc : "/u01/app/oracle/product/12.1.0.2/dbhome_2"
          inventoryLocation : "/u01/app/oraInventory"
          language : "all_langs"
          machines :
            machine :
              machine :
              id : "x8mcompute01_id"
              machine :
              id : "x8mcompute02_id"
          patches :
            patch :
              patchNumber : "25433352"
              patchNumber : "20641213"
              patchNumber : "21923026"
              patchNumber : "24944847"
              patchNumber : "25437695"
              patchNumber : "26729494"
              patchNumber : "28305362"
              patchNumber : "28683167"

          basedir : "/u01/app/oracle"
          useZfs : "false"
          id : "Cluster-cb3ad0db4-e22a-3be6-bf88-824a5a425df3_databaseHome1"

  •     Download the patches from MOS and upload them to the /u01/install/linux-x64/Workdir directory.
  •     If you run the oedacli on Windows save the xml to a new configuration, upload it to the /u01/install/linux-x64 directory and start oedacli from there to deploy the new database home

        oedacli> save file name='test-new-config.xml'
         File : test-new-config.xml saved OK

    Run the Deploy Actions 12.1.0.2.170418 command on the exadata, it will install the new oracle home

        oedacli> load file name=test-new-config.xml
         SUCCESS - file loaded OK
         Customer : test Systems - 000

        oedacli> deploy actions
         Deploying Action ID : 1 ADD DATABASEHOME OWNER='oracle' DBVERSION='12.1.0.2.170418' DBHOMENAME='dbhome_2' DBHOMELOC='/u01/app/oracle/product/12.1.0.2/dbhome_2' WHERE CLUSTERNUMBER=1
         Deploying ADD DATABASEHOMEOn 08/01/2020 03:10
        ... ...  ...

NOTES:

The xml will have these new section:

<actions>

        <action id="1" merged="true" deployed="false">

            <subCommand>ADD DATABASEHOME OWNER='oracle' DBVERSION='12.1.0.2.170418' DBHOMELOC='/u01/app/oracle/product/12.1.0.2/dbhome_2' WHERE CLUSTERNUMBER=1</subCommand>

        </action>

    </actions>

 

AND

 

<databaseHome id="Cluster-cb3ad0db4-e22a-3be6-bf88-824a5a425df3_databaseHome1">

                <version>ZipInstall</version>

                <cluster id="Cluster-cb3ad0db4-e22a-3be6-bf88-824a5a425df3_id"/>

                <databaseHomeName>dbhome_2</databaseHomeName>

                <databaseSwOwner>e9976514-060b-37a4-036c-2199cea027cf</databaseSwOwner>

                <databaseVersion>12.1.0.2.170418</databaseVersion>

                <databaseHomeLoc>/u01/app/oracle/product/12.1.0.2/dbhome_2</databaseHomeLoc>

                <inventoryLocation>/u01/app/oraInventory</inventoryLocation>

                <language>all_langs</language>

                <machines>

                    <machine id="tlvx8mcompute01_id"/>

                    <machine id="tlvx8mcompute02_id"/>

                </machines>

                <patches>

                    <patch>

                        <patchNumber>25433352</patchNumber>

                    </patch>

                    <patch>

                        <patchNumber>20641213</patchNumber>

                    </patch>

                    <patch>

                        <patchNumber>21923026</patchNumber>

                    </patch>

                    <patch>

                        <patchNumber>24944847</patchNumber>

                    </patch>

                    <patch>

                        <patchNumber>25437695</patchNumber>

                    </patch>

                    <patch>

                        <patchNumber>26729494</patchNumber>

                    </patch>

                    <patch>

                        <patchNumber>28305362</patchNumber>

                    </patch>

                    <patch>

                        <patchNumber>28683167</patchNumber>

                    </patch>

                </patches>

                <basedir>/u01/app/oracle</basedir>

                <useZfs>false</useZfs>

            </databaseHome>

 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.