Error 12504 Received Logging On To The Standby
Contents |
to friend Error with shipping redo log from primary to standby [message #601350] Tue, 19 November 2013 20:56 trantuananh24hg Messages: 666Registered: January 2007 Location: error 12154 received logging on to the standby Ha Noi, Viet Nam Senior Member Good morning! I've got error yesterday. error 12154 received logging on to the standby 11g Let me describe: I configure DG successfully at 15/10/2013, both of them are Oracle 11gr2, ASM, RHEL error 12154 received logging on to the standby rac 5 (single), they are fine till 19/11/2013 when system administrator change the IP of primary. So, I got error shipping redo log from primary to standby. P/S: Because of long
Error 1031 Received Logging On To The Standby
brief, so I device into 2 post. I'm sorry for inconvenience Primary (RHEL 5.5, Oracle 11gr2 Grid Infrastructure, Enterprise) Error: Log Transport Services Error 2 1066 12504 YES 20-NOV-13 PING[ARC1]: Heartbeat failed to connect to standby 'wbstdby'. Error is 12504. Log Transport Services Error 0 1067 12504 YES 20-NOV-13 Error 12504 received logging on to the standby Log Transport error 1031 received logging on to the standby ora-01031 insufficient privileges Services Error 2 1068 12504 YES 20-NOV-13 PING[ARC1]: Heartbeat failed to connect to standby 'wbstdby'. Error is 12504. Log Transport Services Error 0 1069 12504 YES 20-NOV-13 Error 12504 received logging on to the standby Log Transport Services Error 2 1070 12504 YES 20-NOV-13 PING[ARC1]: Heartbeat failed to connect to standby 'wbstdby'. Error is 12504. - error log file * alert log file: Fatal NI connect error 12541, connecting to: (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=)(CID=(PROGRAM=oracle)(HOST=webcharge)(USER=oracle)))(ADDRESS=(PROTOCOL=TCP)(HOST=10.54.5. 177)(PORT=1521))) VERSION INFORMATION: TNS for Linux: Version 11.2.0.1.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production Time: 19-NOV-2013 01:16:44 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:no listener ns secondary err code: 12560 nt main err code: 511 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 TNS-00511: No listener nt secondary err code: 111 nt OS err code: 0 Error 12541 received logging on to the standby Check whether the listener is up and running. Errors in file /webcharge/app/oracle/diag/rdbms/webcharge/webcharge/
and SafetyAsset NetworkAsset error 1033 received logging on to the standby Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster
Error 12514 Received Logging On To The Standby
Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise
Error 12514 Received Logging On To The Standby Oracle
Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital http://www.orafaq.com/forum/t/190397/ AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel https://scn.sap.com/thread/1873348 Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication
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/2565258 work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a http://www.dbasupport.com/forums/showthread.php?61511-ORA-12504-TNS-listener-was-not-given-the-SERVICE_NAME-in-CONNECT_DATA blank message. Please type your message and try again. More discussions in Data Guard All PlacesDatabasePerformance & AvailabilityData Guard This discussion is received logging archived 1 2 Previous Next 21 Replies Latest reply on Jul 31, 2013 4:11 PM by AbuFazal [DataGuard][Error 12514] Error received logging on to the standby Piotr91 Jul 31, 2013 9:09 AM Hello everyone,At first I'd like to say I'm a beginer in Oracle databases and received logging on I need help. I need to configure simple standby database. I have followed this http://www.oracle-base.com/articles/11g/data-guard-setup-11gr2.php tutorial to do that. Problem is that primary db cannot log on to the standby db. Informations privided below:Primary DB:CentOS 6.4Oracle 11gR2ORACLE_SID=primdb1SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;MESSAGE--------------------------------------------------------------------------------ARC0: Archival startedARC1: Archival startedARC2: Archival startedARC1: Becoming the 'no FAL' ARCHARC1: Becoming the 'no SRL' ARCHARC2: Becoming the heartbeat ARCHARC1: Beginning to archive thread 1 sequence 31 (336165-356856)Error 12514 received logging on to the standbyPING[ARC2]: Heartbeat failed to connect to standby 'stbydb1'. Error is 12514.ARC1: Completed archiving thread 1 sequence 31 (336165-356856)ARC3: Archival startedMESSAGE--------------------------------------------------------------------------------Error 12514 received logging on to the standbyFAL[server, ARC2]: Error 12514 creating remote archivelog file 'stbydb1'ARC3: Beginning to archive thread 1 sequence 32 (356856-357024)ARC3: Completed archiving thread 1 sequence 32 (356856-357024)ARC0: Beginning to archive thread 1 sequence 33 (357024-357138)ARC0: Com
TNS:listener was not given the SERVICE_NAME in CONNECT_DATA If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 12 Thread: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-20-2010,02:37 PM #1 Jakobud View Profile View Forum Posts Junior Member Join Date Oct 2010 Posts 8 ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA First of all, I've Google'ed the Oracle error to death w/o any luck of getting any of the suggestions to work... We have Oracle running on several servers and just got it installed on a new server. But when trying to run sqlplus as system user, we get the error: Code: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA Obviously the first thing I did was look in our tnsnames.ora to make sure the SERVICE_NAME parameter was in there properly: (FYI the server name is Borg. Oracle is running on Borg and I'm trying to connect to it locally. This is Oracle 11g Release 2 (11.2.0.1.0)). tnsnames.ora: Code: BORG = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = borg)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = BORG) ) ) And here is listener.ora Code: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = BORG)(PORT = 1521)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = BORG) (GLOBAL_DBNAME = BORG) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1) ) ) ADR_BASE_LISTENER = /u01/app/orac