2019-04-03
ora-01017
rman target user/pass@tnsname报ora-01017的问题,而同样用sqlplus user/pass@tnsname连接没有问题,而rman target 不加tnsname连接也没问题
收藏
分享
2条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏
rman target user/pass@tnsname报ora-01017的问题,而同样用sqlplus user/pass@tnsname连接没有问题,而rman target 不加tnsname连接也没问题
参考以下步骤:
SYS@oamp> create user rman_test identified by rman;
User created.
SYS@oamp> grant create session to rman_test;
Grant succeeded.
SYS@oamp> grant connect to rman_test ;
Grant succeeded.
SYS@oamp> grant RECOVERY_CATALOG_OWNER to rman_test;
Grant succeeded.
SYS@oamp> grant sysdba to rman_test;
Grant succeeded.
SYS@oamp> select * from V$PWFILE_USERS;
USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE FALSE
RMAN_TEST TRUE FALSE FALSE
SYS@oamp> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
/home/oracle>
oracle@SV18050 [oamp] > rman target rman_test@oamp
Recovery Manager: Release 11.2.0.3.0 - Production on Wed May 28 09:27:00 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
target database Password:
connected to target database: OAMP (DBID=1348135612)
评论
有用 0
墨值悬赏