azure 云上 oracle11.2.0.4里dataguard归档日志传输 1034 问题详
1 ， dataguard 搭建好后，归档日志传输不过去 去查看master库上面的日志 tail –f /data/oracle/diag/rdbms/test_m1/powerdes/trace/alert_powerdes.log，显示信息如下： Sun May 08 00:34:17 2016 Error 1034 received logging on to the standby PING[ARC
1，dataguard搭建好后，归档日志传输不过去
去查看master库上面的日志
tail –f /data/oracle/diag/rdbms/test_m1/powerdes/trace/alert_powerdes.log，显示信息如下：
Sun May 08 00:34:17 2016
Error 1034 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'test_m2'. Error is1034.
2，tnsping earch_m2是通的
|
[oracle@azure_test_dbm1_3_111 admin]$ tnsping test_m3
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 08-MAY-2016 09:13:42
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.112)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = test_m2))) OK (0 msec) [oracle@azure_test_dbm1_3_111 admin]$ |
3，去standby备库上，Check检查下service_name，看到service_names确实是test_m2
看起来service_name也没用错，如下所示：
|
[oracle@azure_test_dbm1_3_112 admin]$ rlwrap sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 8 09:15:27 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter name;
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cell_offloadgroup_name string db_file_name_convert string /oracle/app/oracle/oradata/pow erdes, /oracle/app/oracle/orad ata/powerdes db_name string powerdes db_unique_name string test_m2 global_names boolean FALSE instance_name string powerdes lock_name_space string log_file_name_convert string /data/oracle/oradata/powerdes, /data/oracle/oradata/pwerdes
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ processor_group_name string service_names string test_m2 SQL> |
文章来源blog地址：http://blog.csdn.net/mchdba/article/details/51344246，谢绝转载
4，在master库、standby库，通过sqlplus登录报错
|
# 主库登录sqlplus报错 [oracle@azure_test_dbm1_3_111 admin]$ sqlplus sys/testsys@test_m2 as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 8 09:19:48 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Enter user-name:
# 备库sqlplus登录报错 [oracle@azure_test_dbm1_3_112 admin]$ sqlplus sys/testsys@test_m2 as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 8 09:18:39 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Enter user-name:
|
都报错：ORA-12514:TNS:listener does not currently know of service requested in connect descriptor，这个问题一般就涉及到的是tnsnames.ora里面的service_name没有写对了。
5，替换service_name，问题解决
回忆这个备库的搭建过程，我刚建库dbca的时候，设置的service_name是powerdes，我在配置dataguard的时候，修改了参数文件initpowerdes.ora，有在里面新设置*.db_unique_name=test_m2，再次create spfile frompfile;然后以新的参数文件启动数据库后，看到service_names变成了test_m2了，而我就在tnsnames.ora里面设置了新的service_names名字test_m2，这个新的test_m2没有生效结果报错ORA-12514了。
因此，我要将没有生效的test_m2换成原来的powerdes，需要换的地方有2个，一个是listener.ora，一个是tnsnames.ora，主库master库和备库standby库都要修改如下所示：
|
#主库master库修改1个文件tnsnames.ora # tnsnames.ora文件 [oracle@azure_test_dbm1_3_111 admin]$ vim tnsnames.ora test_m2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.112)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = powerdes) ) )
#备库standby库需要修改2个文件listener.ora、tnsnames.ora # listener.ora文件 [oracle@azure_test_dbm1_3_112 admin]$ vim listener.ora
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = powerdes) (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1) ) )
ADR_BASE_LISTENER = /oracle/app/oracle
# tnsnames.ora文件 [oracle@azure_test_dbm1_3_112 admin]$ vim tnsnames.ora test_m2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.112)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = powerdes) ) )
|
修改完配置后，然后重启lsnrctl监听服务，再在备库使用sqlplus登录test_m2，登录成功：
|
[oracle@azure_test_dbm1_3_112 admin]$ sqlplus sys/testsys@test_m2 as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 8 09:34:51 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> |
再去看主库master库的后台alert日志，就会发现已经有开始传输归档日志的记录了：
……
******************************************************************
LGWR: Setting 'active' archival fordestination LOG_ARCHIVE_DEST_2
******************************************************************
LGWR: Standby redo logfile selected toarchive thread 1 sequence 26
LGWR: Standby redo logfile selected forthread 1 sequence 26 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 26 (LGWRswitch)
Current log# 2 seq# 26 mem# 0:/oracle/app/oracle/oradata/powerdes/redo02.log
Sun May 08 01:12:22 2016
Archived Log entry 22 added for thread 1sequence 25 ID 0xcf7feffa dest 1:
ARC0: Standby redo logfile selected forthread 1 sequence 25 for destination LOG_ARCHIVE_DEST_2
Destination LOG_ARCHIVE_DEST_2 isSYNCHRONIZED
……
PS：这里问题比较奇怪，我上次这里service_name需要修改成新的参数文件里面的test_m2才能归档日志传输到备库standby上面，但是这次确需要保持原来的service_name。看来这里面还有别的奥妙所在。需要去探索清楚了。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Error code 801c03ed: How to fix it on Windows 11
Oct 04, 2023 pm 06:05 PM
Error 801c03ed is usually accompanied by the following message: Administrator policy does not allow this user to join the device. This error message will prevent you from installing Windows and joining a network, thereby preventing you from using your computer, so it is important to resolve this issue as soon as possible. What is error code 801c03ed? This is a Windows installation error that occurs due to the following reason: Azure setup does not allow new users to join. Device objects are not enabled on Azure. Hardware hash failure in Azure panel. How to fix error code 03c11ed on Windows 801? 1. Check Intune settings Log in to Azure portal. Navigate to Devices and select Device Settings. Change "Users can
Using Azure Semantic Search and OpenAI to build a cognitive search system
Oct 12, 2023 am 10:18 AM
Designed to simplify document search, a combination of services and platforms are key to unparalleled performance. In this article, we'll explore a holistic approach that combines the power of Azure Cognitive Services with the capabilities of OpenAI. By delving into intent recognition, document filtering, domain-specific algorithms, and text summarization, you'll learn to create a system that not only understands user intent but also processes and presents information efficiently.
Microsoft Azure OpenAI service now supports GPT-4 Turbo with Vision
Dec 18, 2023 am 08:18 AM
According to news from this site on December 17, the Azure OpenAI service provides REST API access to OpenAI’s powerful language models, which include GPT-4, GPT-3.5-Turbo and embedded model series. Microsoft announced further enhancements to the Azure OpenAI service and provided customers with a public preview version of the latest GPT-4 Turbo with Vision. This advanced multi-modal AI model inherits all the powerful features of GPT-4 Turbo and also adds image processing and analysis. ability. This opens up the opportunity to leverage GPT-4 for more tasks, such as improving accessibility, interpreting and analyzing data visualizations, and
Microsoft Azure will roll out mandatory multi-factor authentication starting in October
Aug 17, 2024 am 07:40 AM
According to news from this site on August 16, Microsoft issued an announcement yesterday, announcing that it will enforce the multi-factor authentication (MFA) function starting in October to help reduce the possibility of account hacking. Microsoft says MFA can prevent more than 99.2% of such account compromise attacks, so the measure is mandatory. According to reports, this process will be implemented gradually in two phases. This site summarizes it as follows: Phase 1: Starting from October, MFA will be required to log in to the Azure portal, Microsoft Entra Management Center and Intune Management Center, but it will not affect other Azure client. Phase 2: Starting in early 2025, MFA requirements will gradually expand to other Azure clients, such as Azure
How does Go language support file system operations on the cloud?
May 17, 2023 am 08:12 AM
With the continuous development of cloud computing technology, more and more applications are migrated to the cloud. Because file systems on the cloud are different from local file systems, developers need to use different languages and tools to operate these file systems. Go language is a fast, efficient, and concurrent programming language that is increasingly favored by developers. This article will introduce how to use Go language to support file system operations on the cloud. Go language supports cloud file systems. Go language provides a set of functions that can operate local file systems through the standard library, such as: os
Windows Server VNext Preview Build 25099 Now Available
Apr 14, 2023 pm 01:55 PM
Microsoft has released a new version of Windows Server Insider Preview. This week's build 25099 is now available for download in ISO and VHDX from the Windows Server Insider website, but as per usual, there's no full changelog to speak of, so it's unclear what's new. Microsoft once again said that the brand has not been updated and is still Windows Server 2022 in preview. Additionally, Microsoft encourages insiders to work on Azure
How to build reliable cloud applications with React and Microsoft Azure
Sep 26, 2023 am 11:01 AM
How to build reliable cloud applications using React and Microsoft Azure. With the development of cloud computing, more and more applications are migrating to the cloud. In this process, it is very important to choose a reliable and efficient development framework. React, as a popular front-end framework, has features such as efficient component development and virtual DOM updates, while Microsoft Azure is a flexible cloud service platform that provides powerful computing, storage, and deployment capabilities. This article will introduce how
Microsoft sets defense record in response to 3.47 Tbps DDoS attack
Apr 22, 2023 am 08:52 AM
Microsoft inadvertently set a new record last November when it mitigated a 3.47Tbps DDoS (distributed denial of service) attack. In a blog post, the Redmond giant shared Azure DDoS protection data for the third quarter of 2021. The company noted that the number of DDoS attacks increased in the second half of 2021. DDoS is a popular attack method that anyone can use due to the low price of attack services. In the second half of 2021, Microsoft mitigated an average of 1,955 attacks per day, an increase of 40% from the first half of the year. However, this pales in comparison to the 4,296 attacks mitigated on August 10, 2021. Overall,
