暂无图片
分享
手机用户5330
2019-04-03
ora-01017

rman target user/pass@tnsname报ora-01017的问题,而同样用sqlplus user/pass@tnsname连接没有问题,而rman target 不加tnsname连接也没问题

收藏
分享
2条回答
默认
最新
盖国强

参考以下步骤:

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
章芋文
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏