Thursday, March 29, 2012

ORA-12528: TNS:listener: all appropriate instances are blocking new connections

i got this error while create standby databse when i  was trying to connect  remote database through rman
from source database

in tnsnames.ora

DBASE_CONN=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =saturn)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =dupbase)(UR=A)
)
)

OR

Check Listener .Ora File In Standby Db   . Add Sid List Properly With Correct Service Name

No comments: