前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >oracle rac节点不能启动报“has a disk HB, but no network HB”的错误

oracle rac节点不能启动报“has a disk HB, but no network HB”的错误

作者头像
AiDBA宝典
发布2023-10-08 08:50:27
1.1K0
发布2023-10-08 08:50:27
举报

今天同事说有一套rac 19c的环境,不能使用了,让我帮忙看看。

这套rac环境是搭建在华为云ECS上的,操作系统为CentOS 7.6。根据经验,rac不能启动,主要是2个方面的原因:一个是共享存储,一个网络。共享存储常见原因是盘掉了,或盘坏了,或多路径软件出问题等等,而网络问题常见原因是私网网卡坏了,或节点之间网络不通(注意:修改ssh端口或修改oracle和grid密码不会影响rac的正常运行)。

很不幸,这套环境的共享和网络都有问题,下面慢慢分析。

原因一:共享盘掉了

首先,看看2个节点的共享盘是不是一致的,查看后发现节点2少了一块盘,让客户把节点2的盘重新挂载一下,

然后查看,共享盘已经一致了:

代码语言:javascript
复制
[root@oracle-rac2 ~]# ll /dev/asm*
lrwxrwxrwx 1 root root 3 Jul 30 11:09 /dev/asm-diska -> sde
lrwxrwxrwx 1 root root 3 Jul 30 11:09 /dev/asm-diskb -> sdd
lrwxrwxrwx 1 root root 3 Jul 30 11:03 /dev/asm-diskc -> sdc
lrwxrwxrwx 1 root root 3 Jul 30 11:03 /dev/asm-diskd -> sdb
lrwxrwxrwx 1 root root 3 Jul 30 10:55 /dev/asm-diske -> sda

[root@oracle-rac1 trace]# ll /dev/asm*
lrwxrwxrwx 1 root root 3 Jul 30 11:10 /dev/asm-diska -> sde
lrwxrwxrwx 1 root root 3 Jul 30 11:03 /dev/asm-diskb -> sdb
lrwxrwxrwx 1 root root 3 Jul 30 10:23 /dev/asm-diskc -> sda
lrwxrwxrwx 1 root root 3 Jul 30 11:10 /dev/asm-diskd -> sdd
lrwxrwxrwx 1 root root 3 Jul 30 11:03 /dev/asm-diske -> sdc

[root@oracle-rac2 ~]# $GRID_HOME/bin/kfod disks=asm  st=true ds=true cluster=true
--------------------------------------------------------------------------------
 Disk          Size Header    Path                                    Disk Group    User     Group   
================================================================================
   1:      81920 MB MEMBER    /dev/asm-diska                           DATA         grid     asmadmin
   2:      81920 MB MEMBER    /dev/asm-diskb                           OCR          grid     asmadmin
   3:      81920 MB MEMBER    /dev/asm-diskc                           DATA         grid     asmadmin
   4:      81920 MB MEMBER    /dev/asm-diskd                           DATA         grid     asmadmin
   5:      81920 MB MEMBER    /dev/asm-diske                           DATA         grid     asmadmin
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME                                      HOST_NAME           
================================================================================

[root@oracle-rac1 trace]# $GRID_HOME/bin/kfod disks=asm  st=true ds=true cluster=true
--------------------------------------------------------------------------------
 Disk          Size Header    Path                                    Disk Group    User     Group   
================================================================================
   1:      81920 MB MEMBER    /dev/asm-diska                           DATA         grid     asmadmin
   2:      81920 MB MEMBER    /dev/asm-diskb                           DATA         grid     asmadmin
   3:      81920 MB MEMBER    /dev/asm-diskc                           DATA         grid     asmadmin
   4:      81920 MB MEMBER    /dev/asm-diskd                           OCR          grid     asmadmin
   5:      81920 MB MEMBER    /dev/asm-diske                           DATA         grid     asmadmin
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME                                      HOST_NAME           
================================================================================

这里,磁盘顺序虽然不一样,但是,没有关系,用的是udev绑定的,不影响rac的运行

等rac节点正常启动后,可以看到如下内容:

代码语言:javascript
复制
-- 节点1
SYS@orcl1> set line 9999
SYS@orcl1> set pagesize 9999
SYS@orcl1> col path format a60
SYS@orcl1> SELECT a.group_number, disk_number,mount_status, a.name, path FROM v$asm_disk a order by a.disk_number;
select instance_name,status from v$instance;

GROUP_NUMBER DISK_NUMBER MOUNT_STATUS   NAME          PATH
------------ ----------- -------------- ------------- ---------------
           1           0 CACHED         DATA_0000     /dev/asm-diskc
           2           0 CACHED         OCR_0000      /dev/asm-diskd
           1           1 CACHED         DATA_0001     /dev/asm-diske
           1           2 CACHED         DATA_0002     /dev/asm-diska
           1           3 CACHED         DATA_0003     /dev/asm-diskb 


-- 节点2
SQL> set line 9999
SQL> set pagesize 9999
SQL> col path format a60
SQL> SELECT a.group_number, disk_number,mount_status, a.name, path FROM v$asm_disk a order by a.disk_number;
select instance_name,status from v$instance;

GROUP_NUMBER DISK_NUMBER MOUNT_S NAME       PATH
------------ ----------- ------- ---------- ---------------
           2           0 CACHED  OCR_0000   /dev/asm-diskb
           1           0 CACHED  DATA_0000  /dev/asm-diske
           1           1 CACHED  DATA_0001  /dev/asm-diskc
           1           2 CACHED  DATA_0002  /dev/asm-diska
           1           3 CACHED  DATA_0003  /dev/asm-diskd 

原因二:安全组封了

登陆ECS,发现只有节点1在运行,而节点2没有运行集群服务。

代码语言:javascript
复制
[root@oracle-rac1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       oracle-rac1              STABLE
ora.chad
               ONLINE  ONLINE       oracle-rac1              STABLE
ora.net1.network
               ONLINE  ONLINE       oracle-rac1              STABLE
ora.ons
               ONLINE  ONLINE       oracle-rac1              STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       oracle-rac1              STABLE
      2        ONLINE  OFFLINE                               STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       oracle-rac1              STABLE
      2        ONLINE  OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       oracle-rac1              STABLE
ora.OCR.dg(ora.asmgroup)
      1        ONLINE  ONLINE       oracle-rac1              STABLE
      2        ONLINE  OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       oracle-rac1              Started,STABLE
      2        ONLINE  OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       oracle-rac1              STABLE
      2        ONLINE  OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       oracle-rac1              STABLE
ora.oracle-rac1.vip
      1        ONLINE  ONLINE       oracle-rac1              STABLE
ora.oracle-rac2.vip
      1        ONLINE  INTERMEDIATE oracle-rac1              FAILED OVER,STABLE
ora.orcl.db
      1        ONLINE  ONLINE       oracle-rac1              Open,HOME=/u01/app/o
                                                             racle/product/19.3.0
                                                             /dbhome_1,STABLE
      2        ONLINE  OFFLINE                               Instance Shutdown,ST
                                                             ABLE
ora.qosmserver
      1        ONLINE  ONLINE       oracle-rac1              STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       oracle-rac1              STABLE
--------------------------------------------------------------------------------

使用命令crsctl start has启动节点2的集群服务后,通过crsctl stat res -t -init观察启动过程:

代码语言:javascript
复制
[root@oracle-rac2 ~]# crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[root@oracle-rac2 ~]# crsctl stat res -t -init
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  OFFLINE                               STABLE
ora.cluster_interconnect.haip
      1        ONLINE  OFFLINE                               STABLE
ora.crf
      1        ONLINE  ONLINE       oracle-rac2              STABLE
ora.crsd
      1        ONLINE  OFFLINE                               STABLE
ora.cssd
      1        ONLINE  OFFLINE      oracle-rac2              STARTING
ora.cssdmonitor
      1        ONLINE  ONLINE       oracle-rac2              STABLE
ora.ctssd
      1        ONLINE  OFFLINE                               STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  INTERMEDIATE oracle-rac2              STABLE
ora.gipcd
      1        ONLINE  ONLINE       oracle-rac2              STABLE
ora.gpnpd
      1        ONLINE  ONLINE       oracle-rac2              STABLE
ora.mdnsd
      1        ONLINE  ONLINE       oracle-rac2              STABLE
ora.storage
      1        ONLINE  OFFLINE                               STABLE
--------------------------------------------------------------------------------

多次执行crsctl stat res -t -init看到,启动一直卡在ora.cssd服务智利,查看日志:

代码语言:javascript
复制
[root@oracle-rac2 ~]# cd /u01/app/grid/diag/crs/oracle-rac2/crs/trace/
[root@oracle-rac2 trace]# tailf ocssd.trc
。。。
2021-07-30 09:49:44.851 :    CSSD:1881474816: clsssc_CLSFAInit_CB: System not ready for CLSFA initialization
2021-07-30 09:49:45.579 :    CSSD:1530889984: [     INFO] clssscWaitOnEventValue: after CmInfo State  val 3, eval 1 waited 1000 with cvtimewait status 4294967186
2021-07-30 09:49:45.835 :    CSSD:1493997312: [     INFO] clssnmvDHBValidateNCopy: node 1, oracle-rac1, has a disk HB, but no network HB, DHB has rcfg 523049052, wrtcnt, 1472163, LATS 2100744, lastSeqNo 1472162, uniqueness 1627554226, timestamp 1627609785/55291034
2021-07-30 09:49:45.852 :    CSSD:1881474816: clsssc_CLSFAInit_CB: System not ready for CLSFA initialization
2021-07-30 09:49:45.874 :    CSSD:1486112512: [     INFO] clssscSelect: gipcwait returned with status gipcretTimeout (16)
2021-07-30 09:49:46.579 :    CSSD:1530889984: [     INFO] clssscWaitOnEventValue: after CmInfo State  val 3, eval 1 waited 1000 with cvtimewait status 4294967186
2021-07-30 09:49:46.837 :    CSSD:1493997312: [     INFO] clssnmvDHBValidateNCopy: node 1, oracle-rac1, has a disk HB, but no network HB, DHB has rcfg 523049052, wrtcnt, 1472164, LATS 2101744, lastSeqNo 1472163, uniqueness 1627554226, timestamp 1627609786/55292034
2021-07-30 09:49:46.850 :    CSSD:1487689472: [     INFO] clssnmRcfgMgrThread: Local Join
2021-07-30 09:49:46.850 :    CSSD:1487689472: [     INFO] clssnmLocalJoinEvent: begin on node(2), waittime 193000
2021-07-30 09:49:46.850 :    CSSD:1487689472: [     INFO] clssnmLocalJoinEvent: set curtime (2101764) for my node
2021-07-30 09:49:46.850 :    CSSD:1487689472: [     INFO] clssnmLocalJoinEvent: scanning 32 nodes
2021-07-30 09:49:46.850 :    CSSD:1487689472: [     INFO] clssnmLocalJoinEvent: Node oracle-rac1, number 1, is in an existing cluster with disk state 3
2021-07-30 09:49:46.850 :    CSSD:1487689472: [  WARNING] clssnmLocalJoinEvent: takeover aborted due to cluster member node found on disk
。。。。

重复输出以上内容,里边有关键词“has a disk HB, but no network HB”,意思是有磁盘心跳,但是没有网络心跳,猜测是私网通信(网络心跳)的问题,而ohasd进程没有啥有用的信息:

代码语言:javascript
复制
[root@oracle-rac2 trace]# tailf alert.log 
2021-07-30 09:47:56.758 [GIPCD(13240)]CRS-8500: Oracle Clusterware GIPCD process is starting with operating system process ID 13240
2021-07-30 09:48:01.127 [OSYSMOND(13348)]CRS-8500: Oracle Clusterware OSYSMOND process is starting with operating system process ID 13348
2021-07-30 09:48:01.234 [CSSDMONITOR(13346)]CRS-8500: Oracle Clusterware CSSDMONITOR process is starting with operating system process ID 13346
2021-07-30 09:48:02.268 [CSSDAGENT(13407)]CRS-8500: Oracle Clusterware CSSDAGENT process is starting with operating system process ID 13407
2021-07-30 09:48:03.024 [OCSSD(13467)]CRS-8500: Oracle Clusterware OCSSD process is starting with operating system process ID 13467
2021-07-30 09:48:04.135 [OCSSD(13467)]CRS-1713: CSSD daemon is started in hub mode
2021-07-30 09:48:06.416 [OCSSD(13467)]CRS-1707: Lease acquisition for node oracle-rac2 number 2 completed
2021-07-30 09:48:07.528 [OCSSD(13467)]CRS-1621: The IPMI configuration data for this node stored in the Oracle registry is incomplete; details at (:CSSNK00002:) in /u01/app/grid/diag/crs/oracle-rac2/crs/trace/ocssd.trc
2021-07-30 09:48:07.528 [OCSSD(13467)]CRS-1617: The information required to do node kill for node oracle-rac2 is incomplete; details at (:CSSNM00004:) in /u01/app/grid/diag/crs/oracle-rac2/crs/trace/ocssd.trc
2021-07-30 09:48:07.534 [OCSSD(13467)]CRS-1605: CSSD voting file is online: /dev/asm-diskb; details in /u01/app/grid/diag/crs/oracle-rac2/crs/trace/ocssd.trc.
2021-07-30 09:58:02.736 [CSSDAGENT(13407)]CRS-5818: Aborted command 'start' for resource 'ora.cssd'. Details at (:CRSAGF00113:) {0:5:3} in /u01/app/grid/diag/crs/oracle-rac2/crs/trace/ohasd_cssdagent_root.trc.
2021-07-30 09:58:02.737 [OCSSD(13467)]CRS-1609: This node is unable to communicate with other nodes in the cluster and is going down to preserve cluster integrity; details at (:CSSNM00086:) in /u01/app/grid/diag/crs/oracle-rac2/crs/trace/ocssd.trc.
2021-07-30 09:58:02.785 [OHASD(12890)]CRS-2757: Command 'Start' timed out waiting for response from the resource 'ora.cssd'. Details at (:CRSPE00221:) {0:5:3} in /u01/app/grid/diag/crs/oracle-rac2/crs/trace/ohasd.trc.
2021-07-30 09:58:03.738 [OCSSD(13467)]CRS-1656: The CSS daemon is terminating due to a fatal error; Details at (:CSSSC00012:) in /u01/app/grid/diag/crs/oracle-rac2/crs/trace/ocssd.trc
2021-07-30 09:58:03.738 [OCSSD(13467)]CRS-1603: CSSD on node oracle-rac2 has been shut down.
2021-07-30 09:58:03.840 [OCSSD(13467)]CRS-1609: This node is unable to communicate with other nodes in the cluster and is going down to preserve cluster integrity; details at (:CSSNM00086:) in /u01/app/grid/diag/crs/oracle-rac2/crs/trace/ocssd.trc.
2021-07-30T09:58:08.746077+08:00
Errors in file /u01/app/grid/diag/crs/oracle-rac2/crs/trace/ocssd.trc  (incident=353):
CRS-8503 [] [] [] [] [] [] [] [] [] [] [] []
Incident details in: /u01/app/grid/diag/crs/oracle-rac2/crs/incident/incdir_353/ocssd_i353.trc

2021-07-30 09:58:08.739 [OCSSD(13467)]CRS-8503: Oracle Clusterware process OCSSD with operating system process ID 13467 experienced fatal signal or exception code 6.
2021-07-30 09:58:09.829 [CSSDMONITOR(20631)]CRS-8500: Oracle Clusterware CSSDMONITOR process is starting with operating system process ID 20631

[root@oracle-rac2 trace]# tailf ohasd.trc
2021-07-30 09:50:51.551 :   CRSPE:1226725120: [     INFO] {0:0:110} Processing PE command id=133 origin:oracle-rac2. Description: [Stat Resource : 0x7f2cec183100]
2021-07-30 09:50:51.551 :   CRSPE:1226725120: [     INFO] {0:0:110} Expression Filter : ((LAST_SERVER == oracle-rac2) AND (NAME == ora.cssd))
2021-07-30 09:50:51.562 :UiServer:1220421376: [     INFO] {0:0:110} Done for ctx=0x7f2cf803a9e0
2021-07-30 09:51:02.159 :GIPCHTHR:1243535104:  gipchaWorkerWork: workerThread heart beat, time interval since last heartBeat 30080 loopCount 38 sendCount 0 recvCount 102 postCount 0 sendCmplCount 0 recvCmplCount 0
2021-07-30 09:51:04.819 :GIPCHTHR:1216218880:  gipchaDaemonWork: DaemonThread heart beat, time interval since last heartBeat 30860loopCount 28
2021-07-30 09:51:13.992 :UiServer:1220421376: [     INFO] {0:0:111} Sending to PE. ctx= 0x7f2cf803d490, ClientPID=13128 set Properties (grid,101398)
2021-07-30 09:51:13.992 :   CRSPE:1226725120: [     INFO] {0:0:111} Processing PE command id=134 origin:oracle-rac2. Description: [Stat Resource : 0x7f2cec183100]
2021-07-30 09:51:14.002 :UiServer:1220421376: [     INFO] {0:0:111} Done for ctx=0x7f2cf803d490
2021-07-30 09:51:32.232 :GIPCHTHR:1243535104:  gipchaWorkerWork: workerThread heart beat, time interval since last heartBeat 30070 loopCount 31 sendCount 0 recvCount 36 postCount 0 sendCmplCount 0 recvCmplCount 0
2021-07-30 09:51:35.322 :GIPCHTHR:1216218880:  gipchaDaemonWork: DaemonThread heart beat, time interval since last heartBeat 30500loopCount 28
2021-07-30 09:51:49.722 :   CRSPE:1226725120: [     INFO] {0:0:2} waiting for message 'RESOURCE_START[ora.cssd 1 1] ID 4098:339, tint:{0:5:3}' to be completed on server : oracle-rac2
2021-07-30 09:51:51.431 :UiServer:1220421376: [     INFO] {0:0:112} Sending to PE. ctx= 0x7f2cf803a810, ClientPID=12992 set Properties (root,102335), orig.tint: {0:0:2}
2021-07-30 09:51:51.431 :   CRSPE:1226725120: [     INFO] {0:0:112} Processing PE command id=135 origin:oracle-rac2. Description: [Stat Resource : 0x7f2cec183100]
2021-07-30 09:51:51.438 :UiServer:1220421376: [     INFO] {0:0:112} Done for ctx=0x7f2cf803a810
2021-07-30 09:51:51.487 :UiServer:1220421376: [     INFO] {0:0:113} Sending to PE. ctx= 0x7f2cf803da20, ClientPID=12992 set Properties (root,103205), orig.tint: {0:0:2}
2021-07-30 09:51:51.487 :   CRSPE:1226725120: [     INFO] {0:0:113} Processing PE command id=136 origin:oracle-rac2. Description: [Stat Resource : 0x7f2cec183100]
2021-07-30 09:51:51.494 :UiServer:1220421376: [     INFO] {0:0:113} Done for ctx=0x7f2cf803da20
2021-07-30 09:51:51.539 :UiServer:1220421376: [     INFO] {0:0:114} Sending to PE. ctx= 0x7f2cf80012a0, ClientPID=12992 set Properties (root,103573), orig.tint: {0:0:2}
2021-07-30 09:51:51.539 :   CRSPE:1226725120: [     INFO] {0:0:114} Processing PE command id=137 origin:oracle-rac2. Description: [Stat Resource : 0x7f2cec183100]
2021-07-30 09:51:51.539 :   CRSPE:1226725120: [     INFO] {0:0:114} Expression Filter : ((LAST_SERVER == oracle-rac2) AND (NAME == ora.cssd))
2021-07-30 09:51:51.545 :UiServer:1220421376: [     INFO] {0:0:114} Done for ctx=0x7f2cf80012a0

节点1的日志也没有啥可用的信息。

使用ping命令ping公网和私网,都没有问题:

代码语言:javascript
复制
[root@oracle-rac2 ~]# ping oracle-rac1
PING oracle-rac1 (172.18.0.66) 56(84) bytes of data.
64 bytes from oracle-rac1 (172.18.0.66): icmp_seq=1 ttl=64 time=0.250 ms
^C
--- oracle-rac1 ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.250/0.250/0.250/0.000 ms
[root@oracle-rac2 ~]# ping oracle-rac1-priv 
PING oracle-rac1-priv (172.18.1.66) 56(84) bytes of data.
64 bytes from oracle-rac1-priv (172.18.1.66): icmp_seq=1 ttl=64 time=0.360 ms
^C
--- oracle-rac1-priv ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.360/0.360/0.360/0.000 ms

接下来用traceroute来查看:

代码语言:javascript
复制
[root@oracle-rac2 ~]# traceroute oracle-rac1
traceroute to oracle-rac1 (172.18.0.66), 30 hops max, 60 byte packets
 1  * * *
 2  * * *
 3  * * *
 4  * * *
 5  * * *
 6  * * *
 7  * * *
 8  * * *
 9  * * *
10  * * *
11  * * *
12  * * *
13  * * *
14  * * *
15  * * *
16  * * *^C
[root@oracle-rac2 ~]#  traceroute oracle-rac1-priv 
traceroute to oracle-rac1-priv (172.18.1.66), 30 hops max, 60 byte packets
 1  * * *
 2  * * *
 3  * * *
 4  * * *
 5  * * *
 6  *^C
[root@oracle-rac2 ~]# traceroute oracle-rac2
traceroute to oracle-rac2 (127.0.0.1), 30 hops max, 60 byte packets
 1  localhost (127.0.0.1)  0.021 ms  0.003 ms  0.003 ms

发现,使用traceroute结果不通(而且公网和私网都不通),说明网络的确有问题。可见,能ping通,不一定网络就没有问题,能ping通只是说明节点之间的ICMP协议通信没有问题。

之前没碰到过这类错误,只能求助于MOS和各大搜索引擎了,下面总结一下网友碰到的原因:

CSSD not starting up on second Node in a 2 Node Cluster. (Doc ID 2519544.1) :原因是服务器启动了安全类的软件或中病毒了,需要将安全类的软件停止才可以。

禁用HAIP:这个环境之前已经禁用过了,可以参考:https://www.xmmup.com/dbbao44oracle-racjiqunzhongdeipleixingjianjie.html

交换机和网卡有问题:我把网卡删掉,重建了一次网卡(类似于拔掉网卡,再插入),依然没有解决。网卡先down再up也没有解决,可见我的系统不是网卡本身的问题。

防火墙问题:该系统防火墙是关闭的。

多播工作机制异常:多播工作机制可以通过执行oracle的mcasttest.pl脚本进行检测,参考Grid Infrastructure Startup During Patching, Install or Upgrade May Fail Due to Multicasting Requirement (ID 1212703.1)。我运行脚本的时候报错,就没有检查了,感觉不是这个原因引起的。

节点进程gipcd.bin存在异常:gipcd.bin进程负责管理集群中所有的私有网卡,有一定原因是由于正常节点1服务器此进程出现异常,导致节点2服务器集群HAIP一直处于starting,cssd进程无法启动。 1) 手动终止节点1的gipcd.bin进程,kill之后发现集群会自动将此进程拉起,无需重启节点1的集群服务 2) 重启节点2集群服务,集群状态恢复正常,问题解决,由此判断此故障是由于正常节点集群gipcd.bin进程异常造成

oracle bug:此问题可能是BUG 13334158、BUG13811209、BUG12720728造成,在11.2.0.3.12 G I PSU3及以上PSU修复,可参考相关文档。

其他解决方案 导致节点2启动失败的可能原因有很多,如果上述方案无法解决,可参考以下方案: a) 关闭正常节点1集群服务,先重启节点2集群服务再重启节点1集群服务(结果发现我的环境,节点1启动不起来,就是同时只能有1个节点启动) b) 关闭所有集群服务,拔掉心跳线,15分钟后重新插入,再重启集群服务(可反复插拔进行尝试) c) 手动启动haip:crsctl start res ora.cluster_interconnect.haip -init,或禁用HAIP d) 重启两台服务器。

节点互信问题:其实,只要安装好rac后,修改oracle和grid用户的密码或者修改sshd的默认22端口,都不会导致rac的问题,因为互信是通过密钥来通信的,尽管如此,我还是测试了一下互信,没有问题:

代码语言:javascript
复制
[oracle@oracle-rac2 ~]
Fri Jul 30 10:32:20 CST 2021
/*
* 提示:该行代码过长,系统自动注释不进行高亮。一键复制会移除系统注释 
* [grid@oracle-rac2 ~]<span class="katex-html" aria-hidden="true" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;"><span class="strut" style="height:0.69444em;vertical-align:0em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;"><span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">s<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">s<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">h<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">o<span class="mord mathit" style="margin-right:0.02778em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">r<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">a<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">c<span class="mord mathit" style="margin-right:0.01968em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">l<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">e<span class="mord mathit" style="margin-right:0.05764em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">E<span class="mord mathit" style="margin-right:0.05764em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">E<span class="mord mathit" style="margin-right:0.02778em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">r<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">a<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">c<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">d<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">a<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">t<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">e<span class="mord mathit" style="margin-right:0.13889em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">F<span class="mord mathit" style="margin-right:0.02778em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">r<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">i<span class="mord mathit" style="margin-right:0.09618em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">J<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">u<span class="mord mathit" style="margin-right:0.01968em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">l<span class="mspace" style="margin-right:0.2777777777777778em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;"><span class="mspace" style="margin-right:0.2777777777777778em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;"><span class="strut" style="height:0.64444em;vertical-align:0em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;"><span class="mspace" style="margin-right:0.2777777777777778em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;"><span class="mspace" style="margin-right:0.2777777777777778em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;"><span class="strut" style="height:0.8888799999999999em;vertical-align:-0.19444em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;"><span class="mord mathit" style="margin-right:0.07153em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">C<span class="mord mathit" style="margin-right:0.05764em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">S<span class="mord mathit" style="margin-right:0.13889em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">T<span class="mord mathit" style="margin-right:0.05764em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">E<span class="mord mathit" style="margin-right:0.05764em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">E<span class="mord mathit" style="margin-right:0.03588em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">g<span class="mord mathit" style="margin-right:0.02778em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">r<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">i<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">d<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">o<span class="mord mathit" style="margin-right:0.02778em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">r<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">a<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">c<span class="mord mathit" style="margin-right:0.01968em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">l<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">e<span class="mord mathit" style="margin-right:0.05764em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">E<span class="mord mathit" style="margin-right:0.05764em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">E<span class="mord mathit" style="margin-right:0.02778em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">r<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">a<span class="mord mathit" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">c<span class="mord mathit" style="margin-right:0.05764em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">E<span class="mord mathit" style="margin-right:0.05764em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">E<span class="mord mathit" style="margin-right:0.05764em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">E<span class="mord mathit" style="margin-right:0.05764em;" style="color: inherit;line-height: inherit;font-size: 0.9em;overflow-wrap: inherit !important;word-break: inherit !important;">E ssh grid@oracle-rac1 date
*/
Fri Jul 30 10:33:48 CST 2021
</span class="mord mathit" style="margin-right:0.05764em;"></span class="mord mathit" style="margin-right:0.05764em;"></span class="mord mathit" style="margin-right:0.05764em;"></span class="mord mathit" style="margin-right:0.05764em;"></span class="mord mathit"></span class="mord mathit"></span class="mord mathit" style="margin-right:0.02778em;"></span class="mord mathit" style="margin-right:0.05764em;"></span class="mord mathit" style="margin-right:0.05764em;"></span class="mord mathit"></span class="mord mathit" style="margin-right:0.01968em;"></span class="mord mathit"></span class="mord mathit"></span class="mord mathit" style="margin-right:0.02778em;"></span class="mord mathit"></span class="mord mathit"></span class="mord mathit"></span class="mord mathit" style="margin-right:0.02778em;"></span class="mord mathit" style="margin-right:0.03588em;"></span class="mord mathit" style="margin-right:0.05764em;"></span class="mord mathit" style="margin-right:0.05764em;"></span class="mord mathit" style="margin-right:0.13889em;"></span class="mord mathit" style="margin-right:0.05764em;"></span class="mord mathit" style="margin-right:0.07153em;"></span class="strut" style="height:0.8888799999999999em;vertical-align:-0.19444em;"></span class="mspace" style="margin-right:0.2777777777777778em;"></span class="mspace" style="margin-right:0.2777777777777778em;"></span class="strut" style="height:0.64444em;vertical-align:0em;"></span class="mspace" style="margin-right:0.2777777777777778em;"></span class="mspace" style="margin-right:0.2777777777777778em;"></span class="mord mathit" style="margin-right:0.01968em;"></span class="mord mathit"></span class="mord mathit" style="margin-right:0.09618em;"></span class="mord mathit"></span class="mord mathit" style="margin-right:0.02778em;"></span class="mord mathit" style="margin-right:0.13889em;"></span class="mord mathit"></span class="mord mathit"></span class="mord mathit"></span class="mord mathit"></span class="mord mathit"></span class="mord mathit"></span class="mord mathit" style="margin-right:0.02778em;"></span class="mord mathit" style="margin-right:0.05764em;"></span class="mord mathit" style="margin-right:0.05764em;"></span class="mord mathit"></span class="mord mathit" style="margin-right:0.01968em;"></span class="mord mathit"></span class="mord mathit"></span class="mord mathit" style="margin-right:0.02778em;"></span class="mord mathit"></span class="mord mathit"></span class="mord mathit"></span class="mord mathit"></span class="strut" style="height:0.69444em;vertical-align:0em;"></span class="katex-html" aria-hidden="true">

这里,需要说明的一点是,如果你修改过sshd的端口为非22端口,那么应该同时修改/etc/services文件,否则直接用ssh测试肯定不通:

代码语言:javascript
复制
代码语言:javascript
复制
[grid@oracle-rac2 ~]$ more /etc/services | grep SSH
ssh             1520/tcp                          # The Secure Shell (SSH) Protocol
ssh             1520/udp                          # The Secure Shell (SSH) Protocol

重新跑root.sh脚本:这是万般无奈下的解决办法(可以解决很多问题),可惜我做了一次后,也失败了,脚本列出来:

代码语言:javascript
复制
-- 查询ASM磁盘
$GRID_HOME/bin/kfod disks=asm  st=true ds=true cluster=true

#root用户重新执行root.sh,配置文件:$ORACLE_HOME/crs/install/crsconfig_params
crsctl stop crs -f
#kill -9 `ps -ef|grep d.bin| grep -v grep | awk '{print $2}'`
export GRID_HOME=$ORACLE_HOME
$GRID_HOME/crs/install/rootcrs.pl -deconfig -force -verbose
$GRID_HOME/crs/install/rootcrs.pl -deconfig -force -verbose -lastnode -keepdg
#find $ORACLE_HOME/gpnp/* -type f -exec rm -rf {} \;
dd if=/dev/zero of=/dev/rhdiskN bs=1024k count=100  -- 清理磁盘头
#查看磁盘是否有内容
#AIX用:lquerypv -h  /dev/rhdisk5
#linux用:hexdump /dev/sdb ,例如:hexdump -n 1024 -C /dev/sdb1

#保证集群完全关闭,最好重启OS,检查网络情况,是否有cvuqdisk
#find /u01 -name cvuqdisk*
#rpm -qa cvuqdisk
#rpm -ivh $GRID_HOME/cv/rpm/cvuqdisk-*.rpm
#检查配置文件($ORACLE_HOME/crs/install/crsconfig_params)是否需要修改,18c可以去掉MGMTDB
$GRID_HOME/root.sh  #若出现错误,则在解决错误后可以重复执行,不需要先deconfig

到此,从早上10点到晚上8点,时间就这样过去了。。。。已经打算放弃了,准备卸载掉rac,重新安装,可是就是不甘心,没找到原因。。。。:

。。。。然后洗了个澡,当然,洗澡的同时脑子一直在想还有哪个方面没有考虑到,,,最后想到,是不是有人动了华为云的安全组策略了,因为这套rac之前中过病毒,可能客户修改过安全组,于是,赶紧查看安全组,发现:

果然,用户把udp端口都没有开!!!!

于是,添加2个节点之间的所有udp端口,如下所示:

然后,节点2立马就通了,traceroute输出结果:

代码语言:javascript
复制
[root@oracle-rac2 ~]# traceroute oracle-rac2
traceroute to oracle-rac2 (127.0.0.1), 30 hops max, 60 byte packets
 1  localhost (127.0.0.1)  0.017 ms  0.003 ms  0.003 ms
[root@oracle-rac2 ~]# traceroute oracle-rac1
traceroute to oracle-rac1 (172.18.0.66), 30 hops max, 60 byte packets
 1  oracle-rac1 (172.18.0.66)  0.276 ms  0.265 ms  0.251 ms

[root@oracle-rac1 ~]# traceroute oracle-rac2
traceroute to oracle-rac2 (172.18.0.67), 30 hops max, 60 byte packets
 1  oracle-rac2 (172.18.0.67)  0.274 ms  0.271 ms  0.256 ms
[root@oracle-rac1 ~]# traceroute oracle-rac1
traceroute to oracle-rac1 (172.18.0.66), 30 hops max, 60 byte packets
 1  oracle-rac1 (172.18.0.66)  0.014 ms  0.003 ms  0.002 ms

再去启动节点2,发现一切正常,此时是晚上10点左右:

代码语言:javascript
复制
[root@oracle-rac2 ~]# crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[root@oracle-rac2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       oracle-rac1              STABLE
               ONLINE  ONLINE       oracle-rac2              STABLE
ora.chad
               ONLINE  ONLINE       oracle-rac1              STABLE
               ONLINE  ONLINE       oracle-rac2              STABLE
ora.net1.network
               ONLINE  ONLINE       oracle-rac1              STABLE
               ONLINE  ONLINE       oracle-rac2              STABLE
ora.ons
               ONLINE  ONLINE       oracle-rac1              STABLE
               ONLINE  ONLINE       oracle-rac2              STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       oracle-rac1              STABLE
      2        ONLINE  ONLINE       oracle-rac2              STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       oracle-rac1              STABLE
      2        ONLINE  ONLINE       oracle-rac2              STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       oracle-rac1              STABLE
ora.OCR.dg(ora.asmgroup)
      1        ONLINE  ONLINE       oracle-rac1              STABLE
      2        ONLINE  ONLINE       oracle-rac2              STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       oracle-rac1              Started,STABLE
      2        ONLINE  ONLINE       oracle-rac2              Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       oracle-rac1              STABLE
      2        ONLINE  ONLINE       oracle-rac2              STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       oracle-rac1              STABLE
ora.oracle-rac1.vip
      1        ONLINE  ONLINE       oracle-rac1              STABLE
ora.oracle-rac2.vip
      1        ONLINE  ONLINE       oracle-rac2              STABLE
ora.orcl.db
      1        ONLINE  ONLINE       oracle-rac1              Open,HOME=/u01/app/o
                                                             racle/product/19.3.0
                                                             /dbhome_1,STABLE
      2        ONLINE  ONLINE       oracle-rac2              Open,HOME=/u01/app/o
                                                             racle/product/19.3.0
                                                             /dbhome_1,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       oracle-rac1              STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       oracle-rac1              STABLE
--------------------------------------------------------------------------------

一个安全组的问题,耗了我1天!!!

rac中的udp端口

其实,rac的节点之间通信有很多端口是通过udp端口进行通信的(例如cssd、ohasd等),也有部分是通过tcp端口通信的(例如tnslsnr),

代码语言:javascript
复制
[root@oracle-rac2 ~]# netstat -ulp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
udp        0      0 localhost:13530         0.0.0.0:*                           22668/asm_vktm_+ASM 
udp        0      0 oracle-rac2-priv:13530  0.0.0.0:*                           22668/asm_vktm_+ASM 
udp        0      0 0.0.0.0:mdns            0.0.0.0:*                           20912/mdnsd.bin     
udp        0      0 0.0.0.0:mdns            0.0.0.0:*                           20912/mdnsd.bin     
udp        0      0 localhost:13554         0.0.0.0:*                           25142/ora_p000_orcl 
udp        0      0 oracle-rac2-priv:38137  0.0.0.0:*                           23563/ora_ipc0_orcl 
udp        0      0 localhost:38153         0.0.0.0:*                           23871/ora_ocf0_orcl 
udp        0      0 localhost:38162         0.0.0.0:*                           25281/ora_q004_orcl 
udp        0      0 localhost:46396         0.0.0.0:*                           25168/ora_p00b_orcl 
udp        0      0 oracle-rac2-priv:38212  0.0.0.0:*                           25144/ora_p001_orcl 
udp        0      0 oracle-rac2-priv:46452  0.0.0.0:*                           23629/ora_lmd1_orcl 
udp        0      0 oracle-rac2-priv:54646  0.0.0.0:*                           23613/ora_dia0_orcl 
udp        0      0 oracle-rac2-priv:62850  0.0.0.0:*                           24994/ora_rcbg_orcl 
udp        0      0 localhost:21905         0.0.0.0:*                           25265/ora_q002_orcl 
udp        0      0 oracle-rac2-priv:46485  0.0.0.0:*                           22698/asm_dia0_+ASM 
udp        0      0 localhost:38304         0.0.0.0:*                           23747/ora_tmon_orcl 
udp        0      0 oracle-rac2-priv:54708  0.0.0.0:*                           23619/ora_lms1_orcl 
udp        0      0 localhost:54752         0.0.0.0:*                           22840/asm_m000_+ASM 
udp        0      0 oracle-rac2-priv:54752  0.0.0.0:*                           22840/asm_m000_+ASM 
udp        0      0 oracle-rac2-priv:30178  0.0.0.0:*                           22719/asm_ckpt_+ASM 
udp        0      0 oracle-rac2-priv:54759  0.0.0.0:*                           23674/oracle+ASM2_a 
udp        0      0 localhost:22026         0.0.0.0:*                           22644/asm_clmn_+ASM 
udp        0      0 oracle-rac2-priv:22026  0.0.0.0:*                           22644/asm_clmn_+ASM 
udp        0      0 localhost:62992         0.0.0.0:*                           25260/ora_qm02_orcl 
udp        0      0 oracle-rac2-priv:62998  0.0.0.0:*                           23563/ora_ipc0_orcl 
udp        0      0 oracle-rac2-priv:13848  0.0.0.0:*                           23631/ora_rms0_orcl 
udp        0      0 localhost:38454         0.0.0.0:*                           22688/asm_ping_+ASM 
udp        0      0 oracle-rac2-priv:38454  0.0.0.0:*                           22688/asm_ping_+ASM 
udp        0      0 oracle-rac2-priv:13897  0.0.0.0:*                           23573/ora_gen0_orcl 
udp        0      0 localhost:13934         0.0.0.0:*                           23683/ora_mmnl_orcl 
udp        0      0 localhost:13967         0.0.0.0:*                           23181/asm_o000_+ASM 
udp        0      0 oracle-rac2-priv:13967  0.0.0.0:*                           23181/asm_o000_+ASM 
udp        0      0 oracle-rac2-priv:38570  0.0.0.0:*                           25157/ora_p007_orcl 
udp        0      0 localhost:38610         0.0.0.0:*                           22730/asm_gmon_+ASM 
udp        0      0 oracle-rac2-priv:38610  0.0.0.0:*                           22730/asm_gmon_+ASM 
udp        0      0 oracle-rac2-priv:63232  0.0.0.0:*                           23635/ora_lck1_orcl 
udp        0      0 oracle-rac2-priv:63314  0.0.0.0:*                           23671/ora_mmon_orcl 
udp        0      0 oracle-rac2-priv:22358  0.0.0.0:*                           25147/ora_p002_orcl 
udp        0      0 oracle-rac2-priv:63337  0.0.0.0:*                           25281/ora_q004_orcl 
udp        0      0 oracle-rac2-priv:46961  0.0.0.0:*                           23604/ora_ping_orcl 
udp        0      0 localhost:30578         0.0.0.0:*                           23563/ora_ipc0_orcl 
udp        0      0 oracle-rac2-priv:22404  0.0.0.0:*                           23617/ora_lms0_orcl 
udp        0      0 oracle-rac2-priv:30599  0.0.0.0:*                           22682/asm_diag_+ASM 
udp        0      0 localhost:38875         0.0.0.0:*                           23617/ora_lms0_orcl 
udp        0      0 oracle-rac2-priv:38893  0.0.0.0:*                           24111/ora_ppa7_orcl 
udp        0      0 localhost:47092         0.0.0.0:*                           25179/ora_p00f_orcl 
udp        0      0 oracle-rac2-priv:55297  0.0.0.0:*                           25281/ora_q004_orcl 
udp        0      0 oracle-rac2-priv:38923  0.0.0.0:*                           25177/ora_p00e_orcl 
udp        0      0 oracle-rac2-priv:30750  0.0.0.0:*                           23600/ora_dbrm_orcl 
udp        0      0 oracle-rac2-priv:63578  0.0.0.0:*                           23023/asm_ppa7_+ASM 
udp        0      0 oracle-rac2-priv:22643  0.0.0.0:*                           23656/ora_reco_orcl 
udp        0      0 oracle-rac2-priv:55450  0.0.0.0:*                           23606/ora_svcb_orcl 
udp        0      0 oracle-rac2-priv:22684  0.0.0.0:*                           25142/ora_p000_orcl 
udp        0      0 oracle-rac2-priv:55509  0.0.0.0:*                           25170/ora_p00c_orcl 
udp        0      0 oracle-rac2-priv:55521  0.0.0.0:*                           24577/ora_w003_orcl 
udp        0      0 oracle-rac2-priv:30946  0.0.0.0:*                           23645/ora_ckpt_orcl 
udp        0      0 localhost:55527         0.0.0.0:*                           25162/ora_p008_orcl 
udp        0      0 localhost:14584         0.0.0.0:*                           22713/asm_dbw0_+ASM 
udp        0      0 oracle-rac2-priv:14584  0.0.0.0:*                           22713/asm_dbw0_+ASM 
udp        0      0 oracle-rac2-priv:22779  0.0.0.0:*                           23729/ora_rsmn_orcl 
udp        0      0 localhost:55554         0.0.0.0:*                           23579/ora_gen1_orcl 
udp        0      0 oracle-rac2-priv:14621  0.0.0.0:*                           25129/ora_aqpc_orcl 
udp        0      0 oracle-rac2-priv:63778  0.0.0.0:*                           22682/asm_diag_+ASM 
udp        0      0 localhost:55658         0.0.0.0:*                           23183/oracle+ASM2_o 
udp        0      0 oracle-rac2-priv:55658  0.0.0.0:*                           23183/oracle+ASM2_o 
udp        0      0 localhost:22929         0.0.0.0:*                           22646/asm_psp0_+ASM 
udp        0      0 oracle-rac2-priv:22929  0.0.0.0:*                           22646/asm_psp0_+ASM 
udp        0      0 localhost:39353         0.0.0.0:*                           22735/asm_mmnl_+ASM 
udp        0      0 oracle-rac2-priv:39353  0.0.0.0:*                           22735/asm_mmnl_+ASM 
udp        0      0 localhost:22975         0.0.0.0:*                           25147/ora_p002_orcl 
udp        0      0 localhost:14794         0.0.0.0:*                           23573/ora_gen0_orcl 
udp        0      0 oracle-rac2-priv:22987  0.0.0.0:*                           25168/ora_p00b_orcl 
udp        0      0 oracle-rac2-priv:55783  0.0.0.0:*                           25243/oracleorcl2   
udp        0      0 oracle-rac2-priv:47643  0.0.0.0:*                           22700/asm_lmon_+ASM 
udp        0      0 localhost:55842         0.0.0.0:*                           25129/ora_aqpc_orcl 
udp        0      0 localhost:47721         0.0.0.0:*                           22719/asm_ckpt_+ASM 
udp        0      0 oracle-rac2-priv:47721  0.0.0.0:*                           22719/asm_ckpt_+ASM 
udp        0      0 oracle-rac2-priv:39535  0.0.0.0:*                           23771/ora_m000_orcl 
udp        0      0 localhost:31355         0.0.0.0:*                           23645/ora_ckpt_orcl 
udp        0      0 localhost:64166         0.0.0.0:*                           23604/ora_ping_orcl 
udp        0      0 oracle-rac2-priv:39604  0.0.0.0:*                           22733/asm_mmon_+ASM 
udp        0      0 oracle-rac2-priv:55994  0.0.0.0:*                           24994/ora_rcbg_orcl 
udp        0      0 localhost:64206         0.0.0.0:*                           25157/ora_p007_orcl 
udp        0      0 localhost:15056         0.0.0.0:*                           23621/ora_lmd0_orcl 
udp        0      0 oracle-rac2-priv:56120  0.0.0.0:*                           23613/ora_dia0_orcl 
udp        0      0 0.0.0.0:39748           0.0.0.0:*                           20532/ohasd.bin     
udp        0      0 oracle-rac2-priv:64330  0.0.0.0:*                           23656/ora_reco_orcl 
udp        0      0 oracle-rac2-priv:39759  0.0.0.0:*                           25174/ora_p00d_orcl 
udp        0      0 localhost:56173         0.0.0.0:*                           24387/ora_tt01_orcl 
udp        0      0 oracle-rac2-priv:56174  0.0.0.0:*                           22688/asm_ping_+ASM 
udp        0      0 oracle-rac2-priv:64446  0.0.0.0:*                           22674/asm_mman_+ASM 
udp        0      0 oracle-rac2-priv:23524  0.0.0.0:*                           25170/ora_p00c_orcl 
udp        0      0 oracle-rac2-priv:64486  0.0.0.0:*                           23671/ora_mmon_orcl 
udp        0      0 localhost:48117         0.0.0.0:*                           23629/ora_lmd1_orcl 
udp        0      0 localhost:15390         0.0.0.0:*                           24988/ora_gtx0_orcl 
udp        0      0 localhost:15442         0.0.0.0:*                           23877/oracle+ASM2_o 
udp        0      0 oracle-rac2-priv:15442  0.0.0.0:*                           23877/oracle+ASM2_o 
udp        0      0 localhost:23737         0.0.0.0:*                           23226/oracle+ASM2   
udp        0      0 oracle-rac2-priv:23737  0.0.0.0:*                           23226/oracle+ASM2   
udp        0      0 oracle-rac2-priv:64705  0.0.0.0:*                           22756/asm_scm0_+ASM 
udp        0      0 localhost:40137         0.0.0.0:*                           23635/ora_lck1_orcl 
udp        0      0 localhost:64714         0.0.0.0:*                           22783/asm_lck0_+ASM 
udp        0      0 oracle-rac2-priv:64714  0.0.0.0:*                           22783/asm_lck0_+ASM 
udp        0      0 localhost:56541         0.0.0.0:*                           23869/ora_mark_orcl 
udp        0      0 localhost:40160         0.0.0.0:*                           25151/ora_p004_orcl 
udp        0      0 localhost:15585         0.0.0.0:*                           23555/ora_pmon_orcl 
udp        0      0 localhost:40161         0.0.0.0:*                           22723/asm_lreg_+ASM 
udp        0      0 oracle-rac2-priv:40161  0.0.0.0:*                           22723/asm_lreg_+ASM 
udp        0      0 localhost:56641         0.0.0.0:*                           25794/ora_m002_orcl 
udp        0      0 localhost:15693         0.0.0.0:*                           23633/ora_lmhb_orcl 
udp        0      0 localhost:32105         0.0.0.0:*                           25153/ora_p005_orcl 
udp        0      0 oracle-rac2-priv:23948  0.0.0.0:*                           20532/ohasd.bin     
udp        0      0 localhost:48536         0.0.0.0:*                           23667/ora_asmb_orcl 
udp        0      0 localhost:23963         0.0.0.0:*                           23722/ora_lck0_orcl 
udp        0      0 oracle-rac2-priv:48541  0.0.0.0:*                           25179/ora_p00f_orcl 
udp        0      0 oracle-rac2-priv:15831  0.0.0.0:*                           24577/ora_w003_orcl 
udp        0      0 oracle-rac2-priv:40447  0.0.0.0:*                           25281/ora_q004_orcl 
udp        0      0 oracle-rac2-priv:56834  0.0.0.0:*                           25144/ora_p001_orcl 
udp        0      0 oracle-rac2-priv:15902  0.0.0.0:*                           25166/ora_p00a_orcl 
udp        0      0 oracle-rac2-priv:65055  0.0.0.0:*                           21835/octssd.bin    
udp        0      0 localhost:48692         0.0.0.0:*                           25174/ora_p00d_orcl 
udp        0      0 localhost:32344         0.0.0.0:*                           22696/asm_pman_+ASM 
udp        0      0 oracle-rac2-priv:32344  0.0.0.0:*                           22696/asm_pman_+ASM 
udp        0      0 oracle-rac2-priv:56922  0.0.0.0:*                           23875/oracle+ASM2_o 
udp        0      0 oracle-rac2-priv:48788  0.0.0.0:*                           23671/ora_mmon_orcl 
udp        0      0 oracle-rac2-priv:56997  0.0.0.0:*                           25177/ora_p00e_orcl 
udp        0      0 localhost:65213         0.0.0.0:*                           23999/ora_fd00_orcl 
udp        0      0 oracle-rac2-priv:48859  0.0.0.0:*                           22735/asm_mmnl_+ASM 
udp        0      0 oracle-rac2-priv:16109  0.0.0.0:*                           23183/oracle+ASM2_o 
udp        0      0 localhost:16114         0.0.0.0:*                           25243/oracleorcl2   
udp        0      0 localhost:48900         0.0.0.0:*                           23606/ora_svcb_orcl 
udp        0      0 localhost:32544         0.0.0.0:*                           25642/ora_gcr1_orcl 
udp        0      0 oracle-rac2-priv:16165  0.0.0.0:*                           22672/asm_gen0_+ASM 
udp        0      0 localhost:16197         0.0.0.0:*                           23619/ora_lms1_orcl 
udp        0      0 localhost:57173         0.0.0.0:*                           23690/ora_imr0_orcl 
udp        0      0 localhost:8125          0.0.0.0:*                           888/agent           
udp        0      0 localhost:32736         0.0.0.0:*                           23674/oracle+ASM2_a 
udp        0      0 oracle-rac2-priv:32736  0.0.0.0:*                           23674/oracle+ASM2_a 
udp        0      0 oracle-rac2-priv:57322  0.0.0.0:*                           23640/ora_lgwr_orcl 
udp        0      0 localhost:16408         0.0.0.0:*                           24384/ora_tt00_orcl 
udp        0      0 oracle-rac2-priv:24612  0.0.0.0:*                           25149/ora_p003_orcl 
udp        0      0 0.0.0.0:bootpc          0.0.0.0:*                           982/dhclient        
udp        0      0 0.0.0.0:bootpc          0.0.0.0:*                           980/dhclient        
udp        0      0 oracle-rac2-priv:24668  0.0.0.0:*                           25172/ora_cjq0_orcl 
udp        0      0 localhost:41054         0.0.0.0:*                           22711/asm_lck1_+ASM 
udp        0      0 oracle-rac2-priv:41054  0.0.0.0:*                           22711/asm_lck1_+ASM 
udp        0      0 oracle-rac2-priv:16492  0.0.0.0:*                           23637/ora_dbw0_orcl 
udp        0      0 0.0.0.0:sunrpc          0.0.0.0:*                           744/rpcbind         
udp        0      0 localhost:24775         0.0.0.0:*                           25149/ora_p003_orcl 
udp        0      0 localhost:57558         0.0.0.0:*                           23030/oracle+ASM2_a 
udp        0      0 oracle-rac2-priv:57558  0.0.0.0:*                           23030/oracle+ASM2_a 
udp        0      0 localhost:57587         0.0.0.0:*                           23617/ora_lms0_orcl 
udp        0      0 localhost:24840         0.0.0.0:*                           25627/oracleorcl2   
udp        0      0 oracle-rac2-priv:41250  0.0.0.0:*                           21136/gipcd.bin     
udp        0      0 oracle-rac2-priv:33071  0.0.0.0:*                           23584/ora_diag_orcl 
udp        0      0 oracle-rac2-priv:33093  0.0.0.0:*                           25170/ora_p00c_orcl 
udp        0      0 oracle-rac2-priv:49495  0.0.0.0:*                           22642/asm_pmon_+ASM 
udp        0      0 localhost:25155         0.0.0.0:*                           22698/asm_dia0_+ASM 
udp        0      0 oracle-rac2-priv:25155  0.0.0.0:*                           22698/asm_dia0_+ASM 
udp        0      0 oracle-rac2-priv:16973  0.0.0.0:*                           22700/asm_lmon_+ASM 
udp        0      0 localhost:49779         0.0.0.0:*                           23617/ora_lms0_orcl 
udp        0      0 localhost:17025         0.0.0.0:*                           25172/ora_cjq0_orcl 
udp        0      0 localhost:41610         0.0.0.0:*                           23688/ora_s000_orcl 
udp        0      0 oracle-rac2-priv:25232  0.0.0.0:*                           22728/asm_rbal_+ASM 
udp        0      0 oracle-rac2-priv:33485  0.0.0.0:*                           21881/crsd.bin      
udp        0      0 oracle-rac2-priv:49876  0.0.0.0:*                           25147/ora_p002_orcl 
udp        0      0 oracle-rac2-priv:33505  0.0.0.0:*                           22737/asm_imr0_+ASM 
udp        0      0 oracle-rac2-priv:17126  0.0.0.0:*                           25149/ora_p003_orcl 
udp        0      0 oracle-rac2-priv:41743  0.0.0.0:*                           22644/asm_clmn_+ASM 
udp        0      0 oracle-rac2-priv:17195  0.0.0.0:*                           23649/ora_smon_orcl 
udp        0      0 oracle-rac2-priv:17228  0.0.0.0:*                           23615/ora_lmon_orcl 
udp        0      0 oracle-rac2-priv:58238  0.0.0.0:*                           22696/asm_pman_+ASM 
udp        0      0 0.0.0.0:894             0.0.0.0:*                           744/rpcbind         
udp        0      0 localhost:33666         0.0.0.0:*                           22715/asm_lgwr_+ASM 
udp        0      0 oracle-rac2-priv:33666  0.0.0.0:*                           22715/asm_lgwr_+ASM 
udp        0      0 localhost:17289         0.0.0.0:*                           25707/ora_gcr0_orcl 
udp        0      0 oracle-rac2-priv:25512  0.0.0.0:*                           23729/ora_rsmn_orcl 
udp        0      0 oracle-rac2-priv:9141   0.0.0.0:*                           25164/ora_p009_orcl 
udp        0      0 localhost:41912         0.0.0.0:*                           23663/ora_pxmn_orcl 
udp        0      0 oracle-rac2-priv:17385  0.0.0.0:*                           25157/ora_p007_orcl 
udp        0      0 oracle-rac2-priv:58355  0.0.0.0:*                           23621/ora_lmd0_orcl 
udp        0      0 oracle-rac2-priv:25597  0.0.0.0:*                           23629/ora_lmd1_orcl 
udp        0      0 oracle-rac2-priv:58369  0.0.0.0:*                           25157/ora_p007_orcl 
udp        0      0 localhost:42000         0.0.0.0:*                           25267/oracleorcl2   
udp        0      0 oracle-rac2-priv:25625  0.0.0.0:*                           25179/ora_p00f_orcl 
udp        0      0 localhost:58403         0.0.0.0:*                           22678/asm_gen1_+ASM 
udp        0      0 oracle-rac2-priv:58403  0.0.0.0:*                           22678/asm_gen1_+ASM 
udp        0      0 localhost:17490         0.0.0.0:*                           23771/ora_m000_orcl 
udp        0      0 oracle-rac2-priv:17526  0.0.0.0:*                           24111/ora_ppa7_orcl 
udp        0      0 oracle-rac2-priv:25724  0.0.0.0:*                           25164/ora_p009_orcl 
udp        0      0 oracle-rac2-priv:42117  0.0.0.0:*                           25151/ora_p004_orcl 
udp        0      0 oracle-rac2-priv:50348  0.0.0.0:*                           25153/ora_p005_orcl 
udp        0      0 oracle-rac2-priv:58585  0.0.0.0:*                           25142/ora_p000_orcl 
udp        0      0 oracle-rac2-priv:34027  0.0.0.0:*                           25263/ora_qm05_orcl 
udp        0      0 oracle-rac2-priv:9486   0.0.0.0:*                           23722/ora_lck0_orcl 
udp        0      0 localhost:50453         0.0.0.0:*                           25155/ora_p006_orcl 
udp        0      0 localhost:17706         0.0.0.0:*                           23602/ora_vkrm_orcl 
udp        0      0 localhost:25899         0.0.0.0:*                           23706/ora_scm0_orcl 
udp        0      0 oracle-rac2-priv:42297  0.0.0.0:*                           23615/ora_lmon_orcl 
udp        0      0 oracle-rac2-priv:58746  0.0.0.0:*                           23661/ora_lreg_orcl 
udp        0      0 localhost:34186         0.0.0.0:*                           22702/asm_lmd0_+ASM 
udp        0      0 oracle-rac2-priv:34186  0.0.0.0:*                           22702/asm_lmd0_+ASM 
udp        0      0 localhost:58769         0.0.0.0:*                           23619/ora_lms1_orcl 
udp        0      0 oracle-rac2-priv:42395  0.0.0.0:*                           22730/asm_gmon_+ASM 
udp        0      0 oracle-rac2-priv:9637   0.0.0.0:*                           22678/asm_gen1_+ASM 
udp        0      0 oracle-rac2-priv:42421  0.0.0.0:*                           23020/oracle+ASM2_o 
udp        0      0 172.18.1.255:42424      0.0.0.0:*                           21401/ocssd.bin     
udp        0      0 230.0.1.0:42424         0.0.0.0:*                           21401/ocssd.bin     
udp        0      0 224.0.0.251:42424       0.0.0.0:*                           21401/ocssd.bin     
udp        0      0 172.18.1.255:42424      0.0.0.0:*                           20532/ohasd.bin     
udp        0      0 230.0.1.0:42424         0.0.0.0:*                           20532/ohasd.bin     
udp        0      0 224.0.0.251:42424       0.0.0.0:*                           20532/ohasd.bin     
udp        0      0 172.18.1.255:42424      0.0.0.0:*                           21136/gipcd.bin     
udp        0      0 230.0.1.0:42424         0.0.0.0:*                           21136/gipcd.bin     
udp        0      0 224.0.0.251:42424       0.0.0.0:*                           21136/gipcd.bin     
udp        0      0 oracle-rac2-priv:9675   0.0.0.0:*                           23613/ora_dia0_orcl 
udp        0      0 oracle-rac2-priv:42496  0.0.0.0:*                           23181/asm_o000_+ASM 
udp        0      0 localhost:34349         0.0.0.0:*                           24994/ora_rcbg_orcl 
udp        0      0 oracle-rac2-priv:18015  0.0.0.0:*                           23619/ora_lms1_orcl 
udp        0      0 oracle-rac2-priv:59010  0.0.0.0:*                           23604/ora_ping_orcl 
udp        0      0 oracle-rac2-priv:18077  0.0.0.0:*                           23593/ora_ofsd_orcl 
udp        0      0 localhost:26303         0.0.0.0:*                           23609/ora_acms_orcl 
udp        0      0 oracle-rac2-priv:42715  0.0.0.0:*                           23593/ora_ofsd_orcl 
udp        0      0 oracle-rac2-priv:18143  0.0.0.0:*                           25129/ora_aqpc_orcl 
udp        0      0 oracle-rac2-priv:18159  0.0.0.0:*                           25155/ora_p006_orcl 
udp        0      0 localhost:50954         0.0.0.0:*                           22756/asm_scm0_+ASM 
udp        0      0 oracle-rac2-priv:50954  0.0.0.0:*                           22756/asm_scm0_+ASM 
udp        0      0 oracle-rac2-priv:26420  0.0.0.0:*                           25149/ora_p003_orcl 
udp        0      0 localhost:42857         0.0.0.0:*                           23661/ora_lreg_orcl 
udp        0      0 oracle-rac2-priv:42875  0.0.0.0:*                           23771/ora_m000_orcl 
udp        0      0 localhost:51076         0.0.0.0:*                           23686/ora_d000_orcl 
udp        0      0 oracle-rac2-priv:34706  0.0.0.0:*                           25174/ora_p00d_orcl 
udp        0      0 localhost:59285         0.0.0.0:*                           22678/asm_gen1_+ASM 
udp        0      0 oracle-rac2-priv:59285  0.0.0.0:*                           22678/asm_gen1_+ASM 
udp        0      0 oracle-rac2-priv:59321  0.0.0.0:*                           22678/asm_gen1_+ASM 
udp        0      0 oracle-rac2-priv:51150  0.0.0.0:*                           23706/ora_scm0_orcl 
udp        0      0 localhost:51160         0.0.0.0:*                           23640/ora_lgwr_orcl 
udp        0      0 oracle-rac2-priv:34800  0.0.0.0:*                           23030/oracle+ASM2_a 
udp        0      0 oracle-rac2-priv:18466  0.0.0.0:*                           23606/ora_svcb_orcl 
udp        0      0 oracle-rac2-priv:34866  0.0.0.0:*                           22783/asm_lck0_+ASM 
udp        0      0 localhost:26707         0.0.0.0:*                           23649/ora_smon_orcl 
udp        0      0 localhost:43102         0.0.0.0:*                           23637/ora_dbw0_orcl 
udp        0      0 oracle-rac2-priv:43131  0.0.0.0:*                           23600/ora_dbrm_orcl 
udp        0      0 localhost:43141         0.0.0.0:*                           24111/ora_ppa7_orcl 
udp        0      0 oracle-rac2-priv:59539  0.0.0.0:*                           22688/asm_ping_+ASM 
udp        0      0 localhost:10435         0.0.0.0:*                           22700/asm_lmon_+ASM 
udp        0      0 oracle-rac2-priv:10435  0.0.0.0:*                           22700/asm_lmon_+ASM 
udp        0      0 oracle-rac2-priv:43207  0.0.0.0:*                           23643/ora_lg00_orcl 
udp        0      0 localhost:26834         0.0.0.0:*                           23631/ora_rms0_orcl 
udp        0      0 oracle-rac2-priv:51435  0.0.0.0:*                           22725/asm_pxmn_+ASM 
udp        0      0 oracle-rac:MOS-soap-opt 0.0.0.0:*                           23665/ora_rbal_orcl 
udp        0      0 localhost:35150         0.0.0.0:*                           23579/ora_gen1_orcl 
udp        0      0 oracle-rac2-priv:59735  0.0.0.0:*                           23722/ora_lck0_orcl 
udp        0      0 oracle-rac2-priv:18823  0.0.0.0:*                           25164/ora_p009_orcl 
udp        0      0 localhost:59827         0.0.0.0:*                           25170/ora_p00c_orcl 
udp        0      0 oracle-rac2-priv:59838  0.0.0.0:*                           22698/asm_dia0_+ASM 
udp        0      0 oracle-rac2-priv:43455  0.0.0.0:*                           24111/ora_ppa7_orcl 
udp        0      0 oracle-rac2-priv:10703  0.0.0.0:*                           25166/ora_p00a_orcl 
udp        0      0 oracle-rac2-priv:18902  0.0.0.0:*                           22702/asm_lmd0_+ASM 
udp        0      0 oracle-rac2-priv:35342  0.0.0.0:*                           23619/ora_lms1_orcl 
udp        0      0 oracle-rac2-priv:35365  0.0.0.0:*                           23023/asm_ppa7_+ASM 
udp        0      0 oracle-rac2-priv:43580  0.0.0.0:*                           24111/ora_ppa7_orcl 
udp        0      0 localhost:27274         0.0.0.0:*                           22721/asm_smon_+ASM 
udp        0      0 oracle-rac2-priv:27274  0.0.0.0:*                           22721/asm_smon_+ASM 
udp        0      0 oracle-rac2-priv:35486  0.0.0.0:*                           25162/ora_p008_orcl 
udp        0      0 oracle-rac2-priv:10924  0.0.0.0:*                           23661/ora_lreg_orcl 
udp        0      0 oracle-rac2-priv:27314  0.0.0.0:*                           25263/ora_qm05_orcl 
udp        0      0 localhost:60100         0.0.0.0:*                           23665/ora_rbal_orcl 
udp        0      0 oracle-rac2-priv:27365  0.0.0.0:*                           25172/ora_cjq0_orcl 
udp        0      0 oracle-rac2-priv:11038  0.0.0.0:*                           22715/asm_lgwr_+ASM 
udp        0      0 oracle-rac2-priv:35655  0.0.0.0:*                           23584/ora_diag_orcl 
udp        0      0 oracle-rac2-priv:52111  0.0.0.0:*                           23606/ora_svcb_orcl 
udp        0      0 oracle-rac2-priv:43936  0.0.0.0:*                           25823/ora_m003_orcl 
udp        0      0 oracle-rac2-priv:27552  0.0.0.0:*                           25784/ora_m001_orcl 
udp        0      0 localhost:43942         0.0.0.0:*                           23593/ora_ofsd_orcl 
udp        0      0 oracle-rac2-priv:11189  0.0.0.0:*                           22723/asm_lreg_+ASM 
udp        0      0 localhost:43998         0.0.0.0:*                           24487/ora_w002_orcl 
udp        0      0 localhost:60414         0.0.0.0:*                           23569/ora_vktm_orcl 
udp        0      0 oracle-rac2-priv:60447  0.0.0.0:*                           22721/asm_smon_+ASM 
udp        0      0 localhost:44097         0.0.0.0:*                           23669/ora_fenc_orcl 
udp        0      0 oracle-rac2-priv:19608  0.0.0.0:*                           25784/ora_m001_orcl 
udp        0      0 oracle-rac2-priv:19629  0.0.0.0:*                           23722/ora_lck0_orcl 
udp        0      0 oracle-rac2-priv:52418  0.0.0.0:*                           25155/ora_p006_orcl 
udp        0      0 localhost:44263         0.0.0.0:*                           23643/ora_lg00_orcl 
udp        0      0 oracle-rac2-priv:44273  0.0.0.0:*                           25151/ora_p004_orcl 
udp        0      0 oracle-rac2-priv:11559  0.0.0.0:*                           22781/asm_gcr0_+ASM 
udp        0      0 localhost:27954         0.0.0.0:*                           25144/ora_p001_orcl 
udp        0      0 localhost:11588         0.0.0.0:*                           25823/ora_m003_orcl 
udp        0      0 oracle-rac2-priv:60756  0.0.0.0:*                           25144/ora_p001_orcl 
udp        0      0 localhost:28018         0.0.0.0:*                           23875/oracle+ASM2_o 
udp        0      0 oracle-rac2-priv:28018  0.0.0.0:*                           23875/oracle+ASM2_o 
udp        0      0 localhost:28040         0.0.0.0:*                           23647/ora_lg01_orcl 
udp        0      0 oracle-rac2-priv:36233  0.0.0.0:*                           22704/asm_lms0_+ASM 
udp        0      0 oracle-rac2-priv:36242  0.0.0.0:*                           23615/ora_lmon_orcl 
udp        0      0 oracle-rac2-priv:11675  0.0.0.0:*                           22646/asm_psp0_+ASM 
udp        0      0 localhost:52661         0.0.0.0:*                           22704/asm_lms0_+ASM 
udp        0      0 oracle-rac2-priv:52661  0.0.0.0:*                           22704/asm_lms0_+ASM 
udp        0      0 localhost:60857         0.0.0.0:*                           22709/asm_lmhb_+ASM 
udp        0      0 oracle-rac2-priv:60857  0.0.0.0:*                           22709/asm_lmhb_+ASM 
udp        0      0 oracle-rac2-priv:19908  0.0.0.0:*                           23617/ora_lms0_orcl 
udp        0      0 oracle-rac2-priv:44508  0.0.0.0:*                           23729/ora_rsmn_orcl 
udp        0      0 oracle-rac2-priv:52741  0.0.0.0:*                           25263/ora_qm05_orcl 
udp        0      0 localhost:19982         0.0.0.0:*                           23593/ora_ofsd_orcl 
udp        0      0 localhost:44580         0.0.0.0:*                           23873/ora_o000_orcl 
udp        0      0 oracle-rac2-priv:44609  0.0.0.0:*                           25168/ora_p00b_orcl 
udp        0      0 oracle-rac2-priv:52808  0.0.0.0:*                           23604/ora_ping_orcl 
udp        0      0 localhost:20066         0.0.0.0:*                           23658/ora_w001_orcl 
udp        0      0 oracle-rac2-priv:20068  0.0.0.0:*                           25177/ora_p00e_orcl 
udp        0      0 oracle-rac2-priv:44653  0.0.0.0:*                           21401/ocssd.bin     
udp        0      0 oracle-rac2-priv:28321  0.0.0.0:*                           25784/ora_m001_orcl 
udp        0      0 oracle-rac2-priv:36517  0.0.0.0:*                           25142/ora_p000_orcl 
udp        0      0 localhost:20146         0.0.0.0:*                           22672/asm_gen0_+ASM 
udp        0      0 oracle-rac2-priv:20146  0.0.0.0:*                           22672/asm_gen0_+ASM 
udp        0      0 localhost:11968         0.0.0.0:*                           23600/ora_dbrm_orcl 
udp        0      0 localhost:11980         0.0.0.0:*                           22737/asm_imr0_+ASM 
udp        0      0 oracle-rac2-priv:11980  0.0.0.0:*                           22737/asm_imr0_+ASM 
udp        0      0 oracle-rac2-priv:44841  0.0.0.0:*                           23584/ora_diag_orcl 
udp        0      0 oracle-rac2-priv:36677  0.0.0.0:*                           25179/ora_p00f_orcl 
udp        0      0 localhost:28529         0.0.0.0:*                           23651/ora_smco_orcl 
udp        0      0 oracle-rac2-priv:53121  0.0.0.0:*                           25155/ora_p006_orcl 
udp        0      0 oracle-rac2-priv:12183  0.0.0.0:*                           22711/asm_lck1_+ASM 
udp        0      0 oracle-rac2-priv:61337  0.0.0.0:*                           25151/ora_p004_orcl 
udp        0      0 localhost:20388         0.0.0.0:*                           23671/ora_mmon_orcl 
udp        0      0 localhost:28587         0.0.0.0:*                           23575/ora_mman_orcl 
udp        0      0 oracle-rac2-priv:20437  0.0.0.0:*                           25174/ora_p00d_orcl 
udp        0      0 oracle-rac2-priv:20441  0.0.0.0:*                           25243/oracleorcl2   
udp        0      0 localhost:61415         0.0.0.0:*                           23557/ora_clmn_orcl 
udp        0      0 oracle-rac2-priv:12274  0.0.0.0:*                           22668/asm_vktm_+ASM 
udp        0      0 localhost:61445         0.0.0.0:*                           23020/oracle+ASM2_o 
udp        0      0 oracle-rac2-priv:61445  0.0.0.0:*                           23020/oracle+ASM2_o 
udp        0      0 localhost:12303         0.0.0.0:*                           24596/ora_w004_orcl 
udp        0      0 localhost:12325         0.0.0.0:*                           25166/ora_p00a_orcl 
udp        0      0 oracle-rac2-priv:20543  0.0.0.0:*                           22704/asm_lms0_+ASM 
udp        0      0 localhost:53312         0.0.0.0:*                           23656/ora_reco_orcl 
udp        0      0 oracle-rac2-priv:28741  0.0.0.0:*                           22783/asm_lck0_+ASM 
udp        0      0 localhost:28748         0.0.0.0:*                           22704/asm_lms0_+ASM 
udp        0      0 oracle-rac2-priv:28748  0.0.0.0:*                           22704/asm_lms0_+ASM 
udp        0      0 localhost:28767         0.0.0.0:*                           22781/asm_gcr0_+ASM 
udp        0      0 oracle-rac2-priv:28767  0.0.0.0:*                           22781/asm_gcr0_+ASM 
udp        0      0 oracle-rac2-priv:36968  0.0.0.0:*                           23226/oracle+ASM2   
udp        0      0 oracle-rac2-priv:53365  0.0.0.0:*                           25162/ora_p008_orcl 
udp        0      0 localhost:37008         0.0.0.0:*                           22674/asm_mman_+ASM 
udp        0      0 oracle-rac2-priv:37008  0.0.0.0:*                           22674/asm_mman_+ASM 
udp        0      0 localhost:61739         0.0.0.0:*                           23613/ora_dia0_orcl 
udp        0      0 oracle-rac2-priv:37178  0.0.0.0:*                           25153/ora_p005_orcl 
udp        0      0 localhost:12604         0.0.0.0:*                           23023/asm_ppa7_+ASM 
udp        0      0 oracle-rac2-priv:12604  0.0.0.0:*                           23023/asm_ppa7_+ASM 
udp        0      0 localhost:20811         0.0.0.0:*                           25784/ora_m001_orcl 
udp        0      0 oracle-rac2-priv:29025  0.0.0.0:*                           23647/ora_lg01_orcl 
udp        0      0 oracle-rac2-priv:61800  0.0.0.0:*                           25162/ora_p008_orcl 
udp        0      0 localhost:61801         0.0.0.0:*                           24389/ora_tt02_orcl 
udp        0      0 localhost:37252         0.0.0.0:*                           23584/ora_diag_orcl 
udp        0      0 oracle-rac2-priv:45454  0.0.0.0:*                           20910/evmd.bin      
udp        0      0 oracle-rac2-priv:12715  0.0.0.0:*                           22709/asm_lmhb_+ASM 
udp        0      0 localhost:61907         0.0.0.0:*                           23559/ora_psp0_orcl 
udp        0      0 localhost:29206         0.0.0.0:*                           23611/ora_pman_orcl 
udp        0      0 oracle-rac2-priv:12849  0.0.0.0:*                           25166/ora_p00a_orcl 
udp        0      0 localhost:53824         0.0.0.0:*                           23729/ora_rsmn_orcl 
udp        0      0 oracle-rac2-priv:53852  0.0.0.0:*                           25168/ora_p00b_orcl 
udp        0      0 oracle-rac2-priv:37473  0.0.0.0:*                           25819/oracle+ASM2_m 
udp        0      0 localhost:12934         0.0.0.0:*                           25819/oracle+ASM2_m 
udp        0      0 oracle-rac2-priv:12934  0.0.0.0:*                           25819/oracle+ASM2_m 
udp        0      0 localhost:53907         0.0.0.0:*                           23266/oracle+ASM2   
udp        0      0 oracle-rac2-priv:53907  0.0.0.0:*                           23266/oracle+ASM2   
udp        0      0 oracle-rac2-priv:37588  0.0.0.0:*                           23617/ora_lms0_orcl 
udp        0      0 oracle-rac2-priv:45797  0.0.0.0:*                           22704/asm_lms0_+ASM 
udp        0      0 localhost:62186         0.0.0.0:*                           24577/ora_w003_orcl 
udp        0      0 oracle-rac2-priv:45817  0.0.0.0:*                           23025/asm_asmb_+ASM 
udp        0      0 oracle-rac2-priv:13080  0.0.0.0:*                           23266/oracle+ASM2   
udp        0      0 oracle-rac2-priv:54094  0.0.0.0:*                           22840/asm_m000_+ASM 
udp        0      0 oracle-rac2-priv:13141  0.0.0.0:*                           23621/ora_lmd0_orcl 
udp        0      0 localhost:21365         0.0.0.0:*                           22733/asm_mmon_+ASM 
udp        0      0 oracle-rac2-priv:21365  0.0.0.0:*                           22733/asm_mmon_+ASM 
udp        0      0 oracle-rac2-priv:21393  0.0.0.0:*                           25153/ora_p005_orcl 
udp        0      0 oracle-rac2-priv:45976  0.0.0.0:*                           25627/oracleorcl2   
udp        0      0 localhost:21429         0.0.0.0:*                           25263/ora_qm05_orcl 
udp        0      0 localhost:13239         0.0.0.0:*                           22642/asm_pmon_+ASM 
udp        0      0 oracle-rac2-priv:13239  0.0.0.0:*                           22642/asm_pmon_+ASM 
udp        0      0 localhost:13275         0.0.0.0:*                           22682/asm_diag_+ASM 
udp        0      0 oracle-rac2-priv:13275  0.0.0.0:*                           22682/asm_diag_+ASM 
udp        0      0 oracle-rac2-priv:21478  0.0.0.0:*                           25147/ora_p002_orcl 
udp        0      0 localhost:62473         0.0.0.0:*                           23619/ora_lms1_orcl 
udp        0      0 oracle-rac2-priv:46107  0.0.0.0:*                           23877/oracle+ASM2_o 
udp        0      0 localhost:46113         0.0.0.0:*                           23615/ora_lmon_orcl 
udp        0      0 oracle-rac2-priv:37990  0.0.0.0:*                           23722/ora_lck0_orcl 
udp        0      0 localhost:62591         0.0.0.0:*                           23653/ora_w000_orcl 
udp        0      0 localhost:62603         0.0.0.0:*                           25177/ora_p00e_orcl 
udp        0      0 localhost:29836         0.0.0.0:*                           23025/asm_asmb_+ASM 
udp        0      0 oracle-rac2-priv:29836  0.0.0.0:*                           23025/asm_asmb_+ASM 
udp        0      0 localhost:21677         0.0.0.0:*                           25164/ora_p009_orcl 
udp        0      0 oracle-rac2-priv:21677  0.0.0.0:*                           23573/ora_gen0_orcl 
udp        0      0 oracle-rac2-priv:62639  0.0.0.0:*                           23606/ora_svcb_orcl 
udp        0      0 localhost:54450         0.0.0.0:*                           22725/asm_pxmn_+ASM 
udp        0      0 oracle-rac2-priv:54450  0.0.0.0:*                           22725/asm_pxmn_+ASM 
udp        0      0 oracle-rac2-priv:46268  0.0.0.0:*                           23649/ora_smon_orcl 
udp        0      0 localhost:13524         0.0.0.0:*                           22728/asm_rbal_+ASM 
udp        0      0 oracle-rac2-priv:13524  0.0.0.0:*                           22728/asm_rbal_+ASM 
udp6       0      0 [::]:mdns               [::]:*                              20912/mdnsd.bin     
udp6       0      0 [::]:mdns               [::]:*                              20912/mdnsd.bin     
udp6       0      0 localhost:47775         [::]:*                              23688/ora_s000_orcl 
udp6       0      0 localhost:64529         [::]:*                              23686/ora_d000_orcl 
udp6       0      0 localhost:48670         [::]:*                              25267/oracleorcl2   
udp6       0      0 [::]:sunrpc             [::]:*                              744/rpcbind         
udp6       0      0 localhost:41276         [::]:*                              23674/oracle+ASM2_a 
udp6       0      0 [::]:894                [::]:*                              744/rpcbind         
udp6       0      0 localhost:51484         [::]:*                              22723/asm_lreg_+ASM 
udp6       0      0 localhost:43907         [::]:*                              23661/ora_lreg_orcl 
udp6       0      0 localhost:53992         [::]:*                              23030/oracle+ASM2_a 
udp6       0      0 localhost:21720         [::]:*                              20532/ohasd.bin     
[root@oracle-rac2 ~]# netstat -ulp | wc -l
412

[root@oracle-rac2 ~]# netstat -tlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name   
tcp        0      0 localhost:8126          0.0.0.0:*               LISTEN      891/trace-agent     
tcp        0      0 localhost:bootserver    0.0.0.0:*               LISTEN      20878/oraagent.bin  
tcp        0      0 oracle-rac2-priv:12132  0.0.0.0:*               LISTEN      22337/tnslsnr       
tcp        0      0 0.0.0.0:44132           0.0.0.0:*               LISTEN      21039/gpnpd.bin     
tcp        0      0 localhost:commplex-main 0.0.0.0:*               LISTEN      888/agent           
tcp        0      0 localhost:commplex-link 0.0.0.0:*               LISTEN      888/agent           
tcp        0      0 oracle-rac2-priv:11402  0.0.0.0:*               LISTEN      21258/osysmond.bin  
tcp        0      0 localhost:6062          0.0.0.0:*               LISTEN      890/process-agent   
tcp        0      0 0.0.0.0:sunrpc          0.0.0.0:*               LISTEN      744/rpcbind         
tcp        0      0 oracle-rac2-vi:ncube-lm 0.0.0.0:*               LISTEN      22337/tnslsnr       
tcp        0      0 localhost:ncube-lm      0.0.0.0:*               LISTEN      22337/tnslsnr       
tcp        0      0 localhost:synchronet-db 0.0.0.0:*               LISTEN      22473/ons           
tcp        0      0 oracle-rac2:prospero-np 0.0.0.0:*               LISTEN      22392/tnslsnr       
tcp        0      0 localhost:findviatv     0.0.0.0:*               LISTEN      1071/xrdp-sesman    
tcp        0      0 0.0.0.0:ssh             0.0.0.0:*               LISTEN      1931/sshd           
tcp        0      0 localhost:smtp          0.0.0.0:*               LISTEN      1401/master         
tcp6       0      0 [::]:fcp-addr-srvr1     [::]:*                  LISTEN      22337/tnslsnr       
tcp6       0      0 localhost:bootserver    [::]:*                  LISTEN      20878/oraagent.bin  
tcp6       0      0 [::]:29102              [::]:*                  LISTEN      23686/ora_d000_orcl 
tcp6       0      0 [::]:sunrpc             [::]:*                  LISTEN      744/rpcbind         
tcp6       0      0 localhost:synchronet-db [::]:*                  LISTEN      22473/ons           
tcp6       0      0 [::]:lm-x               [::]:*                  LISTEN      22473/ons           
tcp6       0      0 localhost:smtp          [::]:*                  LISTEN      1401/master


[root@oracle-rac2 ~]# netstat -utlp | grep tns
tcp        0      0 oracle-rac2-priv:12132  0.0.0.0:*               LISTEN      22337/tnslsnr       
tcp        0      0 oracle-rac2-vi:ncube-lm 0.0.0.0:*               LISTEN      22337/tnslsnr       
tcp        0      0 localhost:ncube-lm      0.0.0.0:*               LISTEN      22337/tnslsnr       
tcp        0      0 oracle-rac2:prospero-np 0.0.0.0:*               LISTEN      22392/tnslsnr       
tcp6       0      0 [::]:fcp-addr-srvr1     [::]:*                  LISTEN      22337/tnslsnr       
[root@oracle-rac2 ~]# netstat -utlp | grep pmon 
udp        0      0 localhost:15585         0.0.0.0:*                           23555/ora_pmon_orcl 
udp        0      0 oracle-rac2-priv:49495  0.0.0.0:*                           22642/asm_pmon_+ASM 
udp        0      0 localhost:13239         0.0.0.0:*                           22642/asm_pmon_+ASM 
udp        0      0 oracle-rac2-priv:13239  0.0.0.0:*                           22642/asm_pmon_+ASM 
[root@oracle-rac2 ~]# netstat -utlp | grep ocssd
udp        0      0 172.18.1.255:42424      0.0.0.0:*                           21401/ocssd.bin     
udp        0      0 230.0.1.0:42424         0.0.0.0:*                           21401/ocssd.bin     
udp        0      0 224.0.0.251:42424       0.0.0.0:*                           21401/ocssd.bin     
udp        0      0 oracle-rac2-priv:44653  0.0.0.0:*                           21401/ocssd.bin     
[root@oracle-rac2 ~]# netstat -utlp | grep ohas
udp        0      0 0.0.0.0:39748           0.0.0.0:*                           20532/ohasd.bin     
udp        0      0 oracle-rac2-priv:23948  0.0.0.0:*                           20532/ohasd.bin     
udp        0      0 172.18.1.255:42424      0.0.0.0:*                           20532/ohasd.bin     
udp        0      0 230.0.1.0:42424         0.0.0.0:*                           20532/ohasd.bin     
udp        0      0 224.0.0.251:42424       0.0.0.0:*                           20532/ohasd.bin     
udp6       0      0 localhost:21720         [::]:*                              20532/ohasd.bin     

所以,在云平台上安装rac,在安全组里,必须开启2个节点之间的所有udp和tcp端口。

找一个单机的Oracle环境:

代码语言:javascript
复制
[root@lhrora11203 /]#  netstat -tulp 
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name   
tcp        0      0 *:25072                     *:*                         LISTEN      968/ora_d000_LHR11G 
tcp        0      0 *:ncube-lm                  *:*                         LISTEN      844/tnslsnr         
tcp        0      0 *:ssh                       *:*                         LISTEN      790/sshd            
tcp        0      0 localhost:ipp               *:*                         LISTEN      746/cupsd           
tcp        0      0 *:ssh                       *:*                         LISTEN      790/sshd            
udp        0      0 localhost:27586             *:*                                     968/ora_d000_LHR11G 
udp        0      0 localhost:65056             *:*                                     936/ora_pmon_LHR11G 
udp        0      0 *:ipp                       *:*                                     746/cupsd           
udp        0      0 *:42111                     *:*                                     964/ora_mmon_LHR11G 
udp        0      0 localhost:48514             *:*                                     970/ora_s000_LHR11G 

也有部分udp端口。

本文结束。

本文参与 腾讯云自媒体同步曝光计划,分享自微信公众号。
原始发表:2023-10-07 07:43,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 DB宝 微信公众号,前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体同步曝光计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
目录
  • 原因一:共享盘掉了
  • 原因二:安全组封了
  • rac中的udp端口
相关产品与服务
文件存储
文件存储(Cloud File Storage,CFS)为您提供安全可靠、可扩展的共享文件存储服务。文件存储可与腾讯云服务器、容器服务、批量计算等服务搭配使用,为多个计算节点提供容量和性能可弹性扩展的高性能共享存储。腾讯云文件存储的管理界面简单、易使用,可实现对现有应用的无缝集成;按实际用量付费,为您节约成本,简化 IT 运维工作。
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档