ask8332357 发表于 2016-6-20 14:32:26

rman远程登陆异常

使用sqlplus登陆正常
D:\FTP>sqlplus users/password@192.168.0.133/orcl


SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 20 11:36:18 2016
Copyright (c) 1982, 2013, 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, Automatic Storage Management,
OLAP,
Data Mining and Real Application Testing options


SQL>


使用rman连接异常
D:\FTP>rman target users/password@192.168.0.133/orcl


Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jun 20 11:35:53 2016


Copyright (c) 1982, 2011, 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


目标数据库版本Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
本地数据库版本Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
本地操作系统windows server 2008
请问应该如何解决这个问题。

Liu Maclean(刘相兵 发表于 2016-6-20 14:36:05

明确给出
users/password

ask8332357 发表于 2016-6-20 14:40:31

C:\Users\sys-admin>sqlplus PVSIMTRUE/PVSIMTRUE98@192.168.0.133/orcl

SQL*Plus: Release 11.2.0.4.0 Production on 星期一 6月 20 14:37:55 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,
Data Mining and Real Application Testing options

SQL>

C:\Users\sys-admin>rman target PVSIMTRUE/PVSIMTRUE98@192.168.0.133/orcl

恢复管理器: Release 11.2.0.4.0 - Production on 星期一 6月 20 14:38:50 2016

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

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: 内部恢复管理器程序包初始化失败
RMAN-04005: 目标数据库中存在错误:
ORA-01017: invalid username/password; logon denied

C:\Users\sys-admin>

Liu Maclean(刘相兵 发表于 2016-6-20 14:42:46

SQL> create user PVSIMTRUE identified by oracle;

User created.

SQL> grant connect,resource to PVSIMTRUE;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ sqlplus  PVSIMTRUE/oracle@localhost:1521/DBDAO

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 20 14:42:11 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$
$
$
$ rman target PVSIMTRUE/oracle@localhost:1521/DBDAO

Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jun 20 14:42:22 2016

Copyright (c) 1982, 2011, 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


没权限不是很正常？

sidney_wu 发表于 2016-7-6 14:02:10

权限问题啊，给个DBA权限
页: [1]
查看完整版本: rman远程登陆异常