rac环境中emca创建的问题
环境如下:主机名 IP地址 操作系统版本 数据库版本
rac01eth0: 192.168.37.101/eth1: 10.4.16.101 linux5.6-32bit 11gR2
rac02eth0: 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串。
$ 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: 监听程序当前无法识别连接描述符中请求的服务
然后我手工在命令行试了一下:
$ 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串名或是其他指定的信息。请问是不是哪里还要设置一下 解决了。结束。 陈勇辉 发表于 2017-12-5 17:20
解决了。结束。
建议用grid control或cloud control管理
页:
[1]