密码文件导致Data Guard同步错误：error 12514，Error 1033 - 2

最新推荐文章于 2024-09-06 14:29:51 发布

转载最新推荐文章于 2024-09-06 14:29:51 发布 · 728 阅读

本文讨论了Oracle数据库连接错误12514的解决办法，涉及到TNS错误和归档日志问题。提供了从错误日志中获取关键信息的步骤，包括错误代码解释和相关日志文件分析。

***********************************************************************
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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-1826092/