安装与配置Oracle Warehouse Builder 11.2.0.3(2)

二、安装服务器端(Linux)

数据库版本为11.2.0.4.0,所以服务器端不用安装OWB,只需将两个用户解锁即可

SQL> conn / as sysdba

Connected.

SQL> alter user owbsys identified by owbsys account unlock;

User altered.

SQL> alter user owbsys_audit identified by owbsys_audit account unlock;

User altered.

三、在Repository中创建第一个工作区(在数据库端)

[Oracle@localhost ~]$ cd $ORACLE_HOME/owb/bin/unix/

[oracle@localhost unix]$ ./reposinst.sh

安装与配置Oracle Warehouse Builder 11.2.0.3

点击Next

安装与配置Oracle Warehouse Builder 11.2.0.3

输入数据库的连接信息,点击Next

安装与配置Oracle Warehouse Builder 11.2.0.3

选择Manage Warehouse Builder workspace,点击Next

安装与配置Oracle Warehouse Builder 11.2.0.3

选择Create a new Warehouse Builder workspace, 点击Next

安装与配置Oracle Warehouse Builder 11.2.0.3

选择使用新用户创建工作区,点击Next

安装与配置Oracle Warehouse Builder 11.2.0.3

输入system用户的密码,点击Next

安装与配置Oracle Warehouse Builder 11.2.0.3

点击Next

安装与配置Oracle Warehouse Builder 11.2.0.3

为workspace创建一个数据库用户,指定工作区的名称。点击Next

安装与配置Oracle Warehouse Builder 11.2.0.3

输入Repository用户的密码,点击Next。

linux

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/9baeea9d4e971dac01b2be8e602b0696.html