ORA-28009:connection as sys should be as sysdba问题
今天用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 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
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:
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9537053/viewspace-717992/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
关于oracle字符集
下一篇：
putty_连接linux的终端
请登录后发表评论
登录
全部评论
