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

Oracle Study-AIX6.1 to build Oracle 11gR2 RAC (2)

Modify the kernel parameters of the system

[root@aix209 app] # chdev-l sys0-a ncargs=256

Sys0 changed

[root@aix209 app] # lsattr-El sys0-a ncargs

Ncargs 256 ARG/ENV list size in 4K byte blocks True

[root@aix209 app] # vmo-p-o minperm%=3

Setting minperm% to 3 in nextboot file

Setting minperm% to 3

[root@aix209 app] # vmo-p-o maxperm%=90

Modification to restricted tunable maxperm%, confirmation required yes/no yes

Setting maxperm% to 90 in nextboot file

Setting maxperm% to 90

Warning: a restricted tunable has been modified

[root@aix209 app] # vmo-p-o maxclient%=90

Modification to restricted tunable maxclient%, confirmation required yes/no yes

Setting maxclient% to 90 in nextboot file

Setting maxclient% to 90

Warning: a restricted tunable has been modified

[root@aix209 app] # vmo-p-o lru_file_repage=0

Modification to restricted tunable lru_file_repage, confirmation required yes/no yes

Setting lru_file_repage to 0 in nextboot file

Setting lru_file_repage to 0

Warning: a restricted tunable has been modified

[root@aix209 app] # vmo-p-o strict_maxclient=1

Modification to restricted tunable strict_maxclient, confirmation required yes/no yes

Setting strict_maxclient to 1 in nextboot file

Setting strict_maxclient to 1

Warning: a restricted tunable has been modified

[root@aix209 app] # vmo-p-o strict_maxperm=0

Modification to restricted tunable strict_maxperm, confirmation required yes/no yes

Setting strict_maxperm to 0 in nextboot file

Setting strict_maxperm to 0

Warning: a restricted tunable has been modified

Second, configure the system asynchronous Ibank O

[root@aix209 /] # 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

-for aix 6.1, the Asynchronous Imax O (AIO) system is automatically activated when there is a need for Asynchronous Imax O, no configuration is required.

Third, clock synchronization configuration

Ntp:

[root@aix209 /] # smit xntpd

[root@aix209 /] # mv / etc/ntp.conf / etc/ntp.conf.bak

-for Oracle 11g RAC clock, the ntp service of the system can be turned off through the ctssd process of grid.

4. Configure tcp/udp parameters

[root@aix209 /] # lsattr-E-l sys0-a pre520tune

Pre520tune disable Pre-520 tuning compatibility mode True

For disable compatibility, do the following configuration:

[root@aix209 /] # cat mknet.sh

/ usr/sbin/no-r-o ipqmaxlen=512 / usr/sbin/no-p-o rfc1323=1 / usr/sbin/no-p-o sb_max=4194304 / usr/sbin/no-p-o tcp_recvspace=65536 / usr/sbin/no-p-o tcp_sendspace=65536 / usr/sbin/no-p-o udp_recvspace=655360 / usr/sbin/no-p-o udp_sendspace=65536

Execution. Some parameters need to take effect after the system reboot:

[root@aix209 /] # sh mknet.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 4194304Setting sb_max to 4194304 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

5. Configure shared storage

The construction of RAC,DataBase is stored on shared storage (that is, array devices). Since the system uses a storage array of Sun T300 and the disk does not support concurrent access, the storage sharing needs to be configured with hacmp and concurrent VG. If the array supports concurrency, you can directly use ASM and raw to achieve storage sharing.

[root@aix210 /] # lsdev-c disk

Hdisk0 Available 1S-08-00-8pm 0 16 Bit LVD SCSI Disk Drive

Hdisk1 Available 1n-08-02 Other FC SCSI Disk Drive

[root@aix209 /] # lspv

Hdisk0 00096b0dc9e3531f rootvg active

Hdisk1 000f823ae67f2ef2 None

Hdisk2 00096b0dbf3e15be None

[root@aix210 /] # lsattr-El hdisk1

Clr_q no Device CLEARS its Queue on error Truelocation Location Label Truelun_id 0x0 Logical Unit Number ID Falsemax_transfer 0x40000 Maximum TRANSFER Size Truenode_name 0x50020f2000004999 FC Node Name Falsepvid 000f823ae67f2ef20000000000000000 Physical volume identifier Falseq_err yes Use QERR bit Trueq_type simple Queuing TYPE Truequeue_depth 1 Queue DEPTH Truereassign_to 120 REASSIGN timeout value Truerw_timeout 30 READ/WRITE timeout value Truescsi_id 0x10800 SCSI ID Falsestart_timeout 60 START unit timeout value Trueww_name 0x50020f2300004999 FC World Wide Name False

-hdisk1 is an array shared disk and does not have reserve_polic or reserve_lock attributes

Configure concurrent volume groups to share through HACMP:

HACMP Install: http://blog.csdn.net/lqx0405/article/details/50883875

Configuration of concurrent volume groups: http://blog.csdn.net/lqx0405/article/details/51007358

Configure HACMP: http://blog.csdn.net/lqx0405/article/details/51007358

Configure the trust relationship between hosts

Configure the trust relationship between hosts through ssh. For more information, please see:

Http://blog.csdn.net/lqx0405/article/details/51191832

-splendid go on.

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.