- 論壇徽章:
- 0
|
環(huán)境：
軟件：RHEL7.6+Oracle 11.2.0.4.0+Grid+ASM+Rac
硬件：HPGEN10 2臺(tái)+共享存儲(chǔ)
--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機(jī)：
[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機(jī)：
[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]$
------------------------------------分割線---------------------------------------------------
其它同網(wǎng)段：192.168.10.x的win機(jī)器上的PL/SQL可以通過：192.168.10.130 rac-cluster rac-cluster-scan ，1521端口訪問
我的問題是：
1，為何rac2機(jī)運(yùn)行： lsnrctl status LISTENER_SCAN1會(huì)提示TNS-01101
2，rac1機(jī)grid用戶的endpoints_listener.ora文件中的ip127.0.0.1,如何修改為其publicIP:192.168.10.32
個(gè)人情況坦白：首次安裝RAC，以前都是單節(jié)點(diǎn)或HA方式的，故請(qǐng)大家當(dāng)我是小白，謝謝。
|
|
免費(fèi)注冊(cè)
發(fā)表于 2020-04-23 13:01
