Home » Server Options » Data Guard » STANDBY ERR - ORA-16032 (Oracle 10g,10.2.0.1.0, RHEL 4)
STANDBY ERR - ORA-16032 [message #353007] Fri, 10 October 2008 09:42 Go to next message
amandhanjal
Messages: 1
Registered: October 2008
Junior Member

I am configuring the standby database first time, but i am getting the errors in alert log. Below is all the relevant info, in case you need any more info, kindly let me know.
Kindly suggest how to come out of it ?

Error message on production database in alert log:-

ORA-16032: parameter destination string cannot be translated
PING[ARC1]: Heartbeat failed to connect to standby 'point_p'. Error is 16032
-------------------------------------
point_p is fal_server in prod database

Able to connect to standby database using following command:
$sqlplus sys@point_p as sysdba
---------------------------------------
----------------------------------------
Following parameters set in Production Database:-

#DATAGUARD PARAMETERS
fal_server = point_p
fal_client = point_s
standby_file_management = auto
standby_archive_dest = '/disk1/ordata/aman/arch'
log_archive_dest_1 = 'LOCATION=/disk1/oradata/aman/arch'
log_archive_dest_2 = 'service=point_p lgwr sync affirm reopen=10'

------------------------------------------------------------------------------------------
New password file created on both databases

In standby database:-

oldest online log seq - 109
current log seq - 110

Error in alert log in standby database:-
ORA-16032: parameter destination string cannot be translated
PING[ARC1]: Heartbeat failed to connect to standby 'point_s'. Error is 16032
-------------------------

able to connect to production database using following command:-
$sqlplus sys@point_s as sysdba
--------------------------------
Following parameters set in standby:-

#DATAGUARD PARAMETERS
fal_server = point_s
fal_client = point_p
standby_file_management = auto
standby_archive_dest = '/disk1/ordata/aman/arch'
log_archive_dest_1 = 'LOCATION=/disk1/oradata/aman/arch'
log_archive_dest_2 = 'service=point_s lgwr sync affirm reopen=10'


-----------------------------------------

[Updated on: Fri, 10 October 2008 09:44]

Report message to a moderator

Re: STANDBY ERR - ORA-16032 [message #358964 is a reply to message #353007] Thu, 13 November 2008 01:26 Go to previous messageGo to next message
Khurram Siddiqui
Messages: 5
Registered: March 2004
Junior Member
it seems to me that yours tnsnames string 'point_p' is not pointing to valid destination ,check yours tnsnames.ora entry as well either there is fire well enabled at destiantion which is restricting to you connect that destination.

check yours destination is in mount state during shipping the reod.

Khurram
Re: STANDBY ERR - ORA-16032 [message #359743 is a reply to message #358964] Tue, 18 November 2008 02:08 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
How are the initialization parameter log_file_name_convert, log_archive_config, db_file_name_convert, db_unique_name, dispatcher (in physical standby)?
Re: STANDBY ERR - ORA-16032 [message #365063 is a reply to message #353007] Wed, 10 December 2008 16:23 Go to previous message
sonumalhi
Messages: 62
Registered: April 2008
Member
Is the sys password for both primary and standby same?
Previous Topic: Data guard availability
Next Topic: parameter not modifiable
Goto Forum:
  


Current Time: Thu Mar 28 16:27:09 CDT 2024