刚在redhat5.4上安装好oracle11.2 rac,但从客户端(服务器没问题)连接报没有监听,DNS已经配置好的,有二个问题请教一下:1、为什么只监听上只有一个实例?
2、就算一个实例,我直接配tns连接scan ip或二个主机的vip也是应该能连的吧?为什么一样报没有监听?
CEP_DB_01-> lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-MAR-2013 09:22:54
Copyright (c) 1991, 2009, Oracle.All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias
LISTENER
Version
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date
26-MAR-2013 17:40:41
Uptime
0 days 15 hr. 42 min. 13 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/CEP_DB_01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.212.51.29)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.212.51.51)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "streams" has 1 instance(s).
Instance "streams1", status READY, has 1 handler(s) for this service...
Service "streamsXDB" has 1 instance(s).
Instance "streams1", status READY, has 1 handler(s) for this service...
The command completed successfully
CEP_DB_01-> cat /u01/app/11.2.0/grid/network/admin/listener.ora
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))
# line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))
# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON
# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON
# line added by Agent
CEP_DB_01->
SQL> show parameterremote_listener
NAME
TYPE
VALUE
------------------------------------ --------------------------------- ------------------------------
remote_listener
string
scan-cluster:1521
SQL>
CEP_DB_01-> srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node cep_db_01
CEP_DB_01-> srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node cep_db_01
CEP_DB_01->
TNS:
streams-scan =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.212.51.53)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = streams)
)
)
CEP_DB_01-> cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost
10.212.51.29CEP_DB_01 loghost
10.212.51.30CEP_DB_02
10.212.51.51CEP_DB_01-vip
10.212.51.52CEP_DB_02-vip
192.168.20.11 CEP_DB_01-priv
192.168.20.12 CEP_DB_02-priv
10.212.51.53scan-cluster
CEP_DB_01->
|