Error 12154 Received
Contents |
not able to connect to standby [message #433009] Sat, 28 November 2009 13:16 ankush_chawla Messages: 136Registered: November 2006 Senior error 12154 received logging on to the standby 11g Member hi we are receving following error in the Alert log
Error 12154 Received Logging On To The Standby Rac
of the primary Database, not sure why primary database not able to connect to standby database oracle error 12154 received logging on to the standby PING[ARCi]: Heartbeat failed to connect to standby 'orclstand1'. Error is 12154. Sat Nov 28 22:15:06 2009 Error 12154 received logging on to the standby Sat Nov error 12154 connecting to 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 to log on to the standby database from primary database server 3. Log files are shipped to the standby database server Please help Regards
Error 12154 Connecting To Standby Host
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: 24930Registered: January 2009 Location: SoCal Senior Member Ora-12154 = "I can not 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 resp
any loss suffered as a result of following any of this blog posts.. Happy Learning... Tuesday, November 5, 2013 ORA-12154: TNS: could not resolve the connect identifier specified ########################## ## Error ########################## ORA-12154: TNS: could not resolve the connect identifier specified ### Full Error Mon Nov 04 21:01:00 2013 Error 12154 received error 12154 creating remote archivelog file logging on to the standby ########################## # Error Occurred ########################## Error occured while Primary database is trying to connect error 12154 connecting to for fetching gap sequence to a standby database for transfering archive logs in 11.2.0.3.0 version ########################## ## Command Executed ########################## Primary trying to transfer Archive logs to Standby ########################## ## Issue Description /
Oracle Error 12154 Encountered
Troubleshooting ########################## ### 11.2.0.3.0 ######################################### # 1) Check Whether archive destination is showing any errors ######################################### set lines 200 col dest_name for a20 col destination for a50 col error for a15 col db_unique_name for a15 col name for a100 select dest_id,dest_name,target,name_space,destination,status,error,db_unique_name from v$archive_dest where destination is not http://www.orafaq.com/forum/t/152662/ null; DEST_ID DEST_NAME TARGET NAME_SP DESTINATION STATUS ERROR DB_UNIQUE_NAME ---------- -------------------- ------- ------- -------------------------------------------------- --------- --------------- --------------- 1 LOG_ARCHIVE_DEST_1 PRIMARY SYSTEM USE_DB_RECOVERY_FILE_DEST VALID NONE 2 LOG_ARCHIVE_DEST_2 STANDBY SYSTEM oralin_stdby http://stepintooracledba.blogspot.com/2013/11/ora-12154-tns-could-not-resolve-connect.html ERROR ORA-12154: oralin_stdby TNS:could not resolve the connect identifier
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not https://community.oracle.com/thread/2277132?start=15&tstart=0 work correctly without it enabled. Please turn JavaScript back http://oracle.ittoolbox.com/groups/technical-functional/oracle-database-high-availability-l/oracle-dataguard-primary-not-shipping-logs-3114044 on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Data Guard All PlacesDatabasePerformance & AvailabilityData Guard This discussion is archived error 12154 1 2 Previous Next 26 Replies Latest reply on Aug 31, 2011 12:32 AM by mseberg Go to original post This content has been marked as final. Show 26 replies 15. Re: Single instance standby for 2-node RAC mseberg Aug 30, 2011 7:02 AM (in error 12154 received response to poorna) Assuming this is all from the Primary side 246 and 214, yes, not good. log_archive_dest_1 and log_archive_dest_2 appear to be backwards Yours log_archive_dest_1 = "LOCATION=/u02/stand/archive/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stand" log_archive_dest_2 = "SERVICE=RACDB ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=RACDB"What I would expect log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=RACDB' log_archive_dest_2='SERVICE=STAND LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STAND'I'm thinking they are probably wrong on the Standby side too. If you correct these and make sure log_archive_dest_state_2 is set to DEFER on the STANDBY side. I think it will start working. mseberg Like Show 0 Likes(0) Actions 16. Re: Single instance standby for 2-node RAC mseberg Sep 2, 2011 1:11 PM (in response to poorna) Assuming this is all from the Primary side 246 and 214, yes, not good. log_archive_dest_1 and log_archive_dest_2 appear to be backwards Yours log_archive_dest_1 = "LOCATION=/u02/stand/archive/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stand" log_archive_dest_2 = "SERVICE=RACDB ASYNC VALID_FOR=(ONL
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking 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 MacProTX Inside-ERP VoIP_News Inside-CRM maxwellarnold PCMag I_am_the_dragon Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate DukeGanote Dennis Stevenson Craig Borysowich Richard mircea_luca Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones blrvenkat bluesguyAZ59 iudithm COMPANIES RSA Conference UC4 Apperian Sophos 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 , 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: ********************************************** **************************************************************************** file /u01/oracle/admin/cmstst/bdump/cmstst_arc0_438486.t rc: ORA-12154: TNS:could not resolve the connect identifier specified PING[ARC0]: Heartbeat failed to connect to standby 'stdby'. Error is 12154. Mon Nov 9 12:08:42 2009 Error 12154 received logging on to the standby Mon Nov 9 12:08:42 2009 Errors in file /u01/oracle/admin/cmstst/bdump/cmstst_arc0_438486.t rc: ORA-12154: TNS:could not resolve the connect identifier sp