RHEL5 Oracle 11G R2 RAC 靜默安裝 （二）GI靜默安裝

huyi_tony發表於2014-10-07
Oracle
二，  GI靜默安裝
1, vi .bash_profile 節點一

點選(此處)摺疊或開啟

  1. export EDITOR=vi
  2. export ORACLE_SID=+ASM1
  3. export ORACLE_BASE=/u01/app/oracle
  4. export ORACLE_HOME=/u01/11.2.0/grid
  5. export GRID_HOME=/u01/11.2.0/grid
  6. export LD_LIBRARY_PATH=$ORACLE_HOME/lib
  7. export THREADS_FLAG=native
  8. export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
  9. umask 022
節點2  export ORACLE_SID=+ASM1   改成 +ASM2

2， 驗證是否滿足安裝條件 節點一操作
[grid@huy1 grid]$ ./runcluvfy.sh stage -pre crsinst -n huy1,huy2 -fixup -verbose
驗證結果

點選(此處)摺疊或開啟

  1. Performing pre-checks for cluster services setup

  3. Checking node reachability...

  5. Check: Node reachability from node \"huy1\"
  6.   Destination Node Reachable?
  7.   ------------------------------------ ------------------------
  8.   huy1 yes
  9.   huy2 yes
  10. Result: Node reachability check passed from node \"huy1\"


  13. Checking user equivalence...

  15. Check: User equivalence for user \"grid\"
  16.   Node Name Comment
  17.   ------------------------------------ ------------------------
  18.   huy2 passed
  19.   huy1 passed
  20. Result: User equivalence check passed for user \"grid\"

  22. Checking node connectivity...

  24. Checking hosts config file...
  25.   Node Name Status Comment
  26.   ------------ ------------------------ ------------------------
  27.   huy2 passed
  28.   huy1 passed

  30. Verification of the hosts config file successful


  33. Interface information for node \"huy2\"
  34.  Name IP Address Subnet Gateway Def. Gateway HW Address MTU
  35.  ------ --------------- --------------- --------------- --------------- ----------------- ------
  36.  eth0 192.168.56.102 192.168.56.0 0.0.0.0 192.168.56.1 08:00:27:70:1D:15 1500
  37.  eth1 10.10.10.102 10.10.10.0 0.0.0.0 192.168.56.1 08:00:27:60:EE:A3 1500


  40. Interface information for node \"huy1\"
  41.  Name IP Address Subnet Gateway Def. Gateway HW Address MTU
  42.  ------ --------------- --------------- --------------- --------------- ----------------- ------
  43.  eth0 192.168.56.101 192.168.56.0 0.0.0.0 192.168.56.1 08:00:27:7A:C6:9C 1500
  44.  eth1 10.10.10.101 10.10.10.0 0.0.0.0 192.168.56.1 08:00:27:EE:FD:51 1500


  47. Check: Node connectivity of subnet \"192.168.56.0\"
  48.   Source Destination Connected?
  49.   ------------------------------ ------------------------------ ----------------
  50.   huy2:eth0 huy1:eth0 yes
  51. Result: Node connectivity passed for subnet \"192.168.56.0\" with node(s) huy2,huy1


  54. Check: TCP connectivity of subnet \"192.168.56.0\"
  55.   Source Destination Connected?
  56.   ------------------------------ ------------------------------ ----------------
  57.   huy1:192.168.56.101 huy2:192.168.56.102 passed
  58. Result: TCP connectivity check passed for subnet \"192.168.56.0\"


  61. Check: Node connectivity of subnet \"10.10.10.0\"
  62.   Source Destination Connected?
  63.   ------------------------------ ------------------------------ ----------------
  64.   huy2:eth1 huy1:eth1 yes
  65. Result: Node connectivity passed for subnet \"10.10.10.0\" with node(s) huy2,huy1


  68. Check: TCP connectivity of subnet \"10.10.10.0\"
  69.   Source Destination Connected?
  70.   ------------------------------ ------------------------------ ----------------
  71.   huy1:10.10.10.101 huy2:10.10.10.102 passed
  72. Result: TCP connectivity check passed for subnet \"10.10.10.0\"


  75. Interfaces found on subnet \"192.168.56.0\" that are likely candidates for VIP are:
  76. huy2 eth0:192.168.56.102
  77. huy1 eth0:192.168.56.101

  79. Interfaces found on subnet \"10.10.10.0\" that are likely candidates for a private interconnect are:
  80. huy2 eth1:10.10.10.102
  81. huy1 eth1:10.10.10.101

  83. Result: Node connectivity check passed


  86. Check: Total memory
  87.   Node Name Available Required Comment
  88.   ------------ ------------------------ ------------------------ ----------
  89.   huy2 2.97GB (3115728.0KB) 1.5GB (1572864.0KB) passed
  90.   huy1 2.97GB (3115728.0KB) 1.5GB (1572864.0KB) passed
  91. Result: Total memory check passed

  93. Check: Available memory
  94.   Node Name Available Required Comment
  95.   ------------ ------------------------ ------------------------ ----------
  96.   huy2 2.91GB (3051936.0KB) 50MB (51200.0KB) passed
  97.   huy1 2.84GB (2979388.0KB) 50MB (51200.0KB) passed
  98. Result: Available memory check passed

  100. Check: Swap space
  101.   Node Name Available Required Comment
  102.   ------------ ------------------------ ------------------------ ----------
  103.   huy2 3GB (3145712.0KB) 2.97GB (3115728.0KB) passed
  104.   huy1 3GB (3145712.0KB) 2.97GB (3115728.0KB) passed
  105. Result: Swap space check passed

  107. Check: Free disk space for \"huy2:/tmp\"
  108.   Path Node Name Mount point Available Required Comment
  109.   ---------------- ------------ ------------ ------------ ------------ ------------
  110.   /tmp huy2 / 2.49GB 1GB passed
  111. Result: Free disk space check passed for \"huy2:/tmp\"

  113. Check: Free disk space for \"huy1:/tmp\"
  114.   Path Node Name Mount point Available Required Comment
  115.   ---------------- ------------ ------------ ------------ ------------ ------------
  116.   /tmp huy1 / 8.71GB 1GB passed
  117. Result: Free disk space check passed for \"huy1:/tmp\"

  119. Check: User existence for \"grid\"
  120.   Node Name Status Comment
  121.   ------------ ------------------------ ------------------------
  122.   huy2 exists passed
  123.   huy1 exists passed
  124. Result: User existence check passed for \"grid\"

  126. Check: Group existence for \"oinstall\"
  127.   Node Name Status Comment
  128.   ------------ ------------------------ ------------------------
  129.   huy2 exists passed
  130.   huy1 exists passed
  131. Result: Group existence check passed for \"oinstall\"

  133. Check: Group existence for \"dba\"
  134.   Node Name Status Comment
  135.   ------------ ------------------------ ------------------------
  136.   huy2 exists passed
  137.   huy1 exists passed
  138. Result: Group existence check passed for \"dba\"

  140. Check: Membership of user \"grid\" in group \"oinstall\" [as Primary]
  141.   Node Name User Exists Group Exists User in Group Primary Comment
  142.   ---------------- ------------ ------------ ------------ ------------ ------------
  143.   huy2 yes yes yes yes passed
  144.   huy1 yes yes yes yes passed
  145. Result: Membership check for user \"grid\" in group \"oinstall\" [as Primary] passed

  147. Check: Membership of user \"grid\" in group \"dba\"
  148.   Node Name User Exists Group Exists User in Group Comment
  149.   ---------------- ------------ ------------ ------------ ----------------
  150.   huy2 yes yes yes passed
  151.   huy1 yes yes yes passed
  152. Result: Membership check for user \"grid\" in group \"dba\" passed

  154. Check: Run level
  155.   Node Name run level Required Comment
  156.   ------------ ------------------------ ------------------------ ----------
  157.   huy2 5 3,5 passed
  158.   huy1 5 3,5 passed
  159. Result: Run level check passed

  161. Check: Hard limits for \"maximum open file descriptors\"
  162.   Node Name Type Available Required Comment
  163.   ---------------- ------------ ------------ ------------ ----------------
  164.   huy2 hard 65536 65536 passed
  165.   huy1 hard 65536 65536 passed
  166. Result: Hard limits check passed for \"maximum open file descriptors\"

  168. Check: Soft limits for \"maximum open file descriptors\"
  169.   Node Name Type Available Required Comment
  170.   ---------------- ------------ ------------ ------------ ----------------
  171.   huy2 soft 1024 1024 passed
  172.   huy1 soft 1024 1024 passed
  173. Result: Soft limits check passed for \"maximum open file descriptors\"

  175. Check: Hard limits for \"maximum user processes\"
  176.   Node Name Type Available Required Comment
  177.   ---------------- ------------ ------------ ------------ ----------------
  178.   huy2 hard 16384 16384 passed
  179.   huy1 hard 16384 16384 passed
  180. Result: Hard limits check passed for \"maximum user processes\"

  182. Check: Soft limits for \"maximum user processes\"
  183.   Node Name Type Available Required Comment
  184.   ---------------- ------------ ------------ ------------ ----------------
  185.   huy2 soft 2047 2047 passed
  186.   huy1 soft 2047 2047 passed
  187. Result: Soft limits check passed for \"maximum user processes\"

  189. Check: System architecture
  190.   Node Name Available Required Comment
  191.   ------------ ------------------------ ------------------------ ----------
  192.   huy2 i686 x86 passed
  193.   huy1 i686 x86 passed
  194. Result: System architecture check passed

  196. Check: Kernel version
  197.   Node Name Available Required Comment
  198.   ------------ ------------------------ ------------------------ ----------
  199.   huy2 2.6.18-194.el5 2.6.18 passed
  200.   huy1 2.6.18-194.el5 2.6.18 passed
  201. Result: Kernel version check passed

  203. Check: Kernel parameter for \"semmsl\"
  204.   Node Name Configured Required Comment
  205.   ------------ ------------------------ ------------------------ ----------
  206.   huy2 250 250 passed
  207.   huy1 250 250 passed
  208. Result: Kernel parameter check passed for \"semmsl\"

  210. Check: Kernel parameter for \"semmns\"
  211.   Node Name Configured Required Comment
  212.   ------------ ------------------------ ------------------------ ----------
  213.   huy2 32000 32000 passed
  214.   huy1 32000 32000 passed
  215. Result: Kernel parameter check passed for \"semmns\"

  217. Check: Kernel parameter for \"semopm\"
  218.   Node Name Configured Required Comment
  219.   ------------ ------------------------ ------------------------ ----------
  220.   huy2 100 100 passed
  221.   huy1 100 100 passed
  222. Result: Kernel parameter check passed for \"semopm\"

  224. Check: Kernel parameter for \"semmni\"
  225.   Node Name Configured Required Comment
  226.   ------------ ------------------------ ------------------------ ----------
  227.   huy2 128 128 passed
  228.   huy1 128 128 passed
  229. Result: Kernel parameter check passed for \"semmni\"

  231. Check: Kernel parameter for \"shmmax\"
  232.   Node Name Configured Required Comment
  233.   ------------ ------------------------ ------------------------ ----------
  234.   huy2 536870912 536870912 passed
  235.   huy1 536870912 536870912 passed
  236. Result: Kernel parameter check passed for \"shmmax\"

  238. Check: Kernel parameter for \"shmmni\"
  239.   Node Name Configured Required Comment
  240.   ------------ ------------------------ ------------------------ ----------
  241.   huy2 4096 4096 passed
  242.   huy1 4096 4096 passed
  243. Result: Kernel parameter check passed for \"shmmni\"

  245. Check: Kernel parameter for \"shmall\"
  246.   Node Name Configured Required Comment
  247.   ------------ ------------------------ ------------------------ ----------
  248.   huy2 2097152 2097152 passed
  249.   huy1 2097152 2097152 passed
  250. Result: Kernel parameter check passed for \"shmall\"

  252. Check: Kernel parameter for \"file-max\"
  253.   Node Name Configured Required Comment
  254.   ------------ ------------------------ ------------------------ ----------
  255.   huy2 6815744 6815744 passed
  256.   huy1 6815744 6815744 passed
  257. Result: Kernel parameter check passed for \"file-max\"

  259. Check: Kernel parameter for \"ip_local_port_range\"
  260.   Node Name Configured Required Comment
  261.   ------------ ------------------------ ------------------------ ----------
  262.   huy2 between 9000 & 65500 between 9000 & 65500 passed
  263.   huy1 between 9000 & 65500 between 9000 & 65500 passed
  264. Result: Kernel parameter check passed for \"ip_local_port_range\"

  266. Check: Kernel parameter for \"rmem_default\"
  267.   Node Name Configured Required Comment
  268.   ------------ ------------------------ ------------------------ ----------
  269.   huy2 262144 262144 passed
  270.   huy1 262144 262144 passed
  271. Result: Kernel parameter check passed for \"rmem_default\"

  273. Check: Kernel parameter for \"rmem_max\"
  274.   Node Name Configured Required Comment
  275.   ------------ ------------------------ ------------------------ ----------
  276.   huy2 4194304 4194304 passed
  277.   huy1 4194304 4194304 passed
  278. Result: Kernel parameter check passed for \"rmem_max\"

  280. Check: Kernel parameter for \"wmem_default\"
  281.   Node Name Configured Required Comment
  282.   ------------ ------------------------ ------------------------ ----------
  283.   huy2 262144 262144 passed
  284.   huy1 262144 262144 passed
  285. Result: Kernel parameter check passed for \"wmem_default\"

  287. Check: Kernel parameter for \"wmem_max\"
  288.   Node Name Configured Required Comment
  289.   ------------ ------------------------ ------------------------ ----------
  290.   huy2 1048586 1048576 passed
  291.   huy1 1048586 1048576 passed
  292. Result: Kernel parameter check passed for \"wmem_max\"

  294. Check: Kernel parameter for \"aio-max-nr\"
  295.   Node Name Configured Required Comment
  296.   ------------ ------------------------ ------------------------ ----------
  297.   huy2 1048576 1048576 passed
  298.   huy1 1048576 1048576 passed
  299. Result: Kernel parameter check passed for \"aio-max-nr\"

  301. Check: Package existence for \"make-3.81\"
  302.   Node Name Available Required Comment
  303.   ------------ ------------------------ ------------------------ ----------
  304.   huy2 make-3.81-3.el5 make-3.81 passed
  305.   huy1 make-3.81-3.el5 make-3.81 passed
  306. Result: Package existence check passed for \"make-3.81\"

  308. Check: Package existence for \"binutils-2.17.50.0.6\"
  309.   Node Name Available Required Comment
  310.   ------------ ------------------------ ------------------------ ----------
  311.   huy2 binutils-2.17.50.0.6-14.el5 binutils-2.17.50.0.6 passed
  312.   huy1 binutils-2.17.50.0.6-14.el5 binutils-2.17.50.0.6 passed
  313. Result: Package existence check passed for \"binutils-2.17.50.0.6\"

  315. Check: Package existence for \"gcc-4.1.2\"
  316.   Node Name Available Required Comment
  317.   ------------ ------------------------ ------------------------ ----------
  318.   huy2 gcc-4.1.2-48.el5 gcc-4.1.2 passed
  319.   huy1 gcc-4.1.2-48.el5 gcc-4.1.2 passed
  320. Result: Package existence check passed for \"gcc-4.1.2\"

  322. Check: Package existence for \"gcc-c++-4.1.2\"
  323.   Node Name Available Required Comment
  324.   ------------ ------------------------ ------------------------ ----------
  325.   huy2 gcc-c++-4.1.2-48.el5 gcc-c++-4.1.2 passed
  326.   huy1 gcc-c++-4.1.2-48.el5 gcc-c++-4.1.2 passed
  327. Result: Package existence check passed for \"gcc-c++-4.1.2\"

  329. Check: Package existence for \"libgomp-4.1.2\"
  330.   Node Name Available Required Comment
  331.   ------------ ------------------------ ------------------------ ----------
  332.   huy2 libgomp-4.4.0-6.el5 libgomp-4.1.2 passed
  333.   huy1 libgomp-4.4.0-6.el5 libgomp-4.1.2 passed
  334. Result: Package existence check passed for \"libgomp-4.1.2\"

  336. Check: Package existence for \"libaio-0.3.106\"
  337.   Node Name Available Required Comment
  338.   ------------ ------------------------ ------------------------ ----------
  339.   huy2 libaio-0.3.106-5 libaio-0.3.106 passed
  340.   huy1 libaio-0.3.106-5 libaio-0.3.106 passed
  341. Result: Package existence check passed for \"libaio-0.3.106\"

  343. Check: Package existence for \"glibc-2.5-24\"
  344.   Node Name Available Required Comment
  345.   ------------ ------------------------ ------------------------ ----------
  346.   huy2 glibc-2.5-49 glibc-2.5-24 passed
  347.   huy1 glibc-2.5-49 glibc-2.5-24 passed
  348. Result: Package existence check passed for \"glibc-2.5-24\"

  350. Check: Package existence for \"compat-libstdc++-33-3.2.3\"
  351.   Node Name Available Required Comment
  352.   ------------ ------------------------ ------------------------ ----------
  353.   huy2 compat-libstdc++-33-3.2.3-61 compat-libstdc++-33-3.2.3 passed
  354.   huy1 compat-libstdc++-33-3.2.3-61 compat-libstdc++-33-3.2.3 passed
  355. Result: Package existence check passed for \"compat-libstdc++-33-3.2.3\"

  357. Check: Package existence for \"elfutils-libelf-0.125\"
  358.   Node Name Available Required Comment
  359.   ------------ ------------------------ ------------------------ ----------
  360.   huy2 elfutils-libelf-0.137-3.el5 elfutils-libelf-0.125 passed
  361.   huy1 elfutils-libelf-0.137-3.el5 elfutils-libelf-0.125 passed
  362. Result: Package existence check passed for \"elfutils-libelf-0.125\"

  364. Check: Package existence for \"elfutils-libelf-devel-0.125\"
  365.   Node Name Available Required Comment
  366.   ------------ ------------------------ ------------------------ ----------
  367.   huy2 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-devel-0.125 passed
  368.   huy1 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-devel-0.125 passed
  369. Result: Package existence check passed for \"elfutils-libelf-devel-0.125\"

  371. Check: Package existence for \"glibc-common-2.5\"
  372.   Node Name Available Required Comment
  373.   ------------ ------------------------ ------------------------ ----------
  374.   huy2 glibc-common-2.5-49 glibc-common-2.5 passed
  375.   huy1 glibc-common-2.5-49 glibc-common-2.5 passed
  376. Result: Package existence check passed for \"glibc-common-2.5\"

  378. Check: Package existence for \"glibc-devel-2.5\"
  379.   Node Name Available Required Comment
  380.   ------------ ------------------------ ------------------------ ----------
  381.   huy2 glibc-devel-2.5-49 glibc-devel-2.5 passed
  382.   huy1 glibc-devel-2.5-49 glibc-devel-2.5 passed
  383. Result: Package existence check passed for \"glibc-devel-2.5\"

  385. Check: Package existence for \"glibc-headers-2.5\"
  386.   Node Name Available Required Comment
  387.   ------------ ------------------------ ------------------------ ----------
  388.   huy2 glibc-headers-2.5-49 glibc-headers-2.5 passed
  389.   huy1 glibc-headers-2.5-49 glibc-headers-2.5 passed
  390. Result: Package existence check passed for \"glibc-headers-2.5\"

  392. Check: Package existence for \"libaio-devel-0.3.106\"
  393.   Node Name Available Required Comment
  394.   ------------ ------------------------ ------------------------ ----------
  395.   huy2 libaio-devel-0.3.106-5 libaio-devel-0.3.106 passed
  396.   huy1 libaio-devel-0.3.106-5 libaio-devel-0.3.106 passed
  397. Result: Package existence check passed for \"libaio-devel-0.3.106\"

  399. Check: Package existence for \"libgcc-4.1.2\"
  400.   Node Name Available Required Comment
  401.   ------------ ------------------------ ------------------------ ----------
  402.   huy2 libgcc-4.1.2-48.el5 libgcc-4.1.2 passed
  403.   huy1 libgcc-4.1.2-48.el5 libgcc-4.1.2 passed
  404. Result: Package existence check passed for \"libgcc-4.1.2\"

  406. Check: Package existence for \"libstdc++-4.1.2\"
  407.   Node Name Available Required Comment
  408.   ------------ ------------------------ ------------------------ ----------
  409.   huy2 libstdc++-4.1.2-48.el5 libstdc++-4.1.2 passed
  410.   huy1 libstdc++-4.1.2-48.el5 libstdc++-4.1.2 passed
  411. Result: Package existence check passed for \"libstdc++-4.1.2\"

  413. Check: Package existence for \"libstdc++-devel-4.1.2\"
  414.   Node Name Available Required Comment
  415.   ------------ ------------------------ ------------------------ ----------
  416.   huy2 libstdc++-devel-4.1.2-48.el5 libstdc++-devel-4.1.2 passed
  417.   huy1 libstdc++-devel-4.1.2-48.el5 libstdc++-devel-4.1.2 passed
  418. Result: Package existence check passed for \"libstdc++-devel-4.1.2\"

  420. Check: Package existence for \"sysstat-7.0.2\"
  421.   Node Name Available Required Comment
  422.   ------------ ------------------------ ------------------------ ----------
  423.   huy2 sysstat-7.0.2-3.el5 sysstat-7.0.2 passed
  424.   huy1 sysstat-7.0.2-3.el5 sysstat-7.0.2 passed
  425. Result: Package existence check passed for \"sysstat-7.0.2\"

  427. Check: Package existence for \"unixODBC-2.2.11\"
  428.   Node Name Available Required Comment
  429.   ------------ ------------------------ ------------------------ ----------
  430.   huy2 unixODBC-2.2.11-7.1 unixODBC-2.2.11 passed
  431.   huy1 unixODBC-2.2.11-7.1 unixODBC-2.2.11 passed
  432. Result: Package existence check passed for \"unixODBC-2.2.11\"

  434. Check: Package existence for \"unixODBC-devel-2.2.11\"
  435.   Node Name Available Required Comment
  436.   ------------ ------------------------ ------------------------ ----------
  437.   huy2 unixODBC-devel-2.2.11-7.1 unixODBC-devel-2.2.11 passed
  438.   huy1 unixODBC-devel-2.2.11-7.1 unixODBC-devel-2.2.11 passed
  439. Result: Package existence check passed for \"unixODBC-devel-2.2.11\"

  441. Check: Package existence for \"ksh-20060214\"
  442.   Node Name Available Required Comment
  443.   ------------ ------------------------ ------------------------ ----------
  444.   huy2 ksh-20100202-1.el5 ksh-20060214 passed
  445.   huy1 ksh-20100202-1.el5 ksh-20060214 passed
  446. Result: Package existence check passed for \"ksh-20060214\"

  448. Checking for multiple users with UID value 0
  449. Result: Check for multiple users with UID value 0 passed

  451. Check: Current group ID
  452. Result: Current group ID check passed
  453. Checking Core file name pattern consistency...
  454. Core file name pattern consistency check passed.

  456. Checking to make sure user \"grid\" is not in \"root\" group
  457.   Node Name Status Comment
  458.   ------------ ------------------------ ------------------------
  459.   huy2 does not exist passed
  460.   huy1 does not exist passed
  461. Result: User \"grid\" is not part of \"root\" group. Check passed

  463. Check default user file creation mask
  464.   Node Name Available Required Comment
  465.   ------------ ------------------------ ------------------------ ----------
  466.   huy2 0022 0022 passed
  467.   huy1 0022 0022 passed
  468. Result: Default user file creation mask check passed

  470. Starting Clock synchronization checks using Network Time Protocol(NTP)...

  472. NTP Configuration file check started...
  473. Network Time Protocol(NTP) configuration file not found on any of the nodes. Oracle Cluster Time Synchronization Service(CTSS) can be used instead of NTP for time synchronization on the cluster nodes

  475. Result: Clock synchronization check using Network Time Protocol(NTP) passed


  478. Pre-check for cluster services setup was successful.
驗證透過

3， 編寫 response檔案  靜默安裝，沒有圖形化安裝的 人機互動的機會，必須把圖形安裝的那些輸入值 用 response檔案傳進去
 安裝包解壓後，response檔案的模板在response目錄下的 crs_install.rsp。可以借用它來修改。
我的response檔案如下。（ 圖形安裝配置結束時，可以儲存當前配置 到 response檔案。以後也可以基於這個response檔案來調整）

點選(此處)摺疊或開啟

  1. ###############################################################################
  2. ## Copyright(c) Oracle Corporation 1998,2008. All rights reserved. ##
  3. ## ##
  4. ## Specify values for the variables listed below to customize ##
  5. ## your installation. ##
  6. ## ##
  7. ## Each variable is associated with a comment. The comment ##
  8. ## can help to populate the variables with the appropriate ##
  9. ## values.                             ##
  10. ## ##
  11. ## IMPORTANT NOTE: This file contains plain text passwords and ##
  12. ## should be secured to have read permission only by oracle user ##
  13. ## or db administrator who owns this installation. ##
  14. ## ##
  15. ###############################################################################

  17. ###############################################################################
  18. ## ##
  19. ## Instructions to fill this response file ##
  20. ## To install and configure \'Grid Infrastructure for Cluster\' ##
  21. ## - Fill out sections A,B,C,D,E,F and G ##
  22. ## - Fill out section G if OCR and voting disk should be placed on ASM ##
  23. ## ##
  24. ## To install and configure \'Grid Infrastructure for Standalone server\' ##
  25. ## - Fill out sections A,B and G ##
  26. ## ##
  27. ## To install software for \'Grid Infrastructure\' ##
  28. ## - Fill out sections A,B and C ##
  29. ## ##
  30. ## To upgrade clusterware and/or Automatic storage management of earlier ##
  31. ## releases ##
  32. ## - Fill out sections A,B,C,D and H ##
  33. ## ##
  34. ###############################################################################
  35. #------------------------------------------------------------------------------
  36. # Do not change the following system generated value.
  37. #------------------------------------------------------------------------------
  38. oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v11_2_0

  40. ###############################################################################
  41. # #
  42. # SECTION A - BASIC #
  43. # #
  44. ###############################################################################

  46. #-------------------------------------------------------------------------------
  47. # Specify the hostname of the system as set during the install. It can be used
  48. # to force the installation to use an alternative hostname rather than using the
  49. # first hostname found on the system. (e.g., for systems with multiple hostnames
  50. # and network interfaces)
  51. #-------------------------------------------------------------------------------
  52. ORACLE_HOSTNAME=huy1

  54. #-------------------------------------------------------------------------------
  55. # Specify the location which holds the inventory files.
  56. #-------------------------------------------------------------------------------
  57. INVENTORY_LOCATION=/u01/app/oraInventory

  59. #-------------------------------------------------------------------------------
  60. # Specify the languages in which the components will be installed.
  61. #
  62. # en : English ja : Japanese
  63. # fr : French ko : Korean
  64. # ar : Arabic es : Latin American Spanish
  65. # bn : Bengali lv : Latvian
  66. # pt_BR: Brazilian Portuguese lt : Lithuanian
  67. # bg : Bulgarian ms : Malay
  68. # fr_CA: Canadian French es_MX: Mexican Spanish
  69. # ca : Catalan no : Norwegian
  70. # hr : Croatian pl : Polish
  71. # cs : Czech pt : Portuguese
  72. # da : Danish ro : Romanian
  73. # nl : Dutch ru : Russian
  74. # ar_EG: Egyptian zh_CN: Simplified Chinese
  75. # en_GB: English (Great Britain) sk : Slovak
  76. # et : Estonian sl : Slovenian
  77. # fi : Finnish es_ES: Spanish
  78. # de : German sv : Swedish
  79. # el : Greek th : Thai
  80. # iw : Hebrew zh_TW: Traditional Chinese
  81. # hu : Hungarian tr : Turkish
  82. # is : Icelandic uk : Ukrainian
  83. # in : Indonesian vi : Vietnamese
  84. # it : Italian
  85. #
  86. # Example : SELECTED_LANGUAGES=en,fr,ja
  87. #-------------------------------------------------------------------------------
  88. SELECTED_LANGUAGES=en

  90. #-------------------------------------------------------------------------------
  91. # Specify the installation option.
  92. # Allowed values: CRS_CONFIG or HA_CONFIG or UPGRADE or CRS_SWONLY
  93. # CRS_CONFIG - To configure Grid Infrastructure for cluster
  94. # HA_CONFIG - To configure Grid Infrastructure for stand alone server
  95. # UPGRADE - To upgrade clusterware software of earlier release
  96. # CRS_SWONLY - To install clusterware files only (can be configured for cluster
  97. # or stand alone server later)
  98. #-------------------------------------------------------------------------------
  99. oracle.install.option=CRS_CONFIG

  101. #-------------------------------------------------------------------------------
  102. # Specify the complete path of the Oracle Base.
  103. #-------------------------------------------------------------------------------

  105. ORACLE_BASE=/u01/app/oracle

  107. #-------------------------------------------------------------------------------
  108. # Specify the complete path of the Oracle Home.
  109. #-------------------------------------------------------------------------------
  110. ORACLE_HOME=/u01/11.2.0/grid

  112. ################################################################################
  113. # #
  114. # SECTION B - GROUPS #
  115. # #
  116. # The following three groups need to be assigned for all GI installations. #
  117. # OSDBA and OSOPER can be the same or different. OSASM must be different #
  118. # than the other two. #
  119. # #
  120. ################################################################################
  121. #-------------------------------------------------------------------------------
  122. # The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
  123. #-------------------------------------------------------------------------------
  124. oracle.install.asm.OSDBA=asmdba

  126. #-------------------------------------------------------------------------------
  127. # The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
  128. #-------------------------------------------------------------------------------
  129. oracle.install.asm.OSOPER=asmoper

  131. #-------------------------------------------------------------------------------
  132. # The OSASM_GROUP is the OS group which is to be granted OSASM privileges. This
  133. # must be different than the previous two.
  134. #-------------------------------------------------------------------------------
  135. oracle.install.asm.OSASM=asmadmin

  137. ################################################################################
  138. # #
  139. # SECTION C - SCAN #
  140. # #
  141. ################################################################################
  142. #-------------------------------------------------------------------------------
  143. # Specify a name for SCAN
  144. #-------------------------------------------------------------------------------
  145. oracle.install.crs.config.gpnp.scanName=huy-scan

  147. #-------------------------------------------------------------------------------
  148. # Specify a unused port number for SCAN service
  149. #-------------------------------------------------------------------------------
  150. oracle.install.crs.config.gpnp.scanPort=1521

  152. ################################################################################
  153. # #
  154. # SECTION D - CLUSTER & GNS #
  155. # #
  156. ################################################################################
  157. #-------------------------------------------------------------------------------
  158. # Specify a name for the Cluster you are creating.
  159. #
  160. # The maximum length allowed for clutername is 15 characters. The name can be
  161. # any combination of lower and uppercase alphabets (A - Z), (0 - 9), hyphen(-)
  162. # and underscore(_).
  163. #-------------------------------------------------------------------------------
  164. oracle.install.crs.config.clusterName=huy-cluster

  166. #-------------------------------------------------------------------------------
  167. # Specify \'true\' if you would like to configure Grid Naming Service(GNS), else
  168. # specify \'false\'
  169. #-------------------------------------------------------------------------------
  170. oracle.install.crs.config.gpnp.configureGNS=false

  172. #-------------------------------------------------------------------------------
  173. # Applicable only if you choose to configure GNS
  174. # Specify the GNS subdomain and an unused virtual hostname for GNS service
  175. # Additionally you may also specify if VIPs have to be autoconfigured
  176. #-------------------------------------------------------------------------------
  177. oracle.install.crs.config.gpnp.gnsSubDomain=
  178. oracle.install.crs.config.gpnp.gnsVIPAddress=
  179. oracle.install.crs.config.autoConfigureClusterNodeVIP=false

  181. #-------------------------------------------------------------------------------
  182. # Specify a list of public node names, and virtual hostnames that have to be
  183. # part of the cluster.
  184. #
  185. # The list should a comma-separated list of nodes. Each entry in the list
  186. # should be a colon-separated string that contains 2 fields.
  187. #
  188. # The fields should be ordered as follows:
  189. # 1. The first field is for public node name.
  190. # 2. The second field is for virtual host name
  191. # (specify as AUTO if you have chosen \'auto configure for VIP\'
  192. # i.e. autoConfigureClusterNodeVIP=true)
  193. #
  194. # Example: oracle.install.crs.config.clusterNodes=node1:node1-vip,node2:node2-vip
  195. #-------------------------------------------------------------------------------
  196. oracle.install.crs.config.clusterNodes=huy1:huy1-vip,huy2:huy2-vip

  198. #-------------------------------------------------------------------------------
  199. # The value should be a comma separated strings where each string is as shown below
  200. # InterfaceName:SubnetMask:InterfaceType
  201. # where InterfaceType can be either \"1\" or \"2\"(2 indicates private, and 1 indicates public)
  202. #
  203. # For example: eth0:140.87.24.0:1,eth1:140.87.40.0:2,eth2:140.87.52.0:1
  204. #
  205. #-------------------------------------------------------------------------------
  206. oracle.install.crs.config.privateInterconnects=eth0:192.168.56.0:1,eth1:10.10.10.0:2

  208. ################################################################################
  209. # #
  210. # SECTION E - STORAGE #
  211. # #
  212. ################################################################################

  214. #-------------------------------------------------------------------------------
  215. # Specify the type of storage to use for Oracle Cluster Registry(OCR) and Voting
  216. # Disks files
  217. # - ASM_STORAGE
  218. # - FILE_SYSTEM_STORAGE
  219. #-------------------------------------------------------------------------------
  220. oracle.install.crs.config.storageOption=ASM_STORAGE


  223. #-------------------------------------------------------------------------------
  224. # THIS PROPERTY NEEDS TO BE FILLED ONLY IN CASE OF WINDOWS INSTALL.
  225. # Specify a comma separated list of strings where each string is as shown below:
  226. # Disk Number:Partition Number:Drive Letter:Format Option
  227. # The Disk Number and Partition Number should refer to the location which has to
  228. # be formatted. The Drive Letter should refer to the drive letter that has to be
  229. # assigned. \"Format Option\" can be either of the following -
  230. # 1. SOFTWARE - Format to place software binaries.
  231. # 2. DATA - Format to place the OCR/VDSK files.
  232. #
  233. # For example: 1:2:P:DATA,1:3:Q:SOFTWARE,1:4:R:DATA,1:5:S:DATA
  234. #
  235. #-------------------------------------------------------------------------------
  236. oracle.install.crs.config.sharedFileSystemStorage.diskDriveMapping=

  238. #-------------------------------------------------------------------------------
  239. # These properties are applicable only if FILE_SYSTEM_STORAGE is chosen for
  240. # storing OCR and voting disk
  241. # Specify the location(s) and redundancy for OCR and voting disks
  242. # Multiple locations can be specified, seprated by commas.
  243. # In case of windows, mention the drive location that is specified to be
  244. # formatted for DATA in the above property.
  245. # Redundancy can be one of these:
  246. # NORMAL - one(1) location should be specified for OCR and voting disk
  247. # EXTERNAL - three(3) locations should be specified for OCR and voting disk
  248. #-------------------------------------------------------------------------------
  249. oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=
  250. oracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=NORMAL
  251. oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=
  252. oracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=NORMAL
  253.                    
  254. ################################################################################
  255. # #
  256. # SECTION F - IPMI #
  257. # #
  258. ################################################################################

  260. #-------------------------------------------------------------------------------
  261. # Specify \'true\' if you would like to configure Intelligent Power Management interface
  262. # (IPMI), else specify \'false\'
  263. #-------------------------------------------------------------------------------
  264. oracle.install.crs.config.useIPMI=false

  266. #-------------------------------------------------------------------------------
  267. # Applicable only if you choose to configure IPMI
  268. # i.e. oracle.install.crs.config.useIPMI=true
  269. # Specify the username and password for using IPMI service
  270. #-------------------------------------------------------------------------------
  271. oracle.install.crs.config.ipmi.bmcUsername=
  272. oracle.install.crs.config.ipmi.bmcPassword=

  274. ################################################################################
  275. # #
  276. # SECTION G - ASM #
  277. # #
  278. ################################################################################
  279. #-------------------------------------------------------------------------------
  280. # Specify a password for SYSASM user of the ASM instance
  281. #-------------------------------------------------------------------------------
  282. oracle.install.asm.SYSASMPassword=

  284. #-------------------------------------------------------------------------------
  285. # The ASM DiskGroup
  286. #
  287. # Example: oracle.install.asm.diskGroup.name=data
  288. #
  289. #-------------------------------------------------------------------------------
  290. oracle.install.asm.diskGroup.name=OCR_VOTE

  292. #-------------------------------------------------------------------------------
  293. # Redundancy level to be used by ASM.
  294. # It can be one of the following
  295. # - NORMAL
  296. # - HIGH
  297. # - EXTERNAL
  298. # Example: oracle.install.asm.diskGroup.redundancy=NORMAL
  299. #
  300. #-------------------------------------------------------------------------------
  301. oracle.install.asm.diskGroup.redundancy=NORMAL

  303. #-------------------------------------------------------------------------------
  304. # List of disks to create a ASM DiskGroup
  305. #
  306. # Example: oracle.install.asm.diskGroup.disks=/oracle/asm/disk1,/oracle/asm/disk2
  307. #
  308. #-------------------------------------------------------------------------------
  309. oracle.install.asm.diskGroup.disks=ORCL:OCR_VOTE1,ORCL:OCR_VOTE2,ORCL:OCR_VOTE3

  311. #-------------------------------------------------------------------------------
  312. # The disk discovery string to be used to discover the disks used create a ASM DiskGroup
  313. #
  314. # Example: oracle.install.asm.diskGroup.diskDiscoveryString=/oracle/asm/*
  315. #
  316. #-------------------------------------------------------------------------------
  317. oracle.install.asm.diskGroup.diskDiscoveryString=

  319. #-------------------------------------------------------------------------------
  320. # oracle.install.asm.monitorPassword=password
  321. #-------------------------------------------------------------------------------
  322. oracle.install.asm.monitorPassword=

  324. ################################################################################
  325. # #
  326. # SECTION H - UPGRADE #
  327. # #
  328. ################################################################################
  329. #-------------------------------------------------------------------------------
  330. # Specify nodes for Upgrade.
  331. # Example: oracle.install.crs.upgrade.clusterNodes=node1,node2
  332. #-------------------------------------------------------------------------------
  333. oracle.install.crs.upgrade.clusterNodes=

  335. #-------------------------------------------------------------------------------
  336. # For RAC-ASM only. oracle.install.asm.upgradeASM=true/false
  337. #-------------------------------------------------------------------------------
  338. oracle.install.asm.upgradeASM=false

4， 開始靜默安裝   節點一操作
[grid@huy1 grid]$ ./runInstaller -ignorePrereq -silent -force -responseFile /home/grid/grid.rsp
反饋資訊如下

點選(此處)摺疊或開啟

  1. Starting Oracle Universal Installer...

  3. Checking Temp space: must be greater than 80 MB. Actual 8521 MB Passed
  4. Checking swap space: must be greater than 150 MB. Actual 3071 MB Passed
  5. Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-09-11_04-04-17PM. Please wait ...[grid@huy1 grid]$ Xlib: connection to \"localhost:10.0\" refused by server
  6. Xlib: SSH gateway: X11 authentication failed.

  8. [grid@huy1 grid]$ [WARNING] [INS-30011] The password entered does not conform to the Oracle recommended standards.
  9.    CAUSE: Oracle recommends that the SYS password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
  10.    ACTION: Provide a password that conforms to the Oracle recommended standards.
  11. [WARNING] [INS-30011] The password entered does not conform to the Oracle recommended standards.
  12.    CAUSE: Oracle recommends that the ASMSNMP password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
  13.    ACTION: Provide a password that conforms to the Oracle recommended standards.
  14. [WARNING] [INS-30011] The password entered does not conform to the Oracle recommended standards.
  15.    CAUSE: Oracle recommends that the SYS password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
  16.    ACTION: Provide a password that conforms to the Oracle recommended standards.
  17. [WARNING] [INS-30011] The password entered does not conform to the Oracle recommended standards.
  18.    CAUSE: Oracle recommends that the ASMSNMP password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
  19.    ACTION: Provide a password that conforms to the Oracle recommended standards.
  20. You can find the log of this install session at:
  21.  /u01/app/oraInventory/logs/installActions2014-09-11_04-04-17PM.log
  22. The following configuration scripts need to be executed as the \"root\" user.
  23.  #!/bin/sh
  24.  #Root scripts to run

  26. /u01/app/oraInventory/orainstRoot.sh
  27. /u01/11.2.0/grid/root.sh
  28. To execute the configuration scripts:
  29.          1. Open a terminal window
  30.          2. Log in as \"root\"
  31.          3. Run the scripts
  32.          4. Return to this window and hit \"Enter\" key to continue

  34. Configuration assistants have not been run. This can happen for following reasons - either root.sh is to be run before config or Oracle Universal Installer was invoked with the -noConfig option.
  35. \"/u01/11.2.0/grid/cfgtoollogs/configToolAllCommands\" script contains all commands to be executed by the configuration assistants. This file may be used to run the configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.


  38. Successfully Setup Software.

  40. [grid@huy1 grid]$ /u01/11.2.0/grid/cfgtoollogs/configToolAllCommands
  41. Setting the invPtrLoc to /u01/11.2.0/grid/oraInst.loc

  43. perform - mode is starting for action: configure


  46. perform - mode finished for action: configure

  48. You can see the log file: /u01/11.2.0/grid/cfgtoollogs/oui/configActions2014-09-11_04-20-21-PM.log
安裝過程中，在兩邊的節點都用root執行 /u01/app/oraInventory/orainstRoot.sh 和 /u01/11.2.0/grid/root.sh 兩個指令碼。跟圖形安裝一樣的。

5， 編寫配置指令碼的 response檔案 節點一操作
[grid@huy1 ~]$ vi /u01/11.2.0/grid/cfgrsp.properties          內容填寫

點選(此處)摺疊或開啟

  1. oracle.assistants.server|S_SYSPASSWORD=oracle
  2. oracle.assistants.server|S_SYSTEMPASSWORD=oracle
  3. oracle.assistants.server|S_SYSMANPASSWORD=oracle
  4. oracle.assistants.server|S_DBSNMPPASSWORD=oracle
  5. oracle.assistants.server|S_HOSTUSERPASSWORD=oracle
  6. oracle.assistants.server|S_ASMSNMPPASSWORD=oracle
6， 執行配置指令碼 節點一操作
[grid@huy1 ~]$ /u01/11.2.0/grid/cfgtoollogs/configToolAllCommands  RESPONSE_FILE=/u01/11.2.0/grid/cfgrsp.properties

驗證結果
監聽配置

點選(此處)摺疊或開啟

  1. [grid@huy1 grid]$ lsnrctl

  3. LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 11-SEP-2014 16:20:34

  5. Copyright (c) 1991, 2009, Oracle. All rights reserved.

  7. Welcome to LSNRCTL, type \"help\" for information.

  9. LSNRCTL> status
  10. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
  11. STATUS of the LISTENER
  12. ------------------------
  13. Alias LISTENER
  14. Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
  15. Start Date 11-SEP-2014 16:20:28
  16. Uptime 0 days 0 hr. 0 min. 7 sec
  17. Trace Level off
  18. Security ON: Local OS Authentication
  19. SNMP OFF
  20. Listener Parameter File /u01/11.2.0/grid/network/admin/listener.ora
  21. Listener Log File /u01/app/oracle/diag/tnslsnr/huy1/listener/alert/log.xml
  22. Listening Endpoints Summary...
  23.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  24.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.101)(PORT=1521)))
  25.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.201)(PORT=1521)))
  26. Services Summary...
  27. Service \"+ASM\" has 1 instance(s).
  28.   Instance \"+ASM1\", status READY, has 1 handler(s) for this service...
  29. The command completed successfully

口令檔案

點選(此處)摺疊或開啟

  1. [grid@huy1 ~]$ cd $ORACLE_HOME/dbs
  2. [grid@huy1 dbs]$ ls
  3. ab_+ASM1.dat hc_+ASM1.dat init.ora orapwd+ASM peshm_+ASM_1

crs 資源狀態

點選(此處)摺疊或開啟

  1. [grid@huy1 dbs]$ crs_stat -t
  2. Name Type Target State Host
  3. ------------------------------------------------------------
  4. ora....ER.lsnr ora....er.type ONLINE ONLINE huy1
  5. ora....N1.lsnr ora....er.type ONLINE ONLINE huy1
  6. ora....VOTE.dg ora....up.type ONLINE ONLINE huy1
  7. ora.asm ora.asm.type ONLINE ONLINE huy1
  8. ora.eons ora.eons.type ONLINE ONLINE huy1
  9. ora.gsd ora.gsd.type OFFLINE OFFLINE
  10. ora....SM1.asm application ONLINE ONLINE huy1
  11. ora....Y1.lsnr application ONLINE ONLINE huy1
  12. ora.huy1.gsd application OFFLINE OFFLINE
  13. ora.huy1.ons application ONLINE ONLINE huy1
  14. ora.huy1.vip ora....t1.type ONLINE ONLINE huy1
  15. ora....SM2.asm application ONLINE ONLINE huy2
  16. ora....Y2.lsnr application ONLINE ONLINE huy2
  17. ora.huy2.gsd application OFFLINE OFFLINE
  18. ora.huy2.ons application ONLINE ONLINE huy2
  19. ora.huy2.vip ora....t1.type ONLINE ONLINE huy2
  20. ora....network ora....rk.type ONLINE ONLINE huy1
  21. ora.oc4j ora.oc4j.type OFFLINE OFFLINE
  22. ora.ons ora.ons.type ONLINE ONLINE huy1
  23. ora....ry.acfs ora....fs.type ONLINE ONLINE huy1
  24. ora.scan1.vip ora....ip.type ONLINE ONLINE huy1

7， 建立其他ASM磁碟組

點選(此處)摺疊或開啟

  1. [grid@huy1 dbs]$ sqlplus \'/as sysasm\'

  3. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 11 16:36:59 2014

  5. Copyright (c) 1982, 2009, Oracle. All rights reserved.


  8. Connected to:
  9. Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
  10. With the Real Application Clusters and Automatic Storage Management options

  12. SQL> select instance_name, host_name, status from v$instance;

  14. INSTANCE_NAME
  15. ----------------
  16. HOST_NAME STATUS
  17. ---------------------------------------------------------------- ------------
  18. +ASM1
  19. huy1 STARTED


  22. SQL> select instance_name, host_name, status from gv$instance;

  24. INSTANCE_NAME
  25. ----------------
  26. HOST_NAME STATUS
  27. ---------------------------------------------------------------- ------------
  28. +ASM1
  29. huy1 STARTED

  31. +ASM2
  32. huy2 STARTED

  34. SQL> select name, state, type, total_mb, free_mb from v$asm_diskgroup;

  36. NAME STATE TYPE TOTAL_MB FREE_MB
  37. ------------------------------ ----------- ------ ---------- ----------
  38. OCR_VOTE MOUNTED NORMAL 2892 1966

  40. SQL> create diskgroup DATA external redundancy disk \'/dev/oracleasm/disks/DATA1\',\'/dev/oracleasm/disks/DATA2\';

  42. Diskgroup created.

  44. SQL> create diskgroup RCY normal redundancy failgroup fg1 disk \'/dev/oracleasm/disks/RCY1\'
  45.   2 failgroup fg2 disk \'/dev/oracleasm/disks/RCY2\';

  47. Diskgroup created.

  49. SQL> select name, state, type, total_mb, free_mb from v$asm_diskgroup;

  51. NAME STATE TYPE TOTAL_MB FREE_MB
  52. ------------------------------ ----------- ------ ---------- ----------
  53. OCR_VOTE MOUNTED NORMAL 2892 1966
  54. DATA MOUNTED EXTERN 9554 9502
  55. RCY MOUNTED NORMAL 5976 5874

  57. SQL> show parameter asm

  59. NAME TYPE VALUE
  60. ------------------------------------ ----------- ------------------------------
  61. asm_diskgroups string DATA, RCY
  62. asm_diskstring string /dev/oracleasm/disks/*
  63. asm_power_limit integer 1
  64. asm_preferred_read_failure_groups string
  65. SQL>







來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12238525/viewspace-1290619/，如需轉載，請註明出處，否則將追究法律責任。

相關文章