oracle 11g rac 下安装em出错的一些解决方法

最新推荐文章于 2023-04-14 22:53:20 发布

made-in-china

最新推荐文章于 2023-04-14 22:53:20 发布

阅读量2.9k

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle 文章标签： em

本文链接：https://blog.youkuaiyun.com/huoshuyinhua/article/details/52447991

oracle 专栏收录该内容

96 篇文章

订阅专栏

本文记录了使用EMCA工具配置Oracle RAC过程中遇到的问题及解决方法，包括账户锁定、连接失败等问题，并详细展示了如何正确设置参数完成配置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

第一次卡壳
[oracle@rac1 ~]$ emca -config dbcontrol db -repos create -cluster

STARTED EMCA at Sep 6, 2016 1:57:16 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.

Enter the following information:
Database unique name: orcl
Service name: orcl
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]:
Password for SYS user:
Password for DBSNMP user:
Sep 6, 2016 1:59:00 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-28000: the account is locked

Sep 6, 2016 1:59:06 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: ORA-28000: the account is locked

Password for SYSMAN user:
Cluster name:
---------------------------------------------------------
查询cluster name
进入/u01/app/11.2.0/grid/bin下
#./cemutlo -n
将输出结果贴上去
---------------------------------------------------------

第二次
[oracle@rac2 ~]$ emca -config dbcontrol db -repos create -cluster

STARTED EMCA at Sep 6, 2016 1:57:16 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.

Enter the following information:
Database unique name: orcl
Service name: orcl
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]:
Password for SYS user:
Password for DBSNMP user:
Sep 6, 2016 1:59:00 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-28000: the account is locked

Sep 6, 2016 1:59:06 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: ORA-28000: the account is locked

Password for SYSMAN user:
Cluster name: rac-cluster
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /u01/app/11.2.0/grid ]:
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]:
ASM user password:
Sep 6, 2016 1:59:55 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Sep 6, 2016 2:00:09 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: ORA-01017: invalid username/password; logon denied

Sep 6, 2016 2:00:10 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Sep 6, 2016 2:00:17 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: ORA-01017: invalid username/password; logon denied

Password validation failed. Some of the possible reasons may be:

1) Invalid username/password.
2) Database is not up.
3) Scan listener not up.
4) Database service is not registered with scan listener.
5) Password file may be missing or configured incorrectly.

ASM user password:
---------------------------------------------------------------
这个问题的原因是asm实例没有注册到scan_listener
grid
$sqlplus / as sysdba
show parameter remote
SQL> show parameter remote

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_listener string
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
此处remote_listener 为空
cat /etc/hosts
#public
192.168.100.118 rac1
192.168.100.119 rac2
#private
10.0.0.118 rac1-priv
10.0.0.119 rac2-priv
#vip
192.168.100.208 rac1-vip
192.168.100.209 rac2-vip
#scan
192.168.100.211 scanip ===>这里我的scan名字是scanip
alter system set remote_listener='scanip:1521' scope=both sid='*'；
---------------------------------------------------------------
第三次

^C[oracle@rac1 ~]$ emca -config dbcontrol db -repos recreate -cluster

STARTED EMCA at Sep 6, 2016 2:28:32 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.

Enter the following information:
Database unique name: orcl
Service name: orcl
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Cluster name: rac-cluster
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /u01/app/11.2.0/grid ]:
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]:
ASM user password:
Sep 6, 2016 2:29:04 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-01017: invalid username/password; logon denied

Sep 6, 2016 2:29:14 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: ORA-01017: invalid username/password; logon denied

Sep 6, 2016 2:29:17 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-01017: invalid username/password; logon denied

Sep 6, 2016 2:29:26 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: ORA-01017: invalid username/password; logon denied

Password validation failed. Some of the possible reasons may be:

1) Invalid username/password.
2) Database is not up.
3) Scan listener not up.
4) Database service is not registered with scan listener.
5) Password file may be missing or configured incorrectly.

ASM user password:
--------------------------------------------------------------
此处提示用户名密码错误
grid
$sqlplus / as sysasm
alter user asmsnmp identified by oracle;
---------------------------------------------------------------
然后就是等待吧
You have specified the following settings

Database ORACLE_HOME ................ /u02/app/oracle/product/11.2.0/db_home

Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0/grid
Listener port number ................ 1521
Cluster name ................ rac-cluster
Database unique name ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ /u01/app/11.2.0/grid
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP

-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 6, 2016 2:38:33 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u02/app/oracle/cfgtoollogs/emca/orcl/emca_2016_09_06_02_28_32.log.
Sep 6, 2016 2:38:38 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...