Oracle Database Discussions

Hai all,

I have configured physical standby ..

Logs are getting generated at the ends and it was working fine.. and suddenly log generation was stopped and am gettin this error :

Error 12514 received logging on to the standby
Error 12514 connecting to destination LOG_ARCHIVE_DEST_2 standby host '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=orcldr.kil.com.)(PORT=1531)))(CONNECT_DATA=(SERVICE_NAME=DR1_STDBY_XPT)(INSTANCE_NAME=DR1)(SERVER=dedicated)))'
Error 12514 attaching to destination LOG_ARCHIVE_DEST_2 standby host '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=orcldr.kil.com)(PORT=1531)))(CONNECT_DATA=(SERVICE_NAME=DR1_STDBY_XPT)(INSTANCE_NAME=DR1)(SERVER=dedicated)))'
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
*** 2008-07-15 04:24:49.381 61283 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=orcldr.kil.com)(PORT=1531)))(CONNECT_DATA=(SERVICE_NAME=DR1_STDBY_XPT)(INSTANCE_NAME=DR1)(SERVER=dedicated)))'. Error is 12514.
*** 2008-07-15 04:24:49.381 59526 kcrr.c
kcrrfail: dest:2 err:12514 force:0 blast:1


I really wonder where this service DR1_STDBY_XPT is pointing to.. now where I have this service configured. log_archive_dest_2 points to a valid service :

in my ifile.ora ,

LOG_ARCHIVE_DEST_2='SERVICE=DR1_STDBY LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) REOPEN=15 NET_TIMEOUT=30 DB_UNIQUE_NAME=DR1_STDBY'


show parameter log_archive_dest_2

log_archive_dest_2 string service="(DESCRIPTION=(ADDRESS
_LIST=(ADDRESS=(PROTOCOL=tcp)(
HOST=orcldr.kil.com)(PORT=1
531)))(CONNECT_DATA=(SERVICE_N
AME=DR1_STDBY_XPT)(INSTANCE_NA
ME=DR1)(SERVER=dedicated)))",

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
LGWR ASYNC NOAFFIRM delay=0
OPTIONAL max_failure=0 max_co
nnections=1 reopen=15 db_uni
que_name="DR1_STDBY" register
net_timeout=30 valid_for=(onl
ine_logfile,primary_role)

I restarted the database to use that ifile contaiinin log_archive_dest_2.. but even then show parameter shows some other value for log_Archive_dest_2

Any ideas


Kai