[20230323]连接asm实例无需UR=A测试.txt

--//有一些情况我无法登陆服务器,这样要连接asm实例就很麻烦.这样在知道asm的sys口令的情况下在连接串里面加入UR=A.
--//听过在11g下可以不用加入UR=A就可以登录asm实例,测试看看.

--//测试如下,服务上执行
$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 24-FEB-2023 10:22:41

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                13-MAR-2022 12:21:59
Uptime                    347 days 22 hr. 0 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/11.2.0/grid/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.90.14)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.90.16)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Service "fyhis" has 1 instance(s).
  Instance "fyhis1", status READY, has 1 handler(s) for this service...
Service "fyhisXDB" has 1 instance(s).
  Instance "fyhis1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "ywdb1", status READY, has 1 handler(s) for this service...
Service "ywdb" has 1 instance(s).
  Instance "ywdb1", status READY, has 1 handler(s) for this service...
Service "ywdbXDB" has 1 instance(s).
  Instance "ywdb1", status READY, has 1 handler(s) for this service...
Service "ywemr" has 1 instance(s).
  Instance "ywdb1", status READY, has 1 handler(s) for this service...
Service "ywhis" has 1 instance(s).
  Instance "ywdb1", status READY, has 1 handler(s) for this service...
Service "ywportal" has 1 instance(s).
  Instance "ywdb1", status READY, has 1 handler(s) for this service...
The command completed successfully

--//远程执行:
$ rlsql -s -l sys/ZZZZZZZZZ@127.0.0.1:9014/+asm as sysdba <<<'select sysdate from dual;'
SYSDATE
-------------------
2023-03-23 08:41:24
--//确实可以.