最近在用sqlplus连接数据库的时候遇到一个问题:
用非oracle用户可以连db:
[root@test ~]# sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 20 05:44:00 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
用这种方式也可以连:
[oracle@test admin]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 20 05:42:01 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn testdb
Enter password:
ERROR:
ORA-01005: null password given; logon denied
SQL> conn testdb as sysdba
Enter password:(在这里随便输入什么都可以连进去,奇怪)->这是通过本地验证的方法连的,不用密码。
Connected.
SQL>
但是用下面的方式却连不进去:
[oracle@test admin]$ sqlplus as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 20 05:45:34 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
不知道是什么原因会出现以上的问题,查了很久,总是得不到其解
![](http://www.cublog.cn/images/face/012.gif)
阅读(1106) | 评论(0) | 转发(0) |