Connecting to Nomounted database

xychong123發表於2016-12-17
ORA-12528: TNS:listener: all appropriate instances are blocking new connections


Use (UR=A) with (CONNECT_DATA=(SERVICE_NAME=SERVICE))

Connection using SERVICE_NAME without (UR=A) would error with ORA-12528: TNS:listener: all appropriate instances are blocking new connections


TESTUA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = hal)(PORT = 1525)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = v10g.uk.oracle.com) 
      (UR = A) 
    ) 
  )


Please 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. 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20747382/viewspace-2130839/,如需轉載,請註明出處,否則將追究法律責任。

相關文章