Linux平臺(tái) Oracle 10gR2(10.2.0.5)RAC安裝 Part3:db安裝和升級(jí)
環(huán)境:OEL 5.7 + Oracle 10.2.0.5 RAC
Linux平臺(tái) Oracle 10gR2 RAC安裝指導(dǎo):
Part1:Linux平臺(tái) Oracle 10gR2(10.2.0.5)RAC安裝 Part1:準(zhǔn)備工作
Part2:Linux平臺(tái) Oracle 10gR2(10.2.0.5)RAC安裝 Part2:clusterware安裝和升級(jí)
Part3:Linux平臺(tái) Oracle 10gR2(10.2.0.5)RAC安裝 Part3:db安裝和升級(jí)
5.安裝Database軟件
5.1 解壓安裝介質(zhì)
[oracle@oradb27 ~]$ cd /u01/media/ [oracle@oradb27 media]$ gunzip 10201_database_linux_x86_64.cpio.gz [oracle@oradb27 media]$ cpio -idmv < 10201_database_linux_x86_64.cpio [oracle@oradb27 media]$ cd database/ [oracle@oradb27 database]$ ls doc install response runInstaller stage welcome.html [oracle@oradb27 database]$ cd install/ [oracle@oradb27 install]$ ls addLangs.sh addNode.sh images lsnodes oneclick.properties oraparam.ini oraparamsilent.ini resource response unzip [oracle@oradb27 install]$ vi oraparam.ini #找到“[Certified Versions]”這里,行尾添加redhat-5,保存退出[Certified Versions] Linux=redhat-3,SuSE-9,redhat-4,UnitedLinux-1.0,asianux-1,asianux-2,redhat-5
5.2 開始安裝db軟件
使用xquartz連接到節(jié)點(diǎn)1,開始調(diào)用圖形安裝db軟件。
[oracle@oradb27 database]$ pwd /u01/media/database [oracle@oradb27 database]$ ls doc install response runInstaller stage welcome.html [oracle@oradb27 database]$ ./runInstaller
5.3 root用戶執(zhí)行腳本
root用戶按照提示執(zhí)行腳本@all nodes
/u01/app/oracle/product/10.2.0.5/dbhome_1/root.sh
然后繼續(xù)下一步,提示完成安裝:
The following J2EE Applications have been deployed and are accessible at the URLs listed below. iSQL*Plus URL:http://oradb27:5561/isqlplusiSQL*Plus DBA URL:http://oradb27:5561/isqlplus/dba
到這里,就完成db 10.2.0.1的軟件安裝。
6.升級(jí)Database軟件
6.1 升級(jí)db軟件
[oracle@oradb27 Disk1]$ pwd /u01/media/Disk1 [oracle@oradb27 Disk1]$ ls install patch_note.htm response runInstaller stage [oracle@oradb27 Disk1]$ ./runInstaller
6.2 root用戶執(zhí)行腳本@all nodes
root用戶執(zhí)行腳本@all nodes
/u01/app/oracle/product/10.2.0.5/dbhome_1/root.sh
執(zhí)行完成后,返回圖形界面完成安裝:
The iSQL*Plus URL is:http://oradb27:5560/isqlplusThe iSQL*Plus DBA URL is:http://oradb27:5560/isqlplus/dba
到這里,成功升級(jí)db軟件到10.2.0.5版本。
7.創(chuàng)建數(shù)據(jù)庫
7.1 創(chuàng)建監(jiān)聽
netca創(chuàng)建監(jiān)聽。
成功后查看集群資源,已經(jīng)多了監(jiān)聽資源:
[oracle@oradb27 Disk1]$ crs_stat -t -v Name Type R/RA F/FT Target State Host ---------------------------------------------------------------------- ora....27.lsnr application 0/5 0/0 ONLINE ONLINE oradb27 ora....b27.gsd application 0/5 0/0 ONLINE ONLINE oradb27 ora....b27.ons application 0/3 0/0 ONLINE ONLINE oradb27 ora....b27.vip application 0/0 0/0 ONLINE ONLINE oradb27 ora....28.lsnr application 0/5 0/0 ONLINE ONLINE oradb28 ora....b28.gsd application 0/5 0/0 ONLINE ONLINE oradb28 ora....b28.ons application 0/3 0/0 ONLINE ONLINE oradb28 ora....b28.vip application 0/0 0/0 ONLINE ONLINE oradb28 [oracle@oradb27 Disk1]$
7.2 創(chuàng)建ASM
dbca 配置ASM磁盤組,添加DATA,F(xiàn)RA磁盤組。
配置ASM磁盤組的過程中會(huì)創(chuàng)建ASM實(shí)例,成功后,查看集群資源,已經(jīng)多了asm實(shí)例資源:
[oracle@oradb27 Disk1]$ crs_stat -t -v Name Type R/RA F/FT Target State Host ---------------------------------------------------------------------- ora....SM1.asm application 0/5 0/0 ONLINE ONLINE oradb27 ora....27.lsnr application 0/5 0/0 ONLINE ONLINE oradb27 ora....b27.gsd application 0/5 0/0 ONLINE ONLINE oradb27 ora....b27.ons application 0/3 0/0 ONLINE ONLINE oradb27 ora....b27.vip application 0/0 0/0 ONLINE ONLINE oradb27 ora....SM2.asm application 0/5 0/0 ONLINE ONLINE oradb28 ora....28.lsnr application 0/5 0/0 ONLINE ONLINE oradb28 ora....b28.gsd application 0/5 0/0 ONLINE ONLINE oradb28 ora....b28.ons application 0/3 0/0 ONLINE ONLINE oradb28 ora....b28.vip application 0/0 0/0 ONLINE ONLINE oradb28
7.3 創(chuàng)建數(shù)據(jù)庫
dbca 創(chuàng)建數(shù)據(jù)庫。
創(chuàng)建完成后,查看集群資源,多了數(shù)據(jù)庫實(shí)例資源和數(shù)據(jù)庫資源:
[oracle@oradb27 Disk1]$ crs_stat -t -v Name Type R/RA F/FT Target State Host ---------------------------------------------------------------------- ora.jyrac.db application 0/0 0/1 ONLINE ONLINE oradb28 ora....c1.inst application 0/5 0/0 ONLINE ONLINE oradb27 ora....c2.inst application 0/5 0/0 ONLINE ONLINE oradb28 ora....SM1.asm application 0/5 0/0 ONLINE ONLINE oradb27 ora....27.lsnr application 0/5 0/0 ONLINE ONLINE oradb27 ora....b27.gsd application 0/5 0/0 ONLINE ONLINE oradb27 ora....b27.ons application 0/3 0/0 ONLINE ONLINE oradb27 ora....b27.vip application 0/0 0/0 ONLINE ONLINE oradb27 ora....SM2.asm application 0/5 0/0 ONLINE ONLINE oradb28 ora....28.lsnr application 0/5 0/0 ONLINE ONLINE oradb28 ora....b28.gsd application 0/5 0/0 ONLINE ONLINE oradb28 ora....b28.ons application 0/3 0/0 ONLINE ONLINE oradb28 ora....b28.vip application 0/0 0/0 ONLINE ONLINE oradb28 [oracle@oradb27 Disk1]$
驗(yàn)證當(dāng)前數(shù)據(jù)庫版本和可用性:
[oracle@oradb27 Disk1]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jan 3 20:59:21 2017Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing options SQL> select open_mode from v$database; OPEN_MODE ---------- READ WRITE SQL> SQL> col comp_name for a45 SQL> set linesize 120SQL> select comp_name, status, version from dba_registry; COMP_NAME STATUS VERSION --------------------------------------------- ---------------------- ------------------------------ Spatial VALID 10.2.0.5.0Oracle interMedia VALID 10.2.0.5.0OLAP Catalog VALID 10.2.0.5.0Oracle Enterprise Manager VALID 10.2.0.5.0Oracle XML Database VALID 10.2.0.5.0Oracle Text VALID 10.2.0.5.0Oracle Expression Filter VALID 10.2.0.5.0Oracle Rules Manager VALID 10.2.0.5.0Oracle Workspace Manager VALID 10.2.0.5.0Oracle Data Mining VALID 10.2.0.5.0Oracle Database Catalog Views VALID 10.2.0.5.0COMP_NAME STATUS VERSION --------------------------------------------- ---------------------- ------------------------------ Oracle Database Packages and Types VALID 10.2.0.5.0JServer JAVA Virtual Machine VALID 10.2.0.5.0Oracle XDK VALID 10.2.0.5.0Oracle Database Java Packages VALID 10.2.0.5.0OLAP Analytic Workspace VALID 10.2.0.5.0Oracle OLAP API VALID 10.2.0.5.0Oracle Real Application Clusters VALID 10.2.0.5.018 rows selected.
至此,Linux平臺(tái) Oracle 10gR2(10.2.0.5)RAC安裝系列已全部完成。