What should I do if ORA-12528 reports an error when building DataGuard in Linux?

The functions of DataGuard are mainly data protection, fault recovery, etc. When building DataGuard under Linux system, sometimes ORA-12528 will report an error. How to deal with this situation? Let's learn together.

Explanation: DataGuard to build in time to run rman restore the error ORA-12528 errors;

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

resolution steps:

1, check whether the listener startup script: tnsping SCMPRD02

method one: monitor configuration database for the static parameters steps: in ORACLE_HOME /network /admin Check if there is a listener.ora parameter file. If not, run netca to create a database listener. The configured listener file is as follows:

The code 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< Br>

SCMPRD02 =

(DESCR IPTION =

(ADDRESS =

(PROTOCOL = TCP)(HOST = WELL)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED) (

SERVICE_NAME = SCMPRD02)

(UR = A) //Add the comment //

)

)

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

Because our copy database is only opened under nomount, and the database does not have mount, all monitors under 11g are dynamic Listening, and only after the database mount, PMON process can be dynamically registered. So there is no way to register the secondary database, it can only be locked. So modify the database listener to static listener, or increase (UR=A) to solve the problem.

The above is the processing method of ORA-12528 error when building DataGuard under Linux. There are 2 ways to solve it. Hurry and choose a suitable method for processing.