| STANDBY ERR - ORA-16032 [message #353007] |
Fri, 10 October 2008 09:42  |
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  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
