![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
文章平均质量分 53
HXL122LCQ
外向,自学能力强,勤劳勇敢,敢于挑战,积极奋进!
展开
-
Io 异常: The Network Adapter could not establish the connection
Io 异常: The Network Adapter could not establish the connection这个异常的出现一般与数据库和你的PC的设置有关这种异常的出现大致上有下面几种:1。IP错误。在设置URL时错误,例如:jdbc:oracle:thin:@192.168.0.36:1521:sharp数据库服务器不正确:ping 服务器IP是否正确。不正转载 2012-05-07 08:18:47 · 492 阅读 · 0 评论 -
Io 异常: Got minus one from a read call
java.sql.SQLException: Io 异常: Got minus one from a read call at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(Dat转载 2012-05-07 08:30:22 · 1787 阅读 · 0 评论 -
“connection as SYS should be as SYSDBA or SYSOPER”解决办法
在jsp连接oracle的时候,提示“java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER”,下图: 如果是PL/SQL的话直接sys/rebeyond as sysdba就可以了。 其实在java的连接字符串里,只要把String user="sys"改成S转载 2012-05-07 15:17:11 · 2869 阅读 · 0 评论 -
解决‘ORA-12505, TNS:listener does not currently know of SID given in connect descriptor’
完整的错误信息如下: java.sql.SQLException: Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptorThe Connection de转载 2012-05-07 14:54:34 · 37027 阅读 · 4 评论 -
对Oracle 11用户进行解锁
运行——>cmd——>进入dos——>sqlplus /nolog——>connect / as sysdba——>alter user username account unlock 如(alter user scott account unlock)——>alteruser user_name identifiedby new_password account unlock (修改转载 2012-05-10 00:13:11 · 487 阅读 · 0 评论 -
解决ORA-01034: ORACLE not available和ORA-27101: shared memory realm does not exist
今天登陆oracle 11g时,报出ORA-01034: ORACLE not available和ORA-27101: shared memory realm does not exist的错误,经过我上完查阅资料,我进行修改。最后成功了。一下是我的秀该过程。我先到控制面板——>管理工具——>服务中打开oracle是所用服务。然后用用户名和密码登陆在PL/SQL图形化工具中登录oracl原创 2012-05-13 06:30:42 · 2628 阅读 · 0 评论