rman使用字符串连接报用户名密码错误，但真没错！

ZALBB

rman target system/xxx@ORCL as sysdba

manzl

ZALBB 发表于 2017-5-21 09:34
rman target system/xxx@ORCL as sysdba

不行啊

TaihangMeng

RMAN 远程连接，需要用户具有SYSDBA权限。我测试是这样的~

ZALBB

select * from v$pwfile_users; 看看有无 system 用户，没有的话，加进去，

$rman target system/2

Recovery Manager: Release 11.2.0.3.0 - Production on Mon May 22 21:49:09 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1325328971)

RMAN> exit


Recovery Manager complete.
[oracle@rac11 ~]
$rman target system/4

Recovery Manager: Release 11.2.0.3.0 - Production on Mon May 22 21:49:14 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1325328971)

RMAN> exit


Recovery Manager complete.
[oracle@rac11 ~]
$rman target system/5

Recovery Manager: Release 11.2.0.3.0 - Production on Mon May 22 21:49:19 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1325328971)

RMAN>


上面几个看似用 SYSTEM，其实是 SYS 身份登陆， 本机认证，不用密码，

manzl

ZALBB 发表于 2017-5-22 21:51
select * from v$pwfile_users; 看看有无 system 用户，没有的话，加进去，

$rman target system/2

是的，即使密码错了rman也能登录，但是使用远程@依旧报密码错误
[oracle@oracle1 ~]$ rman

Recovery Manager: Release 11.2.0.4.0 - Production on Tue May 23 09:50:57 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect  target bill/22222222222

connected to target database: cmdb (DBID=1119948960)

RMAN> exit


Recovery Manager complete.
[oracle@oracle1 ~]$ rman

Recovery Manager: Release 11.2.0.4.0 - Production on Tue May 23 09:51:08 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect  target bill/33333333333333

connected to target database: cmdb (DBID=1119948960)

RMAN> exit


Recovery Manager complete.
[oracle@oracle1 ~]$ rman

Recovery Manager: Release 11.2.0.4.0 - Production on Tue May 23 09:51:20 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect  target bill/33333333333333@cmdb

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01017: invalid username/password; logon denied

RMAN> exit


Recovery Manager complete.
[oracle@oracle1 ~]$

lq2003

我也遇到这个问题了！
有几次是重新修改密码为不要特殊字符 就可以了。不知道是什么鬼！

cqiwen

通过rman登录远程数据库，要么使用远程数据库的sys用户，要么先将远程数据库注册到catalog，授予recovery_catalog_owner权限，然后其它机器远程连接catalog方式登录。
可以查看论坛中之前的帖子：http://www.itpub.net/forum.php?m ... n%2B%2B%B5%C7%C2%BC

另外还有种方法：

服务器A：grant sysdba to test;
服务器B：rman target 'test/test@ora10g'