1、在用rman target和用sys用户登陆时出现错误:ORA-01031: insufficient privileges
C:\Documents and Settings\mengzhaoliang>rman target/
恢复管理器: Release 10.2.0.1.0 - Production on 星期四 11月 13 22:48:04 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: 内部恢复管理器程序包初始化失败
RMAN-04005: 目标数据库中存在错误:
ORA-01031: insufficient privileges
C:\Documents and Settings\mengzhaoliang>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 11月 13 22:48:26 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
请输入用户名:
但用mzl用户却可以登陆到数据库中:
C:\Documents and Settings\mengzhaoliang>sqlplus mzl/mzl@orcl
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 11月 13 22:51:59 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
2、怎么解决:
原来在$ORACLE_HOME\network\admin\sqlnet.ora被重命名了,改回“sqlnet.ora”文件即可。请看下面登陆正常!
C:\Documents and Settings\mengzhaoliang>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 11月 13 22:53:57 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开
C:\Documents and Settings\mengzhaoliang>rman target/
恢复管理器: Release 10.2.0.1.0 - Production on 星期四 11月 13 22:54:05 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到目标数据库: ORCL (DBID=1193443472)
RMAN>