The following is not a small series of error report just turned the network, but also solved my problem, so I copied to you for reference.
Recently in the 11g of DG, encountered the following problems, recorded.
First look at the report of the following error:
Dgmgrl> show configuration;
Configuration-queue_zs_dg
Protection mode:maxperformance
Databases:
Queuedb-primary Database
Queuedb02-physical Standby Database
Error:ora-16664:unable to receive the result from a database
Fast-start failover:disabled
Configuration Status:
ERROR
Dgmgrl> Show database verbose queuedb02;
Database-queuedb02
Role:physical STANDBY
Intended state:apply-on
Transport Lag: (unknown)
Apply Lag: (unknown)
Apply Rate: (unknown)
Real Time Query:off
Instance (s):
Queuedb
Properties:
Dgconnectidentifier = ' QUEUEDB_ZS02 '
Observerconnectidentifier = ' '
Logxptmode = ' ASYNC '
Delaymins = ' 0 '
Binding = ' Optional '
Maxfailure = ' 0 '
MaxConnections = ' 1 '
Reopensecs = ' 300 '
Nettimeout = ' 30 '
redocompression = ' DISABLE '
logshipping = ' on '
Preferredapplyinstance = ' '
Applyinstancetimeout = ' 0 '
Applyparallel = ' AUTO '
standbyfilemanagement = ' AUTO '
Archivelagtarget = ' 0 '
logarchivemaxprocesses = ' 4 '
Logarchiveminsucceeddest = ' 1 '
Dbfilenameconvert = ' '
Logfilenameconvert = ' '
Faststartfailovertarget = ' '
Inconsistentproperties = ' (monitor) '
Inconsistentlogxptprops = ' (monitor) '
Sendqentries = ' (monitor) '
Logxptstatus = ' (monitor) '
Recvqentries = ' (monitor) '
Applylagthreshold = ' 0 '
Transportlagthreshold = ' 0 '
Transportdisconnectedthreshold = ' 30 '
Sidname = ' Queuedb '
Staticconnectidentifier = ' (description= (address= (protocol=tcp) (host=queuedb_zs02.cyou.com) (PORT=1521)) (CONNECT_ Data= (SERVICE_NAME=QUEUEDB02_DGMGRL) (Instance_name=queuedb) (server=dedicated)) '
standbyarchivelocation = ' Use_db_recovery_file_dest '
alternatelocation = ' '
Logarchivetrace = ' 0 '
Logarchiveformat = '%t_%s_%r.dbf '
Topwaitevents = ' (monitor) '
Database Status:
dgm-17016:failed to retrieve status for database "QUEUEDB02"
Ora-16664:unable to receive the result from a database
Alert Log Mad Brush:
Fatal NI Connect error 12514, connecting to:
(Description= (address_list= (address= (protocol=tcp) (host=queuedb_zs.cyou.com) (port=1521)) (CONNECT_DATA= ( SERVICE_NAME=QUEUEDB_DGB) (server=dedicated) (Cid= (program=oracle) (host=queuedb_zs02.cyou.com) (USER=oracle)))
VERSION Information:
TNS for Linux:version 11.2.0.4.0-production
TCP/IP NT Protocol Adapter for Linux:version 11.2.0.4.0-production
time:02-mar-2015 18:27:06
Tracing not turned on.
Tns error struct:
NS Main ERR code:12564
Tns-12564:tns:connection refused
NS Secondary Err code:0
NT Main ERR code:0
NT Secondary Err code:0
NT OS Err code:0
Tnsping are all through, why do you report this mistake?
To standby to view the database information, reported the following error, primary and standby error information is not the same.
Dgmgrl> show configuration;
Configuration-queue_zs_dg
Protection mode:maxperformance
Databases:
Queuedb-primary Database
Queuedb02-physical Standby Database
Error:ora-16810:multiple errors or warnings detected for the database
Fast-start failover:disabled
Configuration Status:
ERROR
Dgmgrl> Show database verbose queuedb02;
Database-queuedb02
Role:physical STANDBY
Intended state:apply-on
Transport lag:0 seconds (computed 0 seconds ago)
Apply Lag: (unknown)
Apply Rate: (unknown)
Real Time Query:off
Instance (s):
Queuedb
Warning:ora-16714:the value of property Archivelagtarget was inconsistent with the database setting
Warning:ora-16714:the value of property logarchivemaxprocesses was inconsistent with the database setting
Warning:ora-16714:the value of property logarchiveminsucceeddest was inconsistent with the database setting
Warning:ora-16714:the value of property Logarchivetrace was inconsistent with the database setting
Warning:ora-16714:the value of property Logarchiveformat was inconsistent with the database setting
Database Error (s):
Ora-16766:redo Apply is stopped
Properties:
Dgconnectidentifier = ' QUEUEDB_ZS02 '
Observerconnectidentifier = ' '
Logxptmode = ' ASYNC '
Delaymins = ' 0 '
Binding = ' Optional '
Maxfailure = ' 0 '
MaxConnections = ' 1 '
Reopensecs = ' 300 '
Nettimeout = ' 30 '
redocompression = ' DISABLE '
logshipping = ' on '
Preferredapplyinstance = ' '
Applyinstancetimeout = ' 0 '
Applyparallel = ' AUTO '
standbyfilemanagement = ' AUTO '
Archivelagtarget = ' 0 '
logarchivemaxprocesses = ' 4 '
Logarchiveminsucceeddest = ' 1 '
Dbfilenameconvert = ' '
Logfilenameconvert = ' '
Faststartfailovertarget = ' '
Inconsistentproperties = ' (monitor) '
Inconsistentlogxptprops = ' (monitor) '
Sendqentries = ' (monitor) '
Logxptstatus = ' (monitor) '
Recvqentries = ' (monitor) '
Applylagthreshold = ' 0 '
Transportlagthreshold = ' 0 '
Transportdisconnectedthreshold = ' 30 '
Sidname = ' Queuedb '
Staticconnectidentifier = ' (description= (address= (protocol=tcp) (host=queuedb_zs02.cyou.com) (PORT=1521)) (CONNECT_ Data= (SERVICE_NAME=QUEUEDB02_DGMGRL) (Instance_name=queuedb) (server=dedicated)) '
standbyarchivelocation = ' Use_db_recovery_file_dest '
alternatelocation = ' '
Logarchivetrace = ' 0 '
Logarchiveformat = '%t_%s_%r.dbf '
Topwaitevents = ' (monitor) '
Database Status:
ERROR
See the newspaper this mistake: error:ora-16810:multiple errors or warnings detected for the database
Show Database verbose has 5 warnning:
Warning:ora-16714:the value of property Archivelagtarget was inconsistent with the database setting
Warning:ora-16714:the value of property logarchivemaxprocesses was inconsistent with the database setting
Warning:ora-16714:the value of property logarchiveminsucceeddest was inconsistent with the database setting
Warning:ora-16714:the value of property Logarchivetrace was inconsistent with the database setting
Warning:ora-16714:the value of property Logarchiveformat was inconsistent with the database setting
These property values need to be reset:
Edit Database Queuedb02 Set property archivelagtarget= ' 0 ';
Edit Database Queuedb02 Set Property logarchivemaxprocesses= ' 4 ';
Edit Database Queuedb02 Set Property logarchiveminsucceeddest= ' 1 ';
Edit Database Queuedb02 Set property logarchivetrace= ' 0 ';
Edit Database Queuedb02 Set Property logarchiveformat= '%t_%s_%r.dbf ';
The reason is because:
Ora-16714: the value of property, string is inconsistent with the database setting
Cause: the Value of the specified configuration property is inconsistent with database In-memory settings or server parameter file s Ettings. This May is caused by the changing an initialization parameter which corresponds to a configuration property. The
Action: query property inconsistentproperties on the database to determine the inconsistent values. Reset the property to make it consistent with the database setting.
and then enable the database. Previously reported error:ora-16664:unable to receive the results from a database is also a problem with this attribute.
Dgmgrl> show configuration;
CONFIGURATION-QUEUE_ZS_DG
Protection mode:maxperformance
databases: queuedb -Primary database
queuedb02-physical standby database
Fast-start failover:disabled
Configuration Status:
SUCCESS