通过VMWARE虚拟机搭建Oracle 10g R2 R

Because crs PING the default gateway several minutes automatically， so the vip will become OFFLINE if it cannot reach the gateway which doesn’t exists actually （we set 192.168.10.2）。

　　Install Oracle 10g Database with ASM

　　［root@rac01 ~］$ su – oracle

　　Install the Database：

　　［oracle@rac01 ~］$ /media/cdrom/runInstaller

　　Installation Type： Enterprise Product Languages： Add Japanese

　　Name： OraDB_Install

　　Path： /oracle/product/10.2.0/db_1

　　Product-Specific Prerequisite Checks： You can ignore Checking Network Configuration requirements here， because we use static IP not DHCP.

　　ASM’s SYS password： nhy67ujm

　　ORA-15186： ASMLIB error function = ［asm_open］， error = ［1］，

　　ORA-15032： not all alterations performed

　　ORA-15063： ASM discovered an insufficient number of disks for diskgroup

　　Solution： Click ASM parameters：

　　asm_diskstring=’ORCL：*’

　　ERROR： no PST quorum in group 1： required 2， found 0

　　Metalink（309815.1）： There are two issues with using multipath disks in ASM. ASM cannot handle seeing the same disk twice. If it does， it will cause an error.

　　vi /etc/sysconfig/oracleasm

　　ORACLEASM_SCANORDER=”oracleasm”

　　ORACLEASM_SCANEXCLUDE=”sdb sdc sdd sde sdf”

　　You can make any data group here， because we will delete the data group and recreate new ones later.

　　Once the installation is completed， wait while the configuration assistants run. Execute the ” /oracle/product/10.2.0/db_1/root.sh ” as root on all nodes （Enter the full pathname of the local bin directory： ［/usr/local/bin］： /usr/local/bin）， and then click the “OK” button.

　　［oracle@rac01 ~］$ export ORACLE_SID=+ASM1

　　［oracle@rac01 ~］$ sqlplus / as sysdba

　　SQL》 drop diskgroup DATA including contents;

　　SQL》 create diskgroup DATADG

　　normal redundancy

　　failgroup fgroup1 disk

　　‘/dev/raw/raw6′ name DATADG_ASM_1

　　failgroup fgroup2 disk

　　‘/dev/raw/raw7′ name DATADG_ASM_2;

　　create diskgroup REDODG

　　normal redundancy

　　failgroup fgroup1 disk

　　‘/dev/raw/raw8′ name REDODG_ASM_1

　　failgroup fgroup2 disk

　　‘/dev/raw/raw9′ name REDODG_ASM_2;

　　create diskgroup FLASHDG

　　normal redundancy

　　failgroup fgroup1 disk

　　‘/dev/raw/raw10′ name FLASHDG_ASM_1

　　failgroup fgroup2 disk

　　‘/dev/raw/raw11′ name FLASHDG_ASM_2;

　　After configuration， query the state of disk group.

　　SQL》 set line 150

　　col path for a15

　　col G_NO for 99

　　col name for a12

　　col LABEL for a6

　　select dg.GROUP_NUMBER G_NO，dg.name，dg.state dg_stat，d.name name，d.path，d.state d_stat，d.label，d.header_status from v$asm_diskgroup dg，v$asm_disk d where dg.group_number=d.group_number;

　　NAME DG_STAT D_NAME PATH D_STAT

　　———- ———– ——————– ————— ——–

　　DATADG MOUNTED DATADG_ASM_1 /dev/raw/raw6 NORMAL

　　DATADG MOUNTED DATADG_ASM_2 /dev/raw/raw7 NORMAL

　　REDODG MOUNTED REDODG_ASM_1 /dev/raw/raw8 NORMAL

　　REDODG MOUNTED REDODG_ASM_2 /dev/raw/raw9 NORMAL

　　FLASHDG MOUNTED FLASHDG_ASM_1 /dev/raw/raw10 NORMAL

　　FLASHDG MOUNTED FLASHDG_ASM_2 /dev/raw/raw11 NORMAL

　　If any diskgroup is unmount， use “alter diskgroup XXXDG mount” to mount it.

　　Upgrade to 10.2.0.3

　　［oracle@rac01 FTP］$ srvctl stop asm -n rac01

　　［oracle@rac01 FTP］$ srvctl stop nodeapps -n rac01

　　［oracle@rac01 FTP］$ crs_stat -t

　　Name Type Target State Host

　　————————————————————

　　ora….SM1.asm application OFFLINE OFFLINE

　　ora….01.lsnr application OFFLINE OFFLINE

　　ora.rac01.gsd application OFFLINE OFFLINE

　　ora.rac01.ons application OFFLINE OFFLINE

　　ora.rac01.vip application OFFLINE OFFLINE

　　Upgrade Clusterware：

　　［oracle@rac01 FTP］$ / FTP/Disk1/runInstaller （Need to execute “xhost +” as root at first）

　　At Specify Home Details， select Name： crs

　　Run as root：

　　［root@rac01 oracle］# /oracle/crs_home/bin/crsctl stop crs

　　［root@rac01 oracle］# /oracle/crs_home/install/root102.sh

　　Upgrade Database：

　　［oracle@rac01 FTP］$ / FTP/Disk1/runInstaller （Need to execute “xhost +” as root at first）

　　At Specify Home Details， select Name： OraDB_Install

　　Run as root：

　　［root@rac01 FTP］# /oracle/product/10.2.0/db_1/root.sh

　　［oracle @rac01 FTP］# srvctl start nodeapps -n rac01

　　［oracle @rac01 FTP］# srvctl start asm -n rac01

　　［oracle@rac01 FTP］$ crs_stat -t

　　Name Type Target State Host

　　————————————————————

　　ora….SM1.asm application ONLINE ONLINE rac01

　　ora….01.lsnr application ONLINE ONLINE rac01

　　ora.rac01.gsd application ONLINE ONLINE rac01

　　ora.rac01.ons application ONLINE ONLINE rac01

　　ora.rac01.vip application ONLINE ONLINE rac01

　　Create a Database with DBCA

　　Pre-Database creation check：

　　cd /cdrom/clusterware/cluvfy

　　$ 。/runcluvfy.sh stage -pre dbcfg -n rac01，rac02 -d /oracle/product/10.2.0

　　login to RAC01 as the oracle user and start the Database Configuration Assistant.