本帖最后由 莫不言 于 2017-2-15 18:41 编辑
环境:
redhat5.5
oracle10g rac 10.2.0.1
配置完监听后，有个疑问，为啥节点2不能lsnrctl status.
节点1:
[oracle@rac1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-FEB-2017 18:18:40
Copyright (c) 1991, 2005, Oracle.All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias
LISTENER_RAC1
Version
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date
15-FEB-2017 18:07:04
Uptime
0 days 0 hr. 11 min. 36 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2.0/db_1/network/log/listener_rac1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.210)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@rac1 ~]$ lsnrctl status LISTENER_RAC1
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-FEB-2017 18:20:24
Copyright (c) 1991, 2005, Oracle.All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias
LISTENER_RAC1
Version
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date
15-FEB-2017 18:07:04
Uptime
0 days 0 hr. 13 min. 20 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2.0/db_1/network/log/listener_rac1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.210)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@rac1 ~]$ ps -ef |grep lis
oracle 547 276070 18:20 pts/100:00:00 grep lis
68256325550 18:04 ?00:00:00 hald-addon-acpi: listening on acpid socket /var/run/acpid.socket
68256925550 18:04 ?00:00:00 hald-addon-keyboard: listening on /dev/input/event0
68257825550 18:04 ?00:00:00 hald-addon-keyboard: listening on /dev/input/event4
root351835130 18:05 tty7 00:00:01 /usr/bin/Xorg :0 -br -audit 0 -auth /var/gdm/:0.Xauth -nolisten tcp vt7
[oracle@rac1 ~]$ ps -ef |grep LIS
oracle 674 276070 18:20 pts/100:00:00 grep LIS
oracle4922 10 18:07 ?00:00:00 /opt/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER_RAC1 -inherit
[oracle@rac1 ~]$ more /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
# listener.ora.rac1 Network Configuration File: /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora.rac1
# Generated by Oracle configuration tools.
LISTENER_RAC1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)(IP = FIRST))
)
)
SID_LIST_LISTENER_RAC1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
[oracle@rac1 ~]$ more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1
rac1 localhost.localdomain localhost
::1
localhost6.localdomain6 localhost6
#public
192.168.1.200 rac1
192.168.1.201 rac2
#private
10.10.10.200
rac1-priv
10.10.10.201
rac2-priv
#vip
192.168.1.210
rac1-vip
192.168.1.211
rac2-vip
[oracle@rac1 ~]$ more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_SID=orcl1
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs
export PATH=.:$PATH:$HOME/bin:$ORA_CRS_HOME/bin:$ORACLE_HOME/bin
umask 022
stty erase ^h
节点2：
[oracle@rac2 ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-FEB-2017 18:19:14
Copyright (c) 1991, 2005, Oracle.All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS
rotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@rac2 ~]$ lsnrctl status listener_rac2
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-FEB-2017 18:19:42
Copyright (c) 1991, 2005, Oracle.All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias
LISTENER_RAC2
Version
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date
15-FEB-2017 18:07:26
Uptime
0 days 0 hr. 12 min. 16 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2.0/db_1/network/log/listener_rac2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.211)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.201)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@rac2 ~]$ ps -ef |grep lis
oracle1131 283110 18:20 pts/100:00:00 grep lis
68256525570 18:05 ?00:00:00 hald-addon-acpi: listening on acpid socket /var/run/acpid.socket
68257125570 18:05 ?00:00:00 hald-addon-keyboard: listening on /dev/input/event0
68258025570 18:05 ?00:00:00 hald-addon-keyboard: listening on /dev/input/event4
root352335150 18:05 tty7 00:00:01 /usr/bin/Xorg :0 -br -audit 0 -auth /var/gdm/:0.Xauth -nolisten tcp vt7
[oracle@rac2 ~]$ more /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
# listener.ora.rac2 Network Configuration File: /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora.rac2
# Generated by Oracle configuration tools.
LISTENER_RAC2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.201)(PORT = 1521)(IP = FIRST))
)
)
SID_LIST_LISTENER_RAC2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
[oracle@rac2 ~]$ more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1
rac2 localhost.localdomain localhost
::1
localhost6.localdomain6 localhost6
#public
192.168.1.200 rac1
192.168.1.201 rac2
#private
10.10.10.200
rac1-priv
10.10.10.201
rac2-priv
#vip
192.168.1.210
rac1-vip
192.168.1.211
rac2-vip
[oracle@rac2 ~]$ more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_SID=orcl2
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs
export PATH=.:$PATH:$HOME/bin:$ORA_CRS_HOME/bin:$ORACLE_HOME/bin
umask 022
stty erase ^h
[oracle@rac2 ~]$ crs_stat -t -v
Name Type R/RA F/FT TargetState Host
----------------------------------------------------------------------
ora....C1.lsnr application0/50/0ONLINEONLINErac1
ora.rac1.gsd application0/50/0ONLINEONLINErac1
ora.rac1.ons application0/30/0ONLINEONLINErac1
ora.rac1.vip application0/00/0ONLINEONLINErac1
ora....C2.lsnr application0/50/0ONLINEONLINErac2
ora.rac2.gsd application0/50/0ONLINEONLINErac2
ora.rac2.ons application0/30/0ONLINEONLINErac2
ora.rac2.vip application0/00/0ONLINEONLINErac2
请问为啥节点1可以 lsnrctl status 节点2却不能lsnrctl status.
当时在节点2执行root.sh时碰到了这个错误：
Error0(Native:listNetInterfaces:[3])
[Error0(Native:listNetInterfaces:[3])]
解决如下：
===============================
[root@rac2 bin]#./oifcfg iflist
eth0192.168.1.0
eth110.10.10.0
[root@rac2 bin]#./oifcfg setif -global eth0/192.168.1.0
ublic
[root@rac2 bin]#./oifcfg setif -global eth1/10.10.10.0:cluster_interconnect
[root@rac2 bin]#./oifcfg getif
eth0 192.168.1.0 globalpublic
eth1 10.10.10.0 globalcluster_interconnect
只在节点2上执行过以上语句，节点1没有执行，不知道有没有影响。 |
