安装Oracle gc之异常【ERROR:SQLException null Resultset】

安装Oracle gc  11.1.0.1 时遇到以下错误：

sqlQuery = select count(*) from sysman.mgmt_versions where status > 0 and component_mode like
'CENTRAL' and component_name in ('IAS','DB','OCS','CORE')
INFO: 7/31/09 12:28:53 PM CEST: Query Returned: ERROR:SQLException null Resultset
SEVERE: 7/31/09 12:28:53 PM CEST: ERROR:SQLException null Resultset

查询数据库，发现sysman用户存在，但是表 sysman.mgmt_versions不存在。

解决办法：
可参考mos 【278100.1】

具体操作如下：

Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and management objects:


SQL> DECLARE
CURSOR c1 IS
SELECT owner, synonym_name name
FROM dba_synonyms
WHERE table_owner = 'SYSMAN';
BEGIN
FOR r1 IN c1 LOOP
IF r1.owner = 'PUBLIC' THEN
EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
ELSE
EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
END IF;
END LOOP;
END;
/
SQL> DROP USER mgmt_view CASCADE;
SQL> DROP ROLE mgmt_user;
SQL> DROP USER sysman CASCADE;

执行完以上代码后，可继续安装即可。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26247018/viewspace-1160815/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26247018/viewspace-1160815/