溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
Oracle Flex ASM和Flex集群
Oracle RAC 12c 引入了兩個新概念：
中心節點：???和以前的版本一樣，它們通過專用網絡相互連接，并且可以直接訪問共享存儲。這些節點可以直接訪問 Oracle 集群注冊表 (OCR) 和表決磁盤 (VD)。
葉節點：???這些節點是輕型節點，彼此不互連，也不能像中心節點一樣訪問共享存儲。每個葉節點與所連接的中心節點通信，并通過所連接的中心節點連接到集群。
此拓撲允許松散耦合的應用服務器與緊密耦合的數據庫服務器形成一個集群。緊密耦合的服務器是中心服務器，與集群中的其他中心服務器共享數據庫、OCR 和表決設備的存儲并進行對等通信。松耦合的服務器是葉服務器，與集群中的單個中心服務器形成松散通信關聯，不需要與集群中的其他中心服務器或葉服務器共享存儲，也不需要與之進行對等通信，只與所關聯的中心服務器通信。在 12.1.0.1 中，葉服務器旨在提高應用的高可用性和實現多層資源管理。
在 Oracle 12c 之前，對于要使用 ASM 的數據庫實例來說，所有節點上的 ASM 實例必須已處于運行狀態，才能啟動數據庫實例。如果 ASM 實例未運行，則意味著在存儲級使用 ASM 的數據庫實例不能啟動。這實際上意味著無論采用何種技術（即 RAC、ASM 和共享存儲），均不能訪問數據庫實例。
隨著 Oracle 12c 的推出，一個名為 Oracle Flex ASM 的特性解除了上述限制，它的一個主要特性是故障切換到集群中的其他節點。本質上是一個中心和葉架構，Oracle Clusterware 通過一個替代 ASM 實例將故障節點的連接將無縫轉移到另一個成員節點。在給定集群中運行的 ASM 實例數被稱作 ASM 基數，默認值為 3。但此基數值可以使用 Clusterware 命令修改。
從架構上來說，Oracle Flex 集群包括一個中心和葉架構，其中只有中心節點可以直接訪問 Oracle 集群注冊表 (OCR) 和表決磁盤 (VD)。但是應用可以通過葉節點訪問數據庫，而不必在葉節點上運行 ASM 實例。通過中心節點連接到數據庫使得它對應用透明。
圖 1：描繪了一個典型的 Oracle Flex 集群，包含 4 個葉節點和 2 個中心節點。簡單地說，Oracle Flex 集群需要 Oracle Flex ASM。
Oracle Flex ASM 可通過兩種方式實現：
純 12c Flex ASM（相同版本）
Grid Infrasctructure (GI) 和數據庫都運行在 Oracle 12c 上
Oracle 12c 之前的混合版本（不同版本）
和平常一樣，ASM 實例將在每個節點上運行，Flex 配置支持 12c 之前的數據庫。使用 ASM 磁盤組的兼容性參數管理各數據庫實例之間的兼容性。這種方法的優點是，如果 Oracle 12c 數據庫實例與一個 ASM 實例的連接斷開，數據庫連接將故障切換至其他服務器上的另一個 ASM 實例。通過將基數設置為 all 即可以實現這種故障切換。
標準 Oracle Flex ASM 配置：
Oracle Flex ASM 配置上的 ASM 實例故障：
[oracle@oel6-112-rac1?Desktop]$?hostname oel6-112-rac1.localdomain
[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
[oracle@oel6-112-rac1?Desktop]$?srvctl?status?asm ASM?is?running?on?oel6-112-rac2,oel6-112-rac1
[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
[oracle@oel6-112-rac1?Desktop]$?asmcmd ASMCMD>?showclustermode? ASM?cluster?:?Flex?mode?enabled ASMCMD>?showclusterstate Normal
[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
[oracle@oel6-112-rac2?Desktop]$?asmcmd ASMCMD>?showclustermode ASM?cluster?:?Flex?mode?enabled ASMCMD>?showclusterstate Normal ASMCMD>?exit
[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
[oracle@oel6-112-rac1?Desktop]$?srvctl?stop?asm?-node?oel6-112-rac1?-stopoption?abort?-force
[oracle@oel6-112-rac1?Desktop]$?srvctl?status?asm PRCR-1070?:?Failed?to?check?if?resource?ora.asm?is?registered Cannot?communicate?with?crsd
[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
[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
注：?在這里，數據庫實例與特定節點中運行的特定 ASM 實例關聯。如果因為某種原因，ASM 實例無法啟動/服務關閉，數據庫實例仍然可以啟動，因為數據庫實例將查找同一集群中運行的 ASM 實例。圖 3 描繪了 Flex ASM 的高可用特性。
[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
[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
[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>
總結：?數據庫實例使用一個專用 ASM 實例，我們強制該 ASM 實例被停止工作來模擬故障，因此數據庫實例重新連接到另一節點（在本示例中為節點 2 (rac2)）上的現有 ASM 實例。
如前面針對 Oracle 12c 的介紹所述，ASM 與數據庫實例的關聯本質上是特定的。這意味著，如果 ASM 實例無法啟動，該節點/ASM 中的關聯數據庫實例也無法啟動，從而導致該數據庫無法訪問。
login?as:?oracle oracle@192.168.xx.xx's?password: Last?login:?Fri?Sep?27?06:05:44?2013
[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
[oracle@rac1?~]$?srvctl?status?asm ASM?is?running?on?rac2,rac1
[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
[oracle@rac1?~]$?srvctl?stop?asm?-n?rac1?-o?abort?-f
[oracle@rac1?~]$?srvctl?status?asm ASM?is?running?on?rac2
[oracle@rac1?~]$?ps?-ef?|?grep?pmon oracle????7885??5795??0?06:20?pts/0????00:00:00?grep?pmon
總結：?數據庫實例與 ASM 實例強關聯。如果 ASM 實例發生故障，同一節點上的數據庫實例也會發生故障。
Oracle Flex ASM 支持 Oracle Database 12c 客戶端使用更大的 LUN 大小。
支持的最大磁盤組數為 511。
可以靈活地重命名磁盤組中的 ASM 磁盤。
ASM 實例的補丁級驗證
滾動補丁期間禁用補丁級驗證
復制物理元數據
在早期版本中，集群要求：
一個供客戶端應用訪問的公共網絡
一個或多個用于集群內節點間通信（包括 ASM 通信）的專用網絡
Flex ASM 增加 ASM 網絡，可用于 ASM 與其客戶端之間的通信，以便隔離和分流 ASM 通信。
下面是 Flex ASM 安裝程序的屏幕截圖。
選擇選項“Advanced Installation”
?
有三個存儲選項：
標準 ASM
Oracle Flex ASM
非 ASM 托管的存儲
推薦
12c 之前的 ASM 配置模式
?
管理 Flex ASM：
無需 Flex ASM 特定的實例參數
ASM 服務器實例使用自動內存管理 (AMM)
?轉：http://www.oracle.com/technetwork/cn/articles/database/flexasm-flexcluster-benefits-odb12c-2177371-zhs.html?
?
Oracle 在12c 中引入Oracle Flex ASM特性， 其可以使ASM實例和數據庫實例在不同的節點上運行，而不是之前的ASM實例必須和數據庫實例運行在同一個節點上。也就是說當某個節點上的ASM 實例掛掉后，其上的數據庫實例還可以正常運行。
在Oracle 12c中，在創建數據庫的時候還需要選擇是否啟用Oracle Flex 集群和Flex ASM， 但是到了18c中，默認就是Flex 集群和Flex ASM，不再需要選擇。 下圖是12c中使用ASMCA工具將普通ASM 實例轉換成Flex ASM。?
因為在Oracle 18c 中默認就是Flex ASM。 所以我們這里直接在RAC 環境上測試該功能。
[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?~]$
[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?~]$
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
關閉節點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 實例只在節點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上也運行這節點1上的db 實例。
但是節點1上的數據庫實例正常運行：
SQL>?select?instance_name,instance_number?from?gv$instance; INSTANCE_NAME?????????????INSTANCE_NUMBER --------------------------------?--------------- cndba1???????????????????????????1 cndba2???????????????????????????2
啟動節點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
通過實驗，可以驗證任意一個節點的ASM實例的意外關閉/啟動，都不會影響該節點上的數據庫狀態，這極大的增強了RAC的高可用性。
從12c開始，推出了Flex ASM特性，允許RAC節點訪問遠程節點的ASM實例，而自身無需運行ASM實例。?
一般在Flex集群，中心節點運行ASM實例，葉節點遠程訪問中心節點的ASM實例。?
但是中心節點也可以不運行ASM實例而訪問其他節點的ASM實例；另外，標準集群也可以啟用Flex ASM。?
由于有通過網絡遠程訪問ASM實例的狀況，因此也形成了ASM網絡，ASM網絡可與Private網絡共用，即ASM&Private網絡，可在安裝界面指定。?
確認當前ASM狀態?
點擊(?此處?)折疊或打開
$ asmcmd showclustermode?
ASM cluster??:??Flex mode disabled
以上說明是標準ASM?
運行asmca，轉換ASM為Flex ASM，以下是部分步驟截圖?
ASM的subnet與Public不同，將不能使用與Public相同的端口號?
以root用戶運行上圖所示的腳本，將對集群內所有節點重啟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監聽器?
點擊(?此處?)折疊或打開
$ 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
什么是Flex ASM?
我們知道在12c之前的版本里，ASM實例需要在每一個節點運行，而ASM 的客戶端(Database，ACFS，ADVM)只可以訪問本地的ASM 實例。如果使用了Oracle Flex ASM，情況就不一樣了，ASM的客戶端就可以通過ASM網絡訪問遠程的ASM實例。如果一個運行ASM實例的節點宕掉，Oracle集群會在另外一個節點上啟動一個新的ASM實例以此維持它的節點基數(Cardinality)。 同樣，如果一個12c數據庫實例連接了某一個ASM 實例，而這個ASM 實例crash掉或者實例運行出錯，這個數據庫的實例會嘗試重新連接在另一個節點的一個已經存在的ASM實例，這就是 Oracle Flex ASM。
Flex Cluster和Flex ASM的區別
Flex Cluster需要Flex ASM的支持
Flex ASM可以在StandardCluster和Flex Cluster運行
如何控制ASM實例的個數?
[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會出現連接到空實例，但在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?~]$
鄭州不孕不育醫院：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執行?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?~]#
當前系統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個節點上ASM監聽狀態?
這里三個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))) ??(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.21)(PORT=10010))) Services?Summary... Service?"+ASM"?has?3?instance(s). ??Instance?"+ASM1",?status?READY,?has?2?handler(s)?for?this?service... ??Instance?"+ASM2",?status?READY,?has?1?handler(s)?for?this?service... ??Instance?"+ASM3",?status?READY,?has?1?handler(s)?for?this?service... The?command?completed?successfully [orgrid@ohs1?~]$
[orgrid@?ohs2??~]$ lsnrctl status ASMNET1LSNR_ASM?
LSNRCTL?for?Linux:?Version?12.1.0.2.0?-?Production?on?25-SEP-2016?11:28:49 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:17:59 Uptime????????????????????0?days?0?hr.?10?min.?50?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/ohs2/asmnet1lsnr_asm/alert/log.xml Listening?Endpoints?Summary... ??(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ASMNET1LSNR_ASM))) ??(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.22)(PORT=10010))) Services?Summary... Service?"+ASM"?has?3?instance(s). ??Instance?"+ASM1",?status?READY,?has?1?handler(s)?for?this?service... ??Instance?"+ASM2",?status?READY,?has?2?handler(s)?for?this?service... ??Instance?"+ASM3",?status?READY,?has?1?handler(s)?for?this?service... The?command?completed?successfully [orgrid@ohs2?~]$
[orgrid@?ohs3??~]$ lsnrctl status ASMNET1LSNR_ASM?
LSNRCTL?for?Linux:?Version?12.1.0.2.0?-?Production?on?25-SEP-2016?11:28:59 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:20:08 Uptime????????????????????0?days?0?hr.?8?min.?50?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/ohs3/asmnet1lsnr_asm/alert/log.xml Listening?Endpoints?Summary... ??(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ASMNET1LSNR_ASM))) ??(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.23)(PORT=10010))) Services?Summary... Service?"+ASM"?has?3?instance(s). ??Instance?"+ASM1",?status?READY,?has?1?handler(s)?for?this?service... ??Instance?"+ASM2",?status?READY,?has?1?handler(s)?for?this?service... ??Instance?"+ASM3",?status?READY,?has?2?handler(s)?for?this?service... The?command?completed?successfully [orgrid@ohs3?~]$ [orgrid@ohs3?~]$
在節點一上通過服務名連接ASM實例，連接到了+ASM3
[orgrid@ohs1?~]$?sqlplus?sys/oracle@172.16.0.21:10010/+ASM?as?sysasm SQL*Plus:?Release?12.1.0.2.0?Production?on?Sun?Sep?25?11:35:33?2016 Copyright?(c)?1982,?2014,?Oracle.??All?rights?reserved. Connected?to: Oracle?Database?12c?Enterprise?Edition?Release?12.1.0.2.0?-?64bit?Production With?the?Real?Application?Clusters?and?Automatic?Storage?Management?options SQL>?select?instance_name?from?v$instance; INSTANCE_NAME ----------------?+ASM3
SQL>
ASM監聽service狀況
[orgrid@ohs1 ~]$ lsnrctl service ASMNET1LSNR_ASM?
LSNRCTL?for?Linux:?Version?12.1.0.2.0?-?Production?on?25-SEP-2016?11:37:14 Copyright?(c)?1991,?2014,?Oracle.??All?rights?reserved. Connecting?to?(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM))) Services?Summary... Service?"+ASM"?has?3?instance(s). ??Instance?"+ASM1",?status?READY,?has?2?handler(s)?for?this?service... ????Handler(s): ??????"DEDICATED"?established:0?refused:0?state:ready ?????????REMOTE?SERVER ?????????(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.0.21)(PORT=10010))) ??????"DEDICATED"?established:18?refused:0?state:ready ?????????LOCAL?SERVER ??Instance?"+ASM2",?status?READY,?has?1?handler(s)?for?this?service... ????Handler(s): ??????"DEDICATED"?established:0?refused:0?state:ready ?????????REMOTE?SERVER ?????????(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.0.22)(PORT=10010))) ??Instance?"+ASM3",?status?READY,?has?1?handler(s)?for?this?service... ????Handler(s): ??????"DEDICATED"?established:5?refused:0?state:ready ?????????REMOTE?SERVER ?????????(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.0.23)(PORT=10010))) The?command?completed?successfully [orgrid@ohs1?~]$
通過服務名連接ASM實例，并關閉它?
[orgrid@ohs1?~]$?sqlplus?sys/oracle@172.16.0.22:10010/+ASM?as?sysasm SQL*Plus:?Release?12.1.0.2.0?Production?on?Sun?Sep?25?11:38:11?2016 Copyright?(c)?1982,?2014,?Oracle.??All?rights?reserved. Connected?to: Oracle?Database?12c?Enterprise?Edition?Release?12.1.0.2.0?-?64bit?Production With?the?Real?Application?Clusters?and?Automatic?Storage?Management?options SQL>?select?instance_name?from?v$instance; INSTANCE_NAME ---------------- +ASM2 SQL>?shut?immediate ASM?diskgroups?dismounted ASM?instance?shutdown SQL>?exit Disconnected?from?Oracle?Database?12c?Enterprise?Edition?Release?12.1.0.2.0?-?64bit?Production With?the?Real?Application?Clusters?and?Automatic?Storage?Management?options
[orgrid@ohs1 ~]$ lsnrctl service ASMNET1LSNR_ASM?
LSNRCTL?for?Linux:?Version?12.1.0.2.0?-?Production?on?25-SEP-2016?11:38:51 Copyright?(c)?1991,?2014,?Oracle.??All?rights?reserved. Connecting?to?(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM))) Services?Summary... Service?"+ASM"?has?2?instance(s). ??Instance?"+ASM1",?status?READY,?has?2?handler(s)?for?this?service... ????Handler(s): ??????"DEDICATED"?established:0?refused:0?state:ready ?????????REMOTE?SERVER ?????????(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.0.21)(PORT=10010))) ??????"DEDICATED"?established:18?refused:0?state:ready ?????????LOCAL?SERVER ??Instance?"+ASM3",?status?READY,?has?1?handler(s)?for?this?service... ????Handler(s): ??????"DEDICATED"?established:5?refused:0?state:ready ?????????REMOTE?SERVER ?????????(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.0.23)(PORT=10010))) The?command?completed?successfully [orgrid@ohs1?~]$
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
