Configure DataGuard to report to ORA-12528

Configure DataGuard to report to ORA-12528

(In the creation of DataGuard, run rman recovery error ORA-12528 error;

The script is as follows: RMAN> connect auxiliary sys/Oracle @ SCMPRD02

Solution:

1. Check whether the listener is started. Script: tnsping SCMPRD02

Method 1: configure the Database listener as a static parameter step: Check whether there is a listener under ORACLE_HOME/network/admin. ora parameter file. If not, run netca to create a database listener. The configured listener file is as follows:

 

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = SCMPRDDB02) (PORT = 1521 ))

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 ))

)

)

ADR_BASE_LISTENER =/u01/app/oracle
 

Method 2: Modify the tnsnames. ora File

 

SCMPRD02 =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP) (HOST = WELL) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED )(
SERVICE_NAME = SCMPRD02)
(UR = A) // Add this note //
)
)
 

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

Cause: All instances supporting the service requested by the client reported that they were blocking the new connections. this condition may be temporary, such as at instance startup. action: Attempt the connection again. if error persists, then contact the administrator to check the status of the instances.

Because we only open the replication database under nomount, and the database does not mount, all the listeners under 11G are dynamic listeners, and only after the database is mounted, after the PMON process is up, to dynamically register. Therefore, the secondary database cannot be registered and can only be locked.

Therefore, you can modify the Database Listener to A static listener or add (UR = A) to solve the problem;

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Important configuration parameters of Oracle Data Guard

Configure Oracle 11g Data Guard based on the same host

Explore Oracle 11g elastic uard

Oracle Data Guard (RAC + DG) archive deletion policies and scripts

Role conversion for Oracle Data Guard

FAL gap in Oracle Data Guard logs

Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby