Home > received logging > error 12547 received logging on to the standby

Error 12547 Received Logging On To The Standby

Contents

connect to standby [message #348121] Mon, 15 September 2008 13:06 Alps Messages: 28Registered: November 2006 Location: Toronto Junior Member Hi guys, My alert for primary is showing me error 12154 received logging on to the standby these errors. Errors in file /var/ORADUMP/diag/rdbms/test_devzon/TEST ORA-16191: Primary log shipping client not

Error 12154 Received Logging On To The Standby 11g

logged on standby PING[ARC1]: Heartbeat failed to connect to standby 'STANDBY_TEST' Mon Sep 15 14:07:59 2008 Error 1017 received error 12154 received logging on to the standby rac 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 error 1031 received logging on to the standby is same in the password files. returning error ORA-16191 ------------------------------------------------------------ Errors in file /var/ORADUMP/diag/rdbms/testsxu_devzon/TEST/trace/TEST_arc1_10396.trc: ORA-16191: Primary log shipping client not logged on standby PING[ARC1]: Heartbeat failed to connect to standby 'STANDBY_TEST'. Error is 16191. But I can connect from standby and primary as follows. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, Oracle Label Security,

Error 1031 Received Logging On To The Standby Ora-01031 Insufficient Privileges

OLAP, Data Mining, Oracle Database Vault and Real Application Testing options SQL> connect sys/XXXXX@PRIMARY_TEST AS SYSDBA Connected. SQL> connect sys/XXXXX@STANDBY_TEST AS SYSDBA Connected. SQL> Report message to a moderator Re: Heartbeat failed to connect to standby [message #348129 is a reply to message #348121] Mon, 15 September 2008 13:57 BlackSwan Messages: 24930Registered: January 2009 Location: SoCal Senior Member http://www.orafaq.com/forum/t/88153/0/ Please read & follow posting guidelines as stated in URL above When did this last work? What changed? >SQL> connect sys/XXXXX@PRIMARY_TEST AS SYSDBA >Connected. >SQL> connect sys/XXXXX@STANDBY_TEST AS SYSDBA >Connected. >SQL> do the same from BOTH systems. Does listener.log file on standby show failed login attempt from Primary? Provide CUT & PASTE proof. Report message to a moderator Re: Heartbeat failed to connect to standby [message #348150 is a reply to message #348129] Mon, 15 September 2008 15:46 Alps Messages: 28Registered: November 2006 Location: Toronto Junior Member When did this last work? I am implementing on 11g What changed? Nothing changed yet still in process of getting archivelogs from primary Standby listener log: 15-SEP-2008 16:41:33 * (CONNECT_DATA=

by the reviewers are theirs alone and may not reflect my opinion whether implied or not. None of the advice is warranted to be free of errors and ommision. Please use at your own risk and error 1033 received logging on to the standby after thorough testing in your environment. Pages Home Collection of Some of My Very Popular error 12514 received logging on to the standby Published Web Articles Friday, December 18, 2009 Resolving Gaps in Data Guard Apply Using Incremental RMAN BAckup Recently, we had a glitch

Error 12514 Received Logging On To The Standby Oracle

on a Data Guard (physical standby database) on infrastructure. This is not a critical database; so the monitoring was relatively lax. And that being done by an outsourcer does not help it either. In any case, the laxness http://www.orafaq.com/forum/t/124922/ resulted in a failure remaining undetected for quite some time and it was eventually discovered only when the customer complained. This standby database is usually opened for read only access from time to time.This time, however, the customer saw that the data was significantly out of sync with primary and raised a red flag. Unfortunately, at this time it had become a rather political issue.Since the DBA in charge couldn't resolve the problem, I was called http://arup.blogspot.com/2009/12/resolving-gaps-in-data-guard-apply.html in. In this post, I will describe the issue and how it was resolved. In summary, there are two parts of the problem:(1) What happened(2) How to fix itWhat HappenedLet's look at the first question - what caused the standby to lag behind. First, I looked for the current SCN numbers of the primary and standby databases. On the primary:SQL> select current_scn from v$database;CURRENT_SCN----------- 1447102On the standby:SQL> select current_scn from v$database;CURRENT_SCN----------- 1301571Clearly there is a difference. But this by itself does not indicate a problem; since the standby is expected to lag behind the primary (this is an asynchronous non-real time apply setup). The real question is how much it is lagging in the terms of wall clock. To know that I used the scn_to_timestamp function to translate the SCN to a timestamp:SQL> select scn_to_timestamp(1447102) from dual;SCN_TO_TIMESTAMP(1447102)-------------------------------18-DEC-09 08.54.28.000000000 AMI ran the same query to know the timestamp associated with the SCN of the standby database as well (note, I ran it on the primary database, though; since it will fail in the standby in a mounted mode):SQL> select scn_to_timestamp(1301571) from dual;SCN_TO_TIMESTAMP(1301571)-------------------------------15-DEC-09 07.19.27.000000000 PMThis shows that the standby is two and half days lagging! The data at this point is not just stale; it must be rotten.The next question is why it would be lagging so far back in the past. This is a 10.2 databa

entry for my Data Guard series. First things first, below are the specs of my test environment: - HP G60-445DX (w/ http://im-a-dba.blogspot.com/2009/09/settting-up-oracle-dataguard.html 4GB RAM) - Ubuntu 9.04 64-bit (instead of Vista Home premium to maximize https://davidalejomarcos.wordpress.com/2011/01/18/removing-fatal-ni-connect-error-xxxx-from-your-alert-log/ the RAM) - VMWare 2.0 For the Oracle Data Guard Configuration I created 2 Virtual Machines, each with the ff. specs: RAM: 1GB (have tried this with 512 MB before, but very slow) OS : Oracle Enterprise Linux 4 (can be downloaded from e-delivery.oracle.com) DB: Oracle 10g R2 (10.2.0.4) received logging HD: 30 GB (not pre-allocated) I assumed that you guys already have background in database administration, so I will be skipping the fundamentals (e.g DB installation, patching etc.) I named my Primary database as "prim10g" and its host as "oel41", while my Physical Standby database as "stby10g" and its host as "oel42". Setting Up Oracle Data Guard (Physical Standby Database) received logging on 1. Turn on archiving on the Primary database [root@oel41 ~]# su - oracle [oracle@oel41 ~]$ export ORACLE_SID=prim10g [oracle@oel41 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 1 14:20:03 2009 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter system set log_archive_dest='/u02/oradata/archive/' scope=both; System altered. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> startup mount ORACLE instance started. Total System Global Area 285212672 bytes Fixed Size 1267044 bytes Variable Size 104860316 bytes Database Buffers 171966464 bytes Redo Buffers 7118848 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open 2 / Database altered. 2. Gather necessary files to create a physical standby database and perform an RMAN backup 2.1 Create a staging directory on Primary and Standby host [oracle@oel41 ~]$ mkdir -p /u02/stage [oracle@oel41 ~]$ 2.2 Create a copy of the init.ora (pfile) SQL> create pfile='/u02/stage/initprim10g.ora' from spfile; 2.3 Backup the database including archivelogs and create a

have a script to monitor the alert.log file for any ORA-xxxx errors. With 11g we found out many entries in regards of: Fatal NI connect error The problem: alert.log file has many entries for Fatal NI connect error. Examples: *********************************************************************** Fatal NI connect error 12514, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=nnn))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=sss)(CID=(PROGRAM=oracle)(HOST=xxx)(USER=oracle)))) VERSION INFORMATION: TNS for Linux: Version 11.2.0.2.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production Time: 17-JAN-2011 10:20:45 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 Error 12514 received logging on to the standby Mon Jan 17 10:21:45 2011 *********************************************************************** or *********************************************************************** Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 11.2.0.2.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production Time: 18-JAN-2011 15:13:08 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS:operation timed out ns secondary err code: 12560 nt main err code: 505 TNS-00505: Operation timed out nt secondary err code: 110 nt OS err code: 0 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.x.xx)(PORT=nnnn)) Tue Jan 18 15:40:20 2011 The solution: We will have an entry on the alert.log file every time a client connection of any kind fails to complete or is aborted. One way to minimize the impact is by using the parameter SQLNET.INBOUND_CONNECT_TIMEOUT (default to 60 seconds on 10gR2 and 11g) but, sometimes, this value is not adequate. Oracle also mentions the occurrence of this error if you use DB Console or Enterprise Manager to monitor your databases and the emagent will try to connect to the target database repeatedly and, statistically, some will fail (frequency will depend on h

 

Related content

error #1034 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby Oracle a li ul td tr tbody table p and SafetyAsset NetworkAsset Operations error received logging on to the standby and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data error received logging on to the standby g Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk error received

error 1017 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby g a li li a href Ora Primary Log Shipping Client Not Logged On Standby a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p standby 'STBYKOL' Error is Hi Guys Here is an relatedl Interesting case and I was stuck with the error received logging on to the standby ora problem since last days and a half In fact p

error 1017 received logging on to the standby oracle

Error Received Logging On To The Standby Oracle table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Oracle a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p Message Navigator E-mail to friend Standby database error primary failed to connect to standby message Mon relatedl May tomvdduin Messages Registered May error received logging on to the standby ora Location Huizen Junior Member This is my

error 1031 received logging on to the standby oracle

Error Received Logging On To The Standby Oracle table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Ora- Insufficient Privileges a li li a href Error Received Logging On To The Standby Oracle a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p free to correct me if I'm making relatedl some mistakes in this blog Pages Home My Profile error received logging on to the standby rac Sunday April Steps to resolve Error received logging p

error 1031 connecting to destination

Error Connecting To Destination table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby a li ul td tr tbody table p logging of LOG ARCHIVE DEST Fri Nov Error received logging on to the standby relatedl Suppressing further error logging of LOG ARCHIVE DEST Fri Nov error received logging on to the standby rac Error received logging on to the standby Suppressing ping arc heartbeat failed to connect to standby error is further error logging of LOG ARCHIVE DEST Fri Nov Error received logging on to the

error 1031 received logging on to the standby insufficient privileges

Error Received Logging On To The Standby Insufficient Privileges table id toc tbody tr td div id toctitle Contents div ul li a href Ping Arc Heartbeat Failed To Connect To Standby Error Is a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p ourselves Always be positive and keep relatedl smiling have a great day friends Source heartbeat failed to connect to standby error is Internet March Error received logging on to p h id Ping Arc

error 1031 received logging on to the standby 11g

Error Received Logging On To The Standby g table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Ora- Insufficient Privileges a li li a href V pwd file users a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p free to correct me if I'm making some mistakes in relatedl this blog Pages Home My Profile Sunday April error received logging on to the standby rac Steps to resolve Error received logging on to the standby p

error 1031 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Ora- Insufficient Privileges a li li a href Error Virtual Driver Error a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p ourselves Always be positive and keep smiling have a relatedl great day friends Source Internet March p h id Error Received Logging On To The Standby Ora-

error 1031 received logging on to the standby ora 01031

Error Received Logging On To The Standby Ora table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Rac a li li a href Error Received Logging On To The Standby Rac a li li a href Error Creating Remote Archivelog File a li ul td tr tbody table p ourselves Always be positive relatedl and keep smiling have a great day friends error received logging on to the standby ora- insufficient privileges Source Internet March Error received logging p h id Error Received Logging On To The

error 12170 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby Oracle a li ul td tr tbody table p not send to the standby message error received logging on to the standby Wed February andy huang error received logging on to the standby g Messages Registered July Senior Member Dear all The archive log can not error

error 12154 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Rac a li li a href Error Received Logging On To The Standby g a li li a href Ping Arc Heartbeat Failed To Connect To Standby a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p Web and Mobile SQL Plus Data Warehousing Installation Networking Backup Recovery Security relatedl Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO error received logging on

error 12537 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Rac a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware relatedl SupportRemote Support SPAN Development Implementation Consulting error received logging on to the standby StaffConsulting PricesHelp Wanted Oracle PostersOracle Books Oracle Scripts Ion error

error 12541 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Ora- Insufficient Privileges a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p middot Add Comment REFERENCE How to Resolve Error in Remote relatedl Archiving ID Problem ORA- TNS no listener LNS error received logging on to the standby Failed to archive log thread sequence Sun error received logging on to the standby g May Error received logging on to the

error 12560 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Ora- Insufficient Privileges a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p to friend Error with shipping redo log from primary to standby message Tue November trantuananh hg relatedl Messages Registered January Location Ha Noi Viet Nam error received logging on to the standby Senior Member Good morning I've got error yesterday Let me describe I error received logging on

error 12637 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Rac a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p DatabaseOracleopenwares DG maximize availability alert orcl log Fri Jul ORA- LGWR received timedout error relatedl from KSR LGWR Attempting destination LOG ARCHIVE DEST network reconnect error received logging on to the standby LGWR Destination LOG ARCHIVE DEST network

error 12521 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby g a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p hexmanju Messages Registered September Location MUMBAI Member Hi I am trying to configure Physical relatedl Standby Database When i see the Alert Log of error received

error 12505 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby Oracle a li ul td tr tbody table p to friend Error with shipping redo log from primary to standby message Tue November relatedl trantuananh hg Messages Registered January Location Ha Noi error received logging on to the standby Viet Nam Senior Member Good morning I've got

error 12545 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Rac a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p Broker fails error received logging on to the standby to enable databse message Sat error received logging on to the standby g March farnaw u Messages Registered October Location pakistan Junior Member p h id Error Received Logging

error 12520 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby Rac a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby Oracle a li ul td tr tbody table p 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

error 12504 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby Oracle a li ul td tr tbody table p to friend Error with shipping redo log from primary to standby message Tue relatedl November trantuananh hg Messages Registered January Location error received logging on to the standby Ha Noi Viet Nam Senior Member Good morning I've got

error 12514 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby g a li li a href Error Received Logging On To The Standby Ora- Insufficient Privileges a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError You don't have JavaScript enabled This tool uses JavaScript and much of it will relatedl not work correctly without it enabled Please turn error received logging on

error 28547 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Ping Arc Heartbeat Failed To Connect To Standby Error Is a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers relatedl to any questions you might have Meta Discuss error received logging on to the standby the workings and policies of this site About Us Learn more about p h

error 39710 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Ora- Insufficient Privileges a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p The DNS server returned Name Error The domain name does not p h id Error Received Logging On To The Standby Ora- Insufficient Privileges p exist This means that the cache was not able to resolve the hostname presented in the URL Check if the address is correct

error 604 received logging on to the standby

Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby Rac a li li a href Error Received Logging On To The Standby Ora- Insufficient Privileges a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p Comments When setting up relatedl the environment for Change Data Capture CDC which uses alter system register logfile streams and in our case

fal client user error 16191 connecting to

Fal Client User Error Connecting To table id toc tbody tr td div id toctitle Contents div ul li a href Fal client User Error Connecting To For Fetching Gap Sequence a li li a href Fal client User Error a li li a href Ora- a li ul td tr tbody table p before applying anything on production You can reach to me at neeraj vishen gmail com Wednesday relatedl November ORA- Primary log shipping client not logged error received logging on to the standby on standby Once I have changed the password of the primary database error received

fal client user error 1031 connecting

Fal Client User Error Connecting table id toc tbody tr td div id toctitle Contents div ul li a href Fal client User Error Connecting To For Fetching Gap Sequence a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p standby SQL select relatedl from v archive gap THREAD LOW SEQUENCE HIGH SEQUENCE ---------- fal client user error connecting to for fetching gap sequence ------------- --------------

oracle 11g error 1034 received logging on to the standby

Oracle g Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Heartbeat Failed To Connect To Standby Error Is a li li a href Ora- Server Not In Data Guard Configuration a li li a href Error Received Logging On To The Standby a li ul td tr tbody table p and relatedl SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription p h id Heartbeat Failed To Connect To Standby Error Is p Billing and Revenue ManagementMaster Data Management for ping arc heartbeat failed to connect to standby error is

oracle 11g error 1031 received logging on to the standby

Oracle g Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby Ora Insufficient Privileges a li li a href Heartbeat Failed To Connect To Standby Error Is a li li a href Error Received Logging On To The Standby a li li a href Ping Arc Heartbeat Failed To Connect To Standby Error Is a li ul td tr tbody table p logging of LOG ARCHIVE DEST Fri Nov Error received logging on to relatedl the standby Suppressing further error

oracle error 1034 received logging on to the standby

Oracle Error Received Logging On To The Standby table id toc tbody tr td div id toctitle Contents div ul li a href Ping Arc Heartbeat Failed To Connect To Standby Error Is a li li a href Ping arc Heartbeat Failed To Connect To Standby Error Is a li li a href Ora- Server Not In Data Guard Configuration a li ul td tr tbody table p and SafetyAsset NetworkAsset p h id Ping Arc Heartbeat Failed To Connect To Standby Error Is p Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data p h id Ping arc Heartbeat Failed