原因:oracle 服务器修改ip;em访问不了;于是修改em配置资料;
emca -repos drop -----删除之前
SQL> conn /as sysdba
已连接。
SQL> conn sys/sys as sysdba
已连接。
SQL> drop user sysman cascade;
用户已删除。
SQL> drop role mgmt_user;
drop role mgmt_user
*
第 1 行出现错误:
ORA-01919: 角色 'MGMT_USER' 不存在
SQL> drop user mgmt_view cascade;
drop user mgmt_view cascade
*
第 1 行出现错误:
ORA-01918: 用户 'MGMT_VIEW' 不存在
SQL> drop public sysnonym mgmt_target_backouts;
drop public sysnonym mgmt_target_backouts
*
第 1 行出现错误:
ORA-00950: 无效 DROP 选项
SQL> drop public sysnonym mgmt_target_blackouts
drop public sysnonym mgmt_target_blackouts
*
第 1 行出现错误:
ORA-00950: 无效 DROP 选项
SQL> drop publice synonym mgmt_target_blackouts
drop publice synonym mgmt_target_blackouts
*
第 1 行出现错误:
ORA-00950: 无效 DROP 选项
SQL> drop public synonym mgmt_target_blackouts;
drop public synonym mgmt_target_blackouts
*
第 1 行出现错误:
ORA-01432: 要删除的公用同义词不存在
SQL> drop public synonym setemviewusercontext;
drop public synonym setemviewusercontext
*
第 1 行出现错误:
ORA-01432: 要删除的公用同义词不存在
SQL> exit
然后
1、emca -repos create
2、emca -config dbcontrol db