Oracle Standby Error Is 16191
Contents |
set to SHARED or EXCLUSIVE, and that the SYS password is same in the password files. returning error ORA-16191 ORA-16191 -Primary log shipping client ora-16191 standby database not logged on standby Solution :- 1.Defer the remote archival destination (log_archive_dest_state_n)
Error 16191 Connecting To For Fetching Gap Sequence
parameter in primary. In case of RAC defer LOG_ARCHIVE_DEST_STATE_n in all nodes. 2.check parameter REMOTE_PASSWORDFILE is set to
Ora-16191 Dataguard
either EXCLUSIVE or SHARED on the both database . 3.Delete the old password file and create the new one for both the DBs.In case of RAC shutdown all instance of
Error 1017 Received Logging On To The Standby Returning Error Ora-16191
standby before recreating the password file by below command :- orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=sys entries=5 force=y ignorecase=Y 4. set the parameter SEC_CASE_SENSITIVE_LOGON=FALSE on both DBs. 5.Enable the remote archival destination (log_archive_dest_state_n) parameter in primary. 6. Log into standby database and stop the recovery as SQL> alter database recover managed standby database cancel; 7. Now restart the recovery as SQL>alter database recover managed error 1017 received logging on to the standby 11g standby database disconnect from session ; 8.Perform a log switch on the primary database and check the archive sequence ,archive destination and alert logfile. SQL>select DEST_ID, STATUS, DESTINATION, ERROR from V$ARCHIVE_DEST; Posted by Shivendra Narain Nirala at 07:00 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Blog Archive ► 2014 (20) ► December (1) ► September (1) ► August (1) ► July (3) ► June (1) ► May (1) ► April (3) ► March (4) ► February (2) ► January (3) ▼ 2013 (31) ► December (2) ▼ November (3) ORA-00600: [2730], [331] after Switchover in New S... ORA-16191: Primary log shipping client not logged ... ORA-01153: an incompatible media recovery is activ... ► March (1) ► February (3) ► January (22) ► 2012 (15) ► December (15) About Me Shivendra Narain Nirala As an ORACLE RAC Certified Professional, I have handled 15 TB of Databases in critical environment and implementation of large-scale databases with replication and multi-node configurations in RAC, main task include configuration
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back ora-16191 heartbeat failed to connect to standby on and reload this page. Please enter a title. You can error 1017 received logging on to the standby 12c not post a blank message. Please type your message and try again. More discussions in Data error 1017 received logging on to the standby ora-16191 Guard All PlacesDatabasePerformance & AvailabilityData Guard This discussion is archived 1 2 Previous Next 21 Replies Latest reply on Jul 31, 2013 4:11 PM by AbuFazal [DataGuard][Error http://shivenracdba.blogspot.com/2013/11/ora-16191-primary-log-shipping-client.html 12514] Error received logging on to the standby Piotr91 Jul 31, 2013 9:09 AM Hello everyone,At first I'd like to say I'm a beginer in Oracle databases and I need help. I need to configure simple standby database. I have followed this http://www.oracle-base.com/articles/11g/data-guard-setup-11gr2.php tutorial to do that. Problem is that primary db cannot log https://community.oracle.com/thread/2565258 on to the standby db. Informations privided below:Primary DB:CentOS 6.4Oracle 11gR2ORACLE_SID=primdb1SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;MESSAGE--------------------------------------------------------------------------------ARC0: Archival startedARC1: Archival startedARC2: Archival startedARC1: Becoming the 'no FAL' ARCHARC1: Becoming the 'no SRL' ARCHARC2: Becoming the heartbeat ARCHARC1: Beginning to archive thread 1 sequence 31 (336165-356856)Error 12514 received logging on to the standbyPING[ARC2]: Heartbeat failed to connect to standby 'stbydb1'. Error is 12514.ARC1: Completed archiving thread 1 sequence 31 (336165-356856)ARC3: Archival startedMESSAGE--------------------------------------------------------------------------------Error 12514 received logging on to the standbyFAL[server, ARC2]: Error 12514 creating remote archivelog file 'stbydb1'ARC3: Beginning to archive thread 1 sequence 32 (356856-357024)ARC3: Completed archiving thread 1 sequence 32 (356856-357024)ARC0: Beginning to archive thread 1 sequence 33 (357024-357138)ARC0: Completed archiving thread 1 sequence 33 (357024-357138)17 rows selected.[oracle@oracled dbhome_1]$ bin/lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 31-JUL-2013 11:00:13Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 31-JUL-2013 10:37:38Uptime 0 days 0 hr. 22 min. 35 secTrace
Tablespace Issues Enterprise Manager Configuration Errors Oracle 11g Installation Errors Oracle 10g Archive Logs Oracle 9i Data Migration Patching Performance https://juniororacledba.wordpress.com/2011/07/31/oracle-dataguard-error-ora-16191/ SQL Tuning RMAN SQL System Queries Perl Web Design CSS http://dbaforums.org/oracle/index.php?showtopic=17706 PHP About Contact CV Home > Dataguard, Oracle > Oracle - Dataguard ErrorORA-16191 Oracle - Dataguard ErrorORA-16191 July 31, 2011 Kerri Robberts Leave a comment Go to comments If you are receiving the ORA-16191 error on your dataguard environment and the below error 1017 message comes up in your alert log: >------------------------------------------------------------ Errors in file /u01/app/oracle/diag/rdbms/epins/epins/trace/epins_arc1_22410.trc: ORA-16191: Primary log shipping client not logged on standby PING[ARC1]: Heartbeat failed to connect to standby 'rrbs'. Error is 16191. Mon Jul 18 14:26:04 2011 Error 1017 received logging on to the standby ------------------------------------------------------------ Check that the primary and standby error 1017 received are using a password file and remote_login_passwordfile is set to SHARED or EXCLUSIVE, and that the SYS password is same in the password files. returning error ORA-16191 ------------------------------------------------------------ Errors in file /u01/app/oracle/diag/rdbms/epins/epins/trace/epins_arc1_22410.trc: ORA-16191: Primary log shipping client not logged on standby PING[ARC1]: Heartbeat failed to connect to standby 'rrbs'. Error is 16191. Then your password file is incorrect and you need to update it by copying the orapw[SID] from the Primary database to the standby database. Rate this:Share this:TweetMoreEmailPrintLike this:Like Loading... Related Categories: Dataguard, Oracle Tags: dataguard error, ORA-16191, oracle password file, remote_login_passwordfile Comments (0) Trackbacks (0) Leave a comment Trackback No comments yet. No trackbacks yet. Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (Address never made public) Name Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using yo