Oracle Error 12154 Received Logging On To The Standby
Contents |
not able to connect to standby [message #433009] Sat, 28 November 2009 13:16 ankush_chawla Messages: 136Registered: November 2006 Senior Member hi we are receving following error in the Alert log of the primary Database,
Heartbeat Failed To Connect To Standby Error Is 12514
not sure why primary database not able to connect to standby database PING[ARCi]: Heartbeat ping arc2 heartbeat failed to connect to standby error is 12514 failed to connect to standby 'orclstand1'. Error is 12154. Sat Nov 28 22:15:06 2009 Error 12154 received logging on to error 12154 received logging on to the standby 11g rac the standby Sat Nov 28 22:15:06 2009 Errors in file \oracle\product\10.2.0\admin\orcl\bdump\orcl_arci_424.trc: ORA-12154: TNS:could not resolve the connect identifier specified 1. TNSPING for the standby database server gives the positive result 2. We are able
Heartbeat Failed To Connect To Standby Error Is 1033
to log on to the standby database from primary database server 3. Log files are shipped to the standby database server Please help Regards Report message to a moderator Re: primary database not able to connect to standby [message #433010 is a reply to message #433009] Sat, 28 November 2009 13:23 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member Ora-12154 = "I can not
Error 12514 Received Logging On To The Standby
find the entry in the TNSNAMES.ORA file that I am using (regardless of the one YOU THINK I am using)!" >1. TNSPING for the standby database server gives the positive result Above only means you can get to listener, but in this case you are not even getting to the listener. listener records into listener.log every connection request along with the appropriate status code STATUS=0 means success. [Updated on: Sat, 28 November 2009 13:26]Report message to a moderator Re: primary database not able to connect to standby [message #433011 is a reply to message #433010] Sat, 28 November 2009 13:43 ankush_chawla Messages: 136Registered: November 2006 Senior Member thanks for the response Not understanding where the issue is exactly Listener is up and running on both the servers. Listener log 28-NOV-2009 22:29:24 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=EQ-W00300109765)(USER=OraUser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2920)) * establish * orcl * 12518 TNS-12518: TNS:listener could not hand off client connection TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error Report message to a moderator Re: primary database not able to connect to standby [message #433012 is a reply to message #433011] Sat, 28 November 2009 13:53 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member >28-NOV-2009 22:29:24 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=\oracle\product\10.2.0
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle heartbeat failed to connect to standby error is 1031 Applications Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup
Error 12154 Connecting To Destination Log_archive_dest_2 Standby Host
Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) error 12154 received logging on to the standby 12c Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | Best last month | Question Most of http://www.orafaq.com/forum/t/152662/ my databases are on version 12.1 11.2 11.1 10.2 10.1 or lower Answer and see the results DBA Top 10 1 M. Cadot 35800 2 F. Diaz 34000 3 J. Schnackenberg 16400 4 B. Vroman 15450 5 A. Kavsek 15250 6 P. Wisse 14250 7 T. Boles 13500 8 M. Hidayathullah ... 10900 9 A. Hudspith 9200 10 A. Khan 4100 About Advertise here Download PLATOThe http://dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=51881 free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47788Total active users2117Act. users last 24h9Act. users last hour1Registered user hits last week756Registered user hits last month6432 Go up Heartbeat failed to connect to standby Next thread: Steps to fasten import Prev thread: "Oracle Clusterware Configuration Assistant" failed Message Score Author Date Dear Masters, i m getting following error very ...... javed akhtar May 30, 2012, 10:56 From doc.... If the Primary ARCn-Process is n...... Tarun Biswas May 30, 2012, 12:24 Check the network connection. On Dr site try to...... Raj thakur May 30, 2012, 14:25 Follow up by mail Click here Subject: Heartbeat failed to connect to standby Author: javed akhtar, India Date: May 30, 2012, 10:56, 1607 days ago Os info: aix6 Oracle info: 11gr2 Message: Dear Masters, i m getting following error very frequently in my log. Error 12154 received logging on to the standby Errors in file /oracle/oracle/diag/rdbms/primary/primary/trace/primary_arc2_24379410.trc: ORA-12154: TNS:could not resolve the connect identifier specified PING[ARC2]: Heartbeat failed to connect to standby 'stand'. Error is 12154. bash-3.2$ tnsping stand TNS Ping Utility for IBM/AIX RISC System/6000: Version 1
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking http://oracle.ittoolbox.com/groups/technical-functional/oracle-database-high-availability-l/oracle-dataguard-primary-not-shipping-logs-3114044 Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus error 12154 Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database High Availability For discussion on Oracle Database High Availability , received logging on please visit the Oracle Database group. More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Oracle DataGuard Primary Not Shipping logs Moshood Banks asked Nov 11, 2009 | Replies (3) Hello Gurus, I have configured Oracle Physiscal Standby Dataguard on IBM/AIX using Oracle 10gR2 between remotes sites. The configurations shipped a couple of logs after the configurations, and suddenly, I started having the following error message in the alert log file of the primary site: **********************************************