暂无图片
分享
惊蛰
2019-04-02
rman target / 登录不进去

rman登录不进去,但是sqlplus可以很快的登录

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

请提供错误信息,或者操作输出

暂无图片 评论
暂无图片 有用 0
盖国强

确认你没有密码大小写问题


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
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏