欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

ora-28009:connection as sys should be as sysdba or sysoper

程序员文章站 2022-05-07 16:43:35
...

1、在客户端用SQLPLUS以SYS登陆提示ora-28009:connection as sys should be as sysdba or sysoper 错误,但用system 可以登陆。
2、在客户端用 Enterprise manager console可以用SYS登陆;

 

前题条件是如果要使用PLSQL工具用sys用户登录的话,必须要选择SYSDBA,如下图:


ora-28009:connection as sys should be as sysdba or sysoper
            
    
    博客分类: Oracle orclplsqlsql plussyssysdba 
 

 

如果要使用SQL plus工具用sys用户登录的话,密码必须要加as sysdba,如下图:

ora-28009:connection as sys should be as sysdba or sysoper
            
    
    博客分类: Oracle orclplsqlsql plussyssysdba 
 

conn sys/password as sysdba

用SYS用户登陆必须加上AS SYSDBA

  • ora-28009:connection as sys should be as sysdba or sysoper
            
    
    博客分类: Oracle orclplsqlsql plussyssysdba 
  • 大小: 38 KB
  • ora-28009:connection as sys should be as sysdba or sysoper
            
    
    博客分类: Oracle orclplsqlsql plussyssysdba 
  • 大小: 8.3 KB