ORA-28009:connection as sys should be as sysdba
来源:互联网 发布:linux无法打开终端 编辑:程序博客网 时间:2024/04/29 18:16
今天,用iSQL*Plus 以sys用户连接数据库的时候报ORA-28009:connection as sys should be as sysdba or sysoper的错误,不知道是怎么回事,记得以前的时候连接的时候什么错误没报就过去了。有可能是用DBCA又建了一个新库,所以连接不上。从网上找了一下,原文如下:http://linli.blogbus.com/logs/13337529.html
要是不加后面的 as sysdba,则会出现ERROR:ORA-28009: connection to sys should be as sysdba or sysoper
例如,以sys为用户名,password为密码,sysdba为连接身份登录或连接到sql*plus,则输入用户名称:sys,口令:password,主机字符串:orcl as sysdba
这里没看到主机字符串 直接在口令那里输入:sys as sysdba ------到这里我连接上了
上面已经说的很清楚了,不过我还没想明白为什么我以sysoper用还有sys用户在sqlplus里也连不上呢?也是报错,而且提示信息还不一样,sysoper报的错误没有记下来。明天回学校试试。
转自:http://blog.163.com/yde1208@126/blog/static/95872709201111011719179/
- ORA-28009:connection as sys should be as sysdba
- ORA-28009:connection as sys should be as sysdba
- ORA-28009:connection as sys should be as sysdba
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER
- ORA-28009:Connection as SYS should be as sysdba or sysoper
- java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
- ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
- ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER
- ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER
- ORA-28009 Connection to SYS should be as sysdba or sysoper
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- 【ORACLE】用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- 2011级-csdn-java-张侃—Struts2了解
- Struts2课堂总结一
- DAPM之四:dapm机制深入分析(上)
- 算法 洗扑克牌(乱数排列)
- DAPM之五:dapm机制深入分析(下)
- ORA-28009:connection as sys should be as sysdba
- tomcat配置连接池错误解决
- Photoshop图层对齐怎么使用?
- SQLyog.Ultimate.v9.2.0.2.7 破解版
- 数据结构:二叉查找树
- 设置打开或保存文件对话框的文件类型
- 小布老师Oracle 9i DBA Fundamentals II 视频讲座 (1-62)
- JSON介绍
- Linux Glibc(学习笔记三)