Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name

[oracle@localhost ~]$ emctl status

提示
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

 

处理方法:

$sqlplus /nolog
sql>connect sys/密码 as sysdba
sql>alter user dbsnmp identified by admin (更改dbsnmp密码为admin)
sql>drop role MGMT_USER;
sql>drop user MGMT_VIEW cascade;
SQL>drop user sysman cascade;
sql>drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
sql>drop public synonym SETEMVIEWUSERCONTEXT;
sql>drop public synonym setemviewusercontext;
exit后运行$emca -deconfig dbcontrol db -repos drop
$emca -deconfig control db -repos create

输入SID、监听端口、SYS密码和SYSMAN密码

posted @ 2013-04-02 14:45  凉风微雨  阅读(450)  评论(0编辑  收藏  举报