Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.