安装与配置Oracle Warehouse Builder 11.2.0.3-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

安装与配置Oracle Warehouse Builder 11.2.0.3

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 02:55 PM

Installation and configuration

安装与配置Oracle Warehouse Builder 11.2.0.3

The OWB Client (which includes the Design Center and the Control Center Manager)

The OWB Browser

Control Center Service

Control Center Agent

The Repository

Oracle database 11g release 2 包含了owb的所有组件。

根据业务需要，OWB提供了五种拓扑安装

1.单机拓扑

2.客户端和数据库服务分离拓扑

3.多数据库拓扑

4.客户端、控制中心服务、数据库服务分离拓扑

5.控制中心代理拓扑

单机拓扑

OWB所有的组件都运行在单台计算机上。

安装与配置Oracle Warehouse Builder 11.2.0.3

客户端、服务分离拓扑（客户端推荐安装owb11.2 独立版安装版）

安装与配置Oracle Warehouse Builder 11.2.0.3

多数据库拓扑

安装与配置Oracle Warehouse Builder 11.2.0.3

Client、CCS、Server分离拓扑

安装与配置Oracle Warehouse Builder 11.2.0.3

CCA拓扑

安装与配置Oracle Warehouse Builder 11.2.0.3

本次安装配置以客户端服务端拓扑为了。

一、在windows上安装客户端。

到官网上下载安装包OWB_11.2.0.3_Windows_x86-64.zip，将其解压。如下

安装与配置Oracle Warehouse Builder 11.2.0.3

点击setup.bat批处理文件

安装与配置Oracle Warehouse Builder 11.2.0.3

点击下一步

安装与配置Oracle Warehouse Builder 11.2.0.3

选择owb的home目录及产品名称，点击下一步

安装与配置Oracle Warehouse Builder 11.2.0.3

取消“我希望通过My Oracle Support接收安全更新”的选择，点击下一步。

安装与配置Oracle Warehouse Builder 11.2.0.3

点击“是”按钮

安装与配置Oracle Warehouse Builder 11.2.0.3

点击安装按钮

安装与配置Oracle Warehouse Builder 11.2.0.3

至此，安装完毕，点击退出按钮。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AM

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AM

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AM

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

MySQL: String Data Types and ENUMs?May 13, 2025 am 12:05 AM

MySQloffersechar, Varchar, text, Anddenumforstringdata.usecharforfixed-Lengthstrings, VarcharerForvariable-Length, text forlarger text, AndenumforenforcingdataAntegritywithaetofvalues.

MySQL BLOB: how to optimize BLOBs requestsMay 13, 2025 am 12:03 AM

Optimizing MySQLBLOB requests can be done through the following strategies: 1. Reduce the frequency of BLOB query, use independent requests or delay loading; 2. Select the appropriate BLOB type (such as TINYBLOB); 3. Separate the BLOB data into separate tables; 4. Compress the BLOB data at the application layer; 5. Index the BLOB metadata. These methods can effectively improve performance by combining monitoring, caching and data sharding in actual applications.

Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AM

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AM

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AM

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.

See all articles