Fal Client User Error 16191 Connecting To
Contents |
before applying anything on production.You can reach to me at neeraj.vishen@gmail.com . Wednesday, November 9, 2011 ORA-16191: Primary log shipping client not logged error 1017 received logging on to the standby on standby Once I have changed the password of the primary database error 1017 received logging on to the standby 11g and find everything is working fine. Logs are applied on standby and sychronization between primary and standby database is fine
Fal[client, User]: Error 12154 Connecting To For Fetching Gap Sequence
. On next day when i restarted my standby database and find that the redo logs are not applying on the standby database . When I checked the alert log file then
Fal[client, User]: Error 1031
found the below error message. Error 1017 received logging on to the standby ------------------------------------------------------------ Check that the primary and standby 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 ------------------------------------------------------------ FAL[client, ARC0]: Error 16191 connecting to noida for fetching gap sequence Errors in file d:\app\stand\diag\diag\rdbms\delhi\delhi\trace\delhi_arc0_2308.trc: ORA-16191: Primary error 1033 received logging on to the standby log shipping client not logged on standby Errors in file d:\app\stand\diag\diag\rdbms\delhi\delhi\trace\delhi_arc0_2308.trc: ORA-16191: Primary log shipping client not logged on standby Dictionary check complete After some troubleshooting and googling, I came to conclusion that this error occurs because of the invalid user credentials while attempts to ship redo to standby database . To solve this issue we have copy the primary password file to standby database and rename the password file. Once the password-file is copied and renamed on standby database then stop and resatrt the recovery to make password-file in use. The below command will stop and restart the recovery . 1.) Log into standby database and stop the recovery as SQL> alter database recover managed standby database cancel; 2.) Now restart the recovery as SQL>alter database recover managed standby database disconnect from session ; Perform a log switch on the primary database and check the archive sequence ,archive destination and alert logfile. Enjoy :-) Posted by NEERAJ VISHEN at Wednesday, November 09, 2011 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search This Blog Loadi
oracle linux: Linux Server release 6.4 RAC double point ASM+restart-alone ASM Problem description: There can be normal to connect to the standby in the RAC1 real time application restart
Ora-16191
after the standby database with duplicate, but RAC2 was unable to connect, heartbeat failed to connect to standby error is 1033 the following error: standby database: Error 1017 received logging on to the standby ------------------------------------------------------------ Check that the primary error 12514 received logging on to the standby and standby 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 ------------------------------------------------------------ http://neeraj-dba.blogspot.com/2011/11/ora-16191-primary-log-shipping-client.html FAL[client, USER]: Error 16191 connecting to Rac for fetching gap sequence Thu Apr 03 18:16:24 2014 RFS[6]: Assigned to RFS process 3836 RFS[6]: Opened log for thread 2 sequence 30 dbid -1867447592 branch 839537688 Archived Log entry 13 added for thread 2 sequence 30 rlc 839537688 ID 0x90b182d8 dest 2: Thu Apr 03 18:16:26 2014 Media Recovery Log +FRA1/dg/archivelog/2014_04_03/thread_2_seq_30.288.843934585 Media Recovery http://www.programering.com/a/MTMyQTNwATM.html Waiting for thread 2 sequence 31 Error 1017 received logging on to the standby ------------------------------------------------------------ Check that the primary and standby 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 ------------------------------------------------------------ FAL[client, USER]: Error 16191 connecting to Rac for fetching gap sequence RAC2 error: PING[ARC2]: Heartbeat failed to connect to standby 'DG'. Error is 16191. Thu Apr 03 18:23:28 2014 Error 1017 received logging on to the standby ------------------------------------------------------------ Check that the primary and standby 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 ------------------------------------------------------------ PING[ARC2]: Heartbeat failed to connect to standby 'DG'. Error is 16191. Thu Apr 03 18:24:29 2014 Error 1017 received logging on to the standby ------------------------------------------------------------ Check that the primary and standby 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 ------------------------------------------------------------ PING[ARC2]:
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 https://community.oracle.com/thread/2565258 correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Data Guard All PlacesDatabasePerformance & AvailabilityData Guard This discussion is archived 1 received logging 2 Previous Next 21 Replies Latest reply on Jul 31, 2013 4:11 PM by AbuFazal [DataGuard][Error 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 received logging on 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 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 sequenc