数据库版本:

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.重建后执行成功