rac环境中emca创建的问题

陈勇辉

环境如下：
主机名    IP地址                                    操作系统版本       数据库版本
rac01  eth0: 192.168.37.101/eth1: 10.4.16.101      linux5.6-32bit      11gR2
rac02  eth0: 192.168.37.102/eth1: 10.4.16.102      linux5.6-32bit      11gR2

2个主机的/etc/hosts:
# public ip
192.168.37.101   rac01
192.168.37.102   rac02

# virtual ip
192.168.37.103   rac01-vip
192.168.37.104   rac02-vip

# private ip
10.4.16.101      rac01-pvt
10.4.16.102      rac02-pvt

# scan vip
192.168.37.220   rac-cluster-scan

2个主机的tns：
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
/u01/app/11.2.0/grid/network/admin/tnsnames.ora

都是：
orcl =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-cluster-scan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
  
rac01: lsnrctl status如下：
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully

rac02的lsnrctl status

Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully

问题来了：
1. emca创建时提示tns问题, 但是在emca过程中又没有地方可以设置tns串。
[oracle@rac01 ~]$ emca -config dbcontrol db -repos create -cluster

EMCA 开始于 2017-12-5 11:06:05
EM Configuration Assistant, 11.2.0.3.0 正式版
版权所有 (c) 2003, 2011, Oracle。保留所有权利。

输入以下信息:
数据库的唯一名称: orcl
服务名: orcl
监听程序端口号: 1521
监听程序 ORACLE_HOME [ /u01/app/11.2.0/grid ]:
SYS 用户的口令:  
DBSNMP 用户的口令:  
SYSMAN 用户的口令:  
集群名称: rac-cluster
通知的电子邮件地址 (可选):
通知的发件 (SMTP) 服务器 (可选):
ASM ORACLE_HOME [ /u01/app/11.2.0/grid ]:
ASM 端口 [ 1521 ]: 1521
ASM 用户名 [ ASMSNMP ]: ASMSNMP
ASM 用户口令:  
2017-12-5 11:06:28 oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
警告: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

陈勇辉

日志/u01/app/oracle/diag/tnslsnr/rac01/listener_scan1/trace/listener_scan1.log
发现有如下信息显示：
05-12月-2017 11:10:04 * (CONNECT_DATA=(SERVICE_NAME=+ASM)(CID=(PROGRAM=sqlplus@rac01)(HOST=rac01)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.37.220)(PORT=47935)) * establish * +ASM * 12514
TNS-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

然后我手工在命令行试了一下：
[oracle@rac01 ~]$ sqlplus 'ASMSNMP/sys@192.168.37.220:1521/+ASM as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Tue Dec 5 11:23:30 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

也会提示一样的问题。
但是把IP改成vip或物理IP就能连接asm了，就是scan连接不了asm.

如果是这样情况emca创建em的时候又没有提示输入tns串名或是其他指定的信息。请问是不是哪里还要设置一下

陈勇辉

解决了。结束。

botang

陈勇辉 发表于 2017-12-5 17:20
解决了。结束。

建议用grid control或cloud control管理