合 搭建DG时报错RMAN-04006，ORA-17629，ORA-01017: invalid username/password; logon denied
Tags： Oracle故障处理ORA-01017ORA-17629RMAN-04006
👉 本文共约1118个字，系统预计阅读时间或需5分钟。
现象
今天网友也碰到了adg中搭建，ORA-01017: invalid username/password; logon denied的报错，小麦苗远程处理了一下，总结的几点原因：
- listener.ora 监听配置
- tnsnames.ora 配置问题
- 参数service_names的配置问题
密码问题必须显式地指定密码
若有类似的问题，可以从这几个方面去排查。
主库为rac，备库为rac，主备端版本为11.2.0.4.0：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | [ZFLHRDBDB1:oracle]:/oracle/app/oracle/product/11.2.0/db/dbs> rman target sys/lhr@TNS_DGPRI auxiliary sys/lhr@TNS_DGPHY Recovery Manager: Release 11.2.0.1.0 - Production on Thu Feb 18 11:30:10 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: TESTDG (DBID=2836886746) RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied C:\Users\hdzyat>rman target sys/lhr@22.188.194.31/TESTDG auxiliary sys/lhr@22.188.194.64/TESTDG Recovery Manager: Release 11.2.0.1.0 - Production on Thu Feb 18 11:30:10 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: TESTDG (DBID=2836886746) RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied C:\Users\hdzyat>sqlplus sys/lhr@22.188.194.64/TESTDG as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 18 11:30:37 2016 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options C:\Users\hdzyat>rman target sys/lhr@22.188.194.64/TESTDG Recovery Manager: Release 11.2.0.1.0 - Production on Thu Feb 18 12:47:27 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-04005: error from target database: ORA-01017: invalid username/password; logon denied |
【RMAN】使用RMAN的Duplicate功能创建物理DataGuard报错（ORA-17627、ORA-17629）处理
这是一个“貌似简单，实则不然”的报错排查处理过程。不要被表面现象所蒙蔽。
在使用RMAN的Active Database Duplicate创建物理DataGuard是抛出ORA-17627和ORA-17629错误，RMAN环境下的详细报错信息如下：
1 2 | ORA-17627: ORA-01017: invalid username/password; logon denied ORA-17629: Cannot connect to the remote database server |
千万不要以为是由于输入了错误的用户名和密码导致的，而是因为“没有输入用户名和密码”。且看我的分解。
1.数据库版本信息
1 2 3 4 5 6 7 8 9 | SYS@PROD> select * from v$version; BANNER ---------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for Linux: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production |
2.再现问题现象
1）创建物理备库的RMAN脚本如下
注意此脚本本身不存在任何问题。
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
