- 论坛徽章:
- 0
|
环境:
软件:RHEL7.6+Oracle 11.2.0.4.0+Grid+ASM+Rac
硬件:HPGEN10 2台+共享存储
--rac1:/etc/hosts
127.0.0.1 rac1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 rac1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.10.32 rac1
#public
192.168.10.32 rac1 rac1.localdomain
192.168.10.33 rac2 rac2.localdomain
#private
192.108.10.1 rac1-priv rac1-priv.localdomain
192.108.10.2 rac2-priv rac2-priv.localdomain
#virtual
192.168.10.132 rac1-vip rac1-vip.localdomain
192.168.10.133 rac2-vip rac2-vip.localdomain
#scan
192.168.10.130 rac-cluster rac-cluster-scan
--rac2:/etc/hosts
127.0.0.1 rac1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 rac1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.10.33 rac2
#public
192.168.10.32 rac1 rac1.localdomain
192.168.10.33 rac2 rac2.localdomain
#private
192.108.10.1 rac1-priv rac1-priv.localdomain
192.108.10.2 rac2-priv rac2-priv.localdomain
#virtual
192.168.10.132 rac1-vip rac1-vip.localdomain
192.168.10.133 rac2-vip rac2-vip.localdomain
#scan
192.168.10.130 rac-cluster rac-cluster-scan
--rac1机:
[grid@rac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1
ora.cvu
1 ONLINE ONLINE rac1
ora.oc4j
1 ONLINE ONLINE rac1
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac1
[grid@rac1 ~]$
--rac2机:
[grid@rac2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1
ora.cvu
1 ONLINE ONLINE rac1
ora.oc4j
1 ONLINE ONLINE rac1
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac1
[grid@rac2 ~]$
侦听文件检查
--rac1
[grid@rac1 admin]$ more endpoints_listener.ora
LISTENER_RAC1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)(IP=FIRST))
)) # line added by Agent
[grid@rac1 admin]$ more listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
[grid@rac1 admin]$
--rac2
[grid@rac2 admin]$ more endpoints_listener.ora
LISTENER_RAC2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.33)(PORT=1521)(IP=FIR
ST)))) # line added by Agent
[grid@rac2 admin]$ more listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
[grid@rac2 admin]$
lsnrctl status listener_scan1检查
--rac1
[grid@rac1 admin]$ lsnrctl status listener_scan1
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 23-APR-2020 12:54:39
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 22-APR-2020 23:54:12
Uptime 0 days 13 hr. 0 min. 27 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/11.2.0/grid/log/diag/tnslsnr/rac1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.130)(PORT=1521)))
Services Summary...
Service "asp" has 2 instance(s).
Instance "asp1", status READY, has 1 handler(s) for this service...
Instance "asp2", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@rac1 admin]$
--rac2
[grid@rac2 admin]$ lsnrctl status LISTENER_SCAN1
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 23-APR-2020 11:15:27
Copyright (c) 1991, 2013, Oracle. All rights reserved.
TNS-01101: Could not find service name LISTENER_SCAN1
[grid@rac2 admin]$
------------------------------------分割线---------------------------------------------------
其它同网段:192.168.10.x的win机器上的PL/SQL可以通过:192.168.10.130 rac-cluster rac-cluster-scan ,1521端口访问
我的问题是:
1,为何rac2机运行: lsnrctl status LISTENER_SCAN1会提示TNS-01101
2,rac1机grid用户的endpoints_listener.ora文件中的ip127.0.0.1,如何修改为其publicIP:192.168.10.32
个人情况坦白:首次安装RAC,以前都是单节点或HA方式的,故请大家当我是小白,谢谢。
|
|