60.ORA-12528: TNS:listener

1.Oracle创建DG备库时,备库无法连接。

ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
2.解决方法 

newdg2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.1)(PORT = 1600))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = xxx)
      (UR=A)
    )
  )

连接串中加UR=A