Error 12154 Connecting To Destination Log_archive_dest_2
Contents |
9,010 HelloI am having problems with my standby and its driving me up the wall. I created the standby on Saturday, ready to go log archive dest 2 defer Live today. I created it from a cold backup. This was working fine, switched a
Log Archive Dest 2 Data Guard
few logfiles on the primary and these were applied on the standby. I had a hot backup run on the primary at oracle log archive dest 5.30 pm on the same day. Come in this morninga and the logs are not being applied to the standby. I get the following when I look at the trace filekcrrfail: dest:2 err:12154 force:0ORA-12154: TNS:could not resolve
Error 12154 Received Logging On To The Standby 11g
service name*** 2007-10-22 13:02:19.026Error 12154 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'PRD01STBY'Error 12154 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'PRD01STBY'Heartbeat failed to connect to standby 'MCSPRD01STBY'. Error is 12154.This is very baffling as nothing has changed, my tns is fine and so is the listener. I am running Oracle 9i on AIX 5. Could someone please help as its a live environmentThanks burleson View Member Profile Oct 22 2007, 08:00 AM Post #2 Advanced heartbeat failed to connect to standby error is 12154 Member Group: Members Posts: 13,227 Joined: 26-January 04 Member No.: 13 Hi,The ORA-12154 could be due to several things:http://www.dba-oracle.com/t_ora_12154_tns_...ervice_name.htmThe ORA-21254 is a very common error, always related to your local copy of the tnsnames.ora file, your listener configuration and your database name aliases.Make sure that your listener is listening for the same service name that you are using. Your service name might have an alias, so check for global (world) entries and local entries. Check $ORACLE_HOME/network/admin/tnsnames.ora. Check your global_name setting with this SQL: select * from global_name;The query value should match your init.ora parms for db_name and db_domain, You can change the global_name with an alter database commend, as follows: alter database rename global_name to xxx; -------------------- Hope this helps. . . Donald K. BurlesonOracle Press authorAuthor of Oracle Tuning: The Definitive Reference novicedba View Member Profile Oct 22 2007, 09:09 AM Post #3 Advanced Member Group: Members Posts: 50 Joined: 30-May 07 Member No.: 9,010 Many thanksthe tns and listener all seem to be working ok. I have done a tnsping to standby from primary and its workingHowever, I have come across the following message in the alert logRFS network connection lost at host 'MCSPRD01STBY'Error 3113 detaching RFS from standby instance at host 'PRD01STBY'Ignoring kcrrvnc() detach error 3113Standby database restarted; old mount ID 0x4621b206 now 0x462e2752Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT
want be open after standby configuration [message #516561] Tue, 19 July 2011 05:09 piotrtal Messages: 168Registered: June 2011 Location: Poland/Czestochowa Senior Member Hi, I did standby before
Heartbeat Failed To Connect To Standby Error Is 1033
and it works wighout any disturbations and even configuration seems to me
Error 12154 Received Logging On To The Standby Rac
not very complicated - but it was before. now i am trying to do standby configuration once again ping arc2 heartbeat failed to connect to standby error is 12154 and i don't know where I have corruption in my thinking. :/ there is database named DESK. two physical serwers: sczepl-db07 - primary r00979 - standby on each for this http://dbaforums.org/oracle/index.php?showtopic=8693 serwer there is listener listening on port 1521, and on each is tnsnames configured properly: for sczepl-db07 LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sczepl-db07)(PORT = 1521)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = c:\oracle\ora92) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = desk_prm) (ORACLE_HOME = http://www.orafaq.com/forum/t/173210/ C:\oracle\ora92) (SID_NAME = desk) ) ) tns ---------- desk_std = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = r00979)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = desk_std) ) ) desk_prm = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sczepl-db07)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = desk_prm) ) ) for r00979: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = d:\oracle\ora92) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = desk_std) (ORACLE_HOME = d:\oracle\ora92) (SID_NAME = desk) ) ) LISTENER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = r00979)(PORT = 1521)) ) ) tns ------- desk_std = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = r00979)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = desk_std) ) ) desk_prm = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sczepl-db07)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = desk_prm) ) ) after shudown primary system i copied every data files to the same directory on standby se
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 http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=14719 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 error 12154 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 log archive dest 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 Standby Database not recieving archives Next thread: Invalid Package Body Prev thread: rman error Message Score Author Date Hi all, I have been trying to configure Stdb db...... Sumit Sachdeva Oct 05, 2005, 09:11 INIT.ora Primary db log_archive_start = true log...... Sumit Sachdeva Oct 05, 2005, 09:12 Alert log on primary 1. Creating archive destin...... Sumit Sachdeva Oct 05, 2005, 09:13 Hi Sumit Sachdeva, Before to deal about your a...... Lauri Oct 05, 2005, 11:19 Hi Yes as said here above We see SERVICE_NAM...... Guy Lambregts Oct 05, 2005, 12:08 Hi I created new service as oradim -new -si...... Sumit Sachdeva Oct 05, 2005, 12:22 LSNRCTL> services Connecting to (DESCRIPTION=(PRO...... Sumit Sachdeva Oct 05, 2005, 12:25 Follow up by mail Click here Subject: Standby Database not recieving archives Author: Sumit Sachdeva, India Date: Oct 05, 2005, 09:11, 4023 days ago Os info: Win 2000 Oracle info: Oracle 9.2 Message