Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.