ORA-28009:connection as sys should be as sysdba
来源:互联网 发布:2016网络热词 编辑:程序博客网 时间:2024/04/29 10:33
博客11:港湾 海平线上的那道彩虹
blog.163.com/yde1208@126/blog/static/95872709201111011719179/
今天,用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报的错误没有记下来。明天回学校试试。
- 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解决方法
- 【Kettle从零开始】第九弹之Kettle定时任务介绍
- iOS学习方法
- 如何恢复电脑中毒文件
- 棋牌游戏——传递民族精神的桥梁
- zedboard学习资料收集
- ORA-28009:connection as sys should be as sysdba
- 矩阵十大经典题目之三-POJ-3233-Matrix Power Series-两次二分
- VMware vSphere 简介
- week 3
- java发送http的get、post请求
- matlab之nargin函数
- MATLAB中几个比较有用的程序
- 漫谈高数之特征向量物理意义
- 如何用MATLAB为图片加噪声