DataGuard error with ORA-12514

Hi Experts,

I am trying to setup Oracle 10g dataguard on solaris 10 boxes. Here is the config file and tnsnames for primary and standby i have used.

primary database:
############
init.ora:

log_archive_config='DG_CONFIG=(XBRPRI,XBTSTD)'
log_archive_dest_1='LOCATION=/u04/app/oracle/oradata/XBR/archive VALID_FOR=(ALL_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=XBRPRI
'
log_archive_dest_2='SERVICE=to_stdby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=XBRSTD'
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable

standby_file_management=auto
standby_archive_dest='/u04/app/oracle/oradata/standby/archive'

fal_server=to_stdby
fal_client=to_xbr
log_archive_format=arch_%t_%s_%r.dbf


TNSNAMES.ORA:

[oracle@sun4 admin]$ cat tnsnames.ora
to_xbr =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.11.166)(PORT = 1521))
     )
    (CONNECT_DATA =
      (SERVICE_NAME = XBR)
    )
  )

#########################################################################

to_stdby =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.11.165)(PORT = 1521))
     )
    (CONNECT_DATA =
      (SERVICE_NAME = XBR)
    )
  )
#############################################################

on the standby database, here is the init.ora file (tnsnames.ora is exactly same as primary one as it has both the entries for primary and stadnby)

init.ora on standby:


log_archive_config='DG_CONFIG=(XBRPRI,XBTSTD)'
log_archive_dest_1='LOCATION=/u04/app/oracle/oradata/XBR/archive VALID_FOR=(ALL_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=XBRSTD'
log_archive_dest_2='SERVICE=to_xbr LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=XBRPRI'
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable

standby_file_management=auto
standby_archive_dest='/u04/app/oracle/oradata/standby/archive'

fal_server=to_xbr
fal_client=to_stdby
log_archive_format=arch_%t_%s_%r.dbf
##################################################


Now the production database is up and the standby databse is in manage recovery mode. But there is no transfer of the log files from primary to standby. When i checked the alert log file and trace log files, this is what i found out..

####################################################################
From alert log file:

Errors in file /u01/app/oracle/admin/XBR/bdump/xbr_arc1_15393.trc:
ORA-12514: Message 12514 not found; No message file for product=RDBMS, facility=ORA
FAL[server, ARC1]: Error 12514 creating remote archivelog file 'to_stdby'
FAL[server, ARC1]: FAL archive failed, see trace file.
Tue Feb 19 11:28:47 2008
Errors in file /u01/app/oracle/admin/XBR/bdump/xbr_arc1_15393.trc:
ORA-16055: Message 16055 not found; No message file for product=RDBMS, facility=ORA
ARCH: FAL archive failed. Archiver continuing
Tue Feb 19 11:28:47 2008
ORACLE Instance XBR - Archival Error. Archiver continuing.
Error 12514 received logging on to the standby
##################################################


looking at the trace file, here are the contents:

####################################################################
*** 2008-02-19 11:28:47.117 60679 kcrr.c
Error 12514 received logging on to the standby
Error 12514 connecting to destination LOG_ARCHIVE_DEST_1 standby host 'to_stdby'
kcrrwupirfs KCRROCIS Handle 0xffffffff7fffc660 has NULL OCI servicehandle - Returning success
Error 12514 attaching to destination LOG_ARCHIVE_DEST_1 standby host 'to_stdby'
ORA-12514: Message 12514 not found; No message file for product=RDBMS, facility=ORA
*** 2008-02-19 11:28:47.118 58941 kcrr.c
kcrrfail: dest:1 err:12514 force:0 blast:1
kcrrwupirfs KCRROCIS Handle 0xffffffff7fffc660 has NULL OCI servicehandle - Returning success
kcrrwkx: unknown error:12514
ORA-16055: Message 16055 not found; No message file for product=RDBMS, facility=ORA
ARCH: Connecting to console port...
ARCH: Connecting to console port...
kcrrwkx: work to do 0x2 (end)
Redo shipping client performing standby login
OCIServerAttach failed -1
.. Detailed OCI error val is 12514 and errmsg is 'ORA-12514: Message 12514 not found; No message file for product=RDBMS, faci
lity=ORA
##########################################################


When i do a tnsping to the standby database it results ok. But when i try to connect to the standby database from the prmary database, i get the following error:


###################################

[oracle@sun4 bdump]$ sqlplus 'system/**********@to_stdby' as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 19 12:43:42 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


#############################


Can someone please explain where i am going wrong?

thanks a lot
Start Free Trial