启动ASM 实例 报错 先启动LISTENER 在启动 ASM

本文详细介绍了如何使用crs_stat命令检查Oracle RAC环境中的节点状态,包括ASM实例、监听器和应用服务的状态。通过操作示例展示了如何启动、停止ASM实例和监听器,并解决资源状态为UNKNOWN导致的启动失败问题。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

[oracle@node2 bin]$ ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE node1
ora....B2.inst application ONLINE OFFLINE
ora.RACDB.db application ONLINE ONLINE node2
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE UNKNOWN node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE UNKNOWN node2
ora....E2.lsnr application ONLINE UNKNOWN node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
[oracle@node2 bin]$ ./crs_stat
NAME=ora.RACDB.RACDB1.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on node1

NAME=ora.RACDB.RACDB2.inst
TYPE=application
TARGET=ONLINE
STATE=OFFLINE

NAME=ora.RACDB.db
TYPE=application
TARGET=ONLINE
STATE=ONLINE on node2

NAME=ora.node1.ASM1.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on node1

NAME=ora.node1.LISTENER_NODE1.lsnr
TYPE=application
TARGET=ONLINE
STATE=UNKNOWN on node1

NAME=ora.node1.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on node1

NAME=ora.node1.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on node1

NAME=ora.node1.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on node1

NAME=ora.node2.ASM2.asm
TYPE=application
TARGET=ONLINE
STATE=UNKNOWN on node2

NAME=ora.node2.LISTENER_NODE2.lsnr
TYPE=application
TARGET=ONLINE
STATE=UNKNOWN on node2

NAME=ora.node2.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on node2

NAME=ora.node2.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on node2

NAME=ora.node2.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on node2

[oracle@node2 bin]$ pwd
/opt/ora10g/product/10.2.0/crs_1/bin
[oracle@node2 bin]$ srvctl start ora.node2.ASM2.asm
/opt/ora10g/product/10.2.0/db_1/jdk/jre/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
[oracle@node2 bin]$ ./crs_start ora.node2.ASM2.asm
CRS-1028: Dependency analysis failed because of:
'Resource in UNKNOWN state: ora.node2.ASM2.asm'

CRS-0223: Resource 'ora.node2.ASM2.asm' has placement error.

[oracle@node2 bin]$ ./crs_start ora.node1.LISTENER_NODE1.lsnr
CRS-1028: Dependency analysis failed because of:
'Resource in UNKNOWN state: ora.node1.LISTENER_NODE1.lsnr'

CRS-0223: Resource 'ora.node1.LISTENER_NODE1.lsnr' has placement error.

[oracle@node2 bin]$ ./crs_stop ora.node1.LISTENER_NODE1.lsnr
Attempting to stop `ora.node1.LISTENER_NODE1.lsnr` on member `node1`
Stop of `ora.node1.LISTENER_NODE1.lsnr` on member `node1` succeeded.
[oracle@node2 bin]$ ./crs_start ora.node1.LISTENER_NODE1.lsnr
Attempting to start `ora.node1.LISTENER_NODE1.lsnr` on member `node1`
Start of `ora.node1.LISTENER_NODE1.lsnr` on member `node1` succeeded.
[oracle@node2 bin]$ ./crs_stop ora.node2.ASM2.asm
Attempting to stop `ora.node2.ASM2.asm` on member `node2`
Stop of `ora.node2.ASM2.asm` on member `node2` succeeded.
CRS-1016: Resources depending on 'ora.node2.ASM2.asm' are running

CRS-0223: Resource 'ora.node2.ASM2.asm' has placement error.

[oracle@node2 bin]$ ./crs_stop ora.node2.LISTENER_NODE2.lsnr
Attempting to stop `ora.node2.LISTENER_NODE2.lsnr` on member `node2`
Stop of `ora.node2.LISTENER_NODE2.lsnr` on member `node2` succeeded.
[oracle@node2 bin]$ ./crs_start ora.node2.LISTENER_NODE2.lsnr
Attempting to start `ora.node2.LISTENER_NODE2.lsnr` on member `node2`
Start of `ora.node2.LISTENER_NODE2.lsnr` on member `node2` succeeded.
[oracle@node2 bin]$ ./crs_stop ora.node2.ASM2.asm
`ora.node2.ASM2.asm` is already OFFLINE.
CRS-0216: Could not stop resource 'ora.node2.ASM2.asm'.

[oracle@node2 bin]$ ./crs_start ora.node2.ASM2.asm
Attempting to start `ora.node2.ASM2.asm` on member `node2`
Start of `ora.node2.ASM2.asm` on member `node2` succeeded.

<think>嗯,用户想知道如何登录Oracle RAC的ASM实例。首,我需要回忆一下Oracle ASM的基本概念。ASM是Automatic Storage Management,用来管理Oracle数据库的存储,特别是在RAC环境中。用户可能已经知道ASM的一些基本操作,但需要具体的登录步骤。 接下来,我应该考虑用户的实际使用场景。可能用户是DBA,需要管理RAC环境下的存储,或者在进行故障排除时访问ASM实例。需要确保提供的步骤准确,避免误导。 根据引用资料,登录ASM实例通常需要使用sqlplus,并且可能需要特定的环境变量设置。比如,ORACLE_SID需要设置为ASM实例的名称,比如+ASM1。另外,在RAC环境中,每个节点可能有自己的ASM实例,所以需要注意连接到正确的节点和实例。 然后,需要检查用户提供的引用内容。例如,引用[1]提到了ASM实例的基本介绍,引用[2]涉及清除ASM实例的方法,引用[3]和[4]展示了使用srvctl命令添加ASM实例的例子。这些引用可能帮助确认正确的实例名称和路径。 步骤部分,应该分点说明,包括设置环境变量、使用sqlplus登录,以及可能的srvctl工具的使用。同时,需要注意权限问题,比如使用oracle用户登录,并可能需要OS认证或密码文件验证。 另外,用户可能遇到的问题包括权限不足、实例名称错误或监听器配置问题。因此,注意事项部分需要涵盖这些常见错误点,比如检查实例状态、监听配置和用户权限。 最后,生成的相关问题需要与ASM实例管理相关,比如启动关闭、权限管理、存储配置和RAC中的管理操作,这样用户如果有进一步的问题,可以找到相关的指导。</think>### Oracle RAC ASM实例登录方法 #### 一、登录前提条件 1. 确认已安装Oracle Grid Infrastructure组件,ASM实例由Grid Infrastructure管理[^1] 2. 确认当前用户具有操作系统认证权限(通常为oracle用户) 3. 确认实例名格式符合RAC规范,例如:`+ASM1`、`+ASM2`(节点编号后缀) #### 二、具体操作步骤 **方法1:通过SQL*Plus本地登录** 1. 设置环境变量: ```bash export ORACLE_SID=+ASM1 # 根据实际节点编号修改 export ORACLE_HOME=/u01/app/grid/product/12.2.0/grid # Grid Infrastructure安装路径 ``` 2. 使用sysdba权限登录: ```bash sqlplus / as sysdba ``` **方法2:通过srvctl工具验证** ```bash srvctl status asm -n racnode1 # 查看节点1的ASM实例状态[^3][^4] ``` #### 三、验证连接成功 成功连接后应显示: ```sql SQL> SELECT INSTANCE_NAME, STATUS FROM V$ASM_INSTANCE; INSTANCE_NAME STATUS ---------------- ----------- +ASM1 STARTED ``` #### 四、注意事项 1. **权限验证**: - 必须使用`sysdba`权限连接 - 如果使用密码文件认证,需使用`sqlplus sys/<密码>@+ASM1 as sysdba` 2. **RAC环境特殊配置**: - 每个节点对应独立ASM实例(如+ASM1、+ASM2) - 使用`asmcmd`工具管理存储时需指定`-p`参数显示完整路径 3. **监听配置**: 确保监听器已注册ASM实例: ```bash lsnrctl status LISTENER_SCAN1 ```
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值