程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> OracleWarehouseBuilder(OWB)安裝報seedingowbsys錯誤的解決

OracleWarehouseBuilder(OWB)安裝報seedingowbsys錯誤的解決

編輯:Oracle教程

今天在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;

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved