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

tolywang發表於2015-11-09
Linux 6.5 , Oracle 11.2.0.4 

按照建立Data Guard的文件建立資料庫standby後,發現同步總是報錯, 如下是主庫的alert log ,  透過主庫上設定的tnsnames.ora中的備庫別名,發現連線沒有問題,
sqlplus /nolog
conn   sys/xxxxx@em12cdg  as  sysdba 
....

同樣驗證了主庫備庫中的sys密碼一樣。 但是備庫中的 orapwSID 密碼檔案是透過orapwd命令生成的(不是從主庫複製過來的),雖然密碼相同,但是奇怪的是,大小不一樣,
一個1536 Bytes (主庫), 一個2048 Bytes(備庫), 懷疑是不是密碼檔案的問題, 關閉備庫後重新複製主庫上的orapwem12c 到備庫, 開啟備庫到managed standby狀態,結
果可以正常同步了。 


主庫報錯資訊如下: 
***********************************************************************
Fatal NI connect error 12514, connecting to:
 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=szxcld002.hhw.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=em12c)(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:19:25
  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
PING[ARC2]: Heartbeat failed to connect to standby 'em12cdg'. Error is 12514.
Mon Nov 09 13:20:27 2015
Error 1033 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'em12cdg'. Error is 1033.
Mon Nov 09 13:21:22 2015
Thread 1 cannot allocate new log, sequence 658
Private strand flush not complete
  Current log# 8 seq# 657 mem# 0: /data01/oradata/em12c/redo08a.log
  Current log# 8 seq# 657 mem# 1: /data02/oradata/em12c/redo08b.log
Thread 1 advanced to log sequence 658 (LGWR switch)
  Current log# 9 seq# 658 mem# 0: /data01/oradata/em12c/redo09a.log
  Current log# 9 seq# 658 mem# 1: /data02/oradata/em12c/redo09b.log
Mon Nov 09 13:21:23 2015
Archived Log entry 318 added for thread 1 sequence 657 ID 0x72887c16 dest 1:
Mon Nov 09 13:21:25 2015
Error 1033 received logging on to the standby
FAL[server, ARC3]: Error 1033 creating remote archivelog file 'em12cdg'
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance em12c - Archival Error. Archiver continuing.
Mon Nov 09 13:26:30 2015
Error 1033 received logging on to the standby
Suppressing further error logging of LOG_ARCHIVE_DEST_2.

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

相關文章