oracle11.2.0.4 in Azure Cloud Dataguard Archive Log Transfer 1034 issue detailed resolution process

1,Dataguardafter the build, the archive log transfer is not over.

To see the logs above the master library

Tail–f/data/oracle/diag/rdbms/test_m1/powerdes/trace/alert_powerdes.log, the following information is displayed:

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_m2it's a pass.

[Email protected]_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, 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)) (CON Nect_data = (service_name = test_m2))) OK (0 msec) [[Email protected]_test_dbm1_3_111 admin]$

3, GoStandbyon the standby library,CheckCheck theservice_name, seeService_namesYes, really .test_m2

It seems that service_name is useless, as shown below:

[Email protected]_test_dbm1_3_112 admin]$ rlwrap sqlplus/as sysdba Sql*plus:release 11.2.0.4.0 Production on Sun 8 09:15:27 2016 Copyright (c) 1982, 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>

Article source Blog address: http://blog.csdn.net/mchdba/article/details/51344246, declined reprint

4, inMasterLibraries,StandbyLibrary, throughSqlplusLogin Error

# Main Library Login Sqlplus Error [Email protected]_test_dbm1_3_111 admin]$ sqlplus sys/[email protected]_m2 as Sysdba Sql*plus:release 11.2.0.4.0 Production on Sun 8 09:19:48 2016 Copyright (c) 1982, Oracle. All rights reserved. ERROR: Ora-12514:tns:listener does not currently know of service requested in Connect Descriptor Enter User-name: # Standby Library Sqlplus Login Error [Email protected]_test_dbm1_3_112 admin]$ sqlplus sys/[email protected]_m2 as Sysdba Sql*plus:release 11.2.0.4.0 Production on Sun 8 09:18:39 2016 Copyright (c) 1982, Oracle. All rights reserved. ERROR: Ora-12514:tns:listener does not currently know of service requested in Connect Descriptor Enter User-name:

All error:Ora-12514:tns:listener does not currently know of service requested in Connect descriptor, This problem is generally related to the Tnsnames.ora inside the service_name is not written right.

5, replaceservice_name, Problem solving

Memories of the preparation of the library, I just built the library DBCA, set the service_name is Powerdes, I in the configuration Dataguard, modified the parameter file Initpowerdes.ora, there is a new setting in the *.db_unique_ NAME=TEST_M2, create SPFile frompfile again, and then start the database with the new parameter file, see Service_names becomes test_m2, and I set up a new service in Tnsnames.ora _names name test_m2, this new test_m2 no effective result error ORA-12514.

Therefore, I would like to replace the test_m2 with the original powerdes, need to change the place there are 2, one is Listener.ora, one is Tnsnames.ora, the Master Library Master Library and the repository standby library are to be modified as follows:

# Main Library Master Library Modifications 1 a file Tnsnames.ora # Tnsnames.ora file [Email protected]_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 Library Standby library needs to be modified 2 a file Listener.ora , Tnsnames.ora # Listener.ora file [Email protected]_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 file [Email protected]_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) ) )

After you modify the configuration, and then restart the LSNRCTL monitoring service, and then use Sqlplus login test_m2 in the standby, the login succeeds:

[[Email protected]_test_ dbm1_3_112 admin]$ sqlplus sys/[email protected]_m2 as sysdba                                          ,         &N Bsp                          ,         &NB Sp              Sql*plus:release 11.2.0.4.0 Production on Sun 8 09:34:5 1   Copyright (c) 1982, 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>

If you look at the background alert log in the Master Library Master Library, you will find that you have a record of starting the Transfer archive log:

......

******************************************************************

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 for destination log_archive_dest_2

Thread 1 advanced to log sequence (Lgwrswitch)

Current log# 2 seq# mem# 0:/oracle/app/oracle/oradata/powerdes/redo02.log

Sun May 08 01:12:22 2016

Archived Log entry added for thread 1sequence ID 0xcf7feffa dest 1:

Arc0:standby Redo LogFile selected Forthread 1 sequence for destination log_archive_dest_2

Destination log_archive_dest_2 issynchronized

......

PS : The problem here is rather strange, I was here last time service_name it needs to be modified into a new parameter file. test_m2 To archive log transfers to the standby library Standby above, but this time it is necessary to keep the original service_name . It seems that there are other mysteries in this area. Need to be explored clearly.

oracle11.2.0.4 in Azure Cloud Dataguard Archive Log Transfer 1034 issue detailed resolution process