密碼檔案導致Data Guard同步錯誤:error 12514,Error 1033 - 2

tolywang發表於2015-11-09
***********************************************************************
Fatal NI connect error 12514, connecting to:
 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=szxcld002.hhw.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=em12cdg)(CID=(PROGRAM=oracle)(HOST=szxcld001)(USER=oracle))))


  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.4.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
  Time: 09-NOV-2015 13:40:55
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12564
***********************************************************************


TNS-12564: TNS:connection refused
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
Error 12514 received logging on to the standby
Suppressing further error logging of LOG_ARCHIVE_DEST_2.
Mon Nov 09 13:41:57 2015
Thread 1 cannot allocate new log, sequence 659
Private strand flush not complete
  Current log# 9 seq# 658 mem# 0: /data01/oradata/em12c/redo09a.log
  Current log# 9 seq# 658 mem# 1: /data02/oradata/em12c/redo09b.log
Thread 1 advanced to log sequence 659 (LGWR switch)
  Current log# 4 seq# 659 mem# 0: /data01/oradata/em12c/redo04a.log
  Current log# 4 seq# 659 mem# 1: /data02/oradata/em12c/redo04b.log
Mon Nov 09 13:42:00 2015
Archived Log entry 328 added for thread 1 sequence 658 ID 0x72887c16 dest 1:
Mon Nov 09 13:42:00 2015
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNS: Standby redo logfile selected for thread 1 sequence 659 for destination LOG_ARCHIVE_DEST_2

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-1826092/,如需轉載,請註明出處,否則將追究法律責任。

相關文章