Error 12521 Received Logging On To The Standby
Contents |
hexmanju Messages: 71Registered: September 2005 Location: MUMBAI Member Hi I am trying to configure Physical Standby Database.When i see the Alert Log of error 12154 received logging on to the standby Primary Database i get an error as follows:- PING[ARC1]: Heartbeat failed
Error 12154 Received Logging On To The Standby 11g
to connect to standby 'standby'. Error is 12528. Wed Oct 03 15:44:59 2007 Thread 1 cannot allocate error 12154 received logging on to the standby rac new log, sequence 6 Private strand flush not complete Current log# 1 seq# 5 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO01.LOG Thread 1 advanced to log sequence 6 Current log# 2 seq#
Error 1031 Received Logging On To The Standby
6 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO02.LOG Wed Oct 03 15:46:40 2007 Shutting down archive processes Wed Oct 03 15:46:45 2007 ARCH shutting down ARC2: Archival stopped Wed Oct 03 15:46:46 2007 Error 1031 received logging on to the standby Wed Oct 03 15:46:46 2007 Errors in file e:\oracle\product\10.2.0\admin\primary\bdump\primary_arc1_5236.trc: ORA-01031: insufficient privileges PING[ARC1]: Heartbeat failed to connect to standby 'standby'. error 1031 received logging on to the standby ora-01031 insufficient privileges Error is 1031. Wed Oct 03 15:49:08 2007 Thread 1 cannot allocate new log, sequence 7 Private strand flush not complete Current log# 2 seq# 6 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO02.LOG Thread 1 advanced to log sequence 7 Current log# 3 seq# 7 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO03.LOG Wed Oct 03 15:50:39 2007 Thread 1 cannot allocate new log, sequence 8 Private strand flush not complete Current log# 3 seq# 7 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO03.LOG Thread 1 advanced to log sequence 8 Current log# 1 seq# 8 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO01.LOG Wed Oct 03 15:51:47 2007 Error 1031 received logging on to the standby Wed Oct 03 15:51:47 2007 Errors in file e:\oracle\product\10.2.0\admin\primary\bdump\primary_arc1_5236.trc: ORA-01031: insufficient privileges Kindly help me asap Thanks MM Report message to a moderator Re: Config issue [message #272003 is a reply to message #271896] Wed, 03 October 2007 11:09 DreamzZ Messages: 1666Registered: May 2007 Location: Dreamzland Senior Member Post oracle version and result of this query from PRIMARY SQL> Select Status, Error 2 from v$Archive_dest 3 where d
ora-prod2-scan Standby - Single instance (11..2.0.4) Node - dbhost1d Using GI and ASM Error in Standby Alert log - Fatal NI connect error 12521, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbhost1-vip)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=psprod_DGB)(INSTANCE_NAME=psprod2)(SERVER=DEDICATED)(CID=(PROGRAM=oracle)(HOST=dbhost1d.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
Error 1033 Received Logging On To The Standby
Time: 24-MAR-2014 12:17:27 Tracing not turned on. Tns error struct: ns main err code:
Error 12514 Received Logging On To The Standby
12564 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt error 12514 received logging on to the standby oracle OS err code: 0 Error in Standby drcpsprod.log - Failed to connect to remote database psprod. Error is ORA-12521 Error on Node 2 drcpsprod.log - Data Guard Broker Status Summary: Type Name http://www.orafaq.com/forum/t/90343/ Severity Status Configuration psprod_linux Warning ORA-16607 Primary Database psprod Success ORA-00000 Physical Standby Database psproddg Error ORA-16664 The error in Standby alert log show that the standby database http://phxcharger.blogspot.com/2014/03/rac-standby-database-tns-12564.html is trying to connect to second instance (psprod2) of the 2 node RAC database using the vip of node 1. Since psprod2 instance is running on the node 2 which is dbhost2-vip there is an error in the alert log saying it connection refused. Solution - We have to change the DGConnectIdentifier using Data Guard broker to point to SCAN name instead of VIP name of the nodes. DGMGRL> SHOW DATABASE VERBOSE psprod Database - psprod Enterprise Manager Name: psprod_linux Role: PRIMARY Intended State: TRANSPORT-ON Instance(s): psprod1 psprod2 Properties: DGConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbhost1-vip)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=psprod)(SERVER=DEDICATED)))' ObserverConnectIdentifier = '' LogXptMode = 'ASYNC' DelayMins = '0' Binding = 'optional' MaxFailure = '0' MaxConnections = '1' ReopenSecs = '300' NetTimeout = '30' RedoCompression = 'DISABLE' LogShipping = 'ON' PreferredApplyInstance = '' ApplyI
Oracle 11gR1 RAC to 11gR2 Applying PSU 11.2.0.3.5 to Grid Infrastructure and http://askdba.org/weblog/oracle11g/dataguard/dataguard-and-dg-broker-setup-issues/ DB Home ASM Dataguard Install Transportable Tablespace Example Oracle12c Performance Grid MySQL Reset MySQL Root Password Unix Linux AIX HP-UX Solaris Netapp Reference Resource Center ADRCI Starting with Oracle Goldengate Scripts Useful SQL for DBA's Useful Metalink Articles About Us Contact Dataguard and DG Broker received logging Setup Issues This article comprises of various issues encountered by us while setting up Dataguard and DG Broker on 11gR2 RAC setup. 1)Connection to RMAN Auxiliary database gives ORA-1031 rman target [emailprotected]_dgmgrl auxiliary [emailprotected]_dgmgrl Recovery Manager: Release 11.2.0.3.0 - Production on Wed Feb 15 received logging on 10:52:20 2012 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: TINTIN (DBID=2175947715) RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges To resolve this ensure that you are able to connect to database using sqlplus sqlplus [emailprotected]_dgmgrl as sysdba If this gives error then a)Ensure password file exists for auxiliary database and remote_login_passwordfile=exclusive b)In case of RAC ensure that tnsnames.ora entry is correct. It should look like below snowy_dgmgrl = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oradbdev02.eglbp.corp.yahoo.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = oradbdev01.eglbp.corp.yahoo.com)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = snowy_DGMGRL))) ) We are not using load_balance and fa