环境: Oracle 12.2.0.1 RAC
背景: 用户反映 12c ASM 创建的用户具备 sysasm 权限, 但无法在客户端连接到 ASM 实例, 且没有报错.
1.ASM 实例创建用户赋予 sysasm 权限
2. 客户端 tnsnames.ora 配置
3. 客户端测试连接
1.ASM 实例创建用户赋予 sysasm 权限
- sqlplus / as sysasm
- SQL> create user infa identified by infa;
- User created.
- SQL> grant sysasm to infa;
- Grant succeeded.
2. 客户端 tnsnames.ora 配置
分别针对 ASM 实例 1 和实例 2 配置对应的信息:
- ASM12c1 =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.90)(PORT = 1521))
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = +ASM)
- (INSTANCE_NAME = +ASM1)
- )
- )
- ASM12c2 =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.92)(PORT = 1521))
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = +ASM)
- (INSTANCE_NAME = +ASM2)
- )
- )
因为是 12c 版本, 无需配置 UR=A, 关于 UR=A 可参考之前的测试:
关于 UR=A 的测试
3. 客户端测试连接
客户端测试连接 ASM12c1:
- [oracle@db01 admin]$ sqlplus infa/infa@asm12c1 as sysasm
- SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 13 22:45:53 2019
- Copyright (c) 1982, 2013, Oracle. All rights reserved.
- Connected to:
- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
- SQL> show parameter instance_name
- NAME TYPE
- ------------------------------------ ----------------------
- VALUE
- ------------------------------
- instance_name string
- +ASM1
- SQL> exit
- Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
客户端测试连接 ASM12c2:
- [oracle@db01 admin]$ sqlplus infa/infa@asm12c2 as sysasm
- SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 13 22:46:19 2019
- Copyright (c) 1982, 2013, Oracle. All rights reserved.
- Connected to:
- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
- SQL> show parameter instance_name
- NAME TYPE
- ------------------------------------ ----------------------
- VALUE
- ------------------------------
- instance_name string
- +ASM2
- SQL>
我测试是没有任何问题的, 明天连接实际客户环境再进一步看具体情况.
来源: https://www.cnblogs.com/jyzhao/p/10527450.html