Error 12541 Received Logging On To The Standby
Contents |
17, 2012 · Add Comment REFERENCE : How to Resolve Error in Remote Archiving [ID 799353.1] Problem : ORA-12541: TNS:no listener LNS: error 12154 received logging on to the standby Failed to archive log 5 thread 2 sequence 1101 (12541) Sun error 12154 received logging on to the standby 11g May 22 13:05:55 2011 Error 12541 received logging on to the standby Check whether the listener is error 12154 received logging on to the standby rac up and running. Solution : Step 1. Check the status of remote archive destination on primary database SELECT DESTINATION, STATUS, ERROR FROM V$ARCHIVE_DEST WHERE DEST_ID=2; DESTINATION STATUS ERROR ------------- ------ error 1031 received logging on to the standby --------------------------- ERPDR ERROR ORA-12541: TNS:no listener Step 2. Defer and enable the remote archive destination ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER; ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE; Step 3. Perform 2 log switches on the Primary/Source database: ALTER SYSTEM SWITCH LOGFILE; ALTER SYSTEM SWITCH LOGFILE; Step 4. Check the status of remote archive destination again: SELECT DESTINATION, STATUS, ERROR FROM V$ARCHIVE_DEST
Error 1031 Received Logging On To The Standby Ora-01031 Insufficient Privileges
WHERE DEST_ID=2; DESTINATION STATUS ERROR ------------- ------ --------------------------- ERPDR ERROR ORA-12541: TNS:no listener If the status of remote archive destination is error, then check the error code under Error. Resolve the error in the archiving and perform step 1 to 4 again. If there is no error in the remote archiving than status of remote archive destination will be "VALID" SELECT DESTINATION, STATUS, ERROR FROM V$ARCHIVE_DEST WHERE DEST_ID=2; DESTINATION STATUS ERROR -------------------- --------- ---------------------------------------- ERPDR VALID Step 5. Check whether redo logs are getting received on the standby using: FROM STANDBY SELECT THREAD#,MAX(SEQUENCE#) FROM V$ARCHIVED_LOG GROUP BY THREAD#;THREAD# MAX(SEQUENCE#) ---------- -------------- 1 1087 2 1101 Perform 2 log switches on primary database: lang="sql">ALTER SYSTEM SWITCH LOGFILE; ALTER SYSTEM SWITCH LOGFILE; Check whether SEQUENCE# changes SELECT THREAD#,MAX(SEQUENCE#) FROM V$ARCHIVED_LOG GROUP BY THREAD#;THREAD# MAX(SEQUENCE#) ---------- -------------- 1 1087 2 1103 Remote archiving is working fine if the sequence# is moving. Proceed to step 6 if sequence# is not moving: Step 6. Check the value of log_archive_max_processes on p
provides two error 12514 received logging on to the standby types of standby databases:1. Physical Standby DatabaseArchived redo log error 12514 received logging on to the standby oracle transferred from primary database will be directly applied to the standby database.2. Logical Standby Databasewe create http://www.onlinedbasupport.com/2012/05/17/ora-12541-tns-no-listener-while-remote-archiving/ SQL statements then these statements will be applied to stand by database. The key advantage for logical standby databases is that they're opened read/write, even while they're in applied modeIt is http://anuj-singh.blogspot.com/2009/10/create-duplicate-auxiliary-oracle.html important to identify unsupported database objects on the primary database before you create a logical standby database.This is because changes made to unsupported datatypes, table, sequences, or views on the primary database will not be propagated to the logical standby database. Moreover, no error message will be returned.SELECT DISTINCT OWNER,TABLE_NAME FROM DBA_LOGSTDBY_UNSUPPORTED ORDER BY OWNER,TABLE_NAME;SELECT COLUMN_NAME,DATA_TYPE FROM DBA_LOGSTDBY_UNSUPPORTED WHERE OWNER='XXX' AND TABLE_NAME = 'XXXXX';==================We are creating physical standby database on same hostorcl instance is up and running on archive log mode .init ora file for orcl instance =================================[apt-amd-02:oracle:orcl]$ cat init_orcl.txtorcl.__db_cache_size=297795584orcl.__java_pool_size=4194304orcl.__large_pool_size=4194304orcl.__shared_pool_size=130023424orcl.__streams_pool_size=0*.audit_file_dest='/opt/app/oracle/admin/orcl/adump'*.background_dump_dest='/opt/app/oracle/admin/orcl/bdump'*.compatible='10.2.0.1.0'*.control_files='/opt/app/oracle/oradata/orcl/orcl/control01.ctl','/opt/app/oracle/oradata/orcl/orcl/control02.ctl','/opt/app/oracle/oradata/orcl/orcl/control03.ctl'*.core_dump_dest='/opt/app/oracle/admin/orcl/cdump'*.db_block_size=8192*.db_domain=''*.db_file_multiblock_read_count=16*.db_name='orcl'*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'*.job_queue_processes=10*.nls_language='ENGLISH'*.nls_territory='UNITED KINGDOM'*.open_cursors=300*.pga_aggregate_target=146800640*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*.sga_target=440401920*.undo_management='AUTO'*.undo_tablespace='UNDOTBS1'*.user_dump_dest='/opt/app/oracle/admin/orcl/udump'*.log_archive_dest_1='LOCATION=/opt/app/oracle/archive/ MANDATORY'*.log_archive_de
entry for my Data Guard series. First things first, below are the specs of my test environment: - HP G60-445DX (w/ 4GB RAM) - Ubuntu 9.04 64-bit (instead of Vista Home http://im-a-dba.blogspot.com/2009/09/settting-up-oracle-dataguard.html premium to maximize the RAM) - VMWare 2.0 For the Oracle Data Guard Configuration http://dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=51881 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) HD: 30 GB (not pre-allocated) I assumed that you guys already have background in database administration, so I will received logging 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) 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 received logging on 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 backup of the current controlfile for standby database [oracle@oel41 ~]$ rman target / Recovery Manager: Release 10.2.0.4.0 - Production on Tue Sep 1 14:54:14 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: PRIM10G (DBID=3316445735) RMAN> run { allocate channel c1 type disk; 2> backup database format '/u02/stage/db%U' 3> plus archivelog format '/u02/stage/arc%U'; 4> b
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 Applications Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) 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 | No question at this time DBA Top 10 1 M. Cadot 37400 2 F. Diaz 33800 3 J. Schnackenberg 18400 4 B. Vroman 16350 5 A. Kavsek 15950 6 P. Wisse 14750 7 T. Boles 14400 8 M. Hidayathullah ... 11500 9 A. Hudspith 8600 10 A. Khan 4400 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47779Total active users2112Act. users last 24h3Act. users last hour2Registered user hits last week561Registered user hits last month6457 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, 1594 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