Check the existence of public synonyms Remove the public synonyms
来源:互联网 发布:淘宝象印官方旗舰店 编辑:程序博客网 时间:2024/04/23 19:35
在安装12c Cloud Control时遭遇Check the existence of public synonyms, Remove the public synonyms错误,由于之前安装过一次,可能没删除干净
但是不知道public synonym名称是什么,上mos上查查,终于找到了一篇文章,解决方法如下:
1.删除资料库用户:
drop user SYSMAN cascade;
drop user SYSMAN_MDS cascade;
drop user MGMT_VIEW cascade;
drop user SYSMAN_RO cascade;
drop user SYSMAN_OPSS cascade;
drop user SYSMAN_APM cascade;
drop user SYSMAN_BIP;
drop user CLOUD_SWLIB_USER cascade;
drop user CLOUD_ENGINE_USER cascade;
drop role MGMT_USER;
2.删除同义词:
select 'drop '|| decode(owner,'PUBLIC',owner||' synonym '||synonym_name, ' synonym '||owner||'.'||synonym_name) ||';' from dba_synonyms where table_owner in ('SYSMAN', 'SYSMAN_MDS', 'MGMT_VIEW', 'SYSMAN_BIPLATFORM', 'SYSMAN_APM', 'SYSMAN_OPSS', 'SYSMAN_RO') ;
删除之后用如下语句查询一下:
SQL> select owner,synonym_name from dba_synonyms where table_owner in ('SYSMAN', 'SYSMAN_MDS','MGMT_VIEW','SYSMAN_BIP','SYSMAN_APM','SYSMAN_OPSS','SYSMAN_RO') ;
3.删除表空间;
select 'drop tablespace '||tablespace_name||' including contents and datafiles;' from dba_tablespaces where tablespace_name like 'MGMT%';
4.删除对象:
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Metadata Services';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Authorization Policy Manager';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Oracle Platform Security Services';
commit;
执行以上步骤之后,安装顺利完成!
但是不知道public synonym名称是什么,上mos上查查,终于找到了一篇文章,解决方法如下:
1.删除资料库用户:
drop user SYSMAN cascade;
drop user SYSMAN_MDS cascade;
drop user MGMT_VIEW cascade;
drop user SYSMAN_RO cascade;
drop user SYSMAN_OPSS cascade;
drop user SYSMAN_APM cascade;
drop user SYSMAN_BIP;
drop user CLOUD_SWLIB_USER cascade;
drop user CLOUD_ENGINE_USER cascade;
drop role MGMT_USER;
2.删除同义词:
select 'drop '|| decode(owner,'PUBLIC',owner||' synonym '||synonym_name, ' synonym '||owner||'.'||synonym_name) ||';' from dba_synonyms where table_owner in ('SYSMAN', 'SYSMAN_MDS', 'MGMT_VIEW', 'SYSMAN_BIPLATFORM', 'SYSMAN_APM', 'SYSMAN_OPSS', 'SYSMAN_RO') ;
删除之后用如下语句查询一下:
SQL> select owner,synonym_name from dba_synonyms where table_owner in ('SYSMAN', 'SYSMAN_MDS','MGMT_VIEW','SYSMAN_BIP','SYSMAN_APM','SYSMAN_OPSS','SYSMAN_RO') ;
3.删除表空间;
select 'drop tablespace '||tablespace_name||' including contents and datafiles;' from dba_tablespaces where tablespace_name like 'MGMT%';
4.删除对象:
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Metadata Services';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Authorization Policy Manager';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Oracle Platform Security Services';
commit;
执行以上步骤之后,安装顺利完成!
0 0
- Check the existence of public synonyms Remove the public synonyms
- Check the existence of public synonyms Remove the public synonyms
- synonyms
- SYNONYMS
- synonyms
- The way to create oracle synonyms
- How to get the useful synonyms
- The ability of public speaking
- How to check the external public IP in linux
- Verify the existence of the above class
- 10 Misunderstandings of the Public toward links of london
- ORA-01775: looping chain of synonyms
- Overview of Synonyms【每日一译】--20121208
- ORA-01775: looping chain of synonyms
- my synonyms
- Synonyms 同义词
- Oracle synonyms
- The Art of Public Speaking——读后感
- C语言 求一个数列的前n项之和,保留两位小数。
- win7下安装/卸载VirtualBox时出错
- MFC下ADO访问ACCESS插入日期
- cocos2d-x核心概念(四)——动作,动画
- mac升级到10.11.3后CocoaPods不可用的解决办法
- Check the existence of public synonyms Remove the public synonyms
- centos6 postfix配置
- P站来的福利(第三波)
- 关于在头文件中定义变量
- 【Android开发小记--5】动画--两张图片轮回翻转
- 今日的第一个博客
- 数据结构基础之链表
- 求能覆盖到所有点的最少集合情况(超时题,须优化)
- HDU 4518 解题报告