10g RAC on AIX

zhouwf0726發表於2019-05-05
lsattr -El sys0|grep maxuproc
chdev -l sys0 -a maxuproc='5000'
Known Issues for 10.2.0.3 CRS Bundle Patch #2:
ON IBM AIX ONLY:
lsuser -f root | grep capabilities
chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH oracle
chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH root
chuser data=’-1′ fsize='-1' core='-1' cpu='-1' rss=’-1′ stack=’-1′ nofiles='-1' oracle
chuser data=’-1′ fsize='-1' core='-1' cpu='-1' rss=’-1′ stack=’-1′ nofiles='-1' root
/****************************
vi /etc/security/limits
root:
      nofiles = -1
      fsize = -1
      core = -1
      cpu = -1
      data = -1
      rss = -1
      stack = -1
oracle:
      fsize = -1
      core = -1
      cpu = -1
      data = -1
      rss = -1
      stack = -1
      nofiles = -1
     
root:
        fsize = -1
        data = -1
        stack = -1
        core = -1
        fsize_hard = -1
        cpu_hard = -1
        data_hard = -1
        stack_hard = -1
        core_hard = -1
oracle:
        fsize = -1
        data = -1
        stack = -1
        core = -1
        fsize_hard = -1
        cpu_hard = -1
        data_hard = -1
        stack_hard = -1
        core_hard = -1
     
****************************/

/****************************
vmo -p -o lru_file_repage=0
vmo -p -o minperm%=5
vmo -p -o maxperm%=20
vmo -p -o maxclient%=20
vmo -p -o v_pinshm=0
vmo -p -o minfree=4096
vmo -p -o maxfree=8192
****************************/

/****************************
no -a | grep 'rfc1323'     
no -a | grep 'ipqmaxlen'   
no -a | grep 'sb_max'      
no -a | grep 'udp_sendspace'
no -a | grep 'udp_recvspace'
no -a | grep 'tcp_sendspace'
no -a | grep 'tcp_recvspace'
-----------------------------
no -p -o ipqmaxlen=512
no -p -o rfc1323=1
no -p -o sb_max=41943040
no -p -o udp_recvspace=20971520
no -p -o udp_sendspace=2097152
no -p -o tcp_sendspace=262144
no -p -o tcp_recvspace=262144
****************************/

/****************************
# smitty aio
maxreqs 16384 Maximum number of REQUESTS True
Select change / Show Characteristics of Asynchronous I/O
Set STATE to “available”
maxreqs=16384
maxservers=300
minservers=150
****************************/

/****************************
instfix -i | grep 'All filesets for IY'
lslpp -l
-----------------------------
bos.cifs_fs.rte (建議客戶安裝該包,否則Oracle安裝時會報錯。)
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.perfstat
bos.perf.libperfstat
bos.perf.proctools
rsct.basic.rte  (RAC only , V2.4.7.3 + IZ01838或者V2.4.8.1 以及更高版本)
rsct.compat.clients.rte (For RAC only)
xlC.aix50.rte:7.0.0.4(或更新的版本)
xlC.rte:7.0.0.1(或更新的版本)
****************************/

/****************************
hagsuser
/etc/group
lsgroup ALL
lslpp -l cluster.*
****************************/

/****************************
/etc/hosts
ifconfig -l
ifconfig –a
lsattr -El en0
****************************/

/****************************
vi /etc/hosts.equiv
vi $HOME/.rhosts   (root and oracle)
****************************/

/****************************
ORACLE_BASE=/oracle/app/oracle
ORACLE_HOME=$ORACLE_HOME/product/10.2.0/db
ORA_CRS_HOME=$ORACLE_HOME/product/10.2.0/crs
ORACLE_SID=tpiywdb1
ORACLE_TERM=vt100
ORACLE_OWNER=oracle
export ORACLE_BASE ORACLE_HOME ORA_CRS_HOME ORACLE_SID ORACLE_TERM ORACLE_OWNER
LD_LIBRARY_PATH=/oracle/app/oracle/product/10.2.0/db/lib32:/oracle/app/oracle/product/10.2.0/db/lib
NLS_LANG=American_America.ZHS16GBK
ORA_NLS33=/oracle/app/oracle/product/10.2.0/db/nls/data
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin:/oracle/app/oracle/product/10.2.0/db/OPatch:/oracle/app/oracle/product/10.2.0/db/bin:/oracle/app/oracle/product/10.2.0/crs/bin:/bin:/usr/ccs/bin:/usr/bin/X11:.:/oracle/app/oracle/product/10.2.0/db/OPatch:/oracle/app/oracle/product/10.2.0/db/bin:/oracle/app/oracle/product/10.2.0/crs/bin:/bin:/usr/ccs/bin:/usr/bin/X11:.
TMP=/tmp
TMPDIR=/tmp
export LD_LIBRARY_PATH NLS_LANG ORA_NLS33 PATH TMP TMPDIR OPATCH_PLATFORM_ID
export AIXTHREAD_SCOPE=S
umask 022
export DISPLAY=22.188.216.71:0.0
set -o vi
export EDITOR=vi
****************************/

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/756652/viewspace-712462/,如需轉載,請註明出處,否則將追究法律責任。

相關文章