Oracle Warehouse BuilderThis is a featured page


Welcome!

Please add new Wiki pages and other links of interest to the list of links below.


Installation Tips and Tricks

Usage Survey
Do you want to give your 5cents on what is important in OWB or what you want next? Fill out the survey now and let your voice be heard!
Go to the blog (here) and fill out the survey. Make sure you send it using the email send option.

Other OWB Web Resources



Recent Activity on other OWB Web Sites




No user avatar
erictabich 		Latest page update: made by erictabich , Jul 8 2009, 4:00 AM EDT (about this update About This Update erictabich Edited by erictabich


view changes
- complete history)
Keyword tags: audit data data governance data quality ELT ETL governance integrator knowledge module Oracle Warehouse Builder OWB
More Info: links to this page

Threads for this page

Started By Thread Subject Replies Last Post
htu Purge audit records in OWB at ease 3 Aug 13 2009, 9:54 AM EDT by htu
Thread started: Jul 30 2009, 9:09 AM EDT  Watch

We have fount out that the accumulated audit records in the OWB could impact the performance, especially taking long time for users starting the control center. Oracle provide a script template purge_audit_template.sql under %OWB_HOME%\owb\rtp\sql for you to purge audit records:

@purge_audit_template.sql rt_owner {DEPLOYMENT | EXECUTION} {sql_predicate | ALL | DATE_RANGE} [start_date end_date]
where
rt_owner := e.g. MY_RUNTIME - Name of the Runtime Repository Owner
audit_type :- DEPLOYMENT - Deployment Audit Data
| EXECUTION - Execution Audit Data
sql_predicate :- e.g. "number_script_run_errors > 0" - Selection Criteria e.g. deployment errors
| ALL - Purge all deployment or execution audit data
| DATE_RANGE - Purge audit data within given Date Range
start_date :- e.g. TO_DATE('01-Jan-2003') - Start of Date Range
end_date :- e.g. SYSDATE - End of Date Range

You have to run it through SQLPlus and need to specify date range if you do not want to purge all the records. How about if you just want to keep 120 days of audit records and want to run it every night? I have developed a stored procedure owb_purge_audit based on the template, which will allow you just to do that. See the attachment for the code.

Thanks,

Hanming
Do you find this valuable?    
Keyword tags: OWB purge audit record stored procedure
Show Last Reply
htu Major Steps for installing OWB 10gR2 & workflow in Window environment 0 Jul 30 2009, 8:43 AM EDT by htu
Thread started: Jul 30 2009, 8:43 AM EDT  Watch
I have not got chance to install OWB 11gR1. I'd like to share the major steps for installing OWB 10gR2. Is there any difference when installing 11gR1? I have all the detailed steps and screen shots. Just have not figured out how to include picture in the posts.

1. Preparation for installation
1) Check and install a loopback adapter if necessary
2) Use a domain account if needed

2. Install Oracle database
1) Install the database server 10.2.0.1 and create a start database
2) Upgrade database server to 10.2.0.3
3) Upgrade the starter database from 10.2.0.1 to 10.2.0.3

3. Install Oracle warehouse builder
1) Install OWB 10.2.0.1
2) Patch OWB to 10.2.0.2
3) Install DST patch

4. Create an OWB repository
1) Create tablespaces to be used for repository, snapshot, index, etc.
2) Run Start->Programs->Oracle OWB Home->Warehouse Builder->Administration->
Repository Assistant
3) Follow instructions to create repository owner and OWB users

5. Install Workflow

1) Backup the database
2) Add tablespace for workflow manager
3) Shutdown the instance
4) Install workflow server from Oracle companion CD in DB home folder
5) Start Oracle instance
6) Create workflow repository - OWF_MGR
7) Install workflow middle tier from Oracle companion CD
8) Install workspace manager patch 10.2.0.4
9) Edit the workflow setup if needed
10) Start workflow manager and service
11) Check workflow manager http://{your-host}:6061/WFMGRWebApp/uix/
12) Add OWF_MGR to owb repository as a location
Do you find this valuable?    
Keyword tags: installation guide OWB workflow
david.jenkinson Versions of Warehouse Builder at 11.1.0.x 5 Jul 28 2009, 1:26 PM EDT by jon.bridenbaugh
Thread started: Jun 18 2009, 12:33 PM EDT  Watch
I installed what I thought was the latest version of Oracle Warehouse Builder (11.1.0.6) but I can't connect to my data warehouse which is 11.1.0.7. I get the following error: "API5036: Client Version 11.1.0.6.0 is not compatible with repository version 11.1.0.7.0". This seems crazy!! Is there a workaround or a patch to OWB to make it version 11.1.0.7? Googling seems to suggest that 11.1.0.7 is available but I can't find a patchset for it (for OWB).

Help please.

Thanks
Dave Jenkinson
Do you find this valuable?    
Keyword tags: None
Show Last Reply
Showing 3 of 6 threads for this page - view all

Attachments

Unknown File sp_get_pm.sql (Unknown File - 5k)
posted by htu   Dec 3 2007, 4:04 PM EST
Stored procedure for tracing back dangling objects to t heir corresponding projects and modules.
Unknown File owb_exp_prjs.tcl (Unknown File - 13k)
posted by htu   Nov 21 2007, 12:08 PM EST
This OMB+ script was from OWB beta and modified so that the exports will be saved in a separate folder for each run.
Unknown File run_ombplus (Unknown File - 6k)
posted by htu   Nov 21 2007, 12:03 PM EST
OK, here it is the whole script. Sorry for the code chunks.
Compressed Archive OWB Impact Analysis Expert Oracle Wiki.zip (Compressed Archive - 208k)
posted by anthonychow   Nov 21 2007, 10:45 AM EST
Expert: Source-to-Target Impact Analysis

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Purge audit records in OWB at ease more books Major Steps for installing OWB 10gR2 & workflow in Window environment
Export all OWB projects with a batch job Data Pump.....and Compression? Oracle SOA Architect Forum- 2 Abril 09- Madrid
Deploying tables in an OWB Expert Expert: Source-to-Target Impact Analysis SCD Type2 Accelerator for Table Operator
OWB Export Projects Utility Desmistifying SOA OWB Installation Considerations