Home > Database > Mysql Tutorial > 重装Oracle 11g EM控制台

重装Oracle 11g EM控制台

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 17:08:58
Original
1084 people have browsed it

1,修改DBSNMP密码: 重新配置DBCONSOLE,需要输入DBSNMP密码,但任何密码都会显示错误,需要预先修改。 sqlgt;alter user db

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;

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继续 

完成。

以上是常见的。但是自己试了下,会出现如下问题:

1.输入dbsnmp,sysman密码的时候光标闪烁,乱飘。不知道原因,,但是强行输入,可以继续。

2.会报错,查看日志,说是有一个对象 public synonym mgmt_availblity 已存在关联。 重新执行以上语句,加上drop此对象的语句即可。

linux

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template