(UR=A) en Tnsnames
ORA-12528: TNS:listener: all appropriate instances are blocking new connections.
La base de datos se inició en nomount, mount o restricted mode.
Usar (UR=A) con (CONNECT_DATA=(SERVICE_NAME=SERVICE)) en el tnsnames.ora
por ejemplo:
V10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hal)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = v10g.uk.oracle.com)
)
)
SID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hal)(PORT = 1525))
)
(CONNECT_DATA =
(SID = v10g)
(SERVER = DEDICATED)
)
)
TESTUA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hal)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = v10g.uk.oracle.com)
(UR = A)
)
)
Hay que tener en cuenta que (UR=A) se recomienda el uso de SERVICE_NAME en vez de SID .
No hay comentarios.:
Publicar un comentario