查询Oracle RAC Cache Fusion通信的私有网络

最新推荐文章于 2021-04-06 08:32:41 发布
最新推荐文章于 2021-04-06 08:32:41 发布
阅读量6.8k 收藏
点赞数
分类专栏： Oracle Oracle RAC 文章标签： oracle Oracle ORACLE oracle rac Oracle RAC
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/staricqxyz/article/details/8530110
版权 
[oracle@zhongwc1 ~]$ cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 5.7 (Tikanga)
[oracle@zhongwc1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 22 15:12:35 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> oradebug setmypid
Statement processed.
SQL> oradebug ipc
Information written to trace file.
SQL> oradebug tracefile_name
/u01/app/oracle/diag/rdbms/zhongwc/zhongwc1/trace/zhongwc1_ora_31553.trc
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options


Oracle版本是11.2.0.3,从11.2.0.2开始引入了HAIP规则为169.254.xxx.xxx;RAC Cache Fusion通信的IP为169.254.218.13

SKGXP:[7f31b7724c68.96]{ctx}:SSKGXPT 0x7f31b772e848 flags 0x0  sockno 13 IP 169.254.218.13 UDP 30898 lerr 0
SKGXP:[7f31b7724c68.97]{ctx}:   SKGXPGPID Internet address 169.254.218.13 UDP port number 30898

[oracle@zhongwc1 ~]$ cat /u01/app/oracle/diag/rdbms/zhongwc/zhongwc1/trace/zhongwc1_ora_31553.trc
Trace file /u01/app/oracle/diag/rdbms/zhongwc/zhongwc1/trace/zhongwc1_ora_31553.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
System name:	Linux
Node name:	zhongwc1.oracle.com
Release:	2.6.32-200.13.1.el5uek
Version:	#1 SMP Wed Jul 27 21:02:33 EDT 2011
Machine:	x86_64
Instance name: zhongwc1
Redo thread mounted by this instance: 1
Oracle process number: 38
Unix process pid: 31553, image: oracle@zhongwc1.oracle.com (TNS V1-V3)


*** 2013-01-22 15:12:37.782
*** SESSION ID:(56.143) 2013-01-22 15:12:37.782
*** CLIENT ID:() 2013-01-22 15:12:37.782
*** SERVICE NAME:(SYS$USERS) 2013-01-22 15:12:37.782
*** MODULE NAME:(sqlplus@zhongwc1.oracle.com (TNS V1-V3)) 2013-01-22 15:12:37.782
*** ACTION NAME:() 2013-01-22 15:12:37.782
 
Processing Oradebug command 'setmypid'

*** 2013-01-22 15:12:37.782
Oradebug command 'setmypid' console output: <none>

*** 2013-01-22 15:12:39.777
Processing Oradebug command 'ipc'
Dump of unix-generic skgm context
areaflags            000000f7
realmflags           0000001f
mapsize              00000800
protectsize          00001000
lcmsize              00001000
seglen               00200000
largestsize  0000040000000000
smallestsize 0000000001000000
stacklimit     0x7fffafa932a0
stackdir                   -1
mode                      640
magic                acc01ade
Handle:        0x7f31b77150f0 `/u01/app/oracle/product/11.2.0/dbhome_1zhongwc1'
Dump of unix-generic realm handle `/u01/app/oracle/product/11.2.0/dbhome_1zhongwc1', flags = 00000000
 Area #0 `Fixed Size' containing Subareas 0-0
  Total size 000000000021ff10 Minimum Subarea size 00000000
   Area  Subarea    Shmid      Stable Addr      Actual Addr
      0        0  3735560 0x00000060000000 0x00000060000000
                              Subarea size     Segment size
                          0000000000220000 0000000001000000
 Area #1 `Variable Size' containing Subareas 4-4
  Total size 000000004b000000 Minimum Subarea size 01000000
   Area  Subarea    Shmid      Stable Addr      Actual Addr
      1        4  3768329 0x00000061000000 0x00000061000000
                              Subarea size     Segment size
                          000000004b000000 000000004b000000
 Area #2 `Redo Buffers' containing Subareas 1-1
  Total size 0000000000870000 Minimum Subarea size 00000000
   Area  Subarea    Shmid      Stable Addr      Actual Addr
      2        1  3735560 0x00000060220000 0x00000060220000
                              Subarea size     Segment size
                          0000000000870000 0000000001000000
 Area #3 `Base Allocator Control' containing Subareas 3-3
  Total size 0000000000002000 Minimum Subarea size 00000000
   Area  Subarea    Shmid      Stable Addr      Actual Addr
      3        3  3735560 0x00000060ffe000 0x00000060ffe000
                              Subarea size     Segment size
                          0000000000002000 0000000001000000
 Area #4 `Slab Allocator Control' containing Subareas 2-2
  Total size 000000000056e000 Minimum Subarea size 00000000
   Area  Subarea    Shmid      Stable Addr      Actual Addr
      4        2  3735560 0x00000060a90000 0x00000060a90000
                              Subarea size     Segment size
                          000000000056e000 0000000001000000
 Area #5 `skgm overhead' containing Subareas 5-5
  Total size 0000000000002000 Minimum Subarea size 00000000
   Area  Subarea    Shmid      Stable Addr      Actual Addr
      5        5  3801098 0x000000ac000000 0x000000ac000000
                              Subarea size     Segment size
                          0000000000002000 0000000000200000
Dump of Linux-specific skgm context
sharedmmu 00000001
shareddec        0
used region        0: start 0000000060000000 length 000000004d000000
used region        1: start 0000003e61000000 length 0000000003000000
used region        2: start 0000003e66000000 length 0000000001000000
Maximum processes:               = 800
Number of semaphores per set:    = 201
Semaphores key overhead per set: = 4
User Semaphores per set:         = 197
Number of semaphore sets:        = 5
Semaphore identifiers:           = 5
Semaphore List=
2097154
2129923
2162692
2195461
2228230
-------------- system semaphore information -------------
------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status      
0x00000000 2031617    root      644        80         2                       
0x00000000 2064386    root      644        16384      2                       
0x00000000 2097155    root      644        280        2                       
0x00000000 2359301    grid      640        4096       0                       
0x00000000 2392070    grid      640        4096       0                       
0xed304ac0 2424839    grid      640        4096       0                       
0x00000000 3735560    oracle    640        4096       0                       
0x00000000 3768329    oracle    640        4096       0                       
0x62385348 3801098    oracle    640        4096       0                       
------ Semaphore Arrays --------
key        semid      owner      perms      nsems     
0x869d3e0c 262145     grid      640        124       
0xb5514170 2097154    oracle    640        201       
0xb5514171 2129923    oracle    640        201       
0xb5514172 2162692    oracle    640        201       
0xb5514173 2195461    oracle    640        201       
0xb5514174 2228230    oracle    640        201       
------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages    
ksxpdmp:  facility 0 (?) (0x0, (nil)) counts 0, 0
Dumping the osd state
  Dumping the osd context (brief)
SKGXP:[7f31b7724c68.0]{ctx}: SKGXPCTX: 0x0x7f31b7724c68 ctx   
SKGXP:[7f31b7724c68.1]{ctx}: Compatible: 0 0.0 0
SKGXP:[7f31b7724c68.2]{ctx}: SKGXP Versions: 3.3.4.2.2.c0.4(3.2.4.1)
SKGXP:[7f31b7724c68.3]{ctx}: DBG flags1: 0
SKGXP:[7f31b7724c68.4]{ctx}: DBG post_type: 0
SKGXP:[7f31b7724c68.5]{ctx}: DBG post_sig: 0
SKGXP:[7f31b7724c68.6]{ctx}: DBG post_send_thresh: 0
SKGXP:[7f31b7724c68.7]{ctx}: DBG post_timing: 0
SKGXP:[7f31b7724c68.8]{ctx}: DBG post_trace_all: 0
SKGXP:[7f31b7724c68.9]{ctx}: DBG dev_poll: 0
SKGXP:[7f31b7724c68.10]{ctx}: 
SKGXP:[7f31b7724c68.11]{ctx}: WAIT HISTORY
SKGXP:[7f31b7724c68.12]{ctx}: Wait Time  Time since     Fast reaps  Wait Type  Return Code
SKGXP:[7f31b7724c68.13]{ctx}:   (ms)     prev wait(ms)  before                           
SKGXP:[7f31b7724c68.14]{ctx}: ---------  -------------- ----------- ---------  -----------
SKGXP:[7f31b7724c68.15]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.16]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.17]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.18]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.19]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.20]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.21]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.22]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.23]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.24]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.25]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.26]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.27]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.28]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.29]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.30]{ctx}: 0          0              0           NORMAL     invalid status code
SKGXP:[7f31b7724c68.31]{ctx}: wait delta 3 sec (3883 msec) ctx ts 0x0 last ts 0x0
SKGXP:[7f31b7724c68.32]{ctx}: user cpu time since last wait 0 sec 140733193388032 ticks
SKGXP:[7f31b7724c68.33]{ctx}: system cpu time since last wait 0 sec 140733193388032 ticks
SKGXP:[7f31b7724c68.34]{ctx}: locked 2
SKGXP:[7f31b7724c68.35]{ctx}: blocked 0
SKGXP:[7f31b7724c68.36]{ctx}: timed wait receives 0
SKGXP:[7f31b7724c68.37]{ctx}: fast reaps since last wait 0
SKGXP:[7f31b7724c68.38]{ctx}: context timestamp 0
SKGXP:[7f31b7724c68.39]{ctx}: flags=1 flags1=30 zcpyflg=5824 iflags=820 aflags=80 trcflags=0 trclevel=3
SKGXP:[7f31b7724c68.40]{ctx}: rcvbuf=131072 sndbuf=262144
SKGXP:[7f31b7724c68.41]{ctx}: 
SKGXP:[7f31b7724c68.42]{ctx}: admno 0x5c339b5a admport:
SKGXP:[7f31b7724c68.43]{ctx}: 	SSKGXPT 0x7f31b7726390 flags 0x5 { READPENDING } sockno 5 IP 169.254.218.13 UDP 49793 lerr 0
SKGXP:[7f31b7724c68.44]{ctx}: 
SKGXP:[7f31b7724c68.45]{ctx}: post port: 
SKGXP:[7f31b7724c68.46]{ctx}: 	SSKGXPT 0x7f31b77267e8 flags 0x0  sockno 8 IP 127.0.0.1 UDP 26916 lerr 0
SKGXP:[7f31b7724c68.47]{ctx}: 
SKGXP:[7f31b7724c68.48]{ctx}: sconno [693611d6, 693611d6]=0 aconno [507a7b6d, 507a7b6d]=0
SKGXP:[7f31b7724c68.49]{ctx}: 
SKGXP:[7f31b7724c68.50]{ctx}: 
SKGXP:[7f31b7724c68.51]{ctx}: memory (native) allocs 5 free 1 lost 0 out 5712 max 32768
SKGXP:[7f31b7724c68.52]{ctx}: 
SKGXP:[7f31b7724c68.53]{ctx}: ctx(10296) sctx(1920) rqh(1040) cid(24)
SKGXP:[7f31b7724c68.54]{ctx}: prt(464) cnh(1936/15040) ach(1544/14648) rpc(2400) pid(64)
SKGXP:[7f31b7724c68.55]{ctx}: rgnst(472) rgnpt(248) rgn(8056) rbd(120) bid(64) mcph(7872/20976) mupdh(1144/14248)
SKGXP:[7f31b7724c68.56]{ctx}: mcb(852008) smap(4184) nsm(2084) me(1040) mcbe(48) mcbi(24) epid(40)
SKGXP:[7f31b7724c68.57]{ctx}: mhdr(76) fhdr(28) madm(272) aggpid(32)
SKGXP:[7f31b7724c68.58]{ctx}: sta msc(448) cnh(344) prt(216) ep(48)
SKGXP:[7f31b7724c68.59]{ctx}: aggpt(192) swin(384) finfo(176) segf(200)
SKGXP:[7f31b7724c68.60]{ctx}: 
SKGXP:[7f31b7724c68.61]{ctx}: done Queue
SKGXP:[7f31b7724c68.62]{ctx}: 	no completed requests
SKGXP:[7f31b7724c68.63]{ctx}: 
SKGXP:[7f31b7724c68.64]{ctx}: connection Queue
SKGXP:[7f31b7724c68.65]{ctx}: 	no pending connect disconnect operations
SKGXP:[7f31b7724c68.66]{ctx}: 
SKGXP:[7f31b7724c68.67]{ctx}: sends waiting to be transmitted
SKGXP:[7f31b7724c68.68]{ctx}: 	no sends waiting to be transmitted
SKGXP:[7f31b7724c68.69]{ctx}: 
SKGXP:[7f31b7724c68.70]{ctx}: pending ack Queue
SKGXP:[7f31b7724c68.71]{ctx}: 	no send requests pending ack
SKGXP:[7f31b7724c68.72]{ctx}: 
SKGXP:[7f31b7724c68.73]{ctx}: Vrpc requests pending reply
SKGXP:[7f31b7724c68.74]{ctx}: 
SKGXP:[7f31b7724c68.75]{ctx}: Port queue
SKGXP:[7f31b7724c68.76]{ctx}: 
SKGXP:[7f31b7724c68.77]{ctx}: Region queue
SKGXP:[7f31b7724c68.78]{ctx}: SKGXPRGN: 0x7f31b6efdd30
SKGXP:[7f31b7724c68.79]{ctx}:    region id 0xcf2f rgn idx: 0 rgn key: 127980261
SKGXP:[7f31b7724c68.80]{ctx}:    base address 0x61000000 size: 1258291200
SKGXP:[7f31b7724c68.81]{ctx}:    flags 0x0 state: 0x2 largest buffer: 0
SKGXP:[7f31b7724c68.82]{ctx}:    num bids prepared: 0
SKGXP:[7f31b7724c68.83]{ctx}: SKGXPRGNSTATE: 0x7f31b77261a0
SKGXP:[7f31b7724c68.84]{ctx}: 	rgns mapped: 1 num shared: 1 max: 1
SKGXP:[7f31b7724c68.85]{ctx}: 	flags: 0 bseqno: 19445 nxtrgnno: 53039
SKGXP:[7f31b7724c68.86]{ctx}: 	shared ports open: 1 limits (1,16)
SKGXP:[7f31b7724c68.87]{ctx}: 	shared bids prepared: 0 hiwat: 0
SKGXP:[7f31b7724c68.88]{ctx}: 	space - used: 0 max possible: 4194304 sock limit: 524288
SKGXP:[7f31b7724c68.89]{ctx}: 	rgnarr[0x7f31b772e718(32)] rgnpts[0]=0x7f31b772e838
SKGXP:[7f31b7724c68.90]{ctx}:   REGION ARRAY
SKGXP:[7f31b7724c68.91]{ctx}: 	rgn mapped[0] = 0x7f31b6efdd30
SKGXP:[7f31b7724c68.92]{ctx}:   SHARED PORT ARRAY
SKGXP:[7f31b7724c68.93]{ctx}:    rgn port[0]=0x7f31b772e838
SKGXP:[7f31b7724c68.94]{ctx}: 	SKGXPRGNPORT: 0x7f31b772e838
SKGXP:[7f31b7724c68.95]{ctx}: 	nbids: 0 space: 0 used: 0
SKGXP:[7f31b7724c68.96]{ctx}: 	SSKGXPT 0x7f31b772e848 flags 0x0  sockno 13 IP 169.254.218.13 UDP 30898 lerr 0
SKGXP:[7f31b7724c68.97]{ctx}:   SKGXPGPID Internet address 169.254.218.13 UDP port number 30898
SKGXP:[7f31b7724c68.98]{ctx}: 
SKGXP:[7f31b7724c68.99]{ctx}: Dumping Connection Handle Table
SKGXP:[7f31b7724c68.100]{ctx}:                hdl     sconno     aconno      admno   RmtPid  state   seq#       msgs     rtrans    credits      rtt   last ack         id               ip 
SKGXP:[7f31b7724c68.101]{ctx}: 
SKGXP:[7f31b7724c68.102]{ctx}: Dumping Accept Handle Table
SKGXP:[7f31b7724c68.103]{ctx}: 
Done dumping the osd state
Dumping ksxp state
  ksxppg=0x7f31b71e47a8 ksxpsg=0xa7584ed8 ksxpsg_a=0xa7584ed8ksxpssg=0xa7584c20 rm=0xa7584b98
proc state: (pid: 38) [flg: 1 sg: 1]
 curts 1358838759 wtctr 0
  Dumping ksxp contexts
    Context[2] 0x7f31b6f06430 GES state 1
      Dumping region queue
       region count: 0
      Dumping connection queue
       connection count: 0
      Dumping done requests queue
       done requests count: 0
      Dumping mupq requests queue
       mupq requests count: 0
      Dumping zombie requests queue
       zombie requests count: 0
      Dumping delayed callback requests queue
       delayed callback requests count: 0
    Context[1] 0x7f31b6effcc0 gc ksxp component context state 1
      Dumping region queue
       region count: 1
      Dumping connection queue
       connection count: 0
      Dumping done requests queue
       done requests count: 0
      Dumping mupq requests queue
       mupq requests count: 0
      Dumping zombie requests queue
       zombie requests count: 0
      Dumping delayed callback requests queue
       delayed callback requests count: 0
  Dumping pending request queue
   pending request count: 0

*** 2013-01-22 15:12:39.785
Oradebug command 'ipc' console output: 
Information written to trace file.

*** 2013-01-22 15:12:43.443
Processing Oradebug command 'tracefile_name'

*** 2013-01-22 15:12:43.443
Oradebug command 'tracefile_name' console output: 
/u01/app/oracle/diag/rdbms/zhongwc/zhongwc1/trace/zhongwc1_ora_31553.trc
[root@zhongwc1 ~]# ifconfig
eth0      Link encap:Ethernet  HWaddr 08:00:27:8A:E2:5D  
          inet addr:192.168.1.51  Bcast:192.168.255.255  Mask:255.255.0.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:3389451 errors:0 dropped:0 overruns:0 frame:0
          TX packets:6201119 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:339395793 (323.6 MiB)  TX bytes:8658068977 (8.0 GiB)

eth0:1    Link encap:Ethernet  HWaddr 08:00:27:8A:E2:5D  
          inet addr:192.168.1.151  Bcast:192.168.255.255  Mask:255.255.0.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth0:2    Link encap:Ethernet  HWaddr 08:00:27:8A:E2:5D  
          inet addr:192.168.1.59  Bcast:192.168.255.255  Mask:255.255.0.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth1      Link encap:Ethernet  HWaddr 08:00:27:37:B2:DB  
          inet addr:172.168.1.51  Bcast:172.168.255.255  Mask:255.255.0.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:2615419 errors:0 dropped:0 overruns:0 frame:0
          TX packets:2134909 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:1933439785 (1.8 GiB)  TX bytes:1296037536 (1.2 GiB)

eth1:1    Link encap:Ethernet  HWaddr 08:00:27:37:B2:DB  
          inet addr:169.254.218.13  Bcast:169.254.255.255  Mask:255.255.0.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:479910 errors:0 dropped:0 overruns:0 frame:0
          TX packets:479910 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:398794404 (380.3 MiB)  TX bytes:398794404 (380.3 MiB)

以下截取AWR报告中的片段

Cluster Interconnect

  • if IP/Public/Source at End snap is different a '*' is displayed
  Begin End
Interface IP Address Pub Source IP Pub Src
eth1:1 169.254.218.13 N        


在Oracle11g中可以查询X$KSXPIA也能找到用于Cache Fusion的网络接口

SQL> select * from x$ksxpia;

ADDR			   INDX    INST_ID PUB_KSXPIA PICKED_KSXPIA   NAME_KSXPIA     IP_KSXPIA
-------------------- ---------- ---------- ---------- --------------- --------------- ----------------
00007F1525B98998	      0 	 1 N	      GPnP	      eth1:1	      169.254.218.13
00007F1525B98998	      1 	 1 Y	      GPnP	      eth0	      192.168.1.51
00007F1525B98998	      2 	 1 Y	      GPnP	      eth0:1	      192.168.1.151
00007F1525B98998	      3 	 1 Y	      GPnP	      eth0:2	      192.168.1.59


ZhongWeicheng
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle RAC Cache Fusion介绍.pdf
10-14
Oracle RAC Cache Fusion介绍.pdf
oracle rac通讯,查询Oracle RAC Cache Fusion通信的私有网络
weixin_35051143的博客
04-02 338
查询Oracle RAC Cache Fusion通信的私有网络[Oracle@zhongwc1 ~]$ cat /etc/RedHat-releaseRed Hat Enterprise Linux Server release 5.7 (Tikanga)[oracle@zhongwc1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Pr...
查看oracle rac 各节点公网，私网ip信息
Lixora's DB Home
08-27 5956
-----集群私网连接信息： select * from gv$cluster_interconnects;  INST_ID NAME  IP_ADDRESS           IS_PUBLIC SOURCE ---------- ----- -------------------- --------- ------------------------------          
关于RAC的私有网络
congjuyan5037的博客
01-16 131
select * from v$configured_interconnects; NAME IP_ADDRESS IS_PUBLIC SOURCE CON_ID 1 eth1:1 169.254...
oracle私网心跳怎么查询,查看oracle rac 各节点公网，私网ip信息
weixin_42294133的博客
04-06 507
-----集群私网连接信息：select * from gv$cluster_interconnects;INST_ID NAME IP_ADDRESS IS_PUBLIC SOURCE---------- ----- -------------------- --------- ------------------------------1 eth1 192.168.94...
如何在oracle 集群中更换私有网络的网卡
Rhys learn oracle！
03-17 1819
如何在oracle 集群中更换私有网络的网卡。     今天是2014-03-17，目前学习进度也正在紧锣密鼓的进行着，今天把一小部分实验在做一下记录一下笔记。 我们知道RAC网络有私有网络和公用网络，公用网络提供客户访问请求，私用网络提供oracle 的cache fusion和节点心跳等作用，因为在11G R2可以执行4个private network 进行cache fusion。 但
Understanding Oracle RAC Internals - The Cache Fusion Edition
06-09
Oracle cache fushion技术原理讲解，非常有技术含量的文档，Understanding Oracle RAC Internals - The Cache Fusion Edition
RAC cache fusion机制实现原理分析
09-10
本文将详细介绍RAC cache fusion机制实现原理，需要了解更多的朋友可以参考下
oracle rac 不停机调整时间.txt
04-12
oracle rac 不停机调整时间.txt
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一)
热门推荐
Zhong Weicheng Study Notes
12-28 1万+
有关于Oracle Linux 6的安装可以参考Oracle Linux 6 Installation。安装两台OL6分配两个网卡内存均为3G,hostname分别为node1和node2。 OS版本你也可以选择CentOS6或者是RHEL6,建议初次安装选择CentOS6/RHEL6。选择Oracle Linux6可以使用OL6提供的oracle-rdbms-server-11gR2-prei
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (四)
Zhong Weicheng Study Notes
12-29 1万+
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (三) 将安装介质上传到node1,解压准备安装grid infrast
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (三)
Zhong Weicheng Study Notes
12-28 1万+
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二) 配置共享磁盘,本次实验环境是基于VMware ESXi 5搭建。 和vbox配置差不多,具体过程略,关闭node1,node2,说明一下需要注意的地方 SCSI
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二)
Zhong Weicheng Study Notes
12-28 1万+
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 在所有node上创建oracle,grid用户,创建相关目录 [root@node2 ~]# groupadd -g 1000 oinstall [root@node2 ~]# groupadd -g 1200 asmadmin [root@node2 ~]# groupadd
Add a Node to Oracle RAC 11gR2(11.2.0.3) on Oracle Linux 6
Zhong Weicheng Study Notes
01-05 1万+
Delete a Node from Oracle RAC 11gR2(11.2.0.3) on Oracle Linux 6 This guide shows how to add a node to an existing 11gR2(11.2.0.3) Oracle RAC cluster. It is assumed that the node in question is
Delete a Node from Oracle RAC 11gR2(11.2.0.3) on Oracle Linux 6
Zhong Weicheng Study Notes
01-05 1万+
Add a Node to Oracle RAC 11gR2(11.2.0.3) on Oracle Linux 6 This guide shows how to remove a node from an existing 11gR2 Oracle RAC cluster. It is assumed that the node in question is available an
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (五)
Zhong Weicheng Study Notes
12-29 8974
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (三) 使用UDEV在Oracle Linux 6上安装Oracle 11g R
Installation Oracle11gR2 RAC on SuSE Linux Enterprise Server 11
Zhong Weicheng Study Notes
12-30 6730
SLES11安装参考博文 Installation SUSE Linux Enterprise Server 11 vzwc1:~ # cat /etc/issue Welcome to SUSE Linux Enterprise Server 11 SP3 (x86_64) - Kernel \r (\l). vzwc1:~ # 配置/etc/hosts文件 192.1
GoldenGate将Oracle数据同步到GreenPlum
Zhong Weicheng Study Notes
02-16 6715
源端 Oracle 11.2.0.4 RAC 2-Nodes Oracle Linux 5.8 x86_64 目标端 Greenplum Database 4.2.6.1 4-Nodes CentOS 5.7 x86_64 ====================================================== 源端配置 --本例是将OGG安
oracle rac 机器重启后，私有IP消失
最新发布
06-09
在Oracle RAC中，私有IP地址是通过Oracle Clusterware资源管理框架来分配和管理的，如果私有IP地址在机器重启后消失了，可能是以下原因之一： 1. 网络配置问题：检查网络配置是否正确，包括网络接口和路由器设置等。 2. Oracle Clusterware问题：检查Oracle Clusterware是否正常运行，并且检查资源状态是否正确。 3. 操作系统问题：检查操作系统是否正确配置了网络接口和路由，以及是否正确安装了Oracle Clusterware。 解决方法： 1. 检查网络配置：确保网络接口和路由器设置正确，并且可以在操作系统命令行中使用ping命令测试私有IP地址是否可用。 2. 检查Oracle Clusterware：使用crsctl命令检查Oracle Clusterware的状态，如果存在问题，则使用crsctl命令重新启动Oracle Clusterware。 3. 检查操作系统：检查操作系统是否正确配置了网络接口和路由，以及是否正确安装了Oracle Clusterware。如果出现问题，则重新配置或重新安装操作系统和Oracle Clusterware。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值