How to solve the DataGuard Times ORA-12528 error in linux system configuration
This article mainly explains "how to solve the DataGuard Times ORA-12528 error in linux system configuration". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "linux system configuration DataGuard Times ORA-12528 error how to solve it"!
Description: in the construction of DataGuard, an error ORA-12528 was reported when running rman recovery.
The script is: RMAN > connect auxiliary sys/Oracle@SCMPRD02
Resolution steps:
1. Check whether the listening is enabled. Script: tnsping SCMPRD02
Method 1: configure database listening as static parameter step: check whether there is a listener.ora parameter file under ORACLE_HOME/network/admin, and if not, run netca to create database listening. The configured listening 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
SCMPRD02 =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP) (HOST = WELL) (PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED) (
SERVICE_NAME = SCMPRD02)
(UR = A) / / add this comment / /
)
)
Summary: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Because our replication database is only opened under nomount, and the database does not have mount, all listeners under 11g are dynamic listening, but only after the database mount, after the PMON process is up, can we register dynamically. So there is no way to register the secondary database, it can only be locked. Therefore, changing the monitoring of the database to static monitoring, or adding (UR=A) can solve the problem.
At this point, I believe you have a deeper understanding of "how to solve the DataGuard Times ORA-12528 error in linux system configuration". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!
