Error 12521
Contents |
Oracle 11gR1 RAC to 11gR2 Applying PSU 11.2.0.3.5 to Grid Infrastructure and DB Home ASM Dataguard Install Transportable ora-12521: tns:listener does not currently know of instance requested in connect descriptor Tablespace Example Oracle12c Performance Grid MySQL Reset MySQL Root Password
Staticconnectidentifier For Dgmgrl
Unix Linux AIX HP-UX Solaris Netapp Reference Resource Center ADRCI Starting with Oracle Goldengate Scripts
Error: Ora-16664: Unable To Receive The Result From A Database
Useful SQL for DBA's Useful Metalink Articles About Us Contact Dataguard and DG Broker Setup Issues This article comprises of various issues encountered by us
Tns Listener Does Not Currently Know Of Service Requested In Connect Descriptor
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 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 failover in this tns entry as only one instance is up while using rman duplication 2) RMAN duplication failing with following error RMAN-03015: error occurred in stored script Memory Script RMAN-04014: startup failed: ORA-29760: instance_
Help Follow Us Facebook Twitter Google + LinkedIn Newsletter Instagram YouTube DirectoryNetwork InfrastructureWAN, Routing and Switching LAN, Switching and Routing Network Management Remote Access Optical Networking Getting Started with LANs IPv6 Integration and Transition EEM Scripting Other Subjects SecurityVPN Security Management Firewalling Intrusion Prevention Systems/IDS AAA, Identity and NAC Physical Security MARS Email Security Web Security Other Subjects Service ProvidersMetro MPLS Voice Over IP XR OS and Platforms Video Other Subjects Collaboration, Voice and VideoIP Telephony Video Over IP Jabber Clients http://askdba.org/weblog/oracle11g/dataguard/dataguard-and-dg-broker-setup-issues/ Unified Communications Applications TelePresence Digital Media System Contact Center Conferencing UC Migrations Other Subjects Wireless - MobilitySecurity and Network Management Wireless IP Voice and Video Getting Started with Wireless WLCCA Other Subjects ServicesCisco ServiceGrid Connected Analytics Smart Call Home Smart Net Total Care Operations Exchange Mobile ApplicationsCisco Proximity Cisco Technical Support Online Tools and https://supportforums.cisco.com/discussion/11578836/ise-111-error-code-12521-eap-tls-failed-ssltls-handshake-after-client-alert ResourcesCisco Bug Discussions Technical Documentation Ideas Cisco CLI Analyzer Support Community Help Data CenterApplication Centric Infrastructure Application Networking Intelligent Automation Server Networking Storage Networking Unified Computing Wide Area Application Services (WAAS) Other Subjects Small BusinessNetwork Storage Routers Security Surveillance Switches Voice and Conferencing Wireless Solutions and ArchitecturesBorderless Networks Collaboration Cisco User GroupsSeattle Cisco User Group (SEACUG) Silicon Valley Cisco User Group (SVCUG) Southern California Cisco User Group (SCCUG) Cisco Certifications Cisco.com Idea Center Cisco Cafe Expert CornerTop Contributors Leaderboards Cisco Live! Events Events Community CornerAwards & Recognition Behind the Scenes Feedback Forum Cisco Certifications Cisco Press Café Cisco On Demand Support & Downloads Community Resources Security Alerts Security Alerts News News Video Cisco Support YouTube Cisco YouTube Blogs Technical Documentation Cisco Products Products Services Services Solutions Solutions Global Support Numbers Cisco Support Community Directory Network Infrastructure WAN, Routing and Switching LAN, Switching and Routing Network Management Remote Access Optical Networking Getting Started with LANs IPv6 Integration and Transition EEM S
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: http://phxcharger.blogspot.com/2014/03/rac-standby-database-tns-12564.html TNS for Linux: Version 11.2.0.4.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production Time: 24-MAR-2014 12:17:27 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 does not nt 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 Severity Status Configuration does not currently 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 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 = '' LogXp