Oracle 11g RAC + DG installation details-04
6. Verify 1. Start em verification
two。 Log in to sqlplus to check
[oracle@TRAC1 ~] $sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 6 16:51:23 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP
Data Mining and Real Application Testing options
SQL > select instance_name,thread#,status from gv$instance
INSTANCE_NAME THREAD#
STATUS
-
TRAC1 1
OPEN
TRAC2 2
3.ifconfig
Node 1
[oracle@TRAC1] $ifconfig-a
Bond0 Link encap:Ethernet HWaddr 18:66:DA:EF:22:E0
Inet addr:192.168.1.1 Bcast:192.168.1.255 Mask:255.255.255.0
Inet6 addr: fe80::1a66:daff:feef:22e0/64 Scope:Link
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1
RX packets:27014987 errors:0 dropped:0 overruns:0 frame:0
TX packets:92428628 errors:0 dropped:0 overruns:0 carrier:0
Collisions:0 txqueuelen:0
RX bytes:11364667269 (10.5 GiB) TX bytes:134319246728 (125.0 GiB)
Bond0:1 Link encap:Ethernet HWaddr 18:66:DA:EF:22:E0
Inet addr:192.168.1.3 Bcast:192.168.1.255 Mask:255.255.255.0
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1
Bond0:2 Link encap:Ethernet HWaddr 18:66:DA:EF:22:E0
Inet addr:192.168.1.5 Bcast:192.168.1.255 Mask:255.255.255.0
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1
Em1 Link encap:Ethernet HWaddr 18:66:DA:EF:22:E0
UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1
RX packets:26972058 errors:0 dropped:0 overruns:0 frame:0
TX packets:92428628 errors:0 dropped:0 overruns:0 carrier:0
Collisions:0 txqueuelen:1000
RX bytes:11360137420 (10.5 GiB) TX bytes:134319246728 (125.0 GiB)
Interrupt:41
Em2 Link encap:Ethernet HWaddr 18:66:DA:EF:22:E0
UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1
RX packets:42929 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
Collisions:0 txqueuelen:1000
RX bytes:4529849 (4.3 MiB) TX bytes:0 (0.0b)
Interrupt:45
Em3 Link encap:Ethernet HWaddr 18:66:DA:EF:22:E2
Inet addr:10.1.1.1 Bcast:10.188.42.255 Mask:255.255.255.0
Inet6 addr: fe80::1a66:daff:feef:22e2/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:497859 errors:0 dropped:0 overruns:0 frame:0
TX packets:467126 errors:0 dropped:0 overruns:0 carrier:0
Collisions:0 txqueuelen:1000
RX bytes:303233404 (289.1 MiB) TX bytes:308071807 (293.8 MiB)
Interrupt:40
Em3:1 Link encap:Ethernet HWaddr 18:66:DA:EF:22:E2
Inet addr:169.254.193.100 Bcast:169.254.255.255 Mask:255.255.0.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:40
Em4 Link encap:Ethernet HWaddr 18:66:DA:EF:22:E3
Inet addr:192.168.1.6 Bcast:192.168.1.255 Mask:255.255.255.0
Inet6 addr: fe80::1a66:daff:feef:22e3/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:42297 errors:0 dropped:0 overruns:0 frame:0
TX packets:540 errors:0 dropped:0 overruns:0 carrier:0
Collisions:0 txqueuelen:1000
RX bytes:4432306 (4.2 MiB) TX bytes:94741 (92.5 KiB)
Interrupt:44
Lo Link encap:Local Loopback
Inet addr:127.0.0.1 Mask:255.0.0.0
Inet6 addr: 1/128 Scope:Host
UP LOOPBACK RUNNING MTU:65536 Metric:1
RX packets:284965 errors:0 dropped:0 overruns:0 frame:0
TX packets:284965 errors:0 dropped:0 overruns:0 carrier:0
Collisions:0 txqueuelen:0
RX bytes:125597511 (119.7 MiB) TX bytes:125597511 (119.7 MiB)
[oracle@TRAC2] $ifconfig-a
Bond0 Link encap:Ethernet HWaddr 18:66:DA:EF:30:28
Inet addr:192.168.1.2 Bcast:192.168.1.255 Mask:255.255.255.0
Inet6 addr: fe80::1a66:daff:feef:3028/64 Scope:Link
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1
RX packets:49128874 errors:0 dropped:0 overruns:0 frame:0
TX packets:41801949 errors:0 dropped:0 overruns:0 carrier:0
Collisions:0 txqueuelen:0
RX bytes:51230789674 (47.7GiB) TX bytes:34494201349 (32.1GiB)
Bond0:1 Link encap:Ethernet HWaddr 18:66:DA:EF:30:28
Inet addr:192.168.1.4 Bcast:192.168.1.255 Mask:255.255.255.0
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1
Em1 Link encap:Ethernet HWaddr 18:66:DA:EF:30:28
UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1
RX packets:6711042 errors:0 dropped:0 overruns:0 frame:0
TX packets:1794287 errors:0 dropped:0 overruns:0 carrier:0
Collisions:0 txqueuelen:1000
RX bytes:9560067681 (8.9 GiB) TX bytes:230069093 (219.4 MiB)
Interrupt:41
Em2 Link encap:Ethernet HWaddr 18:66:DA:EF:30:28
UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1
RX packets:62811 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
Collisions:0 txqueuelen:1000
RX bytes:6558721 (6.2MiB) TX bytes:0 (0.0b)
Interrupt:45
Em3 Link encap:Ethernet HWaddr 18:66:DA:EF:30:2A
Inet addr:10.1.1.2 Bcast:10.188.42.255 Mask:255.255.255.0
Inet6 addr: fe80::1a66:daff:feef:302a/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:535845 errors:0 dropped:0 overruns:0 frame:0
TX packets:464105 errors:0 dropped:0 overruns:0 carrier:0
Collisions:0 txqueuelen:1000
RX bytes:316346768 (301.6 MiB) TX bytes:301390718 (287.4 MiB)
Interrupt:40
Em3:1 Link encap:Ethernet HWaddr 18:66:DA:EF:30:2A
Inet addr:169.254.128.41 Bcast:169.254.255.255 Mask:255.255.0.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:40
Em4 Link encap:Ethernet HWaddr 18:66:DA:EF:30:2B
Inet addr:192.168.1.7 Bcast:192.168.1.255 Mask:255.255.255.0
Inet6 addr: fe80::1a66:daff:feef:302b/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:61972 errors:0 dropped:0 overruns:0 frame:0
TX packets:739 errors:0 dropped:0 overruns:0 carrier:0
Collisions:0 txqueuelen:1000
RX bytes:6435002 (6.1 MiB) TX bytes:128744 (125.7 KiB)
Interrupt:44
Lo Link encap:Local Loopback
Inet addr:127.0.0.1 Mask:255.0.0.0
Inet6 addr: 1/128 Scope:Host
UP LOOPBACK RUNNING MTU:65536 Metric:1
RX packets:1889685 errors:0 dropped:0 overruns:0 frame:0
TX packets:1889685 errors:0 dropped:0 overruns:0 carrier:0
Collisions:0 txqueuelen:0
RX bytes:1080404664 (1.0 GiB) TX bytes:1080404664 (1.0 GiB)
7. Configure Oracle direct NFS1. Use only when testing using NFS as a data file system
Node 1
Add configuration file / etc/oranfstab
[oracle@TRAC1 ~] $vi / etc/oranfstab
Server: TRAC1
Path: 188.188.42.233
Export: / home/datashare mount: / data
Root execution
Cd / home/app/oracle/product/11.2.0/lib
Mv libodm11.so libodm11.so.bak
Ln-s libnfsodm11.so libodm11.so
Cd / home/app/grid/crs/lib
Mv libodm11.so libodm11.so.bak
Ln-s libnfsodm11.so libodm11.so
Node 2
Add configuration file / etc/oranfstab
[oracle@TRAC1 ~] $vi / etc/oranfstab
Server: TRAC2
Path: 188.188.42.233
Export: / home/datashare mount: / data
Root execution
Cd / home/app/oracle/product/11.2.0/lib
Mv libodm11.so libodm11.so.bak
Ln-s libnfsodm11.so libodm11.so
Cd / home/app/grid/crs/lib
Mv libodm11.so libodm11.so.bak
Ln-s libnfsodm11.so libodm11.so
Restart ASM and database
[grid@TRAC1] $srvctl stop database-d TRAC
[grid@TRAC1] $srvctl stop asm-f
[grid@TRAC1 ~] $srvctl start asm
[grid@TRAC1] $srvctl start database-d TRAC
Modify mount parameters
Node 1.2
Mount-t nfs-o vers=3 188.188.42.233:/home/datashare / data
two。 Fallback does not use direct NFS
Node 1
[root@TRAC1] # / home/app/grid/crs/bin/crsctl stop cluster-all
Node 1 ~ 2 ~ root execution
Rm-f / etc/oranfstab
Cd / home/app/oracle/product/11.2.0/lib
Rm-f libodm11.so
Mv libodm11.so.bak libodm11.so
Cd / home/app/grid/crs/lib
Rm-f libodm11.so
Mv libodm11.so.bak libodm11.so
Restart ASM and database
Node 1
[root@TRAC1] # / home/app/grid/crs/bin/crsctl start cluster-all
[grid@TRAC1] $srvctl start database-d TRAC
