2024年2月26日发(作者:)

ODI 11G安装

/* -----------------------------------------------------------------

Author : RUDY

Email :liu4648573@

Created : 2011-08-03

------------------------------------------------------------------ */

安装环境:

// OS : Windows 2003 SP2 R2

// RDBMS : Oracle 10.2.0.4

// RAM : 2G

// CPU : Inter I7 2630QM

// ODI 11G

一、 安装Oracle 10.2.0.4

安装Oracle 10.2.0.1 ,选择【高级安装】

一路Next,注意:数据库字符集选择【AL32UTF8】;

安装完Oracle 10.2.0.1后,停掉Oracle启动的服务,安装Oracle 10.2.0.4补丁;

安装完 Oracle 10.2.0.4 Patch后,运行以下命令:

Cmd下运行: sqlplus / as sysdba

SQL>startup upgrade

SQL>@C:oracleproduct10.2.0db_

SQL>@C:oracleproduct10.2.0db_

SQL>shutdown immediate

SQL>startup

二、 安装RCU:

Oracle 10.2.0.4到此安装完毕,重启OS。

到 RCU目录下运行

这里如果【定制变量】有默认值可以不用输入;

三、

四、

安装Weblogic Server

安装ODI

如果只是学习,可以只安装【Developer安装】项目;

设置独立代理的名称和端口;

五、配置ODI Weblogic Domain

注意:weblogic密码必须为数字和字母相结合;

五、 开启Weblogic Server

DOMAIN_

whereDOMAIN_NAME is the name of the directory in which you located the domain,

typically

MW_HOMEuser_projectsdomainsDOMAIN_NAME.

On Windows operating systems, the Configuration Wizard creates a shortcut on the

Start menu to start the Administration Server that you created (User

Projects>DOMAIN_NAME>Start Admin Server for WebLogic Domain).

七、【可选】开启独立代理

C:oracleMiddlewareLIU_ODIoraclediagentbinAgent_

八、添加安全性

C:oracleMiddlewareOracle_

connect()

createCred(map="p",key="SUPERVISOR",user="SUPERVISOR",

password="*******", desc="Key for Supervisor")

createCred(map="p", key="LIU_ODI_DOMAIN", user="weblogic",

password="*******", desc="Username and password for base_domain")

disconnect()

到此,ODI已经安装完毕,可以使用。

其他:

安装ODI DEMO 环境

To manually install the Demonstration environment, do the following:

1. Unzip in the ODI_HOME folder.

2. Verify that the JAVA_HOME environment variable is set and contains the path of a

JVM suitable for Oracle Data Integrator.

If this variable is not set correctly, set it to a valid java machine location.

For example:

On UNIX operating systems:

setenv JAVA_HOME/usr/local/java

On Windows operating systems:

Set the JAVA_HOME variable graphically

To start the demonstration environment:

1、Change directory to the ODI_HOME/oracledi/demo/bin directory.

Enter the following command:

On UNIX operating systems:

./

On Windows operating systems:

User: SUPERVISOR

Password: SUNOPSIS