Installation of Oracle Data integrator

Pre-Software Preparation:

JDK Link: Link: http://pan.baidu.com/s/1qXWeP4K Password: 2CZN

Sqldeveloper Link: Link: http://pan.baidu.com/s/1bpHS2sv Password: v5eg

Oracle Data Integrator (ODI) Link: http://pan.baidu.com/s/1skNVtFn Password: Q5CF

ODI needs to create a database account and a work bank account, where Oracle is used as an example.

Enter Oraclewith system users.

1. Query User space

SELECT * from Dba_data_files;

Create a user table space

Create Tablespace ODI

Logging

--datafile '/opt/oracle/oradata/orcl/odi.dbf ' size 1024m autoextend on next 50m maxsize

DataFile ' E:\oracle\product\10.2.0\oradata\ODI.dbf ' size 1024m autoextend on next 50m maxsize

Unlimited

Extent management Local;

Create an Account

-- Create a database

Create User Ly_odi_zlk

Identified by Ly_odi_zlk

Default Tablespace ODI

Temporary Tablespace Temp

Quota Unlimited on ODI;

- Empowering the database

Grant Connect,resource,

Create any table,drop any table,

Create Sequence,drop any sequence,

Create any directory,

Create any view,drop any view,imp_full_database,exp_full_database to ly_odi_zlk;

-- Create a working library

Create User Ly_odi_gzk

Identified by LY_ODI_GZK

Default Tablespace ODI

Temporary Tablespace Temp

Quota Unlimited on ODI;

- Empowering the work bank

Grant Connect,resource,

Create any table,drop any table,

Create Sequence,drop any sequence,

Create any directory,

Create any view,drop any view,imp_full_database,exp_full_database to LY_ODI_GZK;

Note: There is no special request for permission to the right side as far as possible to avoid unnecessary trouble later.

Installation of Oracle Data integrator