Oracle 10g remote connection asm
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)
