Oracle Study-AIX6.1 to build Oracle 10gR2 RAC (2)
Oracle Study-AIX6.1 to build Oracle 10gR2 RAC (2)
1. Check the system iCandle O (for Oracle databases, you need to enable asynchronous iMaguo)
For AIX6.1, the default asynchronous Iamp O is automatically activated when required and does not need to be configured.
[root@aix203 /] # ioo-a | grep aio
Aio_active = 0 aio_maxreqs = 65536 aio_maxservers = 30 aio_minservers = 3 aio_server_inactivity = 300 posix_aio_active = 0 posix_aio_maxreqs = 65536 posix_aio_maxservers = 30 posix_aio_minservers = 3 posix_aio_server_inactivity = 300
Second, configure the host trust relationship between nodes:
[root@aix203 /] # cat / etc/hosts.equiv aix203 rootaix204 rootaix203-vip rootaix204-vip rootaix203-priv rootaix204-priv rootaix203 oracleaix204 oracleaix203-vip oracleaix204-vip oracleaix203-priv oracleaix204-priv oracle [root@aix203 /] # cat .rhostsaix203 rootaix204 rootaix203-vip rootaix204-vip rootaix203-priv rootaix204-priv rootaix203 oracleaix204 oracleaix203-vip oracleaix204-vip oracleaix203-priv oracleaix204-priv oracle [oracle@aix203 ~] $cat .rhostsaix203 rootaix204 rootaix203-vip rootaix204-vip rootaix203-priv rootaix204-priv rootaix203 oracleaix204 oracleaix203-vip oracleaix204-vip oracleaix203-priv oracleaix204-priv oracle
Verify the host trust relationship:
[oracle@aix203 ~] $rsh aix204 date
Tue Mar 15 16:18:47 CDT 2016
[oracle@aix203 ~] $rsh aix204-priv date
Tue Mar 15 16:18:50 CDT 2016
[oracle@aix204 ~] $rsh aix203 date
Tue Mar 15 16:17:12 CDT 2016
[oracle@aix204 ~] $rsh aix203-priv date
Tue Mar 15 16:18:26 CDT 2016
3. Configure time synchronization (NTP)
NTP SERVER:
[root@aix203 /] # cat / etc/ntp.conf
# Default NTP configuration file.
# Broadcast client, no authentication.
Broadcastclient
Driftfile / etc/ntp.drift
Tracefile / etc/ntp.trace
Server 127.127.1.0
NTP CLIENT:
[root@aix204 /] # cat / etc/ntp.conf
# Default NTP configuration file.
#
# Broadcast client, no authentication.
#
# broadcastclient
Driftfile / etc/ntp.drift
Tracefile / etc/ntp.trace
Server 192.168.8.203
Start ntp services:
[root@aix203 /] # smit xntpd;; start ntp service
[root@aix203 /] # lager ls xntpd
Program name: / usr/sbin/xntpd Version: 3 Leap indicator: 11 (Leap indicator is insane.) Sys peer: no peer, system is insane Sys stratum: 16 Sys precision:-17 Debug/Tracing: DISABLED Root distance: 0.000000 Root dispersion: 0.000000 Reference ID: no refid, system is insane Reference time: no reftime System is insane Broadcast delay: 0.003906 (sec) Auth delay: 0.000122 (sec) System flags: bclient pll monitor filegen System uptime: 5 (sec) Clock stability: 0.000000 (sec) Clock frequency: 0.000000 (sec) Peer: 127.127.1.0 flags: (configured) (refclock) stratum: 3, version: 3 our mode: client His mode: server Subsystem Group PID Status xntpd tcpip 3604550 active
4. Configure the transmission parameters of VPC between node
[root@aix203 /] # lsattr-El sys0-a pre520tune
Pre520tune disable Pre-520 tuning compatibility mode True
[root@aix203 /] # no-a | grep tcp
Hstcp = 0 tcp_bad_port_limit = 0 tcp_cwnd_modified = 0 tcp_ecn = 0 tcp_ephemeral_high = 65535 tcp_ephemeral_low = 32768 tcp_fastlo = 0 tcp_fastlo_crosswpar = 0 tcp_finwait2 = 1200 tcp_icmpsecure = 0 tcp_init_window = 0 tcp_inpcb_hashtab_siz = 24499 tcp_keepcnt = 8 tcp_keepidle = 14400 tcp_keepinit = 14400 tcp_keepintvl = 150 tcp_limited_transmit = 1 tcp_low_rto = 0 tcp_maxburst = 0 tcp_mssdflt = 1460 tcp_nagle_limit = 65535 tcp_nagleoverride = 0 tcp_ndebug = 100 Tcp_newreno = 1 tcp_nodelayack = 0 tcp_pmtu_discover = 1 tcp_recvspace = 16384 tcp_sendspace = 16384 tcp_tcpsecure = 0 tcp_timewait = 1 tcp_ttl = 60 tcprexmtthresh = 3 tcptr_enable = 0
[root@aix203 /] # no-a | grep udp
Udp_bad_port_limit = 0 udp_ephemeral_high = 65535 udp_ephemeral_low = 32768 udp_inpcb_hashtab_siz = 24499 udp_pmtu_discover = 1 udp_recvspace = 42080 udp_sendspace = 9216 udp_ttl = 30 udpcksum = 1
Configuration script:
[root@aix203 /] # cat chnet.sh
No-r-o ipqmaxlen=512
No-p-o rfc1323=1
No-p-o sb_max=1310720
No-p-o tcp_recvspace=65536
No-p-o tcp_sendspace=65536
No-p-o udp_recvspace=655360
No-p-o udp_sendspace=65536
[root@aix203 /] # sh chnet.sh
Setting ipqmaxlen to 512 in nextboot fileWarning: changes will take effect only at next rebootSetting rfc1323 to 1Setting rfc1323 to 1 in nextboot fileChange to tunable rfc1323, will only be effective for future connectionsSetting sb_max to 1310720Setting sb_max to 1310720 in nextboot fileSetting tcp_recvspace to 65536Setting tcp_recvspace to 65536 in nextboot fileChange to tunable tcp_recvspace, will only be effective for future connectionsSetting tcp_sendspace to 65536Setting tcp_sendspace to 65536 in nextboot fileChange to tunable tcp_sendspace, will only be effective for future connectionsSetting udp_recvspace to 655360Setting udp_recvspace to 655360 in nextboot fileChange to tunable udp_recvspace Will only be effective for future connectionsSetting udp_sendspace to 65536Setting udp_sendspace to 65536 in nextboot fileChange to tunable udp_sendspace, will only be effective for future connections
-not finished, to be continued!
