windows rac执行set oracle_sid=+asm2不区分大小写

最新推荐文章于 2024-06-10 20:54:49 发布

lk_db

最新推荐文章于 2024-06-10 20:54:49 发布

阅读量787

点赞数

分类专栏： Oracle 文章标签： oracle asm sid

本文链接：https://blog.csdn.net/lk_db/article/details/79635203

版权

Oracle 专栏收录该内容

120 篇文章 5 订阅

订阅专栏

C:\Users\Administrator>crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.registry.acfs
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1
ora.cvu
1 ONLINE ONLINE rac1
ora.oc4j
1 ONLINE ONLINE rac1
ora.orcl.db
1 ONLINE ONLINE rac1 Open
2 ONLINE ONLINE rac2 Open
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac1

C:\Users\Administrator>crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 82ece6e26b384f13bfcbc7a5823ddeac (\\.\ORCLDISKCRS0) [CRS]
2. ONLINE 41f018438ebd4f31bf54aeda416341ce (\\.\ORCLDISKCRS1) [CRS]
3. ONLINE 74f87ea5540e4f84bff4fc06102b6649 (\\.\ORCLDISKCRS2) [CRS]
找到了 3 个表决磁盘。

C:\Users\Administrator>ocrcheck
Oracle 集群注册表的状态如下:
版本 : 3
总空间 (KB) : 262120
已用空间 (KB) : 3204
可用空间 (KB): 258916
ID : 420628353
设备/文件名 : +CRS
设备/文件完整性检查成功
设备/文件尚未配置
设备/文件尚未配置
设备/文件尚未配置
设备/文件尚未配置
集群注册表完整性检查成功
逻辑损坏检查成功

C:\Users\Administrator>set oracle_sid=+asm2
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期三 3月 21 09:30:26 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.

连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter inst
NAME TYPE VALUE
------------------------------------ ---------- ------------------------
cluster_database_instances integer 4
instance_name string +asm2
instance_number integer 2
instance_type string asm
SQL>

C:\Users\Administrator>set oracle_sid=+ASM2
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期三 3月 21 09:29:38 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.

连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter inst
NAME TYPE VALUE
------------------------------------ ---------- ------------------------
cluster_database_instances integer 4
instance_name string +asm2
instance_number integer 2
instance_type string asm
SQL>