密码文件导致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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-1826090/，如需转载，请注明出处，否则将追究法律责任。

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