Sign in or 
Location: Oracle Warehouse Builder
Page Threads
Showing 6 threads
| 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
out of
found this valuable.
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
out of
found this valuable.
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
Show Last Reply
|
||||||
| htu | Export all OWB projects with a batch job | 7 | May 27 2009, 8:06 AM EDT by skott99 | ||||
|
|
Thread started: Nov 21 2007, 11:41 AM EST
Watch
I have developed a ksh script to run an OMB+ script to export all the projects in a OWB repository. The scripts will be posted in the end.
Know limitations: - it requires single user mode to connect to the repository - it stops the export if users are still in a project
6
out of
8 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
ksh
OMB+
Oracle Warehouse Builder
OWB export
tcl
Show Last Reply
|
||||||
| anthonychow | Expert: Source-to-Target Impact Analysis | 3 | Apr 2 2009, 5:37 PM EDT by antonio.romero | ||||
|
Thread started: Nov 21 2007, 10:36 AM EST
Watch
The goal for this Expert is to locate all target tables for any given source table and output the results to a CSV. Through OMB+, I used the technique of parsing the result strings from OMBIMPACT DEPENDENCYTYPE calls.
Some assumptions used during development, which you can certainly modify: · "Project" is equivalent to projects shown as top nodes in the Project Explorer · "Study" is equivalent to Oracle databases under each project · Select to analyze multiple source tables by using the Ctrl key · Target tables have "_FINAL" as the suffix in the name Known limitations: · Patience is certainly virtuous; great results take time to produce · OMBIMPACT DEPENDENCYTYPE is unable to detect impacts against columns embedded into expressions; and the pivot and unpivot operators
3
out of
5 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
Expert
Impact Analysis
Oracle Warehouse Builder
OWB
Show Last Reply
|
||||||
| htu | OWB Installation Considerations | 6 | Nov 13 2008, 8:42 AM EST by htu | ||||
|
|
Thread started: Nov 21 2007, 11:25 AM EST
Watch
If you plan to install Oracle Warehouse Builder, Here are the things that you need to consider:
1. Choose your implementation strategy: Basic Implementation, Traditional Client/ Server Implementation or Split Repositories Implementation. 2. Choose what versions to be installed on a server and clients. Here are the products and their versions that we have installed: a. Oracle Database on the server - Oracle DB 10gR2 (10.2.0.1) - Oracle DB patch set (10.2.0.3) b.Oracle Warehouse Builder on the server and clients OWB 10.2.0.1 - OWB patch set 5696353 (10.2.0.2) - OWB one-off patch: 6270894 + Fix Stack over flow problem +Must apply on client side (readme file is not clear) and can also apply on server + Will not get fixed until OWB 10.2.0.4 (OWB 11g = 10.2.0.3) c. Repository Owner - Only one OWB repository owner in the database is recommended 3. Layout your project structure 4. Plan storage (tablespace) for projects
8
out of
13 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
Installation consideration
OWB
Show Last Reply
|
||||||
