Oracle Study-aix6.1 Building Oracle 11gR2 RAC (2)

Oracle Study-aix6.1 Building Oracle 11gR2 RAC (2)

First, modify the system kernel parameters

[[email protected] app] #chdev-l sys0-a ncargs=256
SYS0 changed
[[email protected] app] #lsattr-el sys0-a Ncargs
Ncargs arg/env list size in 4K byte blocks True
[[email protected] app] #vmo-P-o minperm%=3
Setting minperm% to 3 in Nextboot file
Setting minperm% to 3
[[email protected] app] #vmo-P-o maxperm%=90
Modification to restricted tunable maxperm%, confirmation required yes/no Yes
Setting maxperm% to Nextboot file
Setting maxperm% to 90
Warning:a restricted tunable has been modified
[[email protected] app] #vmo-P-o maxclient%=90
Modification to restricted tunable maxclient%, confirmation required yes/no Yes
Setting maxclient% to Nextboot file
Setting maxclient% to 90
Warning:a restricted tunable has been modified
[[email protected] 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
[[email protected] 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
[[email protected] 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

650) this.width=650; "Src=" http://img.blog.csdn.net/20160419170808143?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

Second, configure the system asynchronous I/O

[[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 

-----for AIX 6.1, asynchronous I/O (AIO) systems are automatically activated when there is an asynchronous I/O requirement, without configuration.

Three, clock synchronization configuration
Ntp:
[[email protected]/] #smit XNTPD
[[email protected]/] #mv/etc/ntp.conf/etc/ntp.conf.bak
----The NTP service can be turned off for the Oracle 11g RAC clock through the CTSSD process through the grid

Iv. Configuring TCP/UDP Parameters

[[email protected]/] #lsattr-e-L sys0-a pre520tune
Pre520tune Disable Pre-520 tuning compatibility mode True
For disable compatibility, make the following configuration:
[[email protected]/] #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_rec Vspace=65536/usr/sbin/no-p-o tcp_sendspace=65536/usr/sbin/no-p-o udp_recvspace=655360/usr/sbin/no-p-o Udp_sendspa ce=65536

execution, some parameters require system restart after the effective:
[[email protected]/] #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

V. Configuration of shared storage

The build rac,database is stored on the shared storage (that is, on the array device), because the system uses the Sun T300 storage array, the disk does not support concurrent access, so this storage needs to configure the sharing hacmp plus concurrent VG implementation, if the array supports concurrency, Storage sharing can be implemented directly using ASM and raw.

[[email protected]/] #lsdev-C disk
Hdisk0 Available 1s-08-00-8,0-Bit LVD SCSI Disk Drive
Hdisk1 Available 1n-08-02 Other FC SCSI Disk Drive

[[email protected]/] #lspv
Hdisk0 00096b0dc9e3531f ROOTVG Active
Hdisk1 000f823ae67f2ef2 None
Hdisk2 00096b0dbf3e15be None

[[email protected]/] #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  time out value          truerw_timeout     30                                                               read/write time out value         Truescsi_id       0x10800                                                        SCSI ID                            Falsestart_timeout 60                                                                start unit time out value         trueww_name       0x50020f2300004999                              FC World Wide Name                false

-------Hdisk1 is an array shared disk and does not have reserve_polic or Reserve_lock properties

Configure concurrent volume groups for sharing 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

Vi. Configuring trust relationships between hosts

to configure the trust relationship between hosts via SSH, see the following documents:

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

----Wonderful to continue ...

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

Oracle Study-aix6.1 Building Oracle 11gR2 RAC (2)