Table of Contents
Overview
- Install ASM instance and Rdbms instance into same OH even not suggested by Oracle - Use ASM for RAC datafiles - You can switch between ASM instance and RAC instance by changing ORACLE_SID ( RACT1 +ASM1 / RACT2 +ASM2 ) - RAC spfile location: +DATA/RACT/spfileRACT.ora - ASM pfile location: /u01/app/oracle/product/10.2/rac_db1/dbs/init+ASM1.ora
Install RDBSMS/ASM software and create database
[oracle@ract1 ~]$ cd /Kits [oracle@ract1 Kits]$ cd database [oracle@ract1 database]$ ls doc install response runInstaller stage welcome.html [oracle@ract1 database]$ ./runInstaller -ignoreSysPrereqs Starting Oracle Universal Installer... -> Database : RACT select ASM and don't install ASM in a separate OH even suggested ! Error: Create database fais with ORA-27125 on OEL 5.10 Solution: cd $ORACLE_HOME/bin mv oracle oracle.bin -- Paste it as one cat >oracle <<"EOF" #!/bin/bash export DISABLE_HUGETLBFS=1 exec $ORACLE_HOME/bin/oracle.bin $@ EOF -- End of paste chmod +x oracle --> Rerun create database assistent It seems only Java utilities need above WA - after installation disable WA $ srvctl stop database -d RACT $ mv oracle oracle.wrapper $ mv oracle.bin oracle $ ls -l oracle -rwsr-s--x 1 oracle oinstall 108916387 Apr 6 11:27 oracle $ srvctl start database -d RACT
Verify Cluster database status
# crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....T1.inst application ONLINE ONLINE ract1 ora....T2.inst application ONLINE ONLINE ract2 ora.RACT.db application ONLINE ONLINE ract1 ora....SM1.asm application ONLINE ONLINE ract1 ora....T1.lsnr application ONLINE ONLINE ract1 ora.ract1.gsd application ONLINE ONLINE ract1 ora.ract1.ons application ONLINE ONLINE ract1 ora.ract1.vip application ONLINE ONLINE ract1 ora....SM2.asm application ONLINE ONLINE ract2 ora....T2.lsnr application ONLINE ONLINE ract2 ora.ract2.gsd application ONLINE ONLINE ract2 ora.ract2.ons application ONLINE ONLINE ract2 ora.ract2.vip application ONLINE ONLINE ract2 Check ASM instance ASM diskgroup RAC instances ASM instance [oracle@ract1 bin]$ export ORACLE_SID=+ASM1 [oracle@ract1 bin]$ asmcmd lsdg State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name MOUNTED NORMAL N N 512 4096 1048576 8188 5786 2047 1869 0 DATA/ [oracle@ract1 bin]$ asmcmd ls +DATA/RACT/spfileRACT.ora spfileRACT.ora RAC instance [oracle@ract1 bin]$ export ORACLE_SID=RACT1 SQL> select INST_ID,INSTANCE_NUMBER,INSTANCE_NAME, status from gv$instance; INST_ID INSTANCE_NUMBER INSTANCE_NAME STATUS ---------- --------------- ---------------- ------------ 2 2 RACT2 OPEN 1 1 RACT1 OPEN Start and monitor instances [oracle@ract1 ~]$ srvctl start database -d RACT [oracle@ract1 ~]$ srvctl status database -d RACT Instance RACT1 is running on node ract1 Instance RACT2 is running on node ract2