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;