没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
Oracle® Warehouse Builder
Installation and Configuration Guide
10
g
Release 1 (10.1)
Part No. B12150-01
April 2004
Oracle Warehouse Builder Installation and Configuration Guide, 10g Release 1 (10.1)
Part No. B12150-01
Copyright © 2004 Oracle. All rights reserved.
Primary Author: Julia M. Stein
Contributors: Srinivasa Ganti, Adrian Scott, Ron Gonzalez, Dick Whittington, Geoff Watters, Edwin
Meijer, Yu Gong, Mark Van De Wiel, John Potter, Barry Cook, Mark Rovers, Elina Sternik, Adrian Scott, Anil
Menon, Bojana Simova, Julie Curdo
The Programs (which include both the software and documentation) contain proprietary information; they
are provided under a license agreement containing restrictions on use and disclosure and are also protected
by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly,
or decompilation of the Programs, except to the extent required to obtain interoperability with other
independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems in
the documentation, please report them to us in writing. This document is not warranted to be error-free.
Except as may be expressly permitted in your license agreement for these Programs, no part of these
Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any
purpose.
If the Programs are delivered to the United States Government or anyone licensing or using the Programs
on behalf of the United States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data
delivered to U.S. Government customers are "commercial computer software" or "commercial technical
data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental
regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including
documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable
Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19,
Commercial Computer Software--Restricted Rights (June 1987). Oracle Corporation, 500 Oracle Parkway,
Redwood City, CA 94065
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently
dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,
redundancy and other measures to ensure the safe use of such applications if the Programs are used for such
purposes, and we disclaim liability for any damages caused by such use of the Programs.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks
of their respective owners.
The Programs may provide links to Web sites and access to content, products, and services from third
parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites.
You bear all risks associated with the use of such content. If you choose to purchase any products or services
from a third party, the relationship is directly between you and the third party. Oracle is not responsible for:
(a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the
third party, including delivery of products or services and warranty obligations related to purchased
products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from
dealing with any third party.
iii
Contents
Send Us Your Comments ....................................................................................................................... vii
Preface ................................................................................................................................................................. ix
Purpose ......................................................................................................................................................... ix
Audience....................................................................................................................................................... ix
How This Guide Is Organized................................................................................................................... x
Documentation Accessibility..................................................................................................................... x
New in 10g Release 1 (10.1)........................................................................................................................ xi
Conventions ............................................................................................................................................... xiii
Related Publications.................................................................................................................................. xiv
Contacting Oracle...................................................................................................................................... xiv
1 Warehouse Builder Installation Requirements
1.1 Quick Steps for Installing Warehouse Builder ....................................................................... 1-1
1.2 Hardware Requirements............................................................................................................ 1-2
1.3 Software Requirements.............................................................................................................. 1-3
1.3.1 Operating System Information .......................................................................................... 1-3
1.3.1.1 Supported Operating System Platforms ................................................................... 1-3
1.3.1.2 UNIX Operating Systems ............................................................................................ 1-3
1.3.1.3 Microsoft Windows Operating Systems ................................................................... 1-3
1.3.2 Required Products ............................................................................................................... 1-3
1.3.2.1 Oracle Database (Required) ........................................................................................ 1-5
1.3.2.2 Oracle Warehouse Builder 10g Release 1 (10.1) Software (Required)................... 1-5
1.3.2.3 Oracle Application Server (Optional)........................................................................ 1-6
1.3.2.4 Oracle Enterprise Manager and Oracle Workflow (Optional)............................... 1-6
1.3.2.5 Name and Address Adapter and Data Libraries (Optional).................................. 1-6
1.4 Coexistence: ORACLE_HOME Considerations ..................................................................... 1-7
1.5 Pre-Installation Checklist........................................................................................................... 1-8
1.6 About Oracle Universal Installer.............................................................................................. 1-8
1.6.1 Inventory Directory............................................................................................................. 1-8
1.6.2 Starting Oracle Universal Installer.................................................................................... 1-9
1.6.2.1 For Windows Users...................................................................................................... 1-9
1.6.2.2 For UNIX Users............................................................................................................. 1-9
1.6.2.3 Running Oracle Universal Installer ........................................................................... 1-9
iv
2 Installing Warehouse Builder
2.1 Overview of Warehouse Builder Architecture and Components........................................ 2-1
2.1.1 Warehouse Builder Product Architecture........................................................................ 2-1
2.1.2 Typical Installation Scenarios ............................................................................................ 2-3
2.1.2.1 Microsoft Windows Server and Optional Clients.................................................... 2-3
2.1.2.2 Consultant Profile......................................................................................................... 2-4
2.1.2.3 UNIX Server and Microsoft Windows Clients......................................................... 2-5
2.1.3 Components Installed by Oracle Universal Installer ..................................................... 2-6
2.1.4 Before You Begin, You Need Access to a SYSDBA User ............................................... 2-8
2.2 Install Warehouse Builder on the Target Schema Host......................................................... 2-9
2.3 Install the Design Repository Using the Repository Assistant ............................................ 2-9
2.4 Install Runtime Objects Using the Runtime Assistant ....................................................... 2-12
2.4.1 Installing a Runtime Repository and Runtime Access User....................................... 2-12
2.4.2 Installing a Warehouse Builder Target Schema ........................................................... 2-15
2.5 Configure the Design and Runtime Audit Browser Environments ................................. 2-17
2.5.1 Enable the Client Version of the Design Browser........................................................ 2-17
2.5.1.1 For Oracle9i Release 2 (9.2.x) or Oracle8i Release 3 (8.1.7.4.x)............................ 2-18
2.5.1.2 For Oracle Database 10g Release 1 (10.1) ............................................................... 2-18
2.5.1.3 Before Starting the Client Version of the Design Browser .................................. 2-21
2.5.2 Configure Web Browser Settings on Each Computer that Will Run the Warehouse
Builder Browsers 2-21
2.5.2.1 Add "LOCALHOST" to Your Web Browser Proxy Server Bypass List............. 2-21
2.5.2.2 Configure the Cache Management in Your Web Browser .................................. 2-21
2.5.2.3 Configure Warehouse Builder with a Net Service Name.................................... 2-22
2.5.2.4 Start the Client Versions of the Design and Runtime Audit Browsers.............. 2-23
2.5.3 (Optional) Integrate the Warehouse Builder Browsers into Oracle Application Server..
2-23
2.5.3.1 Why Integrate the Design and Runtime Audit Browsers with Application Server? .
2-23
2.5.3.2 Install the Browsers into Oracle Application Server with the Browser Assistant ......
2-24
2.5.3.3 Configure Warehouse Builder Design Browser.................................................... 2-26
2.5.3.4 Configure the Warehouse Builder Runtime Audit Browser............................... 2-27
2.5.3.5 Start the Application Server Versions of the Design and Runtime Audit Browsers..
2-33
2.6 (Optional) Install Third-Party Name and Address Data ................................................... 2-33
3 Upgrading to 10
g
Release 1 (10.1) and Migrating Data
3.1 Installing Warehouse Builder in a Separate ORACLE_HOME............................................ 3-2
3.2 Upgrading or Migrating Your Oracle Database Environment ............................................ 3-2
3.2.1 Full Database Export/Import if Moving to a New Database Instance........................ 3-3
3.2.2 Database Migration Utility if Keeping the Same Database Instance............................ 3-3
3.2.3 Partial Database Export/Import for a Selective Migration ........................................... 3-3
3.2.3.1 Migrating Design Metadata with Partial Database Export .................................... 3-4
3.2.3.2 Migrating the Runtime Environment ........................................................................ 3-5
3.3 Upgrading Design Metadata..................................................................................................... 3-8
3.3.1 Upgrading Design Metadata from Warehouse Builder 9.0.3.x or Earlier ................... 3-8
v
3.3.1.1 Exporting Design Metadata from a Prior Release of Warehouse Builder............ 3-8
3.3.1.2 Creating a New Warehouse Builder 10g Release 1 (10.1) Design Repository ..... 3-8
3.3.1.3 Importing Design Metadata to Warehouse Builder 10g Release 1 (10.1) ............. 3-9
3.3.2 Upgrading Design Metadata from Warehouse Builder 9.0.4.x or 9.2.x....................... 3-9
3.3.2.1 Automatic Upgrade Script for Warehouse Builder Design Metadata............... 3-10
3.4 Upgrading Runtime Data ....................................................................................................... 3-10
3.4.1 Upgrading Runtime Data from Warehouse Builder 9.0.3.x or Earlier...................... 3-11
3.4.1.1 Option 1. Regenerate Database Objects Using the Warehouse Builder Interface.......
3-11
3.4.1.2 Option 2. Export and Import Database Objects in the Oracle Database Server 3-12
3.4.1.3 Option 3. Create Synonyms for Original Objects in the New Target Schema.. 3-12
3.4.2 Upgrading Runtime Data from Warehouse Builder 9.0.4.x or 9.2.x ......................... 3-13
3.4.2.1 Upgrading Audit Data from Warehouse Builder 9.0.4.x or 9.2.x....................... 3-13
3.4.2.2 Copying Flat Files and External Directories to Your New Database Instance . 3-14
3.5 Deploying Your Mappings to the New Target Schemas ................................................... 3-15
3.6 Updating Mapping Configuration to Benefit from New Features................................... 3-15
3.7 Optional: Deinstalling the Old Version of Warehouse Builder ........................................ 3-16
4 Deinstalling Warehouse Builder Components
4.1 Step 1. Deinstall Design and Runtime Audit Browsers from Oracle Application Server 4-1
4.2 Step 2. Deinstall Warehouse Builder Target Schema Objects............................................... 4-2
4.3 Step 3. Deinstall Warehouse Builder Runtime Repository Objects ..................................... 4-2
4.4 Step 4. Deinstall Warehouse Builder Design Repository Objects........................................ 4-3
4.5 Step 5. Deinstall Oracle Warehouse Builder or Remaining Oracle Software..................... 4-3
A Preparing an Oracle Database
A.1 Parameters for the Design Repository Database Instance ................................................... A-1
A.2 Parameters for the Runtime Repository Database Instance ................................................ A-2
A.2.1 Configuring the Target Data File Path for Flat File Targets ......................................... A-5
A.3 Parameters for the Oracle Application Server Database (Optional) .................................. A-5
B Mounting CD-ROMs
B.1 Mounting CD-ROMs on AIX.................................................................................................... B-1
B.2 Mounting CD-ROMs on HP-UX.............................................................................................. B-1
B.3 Mounting CD-ROMs on Linux ................................................................................................ B-2
B.4 Mounting CD-ROMs on Solaris............................................................................................... B-3
B.5 Mounting CD-ROMs on Tru64 UNIX..................................................................................... B-4
C Installing Oracle Enterprise Manager and Oracle Workflow
C.1 Configuring Oracle Enterprise Manager................................................................................ C-1
C.1.1 Creating the Enterprise Manager Repository................................................................. C-1
C.1.2 Creating a Windows User ................................................................................................. C-2
C.1.3 Configuring Preferred Credentials .................................................................................. C-3
C.1.4 Configuring Enterprise Manager for the Oracle Developer Suite............................... C-4
C.2 Installing Oracle Workflow ...................................................................................................... C-5
剩余125页未读,继续阅读
资源评论
- tangjing864202012-08-21全英文的 好像是软件的说明文档
wangrui70
- 粉丝: 1
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功