欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

OracleWarehouseBuilder(OWB)安装报seedingowbsys错误的解决

程序员文章站 2022-10-29 15:26:27
今天在rhel6.4上安装oracle warehouse builder 11.2时在最后一步报错,打开日志查看有如下信息: main.taskscheduler timer[...

今天在rhel6.4上安装oracle warehouse builder 11.2时在最后一步报错,打开日志查看有如下信息:

main.taskscheduler timer[5]20140529@12:27:55.055: 00> oracle.wh.ui.install.assistant.wizards.assistantwizarddefinition.display(assistantwizarddefinition.java:1476): [executeowbreposorruntime]:error occurred during seeding owbsys. exception =java.lang.exception: exception occured in 'processloadjavatoken'. oracle.ide.exitnotallowedexception

google了几篇文章,最后这篇的正文加上后面的讨论解决了这个问题:https://www.rittmanmead.com/2009/10/owb-11gr2-workspace-creation-issues/

整理记录如下:

1.clean out the owbsys user and then try to “seed” it manually, which simply means creating the required objects in the schema for supporting new workspaces.:

cd $oracle_home/owb/unifiedrepos

sqlplus / as sysdba;

@clean_owbsys

@cat_owb (这里提示输入tablespace,我选了users)

@reset_owbcc_home (这里提示输入home,我指定了oracle_home的绝对路径给它)

2.unlockowbsys

alter user owbsys account unlock;

alter user owbsys identified by owbsys;

3.不要使用"$oracle_home/owb/bin/unix/owbclient.sh",而是使用"$oracle_home/owb/bin/unix/reposinst.sh"来创建workspace;