数据库版本:
11.2.0.2
现象
1.使用./reposinst.sh创建workspace的时候报错如下(原图没有截图下来,在网上找了一个相同的图)
解决方案
1.因为上次重workspace的时候机器刚好重启,中途中断了,所以计划重建owbsys用户对象再重新执行创建workspace
cd /usr/local/oracle/product/11.2.0/dbhome_1/owb/UnifiedRepos
[oracle@vm29-23 UnifiedRepos]$ cd /usr/local/oracle/product/11.2.0/dbhome_1/owb/UnifiedRepos
[oracle@vm29-23 UnifiedRepos]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Wed Nov 9 11:25:25 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @clean_owbsys
User dropped.
User dropped.
Role dropped.
Role dropped.
Role dropped.
SQL> SQL>
SQL> @cat_owb
Enter Tablespace Name for OWBSYS user:
users
Package created.
Package body created.
Create user OWBSYS with default tablespace users ...
old 1: CREATE USER OWBSYS IDENTIFIED BY OWBSYS DEFAULT TABLESPACE &owbsys_tbs
new 1: CREATE USER OWBSYS IDENTIFIED BY OWBSYS DEFAULT TABLESPACE users
。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
User created.
User altered.
NOTE: To associate the Control Center with the correct OWB home, now run owb/UnifiedRepos/reset_owbcc_home.sql. You must run the script. as a user with java admin privileges. For example, connect as sys as sysdba to run the script.
SQL> SQL> SQL> SQL>
SQL> @reset_owbcc_home
Enter the full path of the Oracle home for the OWB Control Center install.
If you are installing in a Windows environment, please ensure that the case of the path exactly matches the Oracle install path including the drive letter.
OWB Control Center Home:
/usr/local/oracle/product/11.2.0/dbhome_1
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
2.重建后执行成功
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21605631/viewspace-710489/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21605631/viewspace-710489/