oracle flex cluster,Oracle Flex ASM和Flex集群
Oracle Flex ASM和Flex集群
Oracle RAC 12c 引入了兩個新概念：
中心節(jié)點(diǎn)：??和以前的版本一樣，它們通過專用網(wǎng)絡(luò)相互連接，并且可以直接訪問共享存儲。這些節(jié)點(diǎn)可以直接訪問 Oracle 集群注冊表 (OCR) 和表決磁盤 (VD)。
葉節(jié)點(diǎn)：??這些節(jié)點(diǎn)是輕型節(jié)點(diǎn)，彼此不互連，也不能像中心節(jié)點(diǎn)一樣訪問共享存儲。每個葉節(jié)點(diǎn)與所連接的中心節(jié)點(diǎn)通信，并通過所連接的中心節(jié)點(diǎn)連接到集群。
此拓?fù)湓试S松散耦合的應(yīng)用服務(wù)器與緊密耦合的數(shù)據(jù)庫服務(wù)器形成一個集群。緊密耦合的服務(wù)器是中心服務(wù)器，與集群中的其他中心服務(wù)器共享數(shù)據(jù)庫、OCR 和表決設(shè)備的存儲并進(jìn)行對等通信。松耦合的服務(wù)器是葉服務(wù)器，與集群中的單個中心服務(wù)器形成松散通信關(guān)聯(lián)，不需要與集群中的其他中心服務(wù)器或葉服務(wù)器共享存儲，也不需要與之進(jìn)行對等通信，只與所關(guān)聯(lián)的中心服務(wù)器通信。在 12.1.0.1 中，葉服務(wù)器旨在提高應(yīng)用的高可用性和實(shí)現(xiàn)多層資源管理。
在 Oracle 12c 之前，對于要使用 ASM 的數(shù)據(jù)庫實(shí)例來說，所有節(jié)點(diǎn)上的 ASM 實(shí)例必須已處于運(yùn)行狀態(tài)，才能啟動數(shù)據(jù)庫實(shí)例。如果 ASM 實(shí)例未運(yùn)行，則意味著在存儲級使用 ASM 的數(shù)據(jù)庫實(shí)例不能啟動。這實(shí)際上意味著無論采用何種技術(shù)(即 RAC、ASM 和共享存儲)，均不能訪問數(shù)據(jù)庫實(shí)例。
隨著 Oracle 12c 的推出，一個名為 Oracle Flex ASM 的特性解除了上述限制，它的一個主要特性是故障切換到集群中的其他節(jié)點(diǎn)。本質(zhì)上是一個中心和葉架構(gòu)，Oracle Clusterware 通過一個替代 ASM 實(shí)例將故障節(jié)點(diǎn)的連接將無縫轉(zhuǎn)移到另一個成員節(jié)點(diǎn)。在給定集群中運(yùn)行的 ASM 實(shí)例數(shù)被稱作 ASM 基數(shù)，默認(rèn)值為 3。但此基數(shù)值可以使用 Clusterware 命令修改。
Oracle Flex 集群
從架構(gòu)上來說，Oracle Flex 集群包括一個中心和葉架構(gòu)，其中只有中心節(jié)點(diǎn)可以直接訪問 Oracle 集群注冊表 (OCR) 和表決磁盤 (VD)。但是應(yīng)用可以通過葉節(jié)點(diǎn)訪問數(shù)據(jù)庫，而不必在葉節(jié)點(diǎn)上運(yùn)行 ASM 實(shí)例。通過中心節(jié)點(diǎn)連接到數(shù)據(jù)庫使得它對應(yīng)用透明。
圖 1：描繪了一個典型的 Oracle Flex 集群，包含 4 個葉節(jié)點(diǎn)和 2 個中心節(jié)點(diǎn)。簡單地說，Oracle Flex 集群需要 Oracle Flex ASM。
Oracle Flex ASM 的實(shí)現(xiàn)方面
Oracle Flex ASM 可通過兩種方式實(shí)現(xiàn)：純 12c Flex ASM(相同版本)Grid Infrasctructure (GI) 和數(shù)據(jù)庫都運(yùn)行在 Oracle 12c 上Oracle 12c 之前的混合版本(不同版本)和平常一樣，ASM 實(shí)例將在每個節(jié)點(diǎn)上運(yùn)行，Flex 配置支持 12c 之前的數(shù)據(jù)庫。使用 ASM 磁盤組的兼容性參數(shù)管理各數(shù)據(jù)庫實(shí)例之間的兼容性。這種方法的優(yōu)點(diǎn)是，如果 Oracle 12c 數(shù)據(jù)庫實(shí)例與一個 ASM 實(shí)例的連接斷開，數(shù)據(jù)庫連接將故障切換至其他服務(wù)器上的另一個 ASM 實(shí)例。通過將基數(shù)設(shè)置為 all 即可以實(shí)現(xiàn)這種故障切換。
使用 Oracle Flex ASM 的 Oracle RAC 12c
標(biāo)準(zhǔn) Oracle Flex ASM 配置：
Oracle Flex ASM 配置上的 ASM 實(shí)例故障：
1. 登錄 RAC 數(shù)據(jù)庫實(shí)例 1 (rac1)[oracle@oel6-112-rac1?Desktop]$?hostname
oel6-112-rac1.localdomain
2. 檢查 ASM 實(shí)例和 RAC 數(shù)據(jù)庫實(shí)例的狀態(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. 從實(shí)例 1 (rac1) 檢查 RAC 數(shù)據(jù)庫實(shí)例中 ASM 實(shí)例的狀態(tài)[oracle@oel6-112-rac1?Desktop]$?srvctl?status?asm
ASM?is?running?on?oel6-112-rac2,oel6-112-rac1
4. 在實(shí)例 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ù)庫實(shí)例 1 (rac1) 中關(guān)閉 ASM 實(shí)例[oracle@oel6-112-rac1?Desktop]$?srvctl?stop?asm?-node?oel6-112-rac1?-stopoption?abort?-force
10. 在 RAC 數(shù)據(jù)庫實(shí)例 1 (rac1) 中檢查 ASM 實(shí)例的狀態(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ù)庫實(shí)例 1 (rac1) 中檢查集群服務(wù)的狀態(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. 在實(shí)例 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ù)庫實(shí)例與特定節(jié)點(diǎn)中運(yùn)行的特定 ASM 實(shí)例關(guān)聯(lián)。如果因?yàn)槟撤N原因，ASM 實(shí)例無法啟動/服務(wù)關(guān)閉，數(shù)據(jù)庫實(shí)例仍然可以啟動，因?yàn)閿?shù)據(jù)庫實(shí)例將查找同一集群中運(yùn)行的 ASM 實(shí)例。圖 3 描繪了 Flex ASM 的高可用特性。
13. 在 RAC 數(shù)據(jù)庫實(shí)例 1 (rac1) 中檢查沒有 ASM 實(shí)例的正在運(yùn)行的 RAC 數(shù)據(jù)庫實(shí)例的狀態(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ù)庫實(shí)例 1 (rac1) 登錄數(shù)據(jù)庫實(shí)例[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ù)庫實(shí)例 1 (rac1) 連接到 RAC 數(shù)據(jù)庫實(shí)例 2 (rac2) 的 ASM 實(shí)例[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>
總結(jié)：數(shù)據(jù)庫實(shí)例使用一個專用 ASM 實(shí)例，我們強(qiáng)制該 ASM 實(shí)例被停止工作來模擬故障，因此數(shù)據(jù)庫實(shí)例重新連接到另一節(jié)點(diǎn)(在本示例中為節(jié)點(diǎn) 2 (rac2))上的現(xiàn)有 ASM 實(shí)例。
Oracle Database 11.2 或早期版本
如前面針對 Oracle 12c 的介紹所述，ASM 與數(shù)據(jù)庫實(shí)例的關(guān)聯(lián)本質(zhì)上是特定的。這意味著，如果 ASM 實(shí)例無法啟動，該節(jié)點(diǎn)/ASM 中的關(guān)聯(lián)數(shù)據(jù)庫實(shí)例也無法啟動，從而導(dǎo)致該數(shù)據(jù)庫無法訪問。
1. 登錄 RAC 數(shù)據(jù)庫實(shí)例 1 (rac1)login?as:?oracle
oracle@192.168.xx.xx's?password:
Last?login:?Fri?Sep?27?06:05:44?2013
2. 檢查 ASM 實(shí)例和 RAC 數(shù)據(jù)庫實(shí)例的狀態(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ù)庫實(shí)例 1 (rac1) 中檢查 ASM 實(shí)例的狀態(tài)[oracle@rac1?~]$?srvctl?status?asm
ASM?is?running?on?rac2,rac1
4. 在 RAC 數(shù)據(jù)庫實(shí)例 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ù)庫實(shí)例 1 (rac1) 中停止 ASM 實(shí)例[oracle@rac1?~]$?srvctl?stop?asm?-n?rac1?-o?abort?-f
6. 在 RAC 數(shù)據(jù)庫實(shí)例 1 (rac1) 中檢查 ASM 實(shí)例的狀態(tài)[oracle@rac1?~]$?srvctl?status?asm
ASM?is?running?on?rac2
7. 檢查 ASM 實(shí)例和 RAC 數(shù)據(jù)庫實(shí)例 (rac1) 的狀態(tài)[oracle@rac1?~]$?ps?-ef?|?grep?pmon
oracle????7885??5795??0?06:20?pts/0????00:00:00?grep?pmon
總結(jié)：數(shù)據(jù)庫實(shí)例與 ASM 實(shí)例強(qiáng)關(guān)聯(lián)。如果 ASM 實(shí)例發(fā)生故障，同一節(jié)點(diǎn)上的數(shù)據(jù)庫實(shí)例也會發(fā)生故障。
為何使用 Oracle Flex ASMOracle Flex ASM 支持 Oracle Database 12c 客戶端使用更大的 LUN 大小。
支持的最大磁盤組數(shù)為 511。
可以靈活地重命名磁盤組中的 ASM 磁盤。
ASM 實(shí)例的補(bǔ)丁級驗(yàn)證滾動補(bǔ)丁期間禁用補(bǔ)丁級驗(yàn)證
復(fù)制物理元數(shù)據(jù)
Oracle Flex ASM 中的網(wǎng)絡(luò)增強(qiáng)在早期版本中，集群要求：一個供客戶端應(yīng)用訪問的公共網(wǎng)絡(luò)
一個或多個用于集群內(nèi)節(jié)點(diǎn)間通信(包括 ASM 通信)的專用網(wǎng)絡(luò)
Flex ASM 增加 ASM 網(wǎng)絡(luò)，可用于 ASM 與其客戶端之間的通信，以便隔離和分流 ASM 通信。
部署 Flex ASM
下面是 Flex ASM 安裝程序的屏幕截圖。選擇選項(xiàng)“Advanced Installation”
有三個存儲選項(xiàng)：標(biāo)準(zhǔn) ASMOracle Flex ASM非 ASM 托管的存儲推薦
12c 之前的 ASM 配置模式
管理 Flex ASM：無需 Flex ASM 特定的實(shí)例參數(shù)
ASM 服務(wù)器實(shí)例使用自動內(nèi)存管理 (AMM)
轉(zhuǎn)：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í)例和數(shù)據(jù)庫實(shí)例在不同的節(jié)點(diǎn)上運(yùn)行，而不是之前的ASM實(shí)例必須和數(shù)據(jù)庫實(shí)例運(yùn)行在同一個節(jié)點(diǎn)上。也就是說當(dāng)某個節(jié)點(diǎn)上的ASM 實(shí)例掛掉后，其上的數(shù)據(jù)庫實(shí)例還可以正常運(yùn)行。
在Oracle 12c中，在創(chuàng)建數(shù)據(jù)庫的時候還需要選擇是否啟用Oracle Flex 集群和Flex ASM， 但是到了18c中，默認(rèn)就是Flex 集群和Flex ASM，不再需要選擇。 下圖是12c中使用ASMCA工具將普通ASM 實(shí)例轉(zhuǎn)換成Flex ASM。
2. Flex ASM 測試
因?yàn)樵贠racle 18c 中默認(rèn)就是Flex ASM。 所以我們這里直接在RAC 環(huán)境上測試該功能。
2.1 當(dāng)前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中實(shí)例信息[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:?
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 實(shí)例故障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
關(guān)閉節(jié)點(diǎn)1上的ASM 實(shí)例[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 實(shí)例只在節(jié)點(diǎn)2上運(yùn)行：
[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上也運(yùn)行這節(jié)點(diǎn)1上的db 實(shí)例。
但是節(jié)點(diǎn)1上的數(shù)據(jù)庫實(shí)例正常運(yùn)行：SQL>?select?instance_name,instance_number?from?gv$instance;
INSTANCE_NAME?????????????INSTANCE_NUMBER
--------------------------------?---------------
cndba1???????????????????????????1
cndba2???????????????????????????2
啟動節(jié)點(diǎn)1上的ASM實(shí)例，又恢復(fù)原狀：[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
通過實(shí)驗(yàn)，可以驗(yàn)證任意一個節(jié)點(diǎn)的ASM實(shí)例的意外關(guān)閉/啟動，都不會影響該節(jié)點(diǎn)上的數(shù)據(jù)庫狀態(tài)，這極大的增強(qiáng)了RAC的高可用性。
Flex ASM的配置和轉(zhuǎn)換
從12c開始，推出了Flex ASM特性，允許RAC節(jié)點(diǎn)訪問遠(yuǎn)程節(jié)點(diǎn)的ASM實(shí)例，而自身無需運(yùn)行ASM實(shí)例。
一般在Flex集群，中心節(jié)點(diǎn)運(yùn)行ASM實(shí)例，葉節(jié)點(diǎn)遠(yuǎn)程訪問中心節(jié)點(diǎn)的ASM實(shí)例。
但是中心節(jié)點(diǎn)也可以不運(yùn)行ASM實(shí)例而訪問其他節(jié)點(diǎn)的ASM實(shí)例；另外，標(biāo)準(zhǔn)集群也可以啟用Flex ASM。
由于有通過網(wǎng)絡(luò)遠(yuǎn)程訪問ASM實(shí)例的狀況，因此也形成了ASM網(wǎng)絡(luò)，ASM網(wǎng)絡(luò)可與Private網(wǎng)絡(luò)共用，即ASM&Private網(wǎng)絡(luò)，可在安裝界面指定。
確認(rèn)當(dāng)前ASM狀態(tài)
點(diǎn)擊(?此處)折疊或打開$ asmcmd showclustermode
ASM cluster??:?Flex mode disabled
以上說明是標(biāo)準(zhǔn)ASM
運(yùn)行asmca，轉(zhuǎn)換ASM為Flex ASM，以下是部分步驟截圖
ASM的subnet與Public不同，將不能使用與Public相同的端口號
以root用戶運(yùn)行上圖所示的腳本，將對集群內(nèi)所有節(jié)點(diǎn)重啟CRS
最后，確認(rèn)當(dāng)前集群模式
點(diǎn)擊(?此處)折疊或打開$ asmcmd showclustermode
ASM cluster??:?Flex mode enabled
#后兩項(xiàng)是Flex ASM才有的
$ srvctl config asm
ASM home:
Password file: +OCRV/orapwASM
ASM listener: LISTENER
ASM instance count: ALL
Cluster ASM listener: ASMNET1LSNR_ASM
查看ASM監(jiān)聽器
點(diǎ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轉(zhuǎn)化為Flex ASM
什么是Flex ASM?
我們知道在12c之前的版本里，ASM實(shí)例需要在每一個節(jié)點(diǎn)運(yùn)行，而ASM 的客戶端(Database，ACFS，ADVM)只可以訪問本地的ASM 實(shí)例。如果使用了Oracle Flex ASM，情況就不一樣了，ASM的客戶端就可以通過ASM網(wǎng)絡(luò)訪問遠(yuǎn)程的ASM實(shí)例。如果一個運(yùn)行ASM實(shí)例的節(jié)點(diǎn)宕掉，Oracle集群會在另外一個節(jié)點(diǎn)上啟動一個新的ASM實(shí)例以此維持它的節(jié)點(diǎn)基數(shù)(Cardinality)。 同樣，如果一個12c數(shù)據(jù)庫實(shí)例連接了某一個ASM 實(shí)例，而這個ASM 實(shí)例crash掉或者實(shí)例運(yùn)行出錯，這個數(shù)據(jù)庫的實(shí)例會嘗試重新連接在另一個節(jié)點(diǎn)的一個已經(jīng)存在的ASM實(shí)例，這就是 Oracle Flex ASM。
Flex Cluster和Flex ASM的區(qū)別
Flex Cluster需要Flex ASM的支持
Flex ASM可以在StandardCluster和Flex Cluster運(yùn)行
如何控制ASM實(shí)例的個數(shù)
[orgrid@ohs1?~]$?srvctl?modify?asm?-count?2
[orgrid@ohs1?~]$?srvctl?config?asm
ASM?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實(shí)例至少的有2個實(shí)例，這樣不至于單點(diǎn)故障
Flex ASM和Standard ASM的轉(zhuǎn)化
我們可以把Standard ASM轉(zhuǎn)化為Flex ASM，但這個轉(zhuǎn)化是不可逆的。這樣做的目的可能是為了推廣這個特性，這個特性確實(shí)不錯
如果沒有使用Flex ASM，不設(shè)置SID會出現(xiàn)連接到空實(shí)例，但在Flex ASM情況下，會隨機(jī)選擇一個
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?]?[-asmsnmpPassword?]?{?}
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?]
[-asmsnmpPassword?]
[(-param?)]
-diskString?
(-diskGroupName?
(-disk??[-diskName?]?|
-diskList?
[-diskSize?]
[-failuregroup?]
[-force|-noforce]
[-quorum|-noquorum])
[-redundancy?]
[-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?]
3.?Configure?ASM?parameters?by?specifying?the?following?command?and?parameters:
-configureParameter
(-param?)
[-sysAsmPassword?]
4.?Create?Disk?Groups?by?specifying?the?following?command?and?parameters:
-createDiskGroup
[-diskString?]
(-diskGroupName?
(-disk??[-diskName?]?|
-diskList?
[-diskSize?]
[-failuregroup?]
[-force|-noforce]
[-quorum|-noquorum])
[-redundancy?]
[-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?]
5.?Add?disks?to?Disk?Groups?by?specifying?the?following?command?and?parameters:
-addDisk
[-diskString?]
(-diskGroupName?
(-disk??[-diskName?]?|
-diskList?
[-diskSize?]
[-failuregroup?]
[-force|-noforce]
[-quorum|-noquorum])
[-sysAsmPassword?]
6.?Create?volumes?by?specifying?the?following?command?and?parameters:
-createVolume
(-volumeName?
-volumeDiskGroup?
-volumeSizeGB?
[-volumeRedundancy?])
[-sysAsmPassword?]
7.?Create?ASM?Cluster?File?Systems?by?specifying?the?following?command?and?parameters:
-createACFS
(-acfsVolumeDevice?)
(-acfsMountPoint?)
[-acfsUserName?]
[-acfsGroupName?]
[-sysAsmPassword?]
8.?Delete?ASM?instance(s)?by?specifying?the?following?command?and?parameters:
-deleteASM
[-force]
[-dropDiskGroups]
[-sysAsmPassword?]
9. Convert Standard ASM into Oracle Flex ASM by specifying the following command and parameters:
-convertToFlexASM
-asmNetworks
-asmListenerPort
[orgrid@ohs1 ~]$
借助asmca生成轉(zhuǎn)化為Flex ASM的腳本converttoFlexASM.sh
[orgrid@ohs1 ~]$??asmca -silent -convertToFlexASM -asmNetworks eth1/172.16.0.0 -asmListenerPort?10010To?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腳本內(nèi)容
[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.shCRS-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?~]#
當(dāng)前系統(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?-detailASM?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é)點(diǎn)上ASM監(jiān)聽狀態(tài)
這里三個ASM實(shí)例共用一個服務(wù)名，有點(diǎn)類似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_ASMLSNRCTL?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_ASMLSNRCTL?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?~]$
在節(jié)點(diǎn)一上通過服務(wù)名連接ASM實(shí)例，連接到了+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
----------------?+ASM3SQL>
ASM監(jiān)聽service狀況
[orgrid@ohs1 ~]$ lsnrctl service ASMNET1LSNR_ASMLSNRCTL?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?~]$
通過服務(wù)名連接ASM實(shí)例，并關(guān)閉它[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_ASMLSNRCTL?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?~]$
與50位技術(shù)專家面對面20年技術(shù)見證，附贈技術(shù)全景圖總結(jié)
以上是生活随笔為你收集整理的oracle flex cluster,Oracle Flex ASM和Flex集群的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： oracle基于dblink创建视图,【
- 下一篇： dedecms index_testen