[oracle@racserver1 ~]$ srvctl config database -d rac Database unique name: rac Database name: rac Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1 Oracle user: oracle Spfile: +DATA/rac/spfilerac.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: rac Database instances: rac1,rac2 Disk Groups: DATA,CRS Mount point paths: Services: Type: RAC Database is administrator managed
192.168.100.15 rac-cluster-scan
jdbc:oracle:thin:@rac-cluster-scan:1521/RAC
RAC = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac-cluster-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rac) ) )
192.168.100.15 rac-cluster-scan
#ref(): File not found: "2011-1792.png" at page "tech_memo/oracle_RAC/Install"
[oracle@racserver2 ~]$ su - grid [grid@racserver2 ~]$ sqlplus /nolog SQL> connect / as sysasm SQL> startup
SQL> connect / as sysdba SQL> startup
sd=sde,lun=/dev/raw/raw2,size=948114030592,threads=10,openflags=o_direct wd=wd1,sd=sde,xfersize=8k,rdpct=100,seekpct=100 rd=rd1,wd=wd1,iorate=max,elapsed=300,interval=30
Sep 14, 2012 interval i/o MB/sec bytes read resp resp resp cpu% cpu% rate 1024**2 i/o pct time max stddev sys+usr sys 11:40:30.106 1 864.80 6.76 8192 100.00 11.548 118.023 7.215 0.6 0.2 11:41:00.055 2 865.80 6.76 8192 100.00 11.544 110.715 7.201 0.5 0.2 11:41:30.055 3 868.10 6.78 8192 100.00 11.519 89.887 7.157 0.4 0.2 11:42:00.053 4 864.63 6.75 8192 100.00 11.564 81.753 7.198 0.7 0.3 11:42:30.053 5 865.73 6.76 8192 100.00 11.550 81.749 7.159 0.4 0.2 11:43:00.052 6 866.17 6.77 8192 100.00 11.543 109.402 7.233 0.5 0.2 11:43:30.052 7 860.63 6.72 8192 100.00 11.618 101.268 7.322 0.7 0.3 11:44:00.052 8 863.93 6.75 8192 100.00 11.573 110.366 7.376 0.5 0.2 11:44:30.053 9 868.00 6.78 8192 100.00 11.519 81.086 7.143 1.5 0.4 11:45:00.052 10 860.33 6.72 8192 100.00 11.623 89.086 7.316 0.5 0.2 11:45:00.057 avg_2-10 864.81 6.76 8192 100.00 11.561 110.715 7.234 0.6 0.2 11:45:00.996 Vdbench execution completed successfully. Output directory: /var/tmp/result007
sd=sde,lun=/dev/raw/raw2,size=948114030592,threads=10,openflags=o_direct wd=wd1,sd=sde,xfersize=16k,rdpct=50,seekpct=100 rd=rd1,wd=wd1,iorate=max,elapsed=300,interval=30
Sep 14, 2012 interval i/o MB/sec bytes read resp resp resp cpu% cpu% rate 1024**2 i/o pct time max stddev sys+usr sys 11:49:12.109 1 976.20 15.25 16384 49.74 10.216 118.451 15.034 1.5 0.4 11:49:42.056 2 789.43 12.33 16384 49.53 12.667 114.399 17.827 0.6 0.3 11:50:12.055 3 659.43 10.30 16384 49.29 15.160 207.803 21.514 0.5 0.2 11:50:42.053 4 510.50 7.98 16384 50.11 19.584 194.438 25.519 0.4 0.2 11:51:12.053 5 537.83 8.40 16384 50.06 18.572 230.033 24.994 0.4 0.2 11:51:42.052 6 521.60 8.15 16384 49.46 19.196 219.890 26.380 0.5 0.2 11:52:12.052 7 533.23 8.33 16384 50.24 18.754 227.372 25.859 0.5 0.2 11:52:42.052 8 529.33 8.27 16384 49.57 18.889 238.850 25.617 0.4 0.2 11:53:12.052 9 520.83 8.14 16384 50.28 19.195 256.716 25.107 0.5 0.2 11:53:42.052 10 522.60 8.17 16384 49.53 19.087 212.952 24.775 0.7 0.3 11:53:42.058 avg_2-10 569.42 8.90 16384 49.76 17.555 256.716 24.079 0.5 0.2