Oracle Study-aix6.1 Building Oracle 10GR2 RAC (2)

Oracle Study-aix6.1 Building Oracle 10GR2 RAC (2)

First, view system I/O (asynchronous I/O is enabled for Oracle database)

For AIX6.1, the default asynchronous I/O is automatically activated when there is a requirement, and no configuration is required.
[[email protected]/] #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 host trust relationships between nodes:

[[email protected] /] #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[[email protected] /] #cat  .rhostsaix203    rootaix204   rootaix203-vip rootaix204-vip rootaix203-priv  rootaix204-priv rootaix203   oracleaix204   oracleaix203-vip   oracleaix204-vip  oracleaix203-priv  oracleaix204-priv  oracle[[email  Protected] ~] $cat  .rhostsaix203   rootaix204   rootaix203-vip  rootaix204-vip rootaix203-priv rootaix204-priv rootaix203   oracleaix204    oracleaix203-vip &nbSp;oracleaix204-vip  oracleaix203-priv  oracleaix204-priv  oracle 

To verify the host trust relationship:
[[Email protected] ~] $rsh aix204 Date
Tue Mar 16:18:47 CDT 2016
[[Email protected] ~] $rsh aix204-priv Date
Tue Mar 16:18:50 CDT 2016
[[Email protected] ~] $rsh aix203 Date
Tue Mar 16:17:12 CDT 2016
[[Email protected] ~] $rsh aix203-priv Date
Tue Mar 16:18:26 CDT 2016

Third, configure time synchronization (NTP)

NTP SERVER:
[[[email protected]/] #cat/etc/ntp.conf 
# Default NTP Configuration File.
#   Broadcast client, no authentication.

 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

iv. Configuring private network transfer parameters between node
[[email protected]/] #lsattr  -el  sys0  -a  pre520tune
pre520tune disable Pre-520 tuning compatibility mode True

[[[email protected]/] #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 = 150             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

[[email protected]/] #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 = 3 0 Udpcksum = 1

configuration script:             
[[email protected]/] #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_sendspac e=65536     

[[email protected]/] #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!

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1757450

Oracle Study-aix6.1 Building Oracle 10GR2 RAC (2)