ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-28009:connection as sys should be as sysdba问题

ORA-28009:connection as sys should be as sysdba问题

原创 Linux操作系统 作者:treesofthehill 时间:2012-03-07 19:39:51 0 删除 编辑
     今天用sqlplus登录oracle,发现用sys登录时出现ORA-28009:connection as sys should be as sysdba问题,而用system则正常登录。问题如下:
[oracle@treesofthehill ~]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 7 19:38:04 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Enter user-name: sys
Enter password:
ERROR:
ORA-28009:connection as sys should be as sysdba

Enter user-name: system
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
     
     从上可以看出password是对的。数据库要求必须以as sysdba登录,测试如下:
    在Enter password处输入xxxxx as sysdba(注xxxxx为密码)或as sysdba,则正常登录。如下
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 7 19:52:05 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Enter user-name: sys
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>
    

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9537053/viewspace-717992/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 关于oracle字符集
请登录后发表评论 登录
全部评论

注册时间:2008-06-11

  • 博文量
    97
  • 访问量
    179830