安装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博客 ” ,链接:https://blog.itpub.net/26247018/viewspace-1160815/
,如需转载,请注明出处,否则将追究法律责任。