Scribd
Upload
636 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

Install OWB 12c Document 1559046.1

Uploaded by

Anonymous Np1eI08Ce
636 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
636 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
You are on page 1/ 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