Scribd Logo
Upload

Welcome to Scribd!

  • 627 views

    Install OWB 12c Document 1559046.1

    Uploaded by

    Anonymous Np1eI08Ce
    This document provides instructions for installing Oracle Warehouse Builder (OWB) 11g on an Oracle 12c database, which requires downloading a standalone version of OWB 11g and installing it in a new Oracle home. It describes both single-instance and multi-instance setup options, and the steps to install OWB software, apply required patches, create the OWBSYS schema, and set up a new workspace.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Install OWB 12c Document 1559046.1

    Uploaded by

    Anonymous Np1eI08Ce
    627 views3 pages
    This document provides instructions for installing Oracle Warehouse Builder (OWB) 11g on an Oracle 12c database, which requires downloading a standalone version of OWB 11g and installing it in a new Oracle home. It describes both single-instance and multi-instance setup options, and the steps to install OWB software, apply required patches, create the OWBSYS schema, and set up a new workspace.

    Original Description:

    Install OWB in 12c

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions for installing Oracle Warehouse Builder (OWB) 11g on an Oracle 12c database, which requires downloading a standalone version of OWB 11g and installing it in a new Oracle home. It describes both single-instance and multi-instance setup options, and the steps to install OWB software, apply required patches, create the OWBSYS schema, and set up a new workspace.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    627 views3 pages

    Install OWB 12c Document 1559046.1

    Uploaded by

    Anonymous Np1eI08Ce
    This document provides instructions for installing Oracle Warehouse Builder (OWB) 11g on an Oracle 12c database, which requires downloading a standalone version of OWB 11g and installing it in a new Oracle home. It describes both single-instance and multi-instance setup options, and the steps to install OWB software, apply required patches, create the OWBSYS schema, and set up a new workspace.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    HowToInstallOracleWarehouseBuilderIntoa12cDatabase(DocID1559046.

    1)
    InthisDocument
    Goal
    Solution
    References

    APPLIESTO:
    OracleWarehouseBuilderVersion11.2.0.3andlater
    Informationinthisdocumentappliestoanyplatform.

    GOAL
    ThisdocumentexplainshowtoinstallOWBonOracle12c.

    SOLUTION
    A.RequiredSoftwareandPatchLevel
    OracleRDBMS12cisnotshippedwithOWBlikethiswasthecasewithRDBMS11g.
    AseparateinstallationofOWBisrequiredintoanewOracleHome.OnWindows32/64bitandLinux32/64bitserver
    platform,thiscanbeaStandaloneOWBversion.TheseStandaloneOWBversionscanbedownloadedfromfollowingdocument:
    Document:1271208.1ListofPatchesAvailableforOWB11.2
    NotethattheStandaloneOWBsoftwareisafullreleasetobeinstalledinanewhome.
    OnallotherserverplatformstheOWBsoftwarecanbeobtainedbyinstallingafullreleaseofOracleDatabase11.2.0.3.
    OWB11.2.0.2,11.2.0.1andearlierversionsarenotsupportedwithOracle12c.
    SupportforOracle12chasbeenaddedtoOWB11.2.0.4.
    AlsoOWB11.2.0.3supportsOracle12c,butonlywhenatleastfollowingcumulativepatchinstalled:
    Patch:1397611111.2.0.3CUMULATIVEPATCH2.
    Latestcumulativepatchcanbedownloadedfromfollowingdocument:
    Document:1271208.1ListofPatchesAvailableforOWB11.2

    B.Installation
    Beforestartingtheinstallationitisgoodtodecideifmultipledatabaseinstancesorpluggabledatabaseswillbeusedasatargetby
    thesameOWB11.2home.
    MultiInstanceSetup
    WhenthegoalistohavemultipledatabasesinstancesusingthesameOWB11.2hometherearetwopossibilitieswithOracle12c.
    ClassicalmultiinstancesetupofOWB.Thisisdescribedinfollowingdocument:
    Note1291133.1OWB11gandMultipleRepositoryInstancesControlCenterFailsToStartWithORA29532
    MultiInstanceSetupusingtheThe12.1PluggableRDBMSNewFeature
    Note1532674.1HowToUseOWBWithThe12.1PluggableRDBMSFeature

    SingleInstanceSetup
    WhenthegoalistohaveasingledatabaseinstanceusingtheOWB11.2home,thefollowingstepscanbeusedtoinstallOWB.
    TheydescribetheOWB11.2.0.3softwareinstallationandcreationoftheworkspaceinasingleinstance:
    1.InstalltheOWB11.2.0.3softwareintoanewORACLE_HOME
    2.ApplythelatestcumulativepatchtotheOWB11.2.0.3home(lowestcumulativepatchsupportedispatch1397611111.2.0.3
    CUMULATIVEPATCH2)
    Latestcumulativepatchcanbedownloadedfrom:
    Document:1271208.1ListofPatchesAvailableforOWB11.2
    3.StartSQLPlusandconnectwithanaccounthavingSYSDBAprivileges.
    CreatetheOWBSYSschemawiththescript:
    SQL>@<OWB_HOME>/owb/UnifiedRepos/cat_owb.sql<tablespace><OWBSYS_password>

    Parametersareoptionalwithdefaults:
    Parameter

    DefaultValue

    Tablespace

    USERS

    Password

    OWBSYS

    4.UnlocktheOWBSYSandOWBSYS_AUDITusersandassignthemapassword:
    SQL>alteruserOWBSYSidentifiedby<owbsys_password>accountunlock

    SQL>alteruserOWBSYS_AUDITidentifiedby<owbsys_audit_password>accountunlock

    5.Runthereset_owbcc_home.sqlscripttoresettheOWB_HOMEdirectory:
    ThistoensurethattheControlCenterservicewillruncorrectlyfromtheWarehouseBuilder11.2home.
    SQL>@<OWB_HOME>/owb/UnifiedRepos/reset_owbcc_home.sql

    Notethatthisentryiscasesensitive,doesnotacceptatrailingslash,andrequiresforwardslashesonly,regardlessofthe
    operatingsystem.
    OnWindows,makesuretheDriveletterisincapital.
    Forinstance:C:/Oracle/OWB11203
    6.StarttheOWBRepositoryAssistantandcreateaworkspace:
    a.StarttheRepositoryAssistantandenterdatabaseconnectioninformation.
    b.SelectManageWarehouseBuilderWorkspaces
    c.SelectCreateanewWarehouseBuilderWorkspace
    d.SelectCreateaworkspacewithanewuserasworkspaceowner
    e.EnterUsernameandPasswordinformationofadatabaseDBA
    f.Createanewdatabaseuserasworkspaceowner.Enterthetemporaryusername,userpasswordandworkspacename.

    ThefollowingdocumentsmightbeofinterestafterhavinginstalledOWB11.2onOracle12c:
    Note1332043.1HowToCleanUpTheOWBSYSRepositoryInOWB11gAfterAnUpgradeOrInstallationFailure
    Note468965.1HowToEnableOracleWorkflowIntegrationWithOracleWarehouseBuilder11g

    Didn'tfindwhatyouarelookingfor?

    You might also like