密碼檔案導致Data Guard同步錯誤:error 12514,Error 1033 - 1
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.
按照建立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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ADG無法同步:TT00程式報錯 Error 12514Error
- MySQL error 錯 誤 碼MySqlError
- PostgreSQL error 錯誤碼SQLError
- 【Jenkins】data stream error|Error cloning remote repo ‘origin‘ 錯誤解決JenkinsErrorREM
- python匯入資料錯誤:ParserError: Error tokenizing data. C error: Expected 1 fields in line 3, saw 2PythonError
- Error page: / Error infos: DedeCms錯誤警告Error
- Angular 錯誤訊息:ERROR Error NullInjectorError No provider for XXAngularErrorNullIDE
- 【ERROR】Oracle列印錯誤程式碼解釋ErrorOracle
- kernel_data_inpage_error藍屏錯誤怎麼修復Error
- Error Curves——錯誤曲線Error
- Js錯誤Error物件詳解JSError物件
- Fatal NI connect error 12170 錯誤Error
- 15-錯誤處理(Error)Error
- dedecms 搬家 / dedecms error warning!錯誤Error
- kernel_data_inpage_error藍色畫面錯誤怎麼修復Error
- Angular 依賴注入錯誤訊息:ERROR Error NullInjectorError No provider for XXAngular依賴注入ErrorNullIDE
- 錯誤解決:cc: Internal error: Killed (program cc1)Error
- Listener refused the connection with the following error:ORA-12514, TNS:listenerError
- android 打包出現錯誤Error: ResourceNameAndroidError
- PHP curl error 60 錯誤解決PHPError
- HTTP 錯誤 500.19- Internal Server Error 錯誤解決方法HTTPServerError
- 執行SQL發生錯誤!錯誤:disk I/O errorSQLError
- DATA GUARD主庫丟失資料檔案的恢復(1)
- ERROR 1045 (28000): ProxySQL Error: 報錯ErrorSQL
- mysql 索引長度 767 錯誤 ERROR 1071MySql索引Error
- 【ERROR】ORA-8103錯誤分析處理Error
- Http failure response 0 Unknown error 錯誤分析HTTPAIError
- SAP Java Connector 錯誤 - JCO_ERROR_COMMUNICATIONJavaError
- golang原始碼安裝時fatal error: MSpanList_Insert錯誤Golang原始碼Error
- mysql匯入sql檔案報錯 ERROR 2013 2006 2002MySqlError
- Python錯誤:PyCharm 安裝出錯 Internal error,please。。。PythonPyCharmError
- 更改密碼時出現ERROR 1054密碼Error
- load data infile ERROR 1045 (28000)Error
- 執行遷移檔案報錯: Syntax error or access violation: 1166 ...Error
- Mysql連線錯誤ERROR 2003 (HY000)MySqlError
- QT中error: xxx does not name a type xxx錯誤QTError
- HTTP 錯誤 500.21 - Internal Server Error 解決方案HTTPServerError
- 2、MySQL錯誤日誌(Error Log)詳解MySqlError
- 解決 eslint 的 Parsing error: Unexpected token 錯誤EsLintError