############################################################################
  How to establish remote connection to a database in restricted or NO MOUNT mode
############################################################################



Connections via listener to an instance that is in RESTRICTED status or in NO MOUNT status fail with
TNS-12526, TNS-12527 or TNS-12528 even when supplying the credentials for a privileged account.
   
The lsnrctl services output will show that the service handler for this instance is in state: BLOCKED or RESTRICTED.


 
DBTEST_PRIV = 
   (DESCRIPTION = 
     (ADDRESS_LIST = 
          (ADDRESS = (PROTOCOL = TCP)(HOST = rm01it.emilianofusaglia.net)(PORT = 1522)))
      (CONNECT_DATA = 
          (UR=A) 
          (SERVICE_NAME = dbtest.emilianofusaglia.net) 
       ) 
     ) 
 

 
Note that the (UR=A) clause is intended to work with a dynamically registered handler 
so the use of SERVICE_NAME versus SID is preferred.  SID may connect to a statically configured handler.