首页 > 代码库 > Oracle Warehouse Builder(OWB) 安装报seeding owbsys错误的解决

Oracle Warehouse Builder(OWB) 安装报seeding owbsys错误的解决

今天在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了几篇文章,最后这篇的正文加上后面的讨论解决了这个问题:http://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;