我重新装了ORCAL数据库,但安装时提示,无法对所有EM相关帐户解锁。需要手动配置:我手动配置的步骤如下:1、删除相关资料:
emca -repos drop 成功2、再建一个:
emca -repos create 成功3、再配置em时,用如下命令
emca -config dbcontrol db无法对所有EM相关帐户解锁看了日志:
2010-1-4 11:17:16 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: 执行 CMD /C E:\app\yangdaohui\product\11.1.0\db_1\sysman\admin\scripts\emca\emcaDbUtil.bat "E:\app\yangdaohui\product\11.1.0\db_1\sysman\admin\scripts;E:\app\yangdaohui\product\11.1.0\db_1\bin;" E:/app/yangdaohui/product/11.1.0/db_1/perl/5.8.3/bin/MSWin32-x86-multi-thread\perl.exe E:\app\yangdaohui\product\11.1.0\db_1\sysman\admin\scripts\emca\emcaDbUtil.pl E:\app\yangdaohui\product\11.1.0\db_1 power SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; 1 SYSMAN_PWD 时出错
2010-1-4 11:17:16 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
配置: Failed to unlock mgmt_view account
2010-1-4 11:17:16 oracle.sysman.emcp.EMReposConfig invoke
严重: 无法对所有 EM 相关帐户解锁
2010-1-4 11:17:16 oracle.sysman.emcp.EMConfig perform
严重: 无法对所有 EM 相关帐户解锁
有关详细资料, 请参阅 E:\app\yangdaohui\cfgtoollogs\emca\power\emca_2010_01_04_11_17_01.log 中的日志文件。
2010-1-4 11:17:16 oracle.sysman.emcp.EMConfig perform
配置: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: 无法对所有 EM 相关帐户解锁
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:335)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
emca -repos drop 成功2、再建一个:
emca -repos create 成功3、再配置em时,用如下命令
emca -config dbcontrol db无法对所有EM相关帐户解锁看了日志:
2010-1-4 11:17:16 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: 执行 CMD /C E:\app\yangdaohui\product\11.1.0\db_1\sysman\admin\scripts\emca\emcaDbUtil.bat "E:\app\yangdaohui\product\11.1.0\db_1\sysman\admin\scripts;E:\app\yangdaohui\product\11.1.0\db_1\bin;" E:/app/yangdaohui/product/11.1.0/db_1/perl/5.8.3/bin/MSWin32-x86-multi-thread\perl.exe E:\app\yangdaohui\product\11.1.0\db_1\sysman\admin\scripts\emca\emcaDbUtil.pl E:\app\yangdaohui\product\11.1.0\db_1 power SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; 1 SYSMAN_PWD 时出错
2010-1-4 11:17:16 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
配置: Failed to unlock mgmt_view account
2010-1-4 11:17:16 oracle.sysman.emcp.EMReposConfig invoke
严重: 无法对所有 EM 相关帐户解锁
2010-1-4 11:17:16 oracle.sysman.emcp.EMConfig perform
严重: 无法对所有 EM 相关帐户解锁
有关详细资料, 请参阅 E:\app\yangdaohui\cfgtoollogs\emca\power\emca_2010_01_04_11_17_01.log 中的日志文件。
2010-1-4 11:17:16 oracle.sysman.emcp.EMConfig perform
配置: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: 无法对所有 EM 相关帐户解锁
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:335)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
1,修改DBSNMP密码:
重新配置DBCONSOLE,需要输入DBSNMP密码,但任何密码都会显示错误,需要预先修改。
sql>alter user dbsnmp identified by xxx;
2,删除早期DBCONSOLE创建的用户:
sql>drop role MGMT_USER;
sql>drop user MGMT_VIEW cascade;
sql>drop user sysman cascade;
3,删除早期DBCONSOLE创建的对象:
sql>drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
sql>drop public synonym SETEMVIEWUSERCONTEXT;
4,重新创建DBCONSOLE:(如果是在windows下,要先到注册表删除DBCONSOLE的服务,重启电脑)
$emca -config dbcontrol db -repos create
根据提示,先输入SID,再输入Y继续;
输入端口1521,输入SYS密码,输入DBSNMP密码,输入SYSMAN 密码,输入Y继续
完成。
按上面的步骤试试可行?------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716