密碼檔案導致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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 密碼檔案導致Data Guard同步錯誤:error 12514,Error 1033 - 2密碼Error
- Android專案檔案編碼 導致的ErrorAndroidError
- EBS 克隆,密碼大小寫敏感導致白屏或報錯 HTTP error 500 Internal server error密碼HTTPErrorServer
- MySQL error 錯 誤 碼MySqlError
- PostgreSQL error 錯誤碼SQLError
- adautocfg.sh錯誤OAUTH marshaling failure導致IE HTTP error 500 Internal errorOAuthAIHTTPError
- ORA-16191 錯誤導致無法連線DATA GUARD環境
- ADG無法同步:TT00程式報錯 Error 12514Error
- sys密碼修改導致的RMAN-00571錯誤密碼
- 指令碼錯誤量極致優化-監控上報與Script error指令碼優化Error
- 指令碼錯誤量極致優化 - 監控上報與 Script error指令碼優化Error
- python匯入資料錯誤:ParserError: Error tokenizing data. C error: Expected 1 fields in line 3, saw 2PythonError
- 【ERROR】Oracle列印錯誤程式碼解釋ErrorOracle
- mysql錯誤: [ERROR] InnoDB: auto-extending data file /data/ibdata1 is of a different size 768 pages...MySqlError
- kernel_data_inpage_error藍屏錯誤怎麼修復Error
- Error Curves——錯誤曲線Error
- [Modules/zlibmodule.o] Error 1錯誤解決IBMError
- Angular 錯誤訊息:ERROR Error NullInjectorError No provider for XXAngularErrorNullIDE
- 15-錯誤處理(Error)Error
- Js錯誤Error物件詳解JSError物件
- Datastore error in 'dirbdb'錯誤解決ASTError
- 錯誤解決:cc: Internal error: Killed (program cc1)Error
- kernel_data_inpage_error藍色畫面錯誤怎麼修復Error
- 【DataGuard】錯誤的log_file_name_convert引數導致物理Data Guard配置故障分析與處理
- Data Guard無法同步報ORA-16047錯
- PHP curl error 60 錯誤解決PHPError
- MySQL ERROR 1698 (28000) 錯誤MySqlError
- HTTP 錯誤 500.19 - Internal Server ErrorHTTPServerError
- MYSQL-Operating System Error Codes(錯誤程式碼)MySqlError
- DATA GUARD手工管理資料檔案
- Angular 依賴注入錯誤訊息:ERROR Error NullInjectorError No provider for XXAngular依賴注入ErrorNullIDE
- 【LISTENER】修改監聽密碼導致NL-00051錯誤的分析與總結密碼
- [Android] Eclipse錯誤:Conversion to Dalvik format failed with error 1AndroidEclipseORMAIError
- 如何修復 Ubuntu 上“…script returned error exit status 1”的錯誤UbuntuError
- DATA GUARD主庫丟失資料檔案的恢復(1)
- Fatal NI connect error 12170 錯誤Error
- android 打包出現錯誤Error: ResourceNameAndroidError
- 使用error stack診斷特定錯誤資訊Error