ORACLE11GR2在REDHAT63環(huán)境中搭建RAC集群及簡(jiǎn)單維護(hù)

1、系統(tǒng)環(huán)境硬件環(huán)境服務(wù)器：vmware 10，新建個(gè)虛擬機(jī)主機(jī)名分別為rac1和rac2，每個(gè)虛擬機(jī)分配40G磁盤(pán)空間，添加兩個(gè)網(wǎng)絡(luò)適配器。其中第二個(gè)適配器網(wǎng)絡(luò)連接調(diào)整為自定義，且兩個(gè)節(jié)點(diǎn)保持一致。Widonws本機(jī)ip：軟件環(huán)境數(shù)據(jù)庫(kù)：oracle database-x86-64GRID：oracle_grid-x86-64 操作系統(tǒng)：rhel-server-6.3-x86_64采用最小化安裝網(wǎng)絡(luò)環(huán)境Ip地址規(guī)劃分配為IP 名稱子網(wǎng)掩碼IP 地址Rac1-public1Rac2-public2Rac1-privateRac2-privateRac1-vip3Rac2-vip4SCAN5共享磁盤(pán)

2、分區(qū)計(jì)劃創(chuàng)建四個(gè)共享磁盤(pán)sdb、sdc、sdd、sde，每個(gè)磁盤(pán)計(jì)劃分三個(gè)分區(qū)前期環(huán)境準(zhǔn)備 配置靜態(tài)地址vi /etc/sysconfig/network-scripts/ifcfg-eth0修改ip地址。每個(gè)虛擬機(jī)eth0網(wǎng)卡為public，DEVICE=eth0BOOTPROTO=staticHWADDR=00:0C:29:D1:4E:A6NM_CONTROLLED=yesONBOOT=yesTYPE=Ethernet*UUID=e59cb6a0-deb0-4164-a2b0-8b4dcc0cb027IPADDR=1NETMASK=GATEWAY=vi /etc/sysconfig/net

3、work-scripts/ifcfg-eth1修改ip地址。每個(gè)虛擬機(jī)eth1網(wǎng)卡位privateDEVICE=eth1BOOTPROTO=staticHWADDR=00:0C:29:D1:4E:A6NM_CONTROLLED=yesONBOOT=yesTYPE=Ethernet*UUID=e59cb6a0-deb0-4164-a2b0-8b4dcc0cb027IPADDR=NETMASK=修改完成后執(zhí)行service network restart 在rac1和rac2上分別關(guān)閉防火墻service iptables stop -停止防火墻chkconfig iptables off -禁用

4、防火墻 在rac1和rac2上分別修改主機(jī)名vi /etc/sysconfig/network 重啟生效，一個(gè)rac1，另一個(gè)rac2HOSTNAME=rac1 在rac1和rac2 上分別改hosts vi /etc/hosts 添加對(duì)應(yīng)的ip信息#public80 rac181 rac2#private rac1-priv rac2-priv#virtual82 rac1-vip83 rac2-vip#scan84 cluster-scan 在rac1和rac2上分別執(zhí)行配置內(nèi)核參數(shù)vi /etc/sysctl.conf加入以下內(nèi)容fs.aio-max-nr = 1048576fs.fil

5、e-max = 6815744kernel.shmall = 2147483648kernel.shmmax = 68719476736kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586使修改參數(shù)立即生效：sysctl -p 在rac1和r

6、ac2上分別執(zhí)行修改limitsvi /etc/security/limits.conf加入以下信息grid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536 在rac1和rac2上分別修改/etc/pam.d/loginvi /etc/pam.d/login加入以下信息session required

7、/lib/security/pam_limits.so session required pam_limits.so 在rac1和rac2上分別執(zhí)行修改/etc/profilevi /etc/profile加入以下信息if $USER = oracle | $USER = grid ; thenif $SHELL = /bin/ksh ; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fiumask 022fi 在rac1和rac2 上分別執(zhí)行禁用 selinuxvi /etc/selinux/config修改 SE

8、LINUX值SELINUX=disabled 在rac1和rac2上分別執(zhí)行停止 ntp 服務(wù)service ntpd stopchkconfig ntpd offmv /etc/ntp.conf /etc/ntp.conf.bak 在rac1和rac2上分別處理/dev/shm 共享內(nèi)存不足的處理df -h 查看tmpfs分區(qū)是否大于1G，如果過(guò)小需增加。vi /etc/fstab 默認(rèn)的：tmpfs /dev/shm tmpfs defaults 0 0改成：tmpfs /dev/shm tmpfs defaults,size=1024m 0 0mount -o remount /dev/

9、shm 在rac1和rac2上分別檢查軟件是否全部安裝 rpm -qa | grep binutils-rpm -qa | grep compat-libstdc+-rpm -qa | grep elfutils-libelf-rpm -qa | grep elfutils-libelf-devel-rpm -qa | grep glibc-rpm -qa | grep glibc-common-rpm -qa | grep glibc-devel-rpm -qa | grep gcc-rpm -qa | grep gcc-c+-rpm -qa | grep libaio-rpm -qa |

10、grep libaio-devel-rpm -qa | grep libgcc-rpm -qa | grep libstdc+-rpm -qa | grep libstdc+-devel-rpm -qa | grep make-rpm -qa | grep sysstat-rpm -qa | grep unixODBC-rpm -qa | grep unixODBC-devel- 在rac1和rac2 2分別將未安裝的包通過(guò)yum安裝mkdir /yummount /dev/cdrom /yumvi /etc/yum.repos.d/chenbin.repo添加以下內(nèi)容 rhel-chenbi

11、nname=Red Hat Enterprise Linux $releasever - $basearch - Debugbaseurl=file:/yum/enabled=1gpgcheck=1gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-releaseyum list -查看可用包yum -y install binutils* compat-* elfutils-libelf* gcc-* gcc-* kernel-* ksh-* libaio-* libgcc-* libgomp-* libstdc+-* make-* numactl

12、-devel-* sysstat-* unixODBC-* pdksh* 在oradb1和rac2上分別關(guān)閉不需要的服務(wù)chkconfig autofs offchkconfig acpid offchkconfig sendmail offchkconfig cups-config-daemon offchkconfig cpus offchkconfig xfs offchkconfig lm_sensors offchkconfig gpm offchkconfig openibd offchkconfig pcmcia offchkconfig cpuspeed offchkconfi

13、g nfslock offchkconfig ip6tables offchkconfig rpcidmapd offchkconfig apmd offchkconfig sendmail offchkconfig arptables_jf offchkconifg microcode_ctl offchkconfig rpcgssd offchkconfig ntpd off添加組和用戶 在rac1和rac2上分別添加oracle和grid用戶和組groupadd -g 501 oinstallgroupadd -g 502 dbagroupadd -g 503 opergroupadd

14、-g 504 asmadmingroupadd -g 505 asmopergroupadd -g 506 asmdbauseradd -g oinstall -G dba,asmdba,oper oracleuseradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid 在rac1和rac2上分別為oracle和grid用戶設(shè)密碼passwd oraclepasswd grid 在rac1和rac2上分別創(chuàng)建目錄grid 和 oracle 用戶的mkdir -p /u01/app/oraclemkdir -p /u01/app/gri

15、dmkdir -p /u01/app/11.2.0/gridchown -R grid:oinstall /u01/app/gridchown -R grid:oinstall /u01/app/11.2.0chown -R oracle:oinstall /u01/app/oraclechmod -R 775 /u01mkdir -p /u01/app/oraInventorychown -R grid:oinstall /u01/app/oraInventorychmod -R 775 /u01/app/oraInventory 在rac1和rac2上分別修改oracle用戶的.bash_

16、profile文件vi /home/oracle/.bash_profileexport ORACLE_SID=rac1export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1export LD_LIBRARY_PATH=$ORACLE_HOME/libexport NLS_DATE_FORMAT=yyyy-mm-dd HH24:MI:SSexport TMP=/tmpexport TMPDIR=$TMPexport PATH=$PATH:$ORACLE_HOME/bin

17、在rac1和rac2上分別修改grid用戶的.bash_profile文件vi /home/grid/.bash_profileexport ORACLE_SID=+ASM1export ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/app/11.2.0/gridexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport NLS_DATE_FORMAT=yyyy-mm-dd HH24:MI:SSexport PATH=$ORACLE_HOME/bin:$PATH注意另外一臺(tái)數(shù)據(jù)庫(kù)實(shí)例名須做相應(yīng)修改：Oracle

18、：export ORACLE_SID=rac2grid：export ORACLE_SID=+ASM2 建立 ssh 等效性（可不配置）Root用戶等效性可不用配置，配置了僅管理服務(wù)器方便，gird用戶和oracle的ssh等效性由安裝程序配置，mkdir /.ssh chmod 755 /.ssh ssh-keygen -t rsassh-keygen -t dsacat /.ssh/id_rsa.pub /.ssh/authorized_keyscat /.ssh/id_dsa.pub /.ssh/authorized_keys在rac1上執(zhí)行ssh rac2 cat /.ssh/id_r

19、sa.pub /.ssh/authorized_keys ssh rac2 cat /.ssh/id_dsa.pub /.ssh/authorized_keys在rac2上執(zhí)行ssh rac1 cat /.ssh/id_rsa.pub /.ssh/authorized_keys ssh rac1 cat /.ssh/id_dsa.pub /.ssh/authorized_keys在兩臺(tái)服務(wù)器上驗(yàn)證是否可以正常訪問(wèn)對(duì)方，執(zhí)行時(shí)不再提示輸入密碼，則表示SSH 對(duì)等性配置成功ssh rac1 datessh rac2 datessh rac1-priv datessh rac2-priv date添

20、加共享磁盤(pán)（VM） 在本機(jī)上創(chuàng)建共享磁盤(pán)生產(chǎn)環(huán)境使用共享存儲(chǔ)，直接略過(guò)在windows的cmd中進(jìn)入VMware Workstation安裝目錄，執(zhí)行命令創(chuàng)建磁盤(pán)：注意創(chuàng)建共享磁盤(pán)的路徑及文件大小，例如我的VM裝在c盤(pán)，cd c:Program Files (x86)VMwareVMware Workstationvmware-vdiskmanager.exe -c -s 5g -a lsilogic -t 2 F:shdiskvot.vmdkVmware-vdiskmanager.exe -c -s 2g -a lsilogic -t 2 F:shdiskfra.vmdkvmware-vdi

21、skmanager.exe -c -s 5g -a lsilogic -t 2 F:shdiskdata.vmdkvmware-vdiskmanager.exe -c -s 5g -a lsilogic -t 2 F:shdiskdata1.vmdk 將共享磁盤(pán)掛到兩臺(tái)虛擬機(jī)關(guān)閉兩臺(tái)虛擬機(jī)并退出VM，分別用記事本打開(kāi)虛擬機(jī)安裝位置中虛擬機(jī)名字. vmx，添加以下內(nèi)容disk.EnableUUID=TRUEdisk.locking = FALSEscsi1.shared = TRUEdiskLib.dataCacheMaxSize = 0diskLib.dataCacheMaxReadAhead

22、Size = 0diskLib.dataCacheMinReadAheadSize = 0diskLib.dataCachePageSize= 4096diskLib.maxUnsyncedWrites = 0 scsi1.present = TRUEscsi1.virtualDev = lsilogicscsil.sharedBus = VIRTUALscsi1:0.present = TRUEscsi1:0.mode = independent-persistentscsi1:0.fileName = F:shdiskvot.vmdkscsi1:0.deviceType = diskscs

23、i1:0.redo = scsi1:1.present = TRUEscsi1:1.mode = independent-persistentscsi1:1.fileName = F:shdiskfra.vmdkscsi1:1.deviceType = diskscsi1:1.redo = scsi1:2.present = TRUEscsi1:2.mode = independent-persistentscsi1:2.fileName = F:shdiskdata.vmdkscsi1:2.deviceType = diskscsi1:2.redo = scsi1:3.present = T

24、RUEscsi1:3.mode = independent-persistentscsi1:3.fileName = F:shdiskdata1.vmdkscsi1:3.deviceType = diskscsi1:3.redo = 兩個(gè)虛擬機(jī)開(kāi)機(jī)，格式化硬盤(pán)，確認(rèn)是否共享成功。在rac1上執(zhí)行fdsik -l -確認(rèn)看以正常看到sdb,sbc,sdd,sde按前期規(guī)劃創(chuàng)建分區(qū)，分區(qū)完成后在rac2 中執(zhí)行fdisk -l 查詢是否同步 在rac1和rac2上分別將裸設(shè)備文件和分區(qū)設(shè)備文件進(jìn)行綁定vi /etc/udev/rules.d/60-raw.rules 根據(jù)磁盤(pán)情況修改下面信息加入到

25、文件中ACTION=add, KERNEL=sdb1, RUN+=/bin/raw /dev/raw/raw1 %NACTION=add, KERNEL=sdb2, RUN+=/bin/raw /dev/raw/raw2 %NACTION=add, KERNEL=sdb3, RUN+=/bin/raw /dev/raw/raw3 %NACTION=add, KERNEL=sdc1, RUN+=/bin/raw /dev/raw/raw4 %NACTION=add, KERNEL=sdc2, RUN+=/bin/raw /dev/raw/raw5 %NACTION=add, KERNEL=sdc

26、3, RUN+=/bin/raw /dev/raw/raw6 %NACTION=add, KERNEL=sdd1, RUN+=/bin/raw /dev/raw/raw7 %NACTION=add, KERNEL=sdd2, RUN+=/bin/raw /dev/raw/raw8 %NACTION=add, KERNEL=sdd3, RUN+=/bin/raw /dev/raw/raw9 %NKERNEL=raw0-9, OWNER=grid, GROUP=asmadmin, MODE=0660此處、KERNEL=”raw0-9” 10以必須單獨(dú)指定，否則無(wú)效、MODE=”0666”和GROU

27、P=”oinstall”的設(shè)置，在后面的check會(huì)報(bào)waring應(yīng)改為:MODE=”0660 GROUP=”asmadmin”執(zhí)行：start_udev命令，此處建議重啟虛擬機(jī)執(zhí)行 raw -qa查看綁定狀態(tài):確保兩個(gè)節(jié)點(diǎn)看以看到相同的內(nèi)容執(zhí)行l(wèi)s -l /dev/raw/查看 裸設(shè)備歸屬權(quán)限:安裝Grid 在rac1和rac2上分別安裝cvuqdisk包在兩個(gè) Oracle RAC 節(jié)點(diǎn)上安裝操作系統(tǒng)程序包 cvuqdisk。cvuqdisk RPM 包含在 Oracle Grid Infrastructure 安裝介質(zhì)上的 rpm 目錄中。rpm -ivh cvuqdisk-1.0.7-

28、1.rpm 檢查 CRS 的安裝環(huán)境只需要在其中一個(gè)節(jié)點(diǎn)的gird用戶執(zhí)行.執(zhí)行需提前設(shè)置好grid、oracle用戶ssh等效性，本次不檢查./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verbose未檢測(cè)通過(guò)的顯示為failed，根據(jù)情況修復(fù)一下即可：resolv.conf不一致的DNS問(wèn)題可以忽略 安裝Grid Infrastructure軟件 開(kāi)始安裝export DISPLAY=8:0.0 ./runInstaller 語(yǔ)言支持中文 配置Scan name與host文件一致此處的SCAN_NAME與/etc/hosts 文件中的sca

29、n地址保持一致 Grid用戶等效性配置點(diǎn)擊setup出現(xiàn)提示安裝成功。Next 創(chuàng)建OCR磁盤(pán)組設(shè)置asm密碼 選擇grid安裝位置Package這個(gè)只要確保安裝了ksh即可。 Task resolve此項(xiàng)是因?yàn)闆](méi)有使用dns解析scan，可忽略 開(kāi)始安裝 執(zhí)行腳本在每個(gè)服務(wù)器上以root身份執(zhí)行圖中的2個(gè)腳本，兩個(gè)節(jié)點(diǎn)都執(zhí)行完成后點(diǎn)OK。/u01/app/oraInventory/orainstRoot.sh/u01/app/grid/11.2.0/root.sh出現(xiàn)以下字樣表示在該節(jié)點(diǎn)安裝成功Configure Oracle Grid Infrastructure for a Cluste

30、r . succeeded 確認(rèn)Grid安裝 CRS狀態(tài)crs_stat -t -v除GSD外其他全部為onlinecrsctl stat res -t voting disk狀態(tài)crsctl query css votedisk# STATE File Universal Id File Name Disk group- 1. ONLINE 7b8903f49cc84fa8bf06d199bdf5dfe3 (ORCL:DISK01) CRSDG 檢查Oracle集群注冊(cè)表(OCR)ocrcheckStatus of Oracle Cluster Registry is as follows

31、:Version : 3Total space (kbytes) : 262120Used space (kbytes) : 2264Available space (kbytes) : 259856ID : 1510360228Device/File Name : +CRSDGDevice/File integrity check succeededDevice/File not configuredDevice/File not configuredDevice/File not configuredDevice/File not configuredCluster registry in

32、tegrity check succeededLogical corruption check bypassed due to non-privileged user 檢查CRS狀態(tài)crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is onlineASM磁盤(pán)組配置 檢查監(jiān)聽(tīng)

33、狀態(tài)gridrac01 $ lsnrctl status(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11)(PORT=1521) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=13)(PORT=1521)Services Summary.Service +ASM has 1 instance(s).Instance +ASM1, status READY, has 1 handler(s) for this servi

34、ce.The command completed successfully 創(chuàng)建DATA磁盤(pán)組以grid用戶執(zhí)行asmca命令，創(chuàng)建DATADG和FRADG兩個(gè)磁盤(pán)組。 創(chuàng)建FLA磁盤(pán)組：FLASHDG創(chuàng)建成功，退出ASMCA。驗(yàn)證：crs_stat -t -v或 crsctl stat res -t安裝數(shù)據(jù)庫(kù)軟件 切換到oracle用戶export DISPLAY=8:0.0 ./runInstaller 兩個(gè)節(jié)點(diǎn)安裝 oracle用戶等效性輸入oracle用戶密碼。點(diǎn)擊setup 選擇路徑 執(zhí)行root腳本在兩個(gè)節(jié)點(diǎn)上，分別以root身份執(zhí)行上述腳本，然后點(diǎn)擊OK。數(shù)據(jù)庫(kù)軟件安裝完成，點(diǎn)擊

35、close退出。 測(cè)試數(shù)據(jù)庫(kù)安裝完成oraclerac1$ sqlplus / as sysdba SQL*Plus: Release .0 Production on Wed Oct 1 22:42:56 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL使用DBCA創(chuàng)建數(shù)據(jù)庫(kù) 使用oracle用戶登錄，執(zhí)行dbca 啟用em 選擇asm磁盤(pán)組 選擇FRA磁盤(pán)組：確定是否啟用快速恢復(fù)區(qū)、歸檔日志設(shè)置最大連接數(shù) 注意選合適的字符集點(diǎn)擊exit完成安裝集群數(shù)據(jù)

36、庫(kù)維護(hù) 所有Oracle實(shí)例狀態(tài)srvctl status database -d oradbInstance rac1is running on node node1Instance rac2 is running on node node2 單個(gè)Oracle實(shí)例狀態(tài)srvctl status instance -d oradb -i rac1Instance rac1is running on node node1 節(jié)點(diǎn)應(yīng)用程序狀態(tài)srvctl status nodeappsVIP node1-vip is enabledVIP node1-vip is running on node:

37、node1VIP node2-vip is enabledVIP node2-vip is running on node: node2Network is enabledNetwork is running on node: node1Network is running on node: node2GSD is disabledGSD is not running on node: node1GSD is not running on node: node2ONS is enabledONS daemon is running on node: node1ONS daemon is run

38、ning on node: node2 節(jié)點(diǎn)應(yīng)用程序配置srvctl config nodeappsNetwork exists: 1/eth0, type staticVIP exists: /node1-vip/51/eth0, hosting node node1VIP exists: /node2-vip/52/eth0, hosting node node2GSD existsONS exists: Local port 6100, remote port 6200, EM port 2016 數(shù)據(jù)庫(kù)配置srvctl config database -d oradb -aDataba

39、se unique name: oradbDatabase name: oradbOracle home: /u01/app/oracle/product/11.2.0/dbhome_1Oracle user: oracleSpfile: +DATADG/oradb/spfileoradb.oraDomain:Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: oradbDatabase instances: rac1,rac2Disk

40、 Groups: DATADG,FRADGMount point paths:Services:Type: RACDatabase is enabledDatabase is administrator managed ASM狀態(tài)srvctl status asmASM is running on node2,node1 ASM配置srvctl config asm -aASM home: /u01/app/11.2.0/gridASM listener: LISTENERASM is enabled. TNS監(jiān)聽(tīng)器狀態(tài)srvctl status listenerListener LISTEN

41、ER is enabledListener LISTENER is running on node(s): node2,node1 TNS監(jiān)聽(tīng)器配置srvctl config listener -aName: LISTENERNetwork: 1, Owner: gridHome: /u01/app/11.2.0/grid on node(s) node2,node1End points: TCP:1521 SCAN狀態(tài)srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node node2SCAN V

42、IP scan2 is enabledSCAN VIP scan2 is running on node node1SCAN VIP scan3 is enabledSCAN VIP scan3 is running on node node1 SCAN配置srvctl config scanSCAN name: cluster-scan.localdomain, Network: 1/eth0SCAN VIP name: scan1, IP: /cluster-scan.localdomain/7SCAN VIP name: scan2, IP: /cluster-scan.localdom

43、ain/8SCAN VIP name: scan3, IP: /cluster-scan.localdomain/9 驗(yàn)證所有集群節(jié)點(diǎn)間的時(shí)鐘同步cluvfy comp clocksync -verboseResult: Check of clock time offsets passedOracle Cluster Time Synchronization Services check passedVerification of Clock Synchronization across the cluster nodes was successful. 登陸數(shù)據(jù)庫(kù)sqlplus / as s

44、ysdbaset pagesize 999set linesize 200 查看實(shí)例狀態(tài)select instance_name,status from gv$instance; 檢查所有節(jié)點(diǎn)crscrsctl check cluster allcrsctl check crssu gridsqlplsu / as sysasm startup集群的啟停 停止所有節(jié)點(diǎn)上的實(shí)例srvctl status database -d oradb檢查所有的節(jié)點(diǎn)上的實(shí)例狀態(tài)srvctl status database d oradb 啟動(dòng)所有節(jié)點(diǎn)上的實(shí)例srvctl start database -d r

45、acdb附錄資料：不需要的可以自行刪除 Oracle10g在AIX上的安裝準(zhǔn)備工作Oracle For Aix安裝1：安裝Oracle10.2的最基本要求硬件： 64位 內(nèi)存與交換區(qū) 硬盤(pán)空間：除數(shù)據(jù)外，Oracle軟件本身至少需要3G 軟件： 操作系統(tǒng)： AIX 5L version 5.2, Maintenance Level 04 or later , or AIX 5L version 5.3, Maintenance Level 02 or later. AIX的軟件包:o bos.adt.baseo bos.adt.libo bos.adt.libmo bos.perf.libpe

46、rfstato bos.perf.perfstato ctoolso xlC.aix50.rte: or latero xlC.rte: or later2：AIX的修補(bǔ): 對(duì)于(APARs) for AIX 5L v5.2 ML 04: IY63133: large percentage of CPU time spent in ldata_balance routine IY64978: deadlock with concurrent renaming and unlinking under JFS IY63366: dlsym returns null even for valid s

47、ymbol in AIX520 ML-4 IY64691: chvg -b can cause corruption and crash IY64737: AIO can hang in knotunlock IY65001: mklvcopy on a striped lv is failing to update lvcb 對(duì)于(APARs) for AIX 5L v5.3 ML 02: IY58143: REQUIRED UPDATE FOR AIX 5.3 IY59386: libdepend.mk files are all empty IY60930: Unable to dele

48、te network routes IY66513: LDR_CNTRL turns on undesirable option when initialized with incorrect value IY70159: krtl relocation problem 3：安裝AIX 5L 53-001 插入CD 5.3第一片盤(pán)。 2 啟動(dòng)計(jì)算機(jī)，聽(tīng)見(jiàn)嘀嘀兩聲，按F1鍵進(jìn)入systerm management services 界面，選擇boot sequence 。 3 將CD-ROM設(shè)置為啟動(dòng)順序1，保存設(shè)置。 4 進(jìn)入安裝界面，開(kāi)始一個(gè)全新系統(tǒng)安裝。 5 提示插入后續(xù)盤(pán)片，繼續(xù)安裝。

49、6 注意安裝時(shí)Kernel 選擇64bit，用命令prtcont查看。 7 如選擇中文語(yǔ)言，則要求安裝盤(pán)1、2、7，如不選，則安裝盤(pán)1、2 機(jī)器啟動(dòng) 1. 進(jìn)入Configerition assistant界面 2. 設(shè)定IP地址為70，掩碼為。 在安裝Oracle前對(duì)系統(tǒng)進(jìn)行配置步驟一檢查系統(tǒng)所需軟件和修補(bǔ)包4：檢查系統(tǒng)安裝軟件 n 確認(rèn)安裝的AIX版本是否高于5.2-01，否則升級(jí)系統(tǒng)版本。 # oslevel -r 5300-00確認(rèn)是否是 5300-04）需升級(jí)到5300-02以上版本就可以。按如下升級(jí)： 升級(jí)前需打包： bos.adt pat bos. cifs 按smitty-一路

50、回車 a) 擴(kuò)充usr文件系統(tǒng)到3G 檢查usr空間的大小 # df -k Filesystem 1024-blocks Free %Used Iused %Iused Mounted on /dev/hd4 16384 4588 72% 1509 19% / /dev/hd2 1064960 8608 100% 24103 10% /usr 確認(rèn)文件系統(tǒng)類型jfs jfs2 lsvg -l rootvg （查看文件系統(tǒng)類型，例如如下查看到的是jfs） rootvg: LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT hd5 boot 1 1 1 cl

51、osed/syncd N/A hd6 paging 32 32 1 open/syncd N/A hd8 jfslog 1 1 1 open/syncd N/A hd4 jfs 1 1 1 open/syncd / hd2 jfs 65 65 1 open/syncd /usr hd9var jfs 1 1 1 open/syncd /var hd3 jfs 2 2 1 open/syncd /tmp hd1 jfs 1 1 1 open/syncd /home hd10opt jfs 7 7 1 open/syncd /opt 如是jfs 選擇日志文件系統(tǒng)類型,如是 jfs2則選擇擴(kuò)展文件系

52、統(tǒng) 用如下命令查看大小，此時(shí)查看到的usr的大小為3 G # df -k Filesystem 1024-blocks Free %Used Iused %Iused Mounted on /dev/hd4 16384 4584 73% 1509 19% / /dev/hd2 3014656 1897104 38% 24103 4% /usr /dev/hd9var 16384 10048 39% 362 9% /var /dev/hd3 32768 31596 4% 51 1% /tmp /dev/hd1 16384 15820 4% 18 1% /home /proc - - - - -

53、/proc /dev/hd10opt 114688 25600 78% 2202 8% /opt b) 將IY58143上傳到/usr/sys/inst.images c) 進(jìn)入/usr/sys/inst.images目錄，運(yùn)行inutoc d) smitty update_all (接受license yes) (而非install APAR) # instfix -ik IY58143 All filesets for IY58143 were found. # oslevel -r 5300-00 e) 重啟AIX #shutdown Fr f) 將升級(jí)包上傳到/usr/sys/inst

54、.images g) 進(jìn)入/usr/sys/inst.images目錄，運(yùn)行inutoc # cd / # pwd / # cd usr # cd sys # cd inst.images # inutoc h) smitty update_all (接受license yes) i) OK后 重新啟動(dòng)系統(tǒng)后查看oslevel r (5300-03) # oslevel -r 5300-03 # instfix -i |grep ML All filesets for _AIX_ML were found. All filesets for 5300-02_AIX_ML were found.

55、 All filesets for 5300-01_AIX_ML were found. All filesets for 5300-03_AIX_ML were found. 如果不成功就執(zhí)行：Instfix ik 5300-03_AIX_ML 會(huì)列出不成功的包 # instfix -ik 5300-03_AIX_ML All filesets for 5300-03_AIX_ML were found.說(shuō)明已經(jīng)成功 5：檢查AIX系統(tǒng)的安裝情況是否符合要求 Oracle要求的AIX的軟件包:o bos.adt.baseo bos.adt.libo bos.adt.libmo bos.per

56、f.libperfstato bos.perf.perfstato ctoolso xlC.aix50.rte: or latero xlC.rte: or later確認(rèn)需要的軟件是否安裝： # lslpp -l bos.adt.base Fileset Level State Description Path: /usr/lib/objrepos bos.adt.base 0 COMMITTED Base Application Development Toolkit # lslpp -l bos.adt.lib Fileset Level State Description Path:

57、/usr/lib/objrepos bos.adt.lib 0 COMMITTED Base Application Development Libraries # lslpp -l bos.adt.libm lslpp: 0504-132 Fileset bos.adt.libm not installed. # lslpp -l bos.perf.libperfstat Fileset Level State Description Path: /usr/lib/objrepos bos.perf.libperfstat 0 COMMITTED Performance Statistics

58、 Library Interface Path: /etc/objrepos bos.perf.libperfstat COMMITTED Performance Statistics Library Interface # lslpp -l ctools Fileset Level State Description Path: /usr/lib/objrepos ctools 0 COMMITTED Proc Filesystem Tools # # lslpp -l xlC.* Fileset Level State Description Path: /usr/lib/objrepos

59、 xlC.aix50.rte 3 COMMITTED C Set + Runtime for AIX 5.0 xlC.cpp COMMITTED C for AIX Preprocessor xlC.msg.en_US.cpp COMMITTED C for AIX Preprocessor Messages-U.S. English xlC.msg.en_US.rte COMMITTED C Set + Runtime Messages-U.S. English xlC.rte COMMITTED C Set + Runtime # bos.adt.limb不存在，需要安裝。 安裝bos.a

60、dt.libm 進(jìn)入菜單smitty，選擇安裝和更新軟件 ： 選擇安裝軟件： 進(jìn)入安裝軟件后，按F4選擇安裝軟件用到的輸入設(shè)備，選擇CD安裝： 進(jìn)入對(duì)于要安裝的軟件菜單項(xiàng)： 按F4 給出安裝列表。在列表中，軟件項(xiàng)目之前的符號(hào)代表此軟件已經(jīng)安裝，+代表未安裝： 輸入“/”查找軟件bos.adt.libm 按F7選擇，點(diǎn)擊Enter安裝： 選擇接受License Agreements: 回車開(kāi)始安裝： # lslpp -l bos.adt.libm Fileset Level State Description Path: /usr/lib/objrepos bos.adt.libm COMMIT