【DG】搭建DG时报错:ORA-01017、ORA-17627、ORA-17629 invalid username/password

在创建Oracle物理DataGuard时遇到ORA-01017错误,提示用户名/密码无效。可能的原因包括监听配置、tnsnames.ora、service_names参数配置、密码问题等。通过检查和调整这些方面,可以解决登录失败的问题。示例中展示了RMAN命令行的报错情况,进一步帮助排查。
摘要由CSDN通过智能技术生成

【DG】搭建DG时,报错:ORA-01017: invalid username/password; logon denied






今天网友也碰到了adg中搭建,ORA-01017: invalid username/password; logon denied的报错,小麦苗远程处理了一下,总结:

  • listener.ora  监听配置
  • tnsnames.ora  配置问题
  • 参数service_names的配置问题
  • 密码问题
  • 必须显式地指定密码

 
  若有类似的问题,可以从这几个方面去排查。





主库为rac,备库为rac,主备端版本为11.2.0.4.0


[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: ======================================================&

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值