Shulou(Shulou.com)06/01 Report--

Asm remote connections may encounter the following error:

ORA-12505 TNS:listener could not resolve SID given in connect descriptorORA-12541: TNS:no listenerORA-15000: command disallowed by current instance typeORA-12528: TNS:listener: all appropriate instances are blocking new connectionsORA-1031: insufficient privileges

The asm remote connection is configured as follows:

Parameter configuration:

Remote_login_passwordfile = exclusive... For stand alone ASM setupsremote_login_passwordfile = shared... For ASM setups that also use Real Application Cluster (RAC)

Node 1:

[oracle@prodb1 admin] $cat listener.ora SID_LIST_LISTENER_prodb1 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = / u01/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) (SID_DESC = (SID_NAME = + ASM1) (GLOBAL_DBNAME = + ASM) (ORACLE_HOME = / u01 / App/oracle/product/10.2.0/db_1) LISTENER_prodb1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = prodb1-vip) (PORT = 1521) (IP = FIRST)) (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.10.101) (PORT = 1521) (IP = FIRST)

Node 2:

[oracle@prodb2 admin] $cat listener.ora SID_LIST_LISTENER_prodb2 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = / u01/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) (SID_DESC = (SID_NAME = + ASM2) (GLOBAL_DBNAME = + ASM) (ORACLE_HOME = / u01 / App/oracle/product/10.2.0/db_1) LISTENER_prodb2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = prodb2-vip) (PORT = 1521) (IP = FIRST)) (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.10.102) (PORT = 1521) (IP = FIRST)

Client tnsname.ora:

ASM1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.10.101) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = + ASM) (UR=A) ASM2 = (DESCRIPTION = (ADDRESS_LIST = (PROTOCOL = TCP) (HOST = 172.16.10. (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = + ASM) (UR=A)) ASM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.10.102) (PORT = 1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.10.101) (PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = + ASM) (UR=A)

The key part is (UR=A). If this option is not configured, the connection will be reported:

$sqlplus sys/admin@asm1 as sysdbaSQL*Plus: Release 10.2.0.5.0-Production on website 7. 21:44:30 2018Copyright (c) 1982, 2010, Oracle. All Rights Reserved.ERROR:ORA-12528: TNS:listener: all appropriate instances are blocking new connections

The UR=An option is typically used to connect to start the database using nomount,mount or restricted mode.

The database is started to nomount, and the listening status is BLOCKED

The database is started to mount, and the listening status is READY

The database is started to restrict, and the listening status is RESTRICT

The asm for static registration is BLOCKED

Reference from: How to connect to ASM instance from a remote client (Oracle Net) (document ID 340277.1)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.