| 【DG】搭建DG时报错：ORA | 您所在的位置：网站首页 › plsql报ora01017 › 【DG】搭建DG时报错：ORA |
【DG】搭建DG时报错：ORA
|
【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/[email protected]/TESTDG auxiliary sys/[email protected]/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/[email protected]/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/[email protected]/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环境下的详细报错信息如下： ORA-17627: ORA-01017: invalid username/password; logon denied ORA-17629: Cannot connect to the remote database server 千万不要以为是由于输入了错误的用户名和密码导致的，而是因为“没有输入用户名和密码”。且看我的分解。1.数据库版本信息SYS@PROD> select * from v$version;BANNER----------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionPL/SQL Release 11.2.0.1.0 - ProductionCORE 11.2.0.1.0 ProductionTNS for Linux: Version 11.2.0.1.0 - ProductionNLSRTL Version 11.2.0.1.0 - Production2.再现问题现象1）创建物理备库的RMAN脚本如下 注意此脚本本身不存在任何问题。duplicate target databasefor standbyfrom active databaseDORECOVERspfileset db_unique_name='SBDB'set log_archive_dest_1='location=/u01/app/oracle/arch/SBDB'set log_archive_dest_2='service=PROD async lgwr register valid_for=(online_logfile,primary_role) db_unique_name=PROD'set standby_file_management='AUTO'set fal_server='PROD'set fal_client='SBDB'set control_files='/u01/app/oracle/oradata/SBDB/control1.ctl','/u01/app/oracle/oradata/SBDB/control2.ctl'set db_file_name_convert='PROD','SBDB'set log_file_name_convert='PROD','SBDB'set memory_target='0'set sga_target='400M';2）确认当前ORACLE_SID内容PROD@secdb /home/oracle$ echo $ORACLE_SIDPROD3）连接到AUXILIARY辅助实例创建物理备库PROD@secdb /home/oracle$ rman target / auxiliary sys/oracle@sbdbRecovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 25 20:36:53 2012Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.connected to target database: PROD (DBID=193323522)connected to auxiliary database: PROD (not mounted)RMAN>RMAN> duplicate target database2> for standbyfrom active database3> 4> DORECOVER5> spfile6> set db_unique_name='SBDB'7> set log_archive_dest_1='location=/u01/app/oracle/arch/SBDB'8> set log_archive_dest_2='service=PROD async lgwr register valid_for=(online_logfile ,primary_role) db_unique_name=PROD'set standby_file_management='AUTO'9> 10> set fal_server='PROD'11> set fal_client='SBDB'set control_files='/u01/app/oracle/oradata/SBDB/control1.ctl','/u01/app/oracle/oradat a/SBDB/control2.ctl'12> 13> set db_file_name_convert='PROD','SBDB'14> set log_file_name_convert='PROD','SBDB'set memory_target='0'15> 16> set sga_target='400M';Starting Duplicate Db at 20120425 20:37:26using target database control file instead of recovery catalogallocated channel: ORA_AUX_DISK_1channel ORA_AUX_DISK_1: SID=135 device type=DISKcontents of Memory Script.:{ backup as copy reuse targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwPROD' auxiliary format'/u01/app/oracle/product/11.2.0/db_1/dbs/orapwSBDB' targetfile'/u01/app/oracle/product/11.2.0/db_1/dbs/spfilePROD.ora' auxiliary format'/u01/app/oracle/product/11.2.0/db_1/dbs/spfileSBDB.ora' ; sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/db_1/dbs/spfi leSBDB.ora''";}executing Memory ScriptStarting backup at 20120425 20:37:27allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=196 device type=DISKRMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/25/2012 20:37:28ORA-17629: Cannot connect to the remote database serverORA-17627: ORA-01017: invalid username/password; logon deniedORA-17629: Cannot connect to the remote database servercontinuing other job steps, job failed will not be re-runRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of Duplicate Db command at 04/25/2012 20:37:29RMAN-03015: error occurred in stored script. Memory ScriptRMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/25/2012 20:37:29ORA-17629: Cannot connect to the remote database serverORA-17627: ORA-01017: invalid username/password; logon deniedORA-17629: Cannot connect to the remote database serverRMAN> exitRecovery Manager complete.4）RMAN运行过程中报错信息内容RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/25/2012 20:37:28ORA-17629: Cannot connect to the remote database serverORA-17627: ORA-01017: invalid username/password; logon deniedORA-17629: Cannot connect to the remote database servercontinuing other job steps, job failed will not be re-run3.问题原因 报错信息的确够直白：“无效的用户名/密码，禁止登陆”。 这种报错，直接定格到登陆的那一瞬间，命令如下：PROD@secdb /home/oracle$ rman target / auxiliary sys/oracle@sbdb 正常理解的，这里貌似没有问题，前一部分“target /”表明使用操作系统认证的方式登录PROD数据库实例，后一半部分“auxiliary sys/oracle@sbdb”表明使用密码文件方式进行验证。并且，命令行提示信息上显示也已经成功登陆。因此这个报错信息很是诡异。 如果继续对比这两部分的登录方式，问题最有可能出现在前一部分，因为使用的是默认行为方式；另外后半部分是天衣无缝的。最终的原因的确出在这里，在使用Oracle的Active Database Duplicate功能创建物理DataGuard的过程中，连接target数据库必须“显式地指定密码”，即使是使用操作系统认证方式登录。4.问题处理 原因找到后，处理本身就是水到渠成的事情。 正确的连接方式如下：$ rman target sys/oracle@prod auxiliary sys/oracle@sbdb OK，到此问题便完美的处理完毕了，直接执行后续的RMAN命令即可。5.小结 这个问题处理过程告诉我们DBA一个道理，不要被表面现象所蒙蔽，有些提示信息是直白可信的，但是有些提示信息需要我们冷静的思考多种可能的原因，然后再一一尝试排查，必将有柳暗花明之日。
About Me ............................................................................................................................... ● 本文作者：小麦苗，只专注于数据库的技术，更注重技术的运用 ● 本文在itpub（http://blog.itpub.net/26736162）、博客园（http://www.cnblogs.com/lhrbest）和个人微信公众号（xiaomaimiaolhr）上有同步更新 ● 本文itpub地址：http://blog.itpub.net/26736162/abstract/1/ ● 本文博客园地址：http://www.cnblogs.com/lhrbest ● 本文pdf版及小麦苗云盘地址：http://blog.itpub.net/26736162/viewspace-1624453/ ● 数据库笔试面试题库及解答：http://blog.itpub.net/26736162/viewspace-2134706/ ● QQ群：230161599 微信群：私聊 ● 联系我请加QQ好友(646634621)，注明添加缘由 ● 于 2017-07-01 09:00 ~ 2017-07-31 22:00 在魔都完成 ● 文章内容来源于小麦苗的学习笔记，部分整理自网络，若有侵权或不当之处还请谅解 ● 版权所有，欢迎分享本文，转载请保留出处 ............................................................................................................................... 拿起手机使用微信客户端扫描下边的左边图片来关注小麦苗的微信公众号：xiaomaimiaolhr，扫描右边的二维码加入小麦苗的QQ群，学习最实用的数据库技术。
|
【本文地址】