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

Source: Internet
Author: User
Tags reserved sqlplus

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.