OracleFlexASM和Flex集群
Oracle Flex ASM和Flex集群
創(chuàng)新互聯(lián)建站專注為客戶提供全方位的互聯(lián)網(wǎng)綜合服務，包含不限于成都網(wǎng)站建設、網(wǎng)站制作、繁昌網(wǎng)絡推廣、成都小程序開發(fā)、繁昌網(wǎng)絡營銷、繁昌企業(yè)策劃、繁昌品牌公關、搜索引擎seo、人物專訪、企業(yè)宣傳片、企業(yè)代運營等，從售前售中售后，我們都將竭誠為您服務，您的肯定，是我們最大的嘉獎；創(chuàng)新互聯(lián)建站為所有大學生創(chuàng)業(yè)者提供繁昌建站搭建服務，24小時服務熱線：18982081108，官方網(wǎng)址：muchs.cn
Oracle RAC 12c 引入了兩個新概念：
中心節(jié)點：???和以前的版本一樣，它們通過專用網(wǎng)絡相互連接，并且可以直接訪問共享存儲。這些節(jié)點可以直接訪問 Oracle 集群注冊表 (OCR) 和表決磁盤 (VD)。
葉節(jié)點：???這些節(jié)點是輕型節(jié)點，彼此不互連，也不能像中心節(jié)點一樣訪問共享存儲。每個葉節(jié)點與所連接的中心節(jié)點通信，并通過所連接的中心節(jié)點連接到集群。
此拓撲允許松散耦合的應用服務器與緊密耦合的數(shù)據(jù)庫服務器形成一個集群。緊密耦合的服務器是中心服務器，與集群中的其他中心服務器共享數(shù)據(jù)庫、OCR 和表決設備的存儲并進行對等通信。松耦合的服務器是葉服務器，與集群中的單個中心服務器形成松散通信關聯(lián)，不需要與集群中的其他中心服務器或葉服務器共享存儲，也不需要與之進行對等通信，只與所關聯(lián)的中心服務器通信。在 12.1.0.1 中，葉服務器旨在提高應用的高可用性和實現(xiàn)多層資源管理。
在 Oracle 12c 之前，對于要使用 ASM 的數(shù)據(jù)庫實例來說，所有節(jié)點上的 ASM 實例必須已處于運行狀態(tài)，才能啟動數(shù)據(jù)庫實例。如果 ASM 實例未運行，則意味著在存儲級使用 ASM 的數(shù)據(jù)庫實例不能啟動。這實際上意味著無論采用何種技術（即 RAC、ASM 和共享存儲），均不能訪問數(shù)據(jù)庫實例。
隨著 Oracle 12c 的推出，一個名為 Oracle Flex ASM 的特性解除了上述限制，它的一個主要特性是故障切換到集群中的其他節(jié)點。本質上是一個中心和葉架構，Oracle Clusterware 通過一個替代 ASM 實例將故障節(jié)點的連接將無縫轉移到另一個成員節(jié)點。在給定集群中運行的 ASM 實例數(shù)被稱作 ASM 基數(shù)，默認值為 3。但此基數(shù)值可以使用 Clusterware 命令修改。
Oracle Flex 集群
從架構上來說，Oracle Flex 集群包括一個中心和葉架構，其中只有中心節(jié)點可以直接訪問 Oracle 集群注冊表 (OCR) 和表決磁盤 (VD)。但是應用可以通過葉節(jié)點訪問數(shù)據(jù)庫，而不必在葉節(jié)點上運行 ASM 實例。通過中心節(jié)點連接到數(shù)據(jù)庫使得它對應用透明。
圖 1：描繪了一個典型的 Oracle Flex 集群，包含 4 個葉節(jié)點和 2 個中心節(jié)點。簡單地說，Oracle Flex 集群需要 Oracle Flex ASM。
Oracle Flex ASM 的實現(xiàn)方面
Oracle Flex ASM 可通過兩種方式實現(xiàn)：
純 12c Flex ASM（相同版本）
Grid Infrasctructure (GI) 和數(shù)據(jù)庫都運行在 Oracle 12c 上
Oracle 12c 之前的混合版本（不同版本）
和平常一樣，ASM 實例將在每個節(jié)點上運行，F(xiàn)lex 配置支持 12c 之前的數(shù)據(jù)庫。使用 ASM 磁盤組的兼容性參數(shù)管理各數(shù)據(jù)庫實例之間的兼容性。這種方法的優(yōu)點是，如果 Oracle 12c 數(shù)據(jù)庫實例與一個 ASM 實例的連接斷開，數(shù)據(jù)庫連接將故障切換至其他服務器上的另一個 ASM 實例。通過將基數(shù)設置為 all 即可以實現(xiàn)這種故障切換。
使用 Oracle Flex ASM 的 Oracle RAC 12c
標準 Oracle Flex ASM 配置：
Oracle Flex ASM 配置上的 ASM 實例故障：
1. 登錄 RAC 數(shù)據(jù)庫實例 1 (rac1)
[oracle@oel6-112-rac1?Desktop]$?hostname oel6-112-rac1.localdomain
2. 檢查 ASM 實例和 RAC 數(shù)據(jù)庫實例的狀態(tài)
[oracle@oel6-112-rac1?Desktop]$?ps?-ef?|?grep?pmon oracle????3325?????1??0?17:39??????????00:00:00?asm_pmon_+ASM1 oracle????3813?????1??0?17:40??????????00:00:00?mdb_pmon_-MGMTDB oracle????5806?????1??0?17:42??????????00:00:00?ora_pmon_orcl1 oracle????6193?????1??0?17:42??????????00:00:00?apx_pmon_+APX1
3. 從實例 1 (rac1) 檢查 RAC 數(shù)據(jù)庫實例中 ASM 實例的狀態(tài)
[oracle@oel6-112-rac1?Desktop]$?srvctl?status?asm ASM?is?running?on?oel6-112-rac2,oel6-112-rac1
4. 在實例 1 (rac1) 中檢查集群狀態(tài)
[oracle@oel6-112-rac1?Desktop]$?crsctl?check?cluster CRS-4537:?Cluster?Ready?Services?is?online CRS-4529:?Cluster?Synchronization?Services?is?online CRS-4533:?Event?Manager?is?online
5. 用于檢查 Oracle Flex ASM 是否啟用的命令 (rac1)
[oracle@oel6-112-rac1?Desktop]$?asmcmd ASMCMD>?showclustermode? ASM?cluster?:?Flex?mode?enabled ASMCMD>?showclusterstate Normal
6. 用于更改 ASM 基數(shù)的命令 (rac1)
[oracle@oel6-112-rac1?Desktop]$?srvctl?status?asm?-detail ASM?is?running?on?oel6-112-rac2,oel6-112-rac1 ASM?is?enabled. [oracle@oel6-112-rac1?Desktop]$?srvctl?config?asm?-detail ASM?home:?/u01/app/12.1.0/grid Password?file:?+DATA/orapwASM ASM?listener:?LISTENER ASM?is?enabled. ASM?instance?count:?3 Cluster?ASM?listener:?ASMNET1LSNR_ASM
7. 用于檢查 Oracle Flex ASM 是否啟用的命令 (rac2)
[oracle@oel6-112-rac2?Desktop]$?asmcmd ASMCMD>?showclustermode ASM?cluster?:?Flex?mode?enabled ASMCMD>?showclusterstate Normal ASMCMD>?exit
8. 如何更改 ASM 基數(shù) (rac2)
[oracle@oel6-112-rac2?Desktop]$?srvctl?config??asm?-detail ASM?home:?/u01/app/12.1.0/grid Password?file:?+DATA/orapwASM ASM?listener:?LISTENER ASM?is?enabled. ASM?instance?count:?3 Cluster?ASM?listener:?ASMNET1LSNR_ASM
9. 在 RAC 數(shù)據(jù)庫實例 1 (rac1) 中關閉 ASM 實例
[oracle@oel6-112-rac1?Desktop]$?srvctl?stop?asm?-node?oel6-112-rac1?-stopoption?abort?-force
10. 在 RAC 數(shù)據(jù)庫實例 1 (rac1) 中檢查 ASM 實例的狀態(tài)
[oracle@oel6-112-rac1?Desktop]$?srvctl?status?asm PRCR-1070?:?Failed?to?check?if?resource?ora.asm?is?registered Cannot?communicate?with?crsd
11. 在 RAC 數(shù)據(jù)庫實例 1 (rac1) 中檢查集群服務的狀態(tài)
[oracle@oel6-112-rac1?Desktop]$?crsctl?check?cluster CRS-4535:?Cannot?communicate?with?Cluster?Ready?Services CRS-4529:?Cluster?Synchronization?Services?is?online CRS-4533:?Event?Manager?is?online
12. 在實例 1 (rac1) 中檢查 ASM 和 RAC 數(shù)據(jù)庫的狀態(tài)
[oracle@oel6-112-rac1?Desktop]$?ps?-ef?|?grep?pmon oracle????3813?????1??0?17:40??????????00:00:00?mdb_pmon_-MGMTDB oracle????5806?????1??0?17:42??????????00:00:00?ora_pmon_orcl1 oracle????6193?????1??0?17:42??????????00:00:00?apx_pmon_+APX1
注：?在這里，數(shù)據(jù)庫實例與特定節(jié)點中運行的特定 ASM 實例關聯(lián)。如果因為某種原因，ASM 實例無法啟動/服務關閉，數(shù)據(jù)庫實例仍然可以啟動，因為數(shù)據(jù)庫實例將查找同一集群中運行的 ASM 實例。圖 3 描繪了 Flex ASM 的高可用特性。
13. 在 RAC 數(shù)據(jù)庫實例 1 (rac1) 中檢查沒有 ASM 實例的正在運行的 RAC 數(shù)據(jù)庫實例的狀態(tài)
[oracle@oel6-112-rac1?Desktop]$?.?oraenv ORACLE_SID?=?[orcl1]???orcl1 ORACLE_HOME?=?[/home/oracle]???/u01/app/oracle/product/12.1.0/db_1 The?Oracle?base?remains?unchanged?with?value?/u01/app/oracle
14. 從 RAC 數(shù)據(jù)庫實例 1 (rac1) 登錄數(shù)據(jù)庫實例
[oracle@oel6-112-rac1?Desktop]$?sqlplus?/nolog SQL*Plus:?Release?12.1.0.1.0?Production?on?Wed?Sep?25?18:24:36?2013 Copyright?(c)?1982,?2013,?Oracle.??All?rights?reserved. SQL>?connect?sys/oracle@orcl?as?sysdba Connected. SQL>?select?instance_name,instance_number?from?gv$instance; INSTANCE_NAME???????????INSTANCE_NUMBER ------------------------------------------- orcl2?????????????????????????2 orcl1?????????????????????????1 SQL>?select?instance_name,instance_number?from?v$instance; INSTANCE_NAME???????????INSTANCE_NUMBER ------------------------------------------- orcl2?????????????????????????2 SQL>?connect?sys/oracle@orcl?as?sysdba Connected. SQL>?select?instance_name,instance_number?from?gv$instance; INSTANCE_NAME???????????INSTANCE_NUMBER ------------------------------------------- orcl1?????????????????????????1
15. 從 RAC 數(shù)據(jù)庫實例 1 (rac1) 連接到 RAC 數(shù)據(jù)庫實例 2 (rac2) 的 ASM 實例
[oracle@oel6-112-rac1?Desktop]$?.?oraenv ORACLE_SID?=?[orcl1]???+ASM2 ORACLE_HOME?=?[/home/oracle]???/u01/app/12.1.0/grid The?Oracle?base?remains?unchanged?with?value?/u01/app/oracle [oracle@oel6-112-rac1?Desktop]$?asmcmd?--privilege?sysasm?--inst?+ASM2 ASMCMD>?lsdg State????Type????Rebal??Sector??Block???????AU??Total_MB??Free_MB??Req_mir_free_MB??Usable_file_MB??Offline_disks??Voting_files??Name MOUNTED??EXTERN??N?????????512???4096??1048576?????15342?????4782????????????????0????????????4782??????????????0?????????????Y??DATA/ ASMCMD>
總結：?數(shù)據(jù)庫實例使用一個專用 ASM 實例，我們強制該 ASM 實例被停止工作來模擬故障，因此數(shù)據(jù)庫實例重新連接到另一節(jié)點（在本示例中為節(jié)點 2 (rac2)）上的現(xiàn)有 ASM 實例。
Oracle Database 11.2 或早期版本
如前面針對 Oracle 12c 的介紹所述，ASM 與數(shù)據(jù)庫實例的關聯(lián)本質上是特定的。這意味著，如果 ASM 實例無法啟動，該節(jié)點/ASM 中的關聯(lián)數(shù)據(jù)庫實例也無法啟動，從而導致該數(shù)據(jù)庫無法訪問。
1. 登錄 RAC 數(shù)據(jù)庫實例 1 (rac1)
login?as:?oracle oracle@192.168.xx.xx's?password: Last?login:?Fri?Sep?27?06:05:44?2013
2. 檢查 ASM 實例和 RAC 數(shù)據(jù)庫實例的狀態(tài)：
[oracle@rac1?~]$?ps?-ef?|?grep?pmon oracle????3053?????1??0?05:56??????????00:00:00?asm_pmon_+ASM1 oracle????3849?????1??0?05:57??????????00:00:00?ora_pmon_flavia1
3. 在 RAC 數(shù)據(jù)庫實例 1 (rac1) 中檢查 ASM 實例的狀態(tài)
[oracle@rac1?~]$?srvctl?status?asm ASM?is?running?on?rac2,rac1
4. 在 RAC 數(shù)據(jù)庫實例 1 (rac1) 中檢查集群的狀態(tài)
[oracle@rac1?~]$?crsctl?check?cluster CRS-4537:?Cluster?Ready?Services?is?online CRS-4529:?Cluster?Synchronization?Services?is?online CRS-4533:?Event?Manager?is?online
5. 在 RAC 數(shù)據(jù)庫實例 1 (rac1) 中停止 ASM 實例
[oracle@rac1?~]$?srvctl?stop?asm?-n?rac1?-o?abort?-f
6. 在 RAC 數(shù)據(jù)庫實例 1 (rac1) 中檢查 ASM 實例的狀態(tài)
[oracle@rac1?~]$?srvctl?status?asm ASM?is?running?on?rac2
7. 檢查 ASM 實例和 RAC 數(shù)據(jù)庫實例 (rac1) 的狀態(tài)
[oracle@rac1?~]$?ps?-ef?|?grep?pmon oracle????7885??5795??0?06:20?pts/0????00:00:00?grep?pmon
總結：?數(shù)據(jù)庫實例與 ASM 實例強關聯(lián)。如果 ASM 實例發(fā)生故障，同一節(jié)點上的數(shù)據(jù)庫實例也會發(fā)生故障。
?
為何使用 Oracle Flex ASM
Oracle Flex ASM 支持 Oracle Database 12c 客戶端使用更大的 LUN 大小。
支持的最大磁盤組數(shù)為 511。
可以靈活地重命名磁盤組中的 ASM 磁盤。
ASM 實例的補丁級驗證
滾動補丁期間禁用補丁級驗證
復制物理元數(shù)據(jù)
Oracle Flex ASM 中的網(wǎng)絡增強
在早期版本中，集群要求：
一個供客戶端應用訪問的公共網(wǎng)絡
一個或多個用于集群內節(jié)點間通信（包括 ASM 通信）的專用網(wǎng)絡
Flex ASM 增加 ASM 網(wǎng)絡，可用于 ASM 與其客戶端之間的通信，以便隔離和分流 ASM 通信。
部署 Flex ASM
下面是 Flex ASM 安裝程序的屏幕截圖。
選擇選項“Advanced Installation”
?
有三個存儲選項：
標準 ASM
Oracle Flex ASM
非 ASM 托管的存儲
推薦
12c 之前的 ASM 配置模式
?
管理 Flex ASM：
無需 Flex ASM 特定的實例參數(shù)
ASM 服務器實例使用自動內存管理 (AMM)
?轉：http://www.oracle.com/technetwork/cn/articles/database/flexasm-flexcluster-benefits-odb12c-2177371-zhs.html?
?
Oracle 18c Flex ASM 功能測試
1. Flex ASM說明
Oracle 在12c 中引入Oracle Flex ASM特性， 其可以使ASM實例和數(shù)據(jù)庫實例在不同的節(jié)點上運行，而不是之前的ASM實例必須和數(shù)據(jù)庫實例運行在同一個節(jié)點上。也就是說當某個節(jié)點上的ASM 實例掛掉后，其上的數(shù)據(jù)庫實例還可以正常運行。
在Oracle 12c中，在創(chuàng)建數(shù)據(jù)庫的時候還需要選擇是否啟用Oracle Flex 集群和Flex ASM， 但是到了18c中，默認就是Flex 集群和Flex ASM，不再需要選擇。 下圖是12c中使用ASMCA工具將普通ASM 實例轉換成Flex ASM。?
2. Flex ASM 測試
因為在Oracle 18c 中默認就是Flex ASM。 所以我們這里直接在RAC 環(huán)境上測試該功能。
2.1 當前RAC 環(huán)境
[grid@www.cndba.cn?~]$?crsctl?stat?res?-t -------------------------------------------------------------------------------- Name???????????Target??State????????Server???????????????????State?details??????? -------------------------------------------------------------------------------- Local?Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr ???????????????ONLINE??ONLINE???????rac1?????????????????????STABLE ???????????????ONLINE??ONLINE???????rac2?????????????????????STABLE ora.DATA.dg ???????????????ONLINE??ONLINE???????rac1?????????????????????STABLE ???????????????ONLINE??ONLINE???????rac2?????????????????????STABLE ora.LISTENER.lsnr ???????????????ONLINE??ONLINE???????rac1?????????????????????STABLE ???????????????ONLINE??ONLINE???????rac2?????????????????????STABLE ora.MGMT.GHCHKPT.advm ???????????????OFFLINE?OFFLINE??????rac1?????????????????????STABLE ???????????????OFFLINE?OFFLINE??????rac2?????????????????????STABLE ora.MGMT.dg ???????????????ONLINE??ONLINE???????rac1?????????????????????STABLE ???????????????ONLINE??ONLINE???????rac2?????????????????????STABLE ora.OCR.dg ???????????????ONLINE??ONLINE???????rac1?????????????????????STABLE ???????????????ONLINE??ONLINE???????rac2?????????????????????STABLE ora.helper ???????????????OFFLINE?OFFLINE??????rac1?????????????????????IDLE,STABLE ???????????????OFFLINE?OFFLINE??????rac2?????????????????????IDLE,STABLE ora.mgmt.ghchkpt.acfs ???????????????OFFLINE?OFFLINE??????rac1?????????????????????STABLE ???????????????OFFLINE?OFFLINE??????rac2?????????????????????STABLE ora.net1.network ???????????????ONLINE??ONLINE???????rac1?????????????????????STABLE ???????????????ONLINE??ONLINE???????rac2?????????????????????STABLE ora.ons ???????????????ONLINE??ONLINE???????rac1?????????????????????STABLE ???????????????ONLINE??ONLINE???????rac2?????????????????????STABLE ora.proxy_advm ???????????????ONLINE??ONLINE???????rac1?????????????????????STABLE ???????????????ONLINE??ONLINE???????rac2?????????????????????STABLE -------------------------------------------------------------------------------- Cluster?Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr ??????1????????ONLINE??ONLINE???????rac2?????????????????????STABLE ora.MGMTLSNR ??????1????????ONLINE??ONLINE???????rac2?????????????????????169.254.11.39?192.16 ?????????????????????????????????????????????????????????????8.56.101,STABLE ora.asm ??????1????????ONLINE??ONLINE???????rac1?????????????????????Started,STABLE ??????2????????ONLINE??ONLINE???????rac2?????????????????????Started,STABLE ??????3????????OFFLINE?OFFLINE???????????????????????????????STABLE ora.cndba.db ??????1????????ONLINE??ONLINE???????rac2?????????????????????Open,HOME=/u01/app/o ?????????????????????????????????????????????????????????????racle/product/18.3.0 ?????????????????????????????????????????????????????????????/db_1,STABLE ??????2????????ONLINE??ONLINE???????rac1?????????????????????Open,HOME=/u01/app/o ?????????????????????????????????????????????????????????????racle/product/18.3.0 ?????????????????????????????????????????????????????????????/db_1,STABLE ora.cvu ??????1????????ONLINE??ONLINE???????rac2?????????????????????STABLE ora.mgmtdb ??????1????????ONLINE??ONLINE???????rac2?????????????????????Open,STABLE ora.qosmserver ??????1????????ONLINE??ONLINE???????rac2?????????????????????STABLE ora.rac1.vip ??????1????????ONLINE??ONLINE???????rac1?????????????????????STABLE ora.rac2.vip ??????1????????ONLINE??ONLINE???????rac2?????????????????????STABLE ora.rhpserver ??????1????????OFFLINE?OFFLINE???????????????????????????????STABLE ora.scan1.vip ??????1????????ONLINE??ONLINE???????rac2?????????????????????STABLE -------------------------------------------------------------------------------- [grid@www.cndba.cn?~]$ [grid@www.cndba.cn?~]$?srvctl?-version srvctl?version:?18.0.0.0.0 [grid@www.cndba.cn?~]$?crsctl?check?cluster CRS-4537:?Cluster?Ready?Services?is?online CRS-4529:?Cluster?Synchronization?Services?is?online CRS-4533:?Event?Manager?is?online [grid@rac1?~]$
2.2 查看Flex ASM中實例信息
[grid@www.cndba.cn?~]$?asmcmd?showclustermode ASM?cluster?:?Flex?mode?enabled?-?Direct?Storage?Access [grid@www.cndba.cn?~]$?asmcmd?showclusterstate Normal [grid@www.cndba.cn?~]$ [grid@www.cndba.cn?~]$?srvctl?status?asm?-detail ASM?is?running?on?rac1,rac2 ASM?is?enabled. ASM?instance?+ASM1?is?running?on?node?rac1 Number?of?connected?clients:?3 Client?names:?+APX1:+APX:rac?cndba1:cndba:rac?rac1:_OCR:rac ASM?instance?+ASM2?is?running?on?node?rac2 Number?of?connected?clients:?4 Client?names:?+APX2:+APX:rac?-MGMTDB:_mgmtdb:rac?cndba2:cndba:rac?rac2:_OCR:rac [grid@www.cndba.cn?~]$ [grid@www.cndba.cn?~]$?srvctl?config?asm?-detail ASM?home:?<CRS?home> Password?file:?+OCR/orapwASM Backup?of?Password?file:? ASM?listener:?LISTENER ASM?is?enabled. ASM?is?individually?enabled?on?nodes:? ASM?is?individually?disabled?on?nodes:? ASM?instance?count:?3 Cluster?ASM?listener:?ASMNET1LSNR_ASM [grid@www.cndba.cn?~]$
2.3 模擬ASM 實例故障
SQL>select?instance_name,instance_number?from?gv$instance; INSTANCE_NAME?????????????INSTANCE_NUMBER --------------------------------?--------------- cndba1???????????????????????????1 cndba2???????????????????????????2 [grid@www.cndba.cn?~]$?srvctl?status?database?-d?cndba?-detail Instance?cndba1?is?running?on?node?rac1 Instance?cndba1?is?connected?to?ASM?instance?+ASM1 Instance?cndba2?is?running?on?node?rac2 Instance?cndba2?is?connected?to?ASM?instance?+ASM2
關閉節(jié)點1上的ASM 實例
[grid@www.cndba.cn?~]$?ps?-ef|grep?pmon grid??????8425?12500??0?09:00?pts/2????00:00:00?grep?--color=auto?pmon oracle???15875?????1??0?06:19??????????00:00:00?ora_pmon_cndba1 grid?????27886?????1??0?05:21??????????00:00:00?asm_pmon_+ASM1 grid?????29346?????1??0?05:21??????????00:00:00?apx_pmon_+APX1 [grid@www.cndba.cn?~]$?srvctl?stop?asm?-node?rac1?-stopoption?abort?-force [grid@www.cndba.cn?~]$?ps?-ef|grep?pmon grid??????8620?12500??0?09:00?pts/2????00:00:00?grep?--color=auto?pmon oracle???15875?????1??0?06:19??????????00:00:00?ora_pmon_cndba1 grid?????29346?????1??0?05:21??????????00:00:00?apx_pmon_+APX1 [grid@www.cndba.cn?~]$
此時ASM 實例只在節(jié)點2上運行：
[grid@www.cndba.cn?~]$?srvctl?status?asm ASM?is?running?on?rac2 [grid@www.cndba.cn?~]$?srvctl?status?database?-d?cndba?-detail Instance?cndba1?is?running?on?node?rac1 Instance?cndba1?is?connected?to?ASM?instance?+ASM2 Instance?cndba2?is?running?on?node?rac2 Instance?cndba2?is?connected?to?ASM?instance?+ASM2 [grid@www.cndba.cn?~]$?srvctl?status?asm?-detail ASM?is?running?on?rac2 ASM?is?enabled. ASM?instance?+ASM2?is?running?on?node?rac2 Number?of?connected?clients:?6 Client?names:?+APX1:+APX:rac?+APX2:+APX:rac?-MGMTDB:_mgmtdb:rac?cndba1:cndba:rac?cndba2:cndba:rac?rac2:_OCR:rac [grid@www.cndba.cn?~]$
我們可以看到+ASM2上也運行這節(jié)點1上的db 實例。
但是節(jié)點1上的數(shù)據(jù)庫實例正常運行：
SQL>?select?instance_name,instance_number?from?gv$instance; INSTANCE_NAME?????????????INSTANCE_NUMBER --------------------------------?--------------- cndba1???????????????????????????1 cndba2???????????????????????????2
啟動節(jié)點1上的ASM實例，又恢復原狀：
[grid@www.cndba.cn?~]$?srvctl?start?asm?-node?rac1 [grid@www.cndba.cn?~]$?srvctl?status?asm?-detail ASM?is?running?on?rac1,rac2 ASM?is?enabled. ASM?instance?+ASM1?is?running?on?node?rac1 Number?of?connected?clients:?3 Client?names:?+APX1:+APX:rac?cndba1:cndba:rac?rac1:_OCR:rac ASM?instance?+ASM2?is?running?on?node?rac2 Number?of?connected?clients:?4 Client?names:?+APX2:+APX:rac?-MGMTDB:_mgmtdb:rac?cndba2:cndba:rac?rac2:_OCR:rac [grid@www.cndba.cn?~]$? [grid@www.cndba.cn?~]$?srvctl?status?database?-d?cndba?-detail Instance?cndba1?is?running?on?node?rac1 Instance?cndba1?is?connected?to?ASM?instance?+ASM1 Instance?cndba2?is?running?on?node?rac2 Instance?cndba2?is?connected?to?ASM?instance?+ASM2
通過實驗，可以驗證任意一個節(jié)點的ASM實例的意外關閉/啟動，都不會影響該節(jié)點上的數(shù)據(jù)庫狀態(tài)，這極大的增強了RAC的高可用性。
Flex ASM的配置和轉換
從12c開始，推出了Flex ASM特性，允許RAC節(jié)點訪問遠程節(jié)點的ASM實例，而自身無需運行ASM實例。?
一般在Flex集群，中心節(jié)點運行ASM實例，葉節(jié)點遠程訪問中心節(jié)點的ASM實例。?
但是中心節(jié)點也可以不運行ASM實例而訪問其他節(jié)點的ASM實例；另外，標準集群也可以啟用Flex ASM。?
由于有通過網(wǎng)絡遠程訪問ASM實例的狀況，因此也形成了ASM網(wǎng)絡，ASM網(wǎng)絡可與Private網(wǎng)絡共用，即ASM&Private網(wǎng)絡，可在安裝界面指定。?
確認當前ASM狀態(tài)?
點擊(?此處?)折疊或打開
$ asmcmd showclustermode?
ASM cluster??:??Flex mode disabled
以上說明是標準ASM?
運行asmca，轉換ASM為Flex ASM，以下是部分步驟截圖?
ASM的subnet與Public不同，將不能使用與Public相同的端口號?
以root用戶運行上圖所示的腳本，將對集群內所有節(jié)點重啟CRS?
最后，確認當前集群模式?
點擊(?此處?)折疊或打開
$ asmcmd showclustermode?
ASM cluster??:??Flex mode enabled
#后兩項是Flex ASM才有的
$ srvctl config asm?
ASM home: <CRS home>?
Password file: +OCRV/orapwASM?
ASM listener: LISTENER?
ASM instance count: ALL?
Cluster ASM listener: ASMNET1LSNR_ASM?
查看ASM監(jiān)聽器?
點擊(?此處?)折疊或打開
$ lsnrctl status ASMNET1LSNR_ASM?
LSNRCTL??for??Linux?:??Version 12?.?1?.?.?2?.?0??-??Production on 01?-?JUN?-?2016 15?:?08?:?11?
Copyright??(?c?)??1991?,??2014?,??Oracle?.??All rights reserved?.?
Connecting to??(?DESCRIPTION?=?(?ADDRESS?=?(?PROTOCOL?=?IPC?)?(?KEY?=?ASMNET1LSNR_ASM?)?)?)?
STATUS??of??the LISTENER?
-?-?-?-?-?-?-?-?-?-?-?-?-?-?-?-?-?-?-?-?-?-?-?-?
Alias ASMNET1LSNR_ASM?
Version TNSLSNR??for??Linux?:??Version 12?.?1?.?.?2?.?0??-??Production?
Start Date 01?-?JUN?-?2016 15?:?02?:?46?
Uptime 0 days 0 hr?.??5 min?.??24 sec?
Trace Level off?
Security ON?:???Local??OS Authentication?
SNMP OFF?
Listener Parameter File /u01/app/12?.?1?.?0/grid/network/admin/listener?.?ora?
Listener Log File /u01/app/grid/diag/tnslsnr/node2/asmnet1lsnr_asm/alert/log?.?xml?
Listening Endpoints Summary?.?.?.?
???(?DESCRIPTION?=?(?ADDRESS?=?(?PROTOCOL?=?ipc?)?(?KEY?=?ASMNET1LSNR_ASM?)?)?)?
???(?DESCRIPTION?=?(?ADDRESS?=?(?PROTOCOL?=?tcp?)?(?HOST?=?10?.?1?.?1?.?2?)?(?PORT?=?1522?)?)?)?
Services Summary?.?.?.?
Service??"+ASM"??has 2 instance?(?s?)?.?
??Instance??"+ASM1"?,??status READY?,??has 1 handler?(?s?)???for???this??service?.?.?.?
??Instance??"+ASM2"?,??status READY?,??has 2 handler?(?s?)???for???this??service?.?.?.?
The command completed successfully
12c 如何將Standard ASM轉化為Flex ASM
什么是Flex ASM?
我們知道在12c之前的版本里，ASM實例需要在每一個節(jié)點運行，而ASM 的客戶端(Database，ACFS，ADVM)只可以訪問本地的ASM 實例。如果使用了Oracle Flex ASM，情況就不一樣了，ASM的客戶端就可以通過ASM網(wǎng)絡訪問遠程的ASM實例。如果一個運行ASM實例的節(jié)點宕掉，Oracle集群會在另外一個節(jié)點上啟動一個新的ASM實例以此維持它的節(jié)點基數(shù)(Cardinality)。 同樣，如果一個12c數(shù)據(jù)庫實例連接了某一個ASM 實例，而這個ASM 實例crash掉或者實例運行出錯，這個數(shù)據(jù)庫的實例會嘗試重新連接在另一個節(jié)點的一個已經(jīng)存在的ASM實例，這就是 Oracle Flex ASM。
Flex Cluster和Flex ASM的區(qū)別
Flex Cluster需要Flex ASM的支持
Flex ASM可以在StandardCluster和Flex Cluster運行
如何控制ASM實例的個數(shù)?
[orgrid@ohs1?~]$?srvctl?modify?asm?-count?2 [orgrid@ohs1?~]$?srvctl?config?asm ASM?home:?<CRS?home> Password?file:?+SYSTEMDG/orapwASM ASM?listener:?LISTENER ASM?instance?count:?2 Cluster?ASM?listener:?ASMNET1LSNR_ASM [orgrid@ohs1?~]$ [orgrid@ohs1?~]$?srvctl?modify?asm?-count?1 PRCA-1123?:?The?specified?ASM?cardinality?1?is?less?than?the?minimum?cardinality?of?2.
注意：ASM實例至少的有2個實例，這樣不至于單點故障?
Flex ASM和Standard ASM的轉化
我們可以把Standard ASM轉化為Flex ASM，但這個轉化是不可逆的。這樣做的目的可能是為了推廣這個特性，這個特性確實不錯
如果沒有使用Flex ASM，不設置SID會出現(xiàn)連接到空實例，但在Flex ASM情況下，會隨機選擇一個?
Standard ASM輸出?
[orgrid@ohs1?~]$?asmcmd Connected?to?an?idle?instance. ASMCMD>?exit [orgrid@ohs1?~]$?export?ORACLE_SID=+ASM1 [orgrid@ohs1?~]$?asmcmd ASMCMD>?showclustermode ASM?cluster?:?Flex?mode?disabled ASMCMD>?showclusterstate Normal ASMCMD>?lsdsk Path ORCL:ASMDISK1 ORCL:ASMDISK2 ORCL:ASMDISK3 ORCL:ASMDISK4 ASMCMD>?lsattr?-G?systemdg?-l Name?????????????????????Value??????? access_control.enabled???FALSE??????? access_control.umask?????066????????? au_size??????????????????1048576????? cell.smart_scan_capable??FALSE??????? compatible.asm???????????12.1.0.0.0?? compatible.rdbms?????????10.1.0.0.0?? content.check????????????FALSE??????? content.type?????????????data???????? disk_repair_time?????????3.6h???????? failgroup_repair_time????24.0h??????? idp.boundary?????????????auto???????? idp.type?????????????????dynamic????? phys_meta_replicated?????true???????? sector_size??????????????512????????? thin_provisioned?????????FALSE??????? ASMCMD> ASMCMD>?exit
Flex ASM輸出
[orgrid@ohs1?~]$?echo?$ORACLE_SID [orgrid@ohs1?~]$?asmcmd ASMCMD>?showclustermode ASM?cluster?:?Flex?mode?enabled ASMCMD>?showclusterstate Normal ASMCMD>
asmca幫助信息
[orgrid@ohs1?~]$
[orgrid@ohs1?~]$?asmca?-h
asmca?[-silent]?[-sysAsmPassword?<SYS?user?password>]?[-asmsnmpPassword?<ASM?monitor?password>]?{<command>?<options>}
Please?refer?to?the?manual?for?details.
You?can?enter?one?of?the?following?commands:
1.?Configure?an?ASM?instance?by?specifying?the?following?command?and?parameters:
????????-configureASM
????????????????[-sysAsmPassword?<SYS?user?password>]
????????????????[-asmsnmpPassword?<ASM?monitor?password>]
????????????????[(-param?<paramname=paramvalue>)]
????????????????-diskString?<disk?discovery?path>
????????????????(-diskGroupName?<disk?group?name>
????????????????????????(-disk?<disk?path>?[-diskName?<disk?name>]?|
?????????????????????????-diskList?<comma?separated?disk?list>
????????????????????????????????[-diskSize?<disk?size?in?MB>]
????????????????????????????????[-failuregroup?<failure?group?name>]
????????????????????????????????[-force|-noforce]
????????????????????????????????[-quorum|-noquorum])
????????????????????????[-redundancy?<HIGH|NORMAL|EXTERNAL>]
????????????????????????[-au_size?<2^0?~?2^6?(1?~?64)>]
????????????????????????[-compatible.asm?<10.1?~?11.2>]
????????????????????????[-compatible.rdbms?<10.1?~?11.2>]
????????????????????????[-compatible.advm?<11.2>])
2.?Upgrade?an?existing?ASM?instance?by?specifying?the?following?command?and?parameters:
????????-upgradeASM
????????????????[-asmsnmpPassword?<ASM?monitor?password>]
3.?Configure?ASM?parameters?by?specifying?the?following?command?and?parameters:
????????-configureParameter
????????????????(-param?<paramname=paramvalue>)
????????????????[-sysAsmPassword?<SYS?user?password>]
4.?Create?Disk?Groups?by?specifying?the?following?command?and?parameters:
????????-createDiskGroup
????????????????[-diskString?<disk?discovery?path>]
????????????????(-diskGroupName?<disk?group?name>
????????????????????????(-disk?<disk?path>?[-diskName?<disk?name>]?|
?????????????????????????-diskList?<comma?separated?disk?list>
????????????????????????????????[-diskSize?<disk?size?in?MB>]
????????????????????????????????[-failuregroup?<failure?group?name>]
????????????????????????????????[-force|-noforce]
????????????????????????????????[-quorum|-noquorum])
????????????????????????[-redundancy?<HIGH|NORMAL|EXTERNAL>]
????????????????????????[-au_size?<2^0?~?2^6?(1?~?64)>]
????????????????????????[-compatible.asm?<10.1?~?11.2>]
????????????????????????[-compatible.rdbms?<10.1?~?11.2>]
????????????????????????[-compatible.advm?<11.2>])
????????????????[-sysAsmPassword?<SYS?user?password>]
5.?Add?disks?to?Disk?Groups?by?specifying?the?following?command?and?parameters:
????????-addDisk
????????????????[-diskString?<disk?discovery?path>]
????????????????(-diskGroupName?<disk?group?name>
????????????????????????(-disk?<disk?path>?[-diskName?<disk?name>]?|
?????????????????????????-diskList?<comma?separated?disk?list>
????????????????????????????????[-diskSize?<disk?size?in?MB>]
????????????????????????????????[-failuregroup?<failure?group?name>]
????????????????????????????????[-force|-noforce]
????????????????????????????????[-quorum|-noquorum])
????????????????[-sysAsmPassword?<SYS?user?password>]
6.?Create?volumes?by?specifying?the?following?command?and?parameters:
????????-createVolume
????????????????(-volumeName?<ASM?volume?name>
????????????????-volumeDiskGroup?<ASM?disk?group?name?for?the?volume>
????????????????-volumeSizeGB?<ASM?volume?size?in?GB>
????????????????[-volumeRedundancy?<INHERIT|MIRROR|HIGH|UNPROTECTED>])
????????????????[-sysAsmPassword?<SYS?user?password>]
7.?Create?ASM?Cluster?File?Systems?by?specifying?the?following?command?and?parameters:
????????-createACFS
????????????????(-acfsVolumeDevice?<ASM?volume?device>)
????????????????(-acfsMountPoint?<existing?host?file?system?path>)
????????????????[-acfsUserName?<ACFS?User?Name>]
????????????????[-acfsGroupName?<ACFS?Group?Name>]
????????????????[-sysAsmPassword?<SYS?user?password>]
8.?Delete?ASM?instance(s)?by?specifying?the?following?command?and?parameters:
????????-deleteASM
????????????????[-force]
????????????????[-dropDiskGroups]
????????????????[-sysAsmPassword?<SYS?user?password>]9. Convert Standard ASM into Oracle Flex ASM by specifying the following command and parameters:?
??????? -convertToFlexASM?
??????????????? -asmNetworks <comma separated ASM Networks each network of the form interface name/subnet>?
??????????????? -asmListenerPort <ASM listener port number>?
[orgrid@ohs1 ~]$??
借助asmca生成轉化為Flex ASM的腳本converttoFlexASM.sh
[orgrid@ohs1 ~]$??asmca -silent -convertToFlexASM -asmNetworks eth2/172.16.0.0 -asmListenerPort?10010?
To?complete?ASM?conversion,?run?the?following?script?as?privileged?user?in?local?node. /pgold/orgrid/grid_base/cfgtoollogs/asmca/scripts/converttoFlexASM.sh??[orgrid@ohs1?~]$
鄭州不孕不育醫(yī)院：http://jbk.39.net/yiyuanzaixian/zztjyy/
converttoFlexASM.sh?腳本內容
[orgrid@ohs1 ~]$ cat /pgold/orgrid/grid_base/cfgtoollogs/asmca/scripts/converttoFlexASM.sh?
#!/bin/sh cd?/pgold/orgrid/grid_base/cfgtoollogs/asmca/scripts /pgold/orgrid/oracle/product/121/srvm/admin/srvmhelper?-updateDepASM if?[?"$?"?!=?"0"?];?then ????????echo?"Error?updating?ASM?resource?dependencies" ????????exit?1 fi for?node?in?ohs1?ohs2?ohs3 do ????????/pgold/orgrid/oracle/product/121/bin/crsctl?stop?cluster?-n?$node ????????if?[?"$?"?!=?"0"?];?then ????????????????echo?"Error?stopping?Oracle?Grid?Infrastructure?in?node?$node" ????????????????exit?1 ????????fi ????????/pgold/orgrid/oracle/product/121/bin/crsctl?start?cluster?-n?$node ????????stat=1 ????????cmd="/pgold/orgrid/oracle/product/121/bin/crsctl?status?server?$node" ????????while?[?$stat?=?1?] ????????do ????????????????sleep?5 ????????????????op=`$cmd` ????????????????op=`echo?$op?|?/bin/cut?-d'?'?-f2??|?/bin/cut?-d'='?-f2` ????????????????if?[?"$op"?=?"ONLINE"?] ????????????????then ????????????????????????stat=0 ????????????????????????echo?"Oracle?Grid?Infrastructure?restarted?in?node?$node" ????????????????fi ????????done ????????if?[?"$node"?=?ohs1?];?then ????????????????for?lsnr?in?ASMNET1LSNR_ASM ????????????????do ????????????????????????/pgold/orgrid/oracle/product/121/bin/srvctl?start?listener?-listener?$lsnr ????????????????????????lsnrret=$? ????????????????????????if?[?"$lsnrret"?=?"2"?];?then ????????????????????????????????echo?"ASM?listener?$lsnr?running?already" ????????????????????????elif?[?"$lsnrret"?!=?"0"?];?then ????????????????????????????????echo?"Error?starting?ASM?listener?$lsnr" ????????????????????????????????exit?1 ????????????????????????fi ????????????????done ????????fi done
用root執(zhí)行?converttoFlexASM.sh?輸出
[orgrid@ohs1 ~]$ /pgold/orgrid/grid_base/cfgtoollogs/asmca/scripts/converttoFlexASM.sh?
CRS-4563: Insufficient user privileges.?
CRS-4000: Command Stop failed, or completed with errors.?
Error stopping Oracle Grid Infrastructure in node ohs1?
[orgrid@ohs1 ~]$ exit?
logout?
[root@ohs1 ~]# /pgold/orgrid/grid_base/cfgtoollogs/asmca/scripts/converttoFlexASM.sh?
CRS-2673:?Attempting?to?stop?'ora.crsd'?on?'ohs1' CRS-2790:?Starting?shutdown?of?Cluster?Ready?Services-managed?resources?on?'ohs1' CRS-2673:?Attempting?to?stop?'ora.cvu'?on?'ohs1' CRS-2673:?Attempting?to?stop?'ora.mgmtdb'?on?'ohs1' CRS-2673:?Attempting?to?stop?'ora.gns'?on?'ohs1' CRS-2673:?Attempting?to?stop?'ora.LISTENER_SCAN3.lsnr'?on?'ohs1' CRS-2673:?Attempting?to?stop?'ora.oc4j'?on?'ohs1' CRS-2673:?Attempting?to?stop?'ora.LISTENER.lsnr'?on?'ohs1' CRS-2673:?Attempting?to?stop?'ora.FRA_PGOLD.dg'?on?'ohs1' CRS-2673:?Attempting?to?stop?'ora.SYSTEMDG.dg'?on?'ohs1' CRS-2673:?Attempting?to?stop?'ora.DATA_PGOLD.dg'?on?'ohs1' CRS-2677:?Stop?of?'ora.cvu'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.cvu'?on?'ohs3' CRS-2677:?Stop?of?'ora.FRA_PGOLD.dg'?on?'ohs1'?succeeded CRS-2676:?Start?of?'ora.cvu'?on?'ohs3'?succeeded CRS-2677:?Stop?of?'ora.SYSTEMDG.dg'?on?'ohs1'?succeeded CRS-2677:?Stop?of?'ora.DATA_PGOLD.dg'?on?'ohs1'?succeeded CRS-2677:?Stop?of?'ora.LISTENER_SCAN3.lsnr'?on?'ohs1'?succeeded CRS-2673:?Attempting?to?stop?'ora.scan3.vip'?on?'ohs1' CRS-2677:?Stop?of?'ora.LISTENER.lsnr'?on?'ohs1'?succeeded CRS-2673:?Attempting?to?stop?'ora.ohs1.vip'?on?'ohs1' CRS-2677:?Stop?of?'ora.scan3.vip'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.scan3.vip'?on?'ohs2' CRS-2677:?Stop?of?'ora.ohs1.vip'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.ohs1.vip'?on?'ohs3' CRS-2677:?Stop?of?'ora.mgmtdb'?on?'ohs1'?succeeded CRS-2673:?Attempting?to?stop?'ora.MGMTLSNR'?on?'ohs1' CRS-2677:?Stop?of?'ora.MGMTLSNR'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.MGMTLSNR'?on?'ohs2' CRS-2677:?Stop?of?'ora.gns'?on?'ohs1'?succeeded CRS-2673:?Attempting?to?stop?'ora.gns.vip'?on?'ohs1' CRS-2677:?Stop?of?'ora.gns.vip'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.gns.vip'?on?'ohs2' CRS-2676:?Start?of?'ora.gns.vip'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.gns'?on?'ohs2' CRS-2677:?Stop?of?'ora.oc4j'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.oc4j'?on?'ohs3' CRS-2676:?Start?of?'ora.MGMTLSNR'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.mgmtdb'?on?'ohs2' CRS-2676:?Start?of?'ora.gns'?on?'ohs2'?succeeded CRS-2676:?Start?of?'ora.scan3.vip'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.LISTENER_SCAN3.lsnr'?on?'ohs2' CRS-2676:?Start?of?'ora.oc4j'?on?'ohs3'?succeeded CRS-2676:?Start?of?'ora.mgmtdb'?on?'ohs2'?succeeded CRS-2676:?Start?of?'ora.LISTENER_SCAN3.lsnr'?on?'ohs2'?succeeded CRS-2676:?Start?of?'ora.ohs1.vip'?on?'ohs3'?succeeded CRS-2673:?Attempting?to?stop?'ora.ons'?on?'ohs1' CRS-2677:?Stop?of?'ora.ons'?on?'ohs1'?succeeded CRS-2673:?Attempting?to?stop?'ora.net1.network'?on?'ohs1' CRS-2677:?Stop?of?'ora.net1.network'?on?'ohs1'?succeeded CRS-2792:?Shutdown?of?Cluster?Ready?Services-managed?resources?on?'ohs1'?has?completed CRS-2677:?Stop?of?'ora.crsd'?on?'ohs1'?succeeded CRS-2673:?Attempting?to?stop?'ora.ctssd'?on?'ohs1' CRS-2673:?Attempting?to?stop?'ora.evmd'?on?'ohs1' CRS-2673:?Attempting?to?stop?'ora.storage'?on?'ohs1' CRS-2677:?Stop?of?'ora.storage'?on?'ohs1'?succeeded CRS-2673:?Attempting?to?stop?'ora.asm'?on?'ohs1' CRS-2677:?Stop?of?'ora.ctssd'?on?'ohs1'?succeeded CRS-2677:?Stop?of?'ora.evmd'?on?'ohs1'?succeeded CRS-2677:?Stop?of?'ora.asm'?on?'ohs1'?succeeded CRS-2673:?Attempting?to?stop?'ora.cluster_interconnect.haip'?on?'ohs1' CRS-2677:?Stop?of?'ora.cluster_interconnect.haip'?on?'ohs1'?succeeded CRS-2673:?Attempting?to?stop?'ora.cssd'?on?'ohs1' CRS-2677:?Stop?of?'ora.cssd'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.evmd'?on?'ohs1' CRS-2672:?Attempting?to?start?'ora.cssdmonitor'?on?'ohs1' CRS-2676:?Start?of?'ora.cssdmonitor'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.cssd'?on?'ohs1' CRS-2672:?Attempting?to?start?'ora.diskmon'?on?'ohs1' CRS-2676:?Start?of?'ora.diskmon'?on?'ohs1'?succeeded CRS-2676:?Start?of?'ora.evmd'?on?'ohs1'?succeeded CRS-2676:?Start?of?'ora.cssd'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.ctssd'?on?'ohs1' CRS-2672:?Attempting?to?start?'ora.cluster_interconnect.haip'?on?'ohs1' CRS-2676:?Start?of?'ora.ctssd'?on?'ohs1'?succeeded CRS-2676:?Start?of?'ora.cluster_interconnect.haip'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.asm'?on?'ohs1' CRS-2676:?Start?of?'ora.asm'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.storage'?on?'ohs1' CRS-2676:?Start?of?'ora.storage'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.crsd'?on?'ohs1' CRS-2676:?Start?of?'ora.crsd'?on?'ohs1'?succeeded Oracle?Grid?Infrastructure?restarted?in?node?ohs1 PRCC-1014?:?ASMNET1LSNR_ASM?was?already?running PRCR-1004?:?Resource?ora.ASMNET1LSNR_ASM.lsnr?is?already?running PRCR-1079?:?Failed?to?start?resource?ora.ASMNET1LSNR_ASM.lsnr CRS-5702:?Resource?'ora.ASMNET1LSNR_ASM.lsnr'?is?already?running?on?'ohs3' CRS-5702:?Resource?'ora.ASMNET1LSNR_ASM.lsnr'?is?already?running?on?'ohs2' CRS-5702:?Resource?'ora.ASMNET1LSNR_ASM.lsnr'?is?already?running?on?'ohs1' ASM?listener?ASMNET1LSNR_ASM?running?already CRS-2673:?Attempting?to?stop?'ora.crsd'?on?'ohs2' CRS-2790:?Starting?shutdown?of?Cluster?Ready?Services-managed?resources?on?'ohs2' CRS-2673:?Attempting?to?stop?'ora.mgmtdb'?on?'ohs2' CRS-2673:?Attempting?to?stop?'ora.LISTENER_SCAN3.lsnr'?on?'ohs2' CRS-2673:?Attempting?to?stop?'ora.ASMNET1LSNR_ASM.lsnr'?on?'ohs2' CRS-2673:?Attempting?to?stop?'ora.SYSTEMDG.dg'?on?'ohs2' CRS-2673:?Attempting?to?stop?'ora.LISTENER.lsnr'?on?'ohs2' CRS-2673:?Attempting?to?stop?'ora.DATA_PGOLD.dg'?on?'ohs2' CRS-2673:?Attempting?to?stop?'ora.FRA_PGOLD.dg'?on?'ohs2' CRS-2677:?Stop?of?'ora.SYSTEMDG.dg'?on?'ohs2'?succeeded CRS-2677:?Stop?of?'ora.DATA_PGOLD.dg'?on?'ohs2'?succeeded CRS-2677:?Stop?of?'ora.FRA_PGOLD.dg'?on?'ohs2'?succeeded CRS-2677:?Stop?of?'ora.LISTENER_SCAN3.lsnr'?on?'ohs2'?succeeded CRS-2673:?Attempting?to?stop?'ora.scan3.vip'?on?'ohs2' CRS-2677:?Stop?of?'ora.ASMNET1LSNR_ASM.lsnr'?on?'ohs2'?succeeded CRS-2677:?Stop?of?'ora.LISTENER.lsnr'?on?'ohs2'?succeeded CRS-2673:?Attempting?to?stop?'ora.ohs2.vip'?on?'ohs2' CRS-2677:?Stop?of?'ora.scan3.vip'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.scan3.vip'?on?'ohs1' CRS-2677:?Stop?of?'ora.ohs2.vip'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.ohs2.vip'?on?'ohs3' CRS-2677:?Stop?of?'ora.mgmtdb'?on?'ohs2'?succeeded CRS-2673:?Attempting?to?stop?'ora.MGMTLSNR'?on?'ohs2' CRS-2677:?Stop?of?'ora.MGMTLSNR'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.MGMTLSNR'?on?'ohs3' CRS-2676:?Start?of?'ora.MGMTLSNR'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.mgmtdb'?on?'ohs3' CRS-2676:?Start?of?'ora.scan3.vip'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.LISTENER_SCAN3.lsnr'?on?'ohs1' CRS-2676:?Start?of?'ora.LISTENER_SCAN3.lsnr'?on?'ohs1'?succeeded CRS-2673:?Attempting?to?stop?'ora.gns'?on?'ohs2' CRS-2676:?Start?of?'ora.ohs2.vip'?on?'ohs3'?succeeded CRS-2676:?Start?of?'ora.mgmtdb'?on?'ohs3'?succeeded CRS-2677:?Stop?of?'ora.gns'?on?'ohs2'?succeeded CRS-2673:?Attempting?to?stop?'ora.gns.vip'?on?'ohs2' CRS-2677:?Stop?of?'ora.gns.vip'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.gns.vip'?on?'ohs3' CRS-2676:?Start?of?'ora.gns.vip'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.gns'?on?'ohs3' CRS-2676:?Start?of?'ora.gns'?on?'ohs3'?succeeded CRS-2673:?Attempting?to?stop?'ora.ons'?on?'ohs2' CRS-2677:?Stop?of?'ora.ons'?on?'ohs2'?succeeded CRS-2673:?Attempting?to?stop?'ora.net1.network'?on?'ohs2' CRS-2677:?Stop?of?'ora.net1.network'?on?'ohs2'?succeeded CRS-2792:?Shutdown?of?Cluster?Ready?Services-managed?resources?on?'ohs2'?has?completed CRS-2677:?Stop?of?'ora.crsd'?on?'ohs2'?succeeded CRS-2673:?Attempting?to?stop?'ora.ctssd'?on?'ohs2' CRS-2673:?Attempting?to?stop?'ora.evmd'?on?'ohs2' CRS-2673:?Attempting?to?stop?'ora.storage'?on?'ohs2' CRS-2677:?Stop?of?'ora.storage'?on?'ohs2'?succeeded CRS-2673:?Attempting?to?stop?'ora.asm'?on?'ohs2' CRS-2677:?Stop?of?'ora.ctssd'?on?'ohs2'?succeeded CRS-2677:?Stop?of?'ora.evmd'?on?'ohs2'?succeeded CRS-2677:?Stop?of?'ora.asm'?on?'ohs2'?succeeded CRS-2673:?Attempting?to?stop?'ora.cluster_interconnect.haip'?on?'ohs2' CRS-2677:?Stop?of?'ora.cluster_interconnect.haip'?on?'ohs2'?succeeded CRS-2673:?Attempting?to?stop?'ora.cssd'?on?'ohs2' CRS-2677:?Stop?of?'ora.cssd'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.evmd'?on?'ohs2' CRS-2672:?Attempting?to?start?'ora.cssdmonitor'?on?'ohs2' CRS-2676:?Start?of?'ora.cssdmonitor'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.cssd'?on?'ohs2' CRS-2672:?Attempting?to?start?'ora.diskmon'?on?'ohs2' CRS-2676:?Start?of?'ora.diskmon'?on?'ohs2'?succeeded CRS-2676:?Start?of?'ora.evmd'?on?'ohs2'?succeeded CRS-2676:?Start?of?'ora.cssd'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.ctssd'?on?'ohs2' CRS-2672:?Attempting?to?start?'ora.cluster_interconnect.haip'?on?'ohs2' CRS-2676:?Start?of?'ora.ctssd'?on?'ohs2'?succeeded CRS-2676:?Start?of?'ora.cluster_interconnect.haip'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.asm'?on?'ohs2' CRS-2676:?Start?of?'ora.asm'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.storage'?on?'ohs2' CRS-2676:?Start?of?'ora.storage'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.crsd'?on?'ohs2' CRS-2676:?Start?of?'ora.crsd'?on?'ohs2'?succeeded Oracle?Grid?Infrastructure?restarted?in?node?ohs2 CRS-2673:?Attempting?to?stop?'ora.crsd'?on?'ohs3' CRS-2790:?Starting?shutdown?of?Cluster?Ready?Services-managed?resources?on?'ohs3' CRS-2673:?Attempting?to?stop?'ora.oc4j'?on?'ohs3' CRS-2673:?Attempting?to?stop?'ora.ASMNET1LSNR_ASM.lsnr'?on?'ohs3' CRS-2673:?Attempting?to?stop?'ora.FRA_PGOLD.dg'?on?'ohs3' CRS-2673:?Attempting?to?stop?'ora.cvu'?on?'ohs3' CRS-2673:?Attempting?to?stop?'ora.SYSTEMDG.dg'?on?'ohs3' CRS-2673:?Attempting?to?stop?'ora.DATA_PGOLD.dg'?on?'ohs3' CRS-2677:?Stop?of?'ora.cvu'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.cvu'?on?'ohs1' CRS-2677:?Stop?of?'ora.FRA_PGOLD.dg'?on?'ohs3'?succeeded CRS-2677:?Stop?of?'ora.SYSTEMDG.dg'?on?'ohs3'?succeeded CRS-2677:?Stop?of?'ora.DATA_PGOLD.dg'?on?'ohs3'?succeeded CRS-2676:?Start?of?'ora.cvu'?on?'ohs1'?succeeded CRS-2677:?Stop?of?'ora.ASMNET1LSNR_ASM.lsnr'?on?'ohs3'?succeeded CRS-2673:?Attempting?to?stop?'ora.LISTENER_SCAN2.lsnr'?on?'ohs3' CRS-2677:?Stop?of?'ora.LISTENER_SCAN2.lsnr'?on?'ohs3'?succeeded CRS-2673:?Attempting?to?stop?'ora.scan2.vip'?on?'ohs3' CRS-2677:?Stop?of?'ora.scan2.vip'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.scan2.vip'?on?'ohs2' CRS-2677:?Stop?of?'ora.oc4j'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.oc4j'?on?'ohs1' CRS-2676:?Start?of?'ora.scan2.vip'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.LISTENER_SCAN2.lsnr'?on?'ohs2' CRS-2676:?Start?of?'ora.oc4j'?on?'ohs1'?succeeded CRS-2676:?Start?of?'ora.LISTENER_SCAN2.lsnr'?on?'ohs2'?succeeded CRS-2673:?Attempting?to?stop?'ora.mgmtdb'?on?'ohs3' CRS-2672:?Attempting?to?start?'ora.SYSTEMDG.dg'?on?'ohs2' CRS-2673:?Attempting?to?stop?'ora.LISTENER.lsnr'?on?'ohs3' CRS-2673:?Attempting?to?stop?'ora.gns'?on?'ohs3' CRS-2676:?Start?of?'ora.SYSTEMDG.dg'?on?'ohs2'?succeeded CRS-2677:?Stop?of?'ora.LISTENER.lsnr'?on?'ohs3'?succeeded CRS-2673:?Attempting?to?stop?'ora.ohs3.vip'?on?'ohs3' CRS-2677:?Stop?of?'ora.ohs3.vip'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.ohs3.vip'?on?'ohs2' CRS-2677:?Stop?of?'ora.mgmtdb'?on?'ohs3'?succeeded CRS-2673:?Attempting?to?stop?'ora.MGMTLSNR'?on?'ohs3' CRS-2677:?Stop?of?'ora.gns'?on?'ohs3'?succeeded CRS-2673:?Attempting?to?stop?'ora.gns.vip'?on?'ohs3' CRS-2677:?Stop?of?'ora.MGMTLSNR'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.MGMTLSNR'?on?'ohs1' CRS-2677:?Stop?of?'ora.gns.vip'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.gns.vip'?on?'ohs2' CRS-2676:?Start?of?'ora.gns.vip'?on?'ohs2'?succeeded CRS-2672:?Attempting?to?start?'ora.gns'?on?'ohs2' CRS-2676:?Start?of?'ora.MGMTLSNR'?on?'ohs1'?succeeded CRS-2672:?Attempting?to?start?'ora.mgmtdb'?on?'ohs1' CRS-2676:?Start?of?'ora.gns'?on?'ohs2'?succeeded CRS-2676:?Start?of?'ora.ohs3.vip'?on?'ohs2'?succeeded CRS-2676:?Start?of?'ora.mgmtdb'?on?'ohs1'?succeeded CRS-2673:?Attempting?to?stop?'ora.ons'?on?'ohs3' CRS-2677:?Stop?of?'ora.ons'?on?'ohs3'?succeeded CRS-2673:?Attempting?to?stop?'ora.net1.network'?on?'ohs3' CRS-2677:?Stop?of?'ora.net1.network'?on?'ohs3'?succeeded CRS-2792:?Shutdown?of?Cluster?Ready?Services-managed?resources?on?'ohs3'?has?completed CRS-2677:?Stop?of?'ora.crsd'?on?'ohs3'?succeeded CRS-2673:?Attempting?to?stop?'ora.ctssd'?on?'ohs3' CRS-2673:?Attempting?to?stop?'ora.evmd'?on?'ohs3' CRS-2673:?Attempting?to?stop?'ora.storage'?on?'ohs3' CRS-2677:?Stop?of?'ora.storage'?on?'ohs3'?succeeded CRS-2673:?Attempting?to?stop?'ora.asm'?on?'ohs3' CRS-2677:?Stop?of?'ora.ctssd'?on?'ohs3'?succeeded CRS-2677:?Stop?of?'ora.evmd'?on?'ohs3'?succeeded CRS-2677:?Stop?of?'ora.asm'?on?'ohs3'?succeeded CRS-2673:?Attempting?to?stop?'ora.cluster_interconnect.haip'?on?'ohs3' CRS-2677:?Stop?of?'ora.cluster_interconnect.haip'?on?'ohs3'?succeeded CRS-2673:?Attempting?to?stop?'ora.cssd'?on?'ohs3' CRS-2677:?Stop?of?'ora.cssd'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.evmd'?on?'ohs3' CRS-2672:?Attempting?to?start?'ora.cssdmonitor'?on?'ohs3' CRS-2676:?Start?of?'ora.cssdmonitor'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.cssd'?on?'ohs3' CRS-2672:?Attempting?to?start?'ora.diskmon'?on?'ohs3' CRS-2676:?Start?of?'ora.diskmon'?on?'ohs3'?succeeded CRS-2676:?Start?of?'ora.evmd'?on?'ohs3'?succeeded CRS-2676:?Start?of?'ora.cssd'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.ctssd'?on?'ohs3' CRS-2672:?Attempting?to?start?'ora.cluster_interconnect.haip'?on?'ohs3' CRS-2676:?Start?of?'ora.ctssd'?on?'ohs3'?succeeded CRS-2676:?Start?of?'ora.cluster_interconnect.haip'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.asm'?on?'ohs3' CRS-2676:?Start?of?'ora.asm'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.storage'?on?'ohs3' CRS-2676:?Start?of?'ora.storage'?on?'ohs3'?succeeded CRS-2672:?Attempting?to?start?'ora.crsd'?on?'ohs3' CRS-2676:?Start?of?'ora.crsd'?on?'ohs3'?succeeded Oracle?Grid?Infrastructure?restarted?in?node?ohs3 [root@ohs1?~]#
當前系統(tǒng)Cluster和ASM的類型
[orgrid@ohs1?~]$?crsctl?get?cluster?mode?status Cluster?is?running?in?"standard"?mode [orgrid@ohs1?~]$ [orgrid@ohs1?~]$?asmcmd ASMCMD>?showclustermode ASM?cluster?:?Flex?mode?enabled ASMCMD>
ASM配置信息?
[orgrid@ohs1 ~]$ srvctl status asm -detail
ASM?is?running?on?ohs3,ohs2,ohs1 ASM?is?enabled.?[orgrid@ohs1?~]$?srvctl?config?asm?-detail
ASM?home:?<CRS?home> Password?file:?+SYSTEMDG/orapwASM ASM?listener:?LISTENER ASM?is?enabled. ASM?is?individually?enabled?on?nodes: ASM?is?individually?disabled?on?nodes: ASM?instance?count:?ALL Cluster?ASM?listener:?ASMNET1LSNR_ASM
3個節(jié)點上ASM監(jiān)聽狀態(tài)?
這里三個ASM實例共用一個服務名，有點類似SCAN的意思?
[orgrid@?ohs1??~]$ lsnrctl status ASMNET1LSNR_ASM
LSNRCTL?for?Linux:?Version?12.1.0.2.0?-?Production?on?25-SEP-2016?11:25:23
Copyright?(c)?1991,?2014,?Oracle.??All?rights?reserved.
Connecting?to?(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))
STATUS?of?the?LISTENER
------------------------
Alias?????????????????????ASMNET1LSNR_ASM
Version???????????????????TNSLSNR?for?Linux:?Version?12.1.0.2.0?-?Production
Start?Date????????????????25-SEP-2016?11:16:40
Uptime????????????????????0?days?0?hr.?8?min.?43?sec
Trace?Level???????????????off
Security??????????????????ON:?Local?OS?Authentication
SNMP??????????????????????OFF
Listener?Parameter?File???/pgold/orgrid/oracle/product/121/network/admin/listener.ora
Listener?Log?File?????????/pgold/orgrid/grid_base/diag/tnslsnr/ohs1/asmnet1lsnr_asm/alert/log.xml
Listening?Endpoints?Summary...
??(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ASMNET1LSNR_ASM)))
網(wǎng)站標題：OracleFlexASM和Flex集群
當前URL：http://muchs.cn/article30/gesipo.html
成都網(wǎng)站建設公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站收錄、自適應網(wǎng)站、網(wǎng)站導航、動態(tài)網(wǎng)站、外貿網(wǎng)站建設、手機網(wǎng)站建設
聲明：本網(wǎng)站發(fā)布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經(jīng)允許不得轉載，或轉載時需注明來源：
創(chuàng)新互聯(lián)
- 網(wǎng)站建設的虛擬主機網(wǎng)站空間容量是什么？ 2022-05-22
- 【SEO優(yōu)化】網(wǎng)站優(yōu)化中虛擬主機的網(wǎng)站安全遷移技巧分享 2022-05-01
- 虛擬主機對SEO優(yōu)化有哪些影響 2016-01-20
- 企業(yè)外貿網(wǎng)站建設，服務器或虛擬主機選擇至關重要！ 2022-05-02
- 為什么有些獨立IP的云主機會比共享虛擬主機的速度慢？ 2021-02-14
- 云主機和虛擬主機哪個更好 2022-10-03
- 你的網(wǎng)站適合虛擬主機嗎？ 2022-08-01
- 網(wǎng)站建設之第二步：虛擬主機的選擇 2016-09-15
- 為你解決虛擬主機的疑惑？ 2022-06-13
- 租用虛擬主機與自建主機差異及優(yōu)缺點比較。 2019-02-17
- 佛山網(wǎng)站建設如何規(guī)劃?佛山建網(wǎng)站有哪些好的公司? 2022-06-06
- 閑聊虛擬主機網(wǎng)站遷移 2021-03-13