我用jdbc 程序 访问oracle 但程序开了一会,就报
ORA-01034: ORACLE not availableORA-27101: shared memory realm does not exist错误
用sqlplsu " / as sysdba "进去startup 重启后,过会又出现这问题oracle 9iR2 win2003
我插入数据到表中,表设置了主键,因为插入的数据库与表中有好多重复,所以报ORA-00001: 违反唯一约束条件 (KAILIAO.SITES_INFO_HOSTNAME) 错频率很高还有就是用了金山杀毒软件杀了下毒到底是报错频率太高了还是金山杀毒 引起oralce 报上面的错
有没有人遇到类似的问题
ORA-01034: ORACLE not availableORA-27101: shared memory realm does not exist错误
用sqlplsu " / as sysdba "进去startup 重启后,过会又出现这问题oracle 9iR2 win2003
我插入数据到表中,表设置了主键,因为插入的数据库与表中有好多重复,所以报ORA-00001: 违反唯一约束条件 (KAILIAO.SITES_INFO_HOSTNAME) 错频率很高还有就是用了金山杀毒软件杀了下毒到底是报错频率太高了还是金山杀毒 引起oralce 报上面的错
有没有人遇到类似的问题
SQL> startup
ORACLE 例程已经启动。Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
数据库装载完毕。
ORA-03113: 通信通道的文件结束又出现这个错了
Tue Feb 02 17:08:45 2010
Rolling back half complete log switch of thread 1
Tue Feb 02 17:08:47 2010
Errors in file e:\oracle\admin\kailiao\bdump\kailiao_lgwr_31560.trc:
ORA-00202: controlfile: 'E:\ORACLE\ORADATA2\KAILIAO\CONTROL01.CTL'
ORA-27091: skgfqio: unable to queue I/O
ORA-27070: skgfdisp: async read/write failed
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 23) 数据错误(循环冗余检查)。Tue Feb 02 17:08:48 2010
Errors in file e:\oracle\admin\kailiao\bdump\kailiao_lgwr_31560.trc:
ORA-00204: error in reading (block 191, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:\ORACLE\ORADATA2\KAILIAO\CONTROL01.CTL'
ORA-27091: skgfqio: unable to queue I/O
ORA-27070: skgfdisp: async read/write failed
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 23) 数据错误(循环冗余检查)。LGWR: terminating instance due to error 204
Instance terminated by LGWR, pid = 31560文件坏了,请问要怎么修复
http://www.eygle.com/faq/How.To.Backup.and.Recreate.Controlfile.htm
Rolling back half complete log switch of thread 1 数据库之前有异常关机?ORA-00202: control file: 'string'
Cause: This message reports the name file involved in other messages.
Action: See associated error messages for a description of the problem.控制文件有问题,如果有备份的话,可以先尝试用备份来恢复一下看看。 如果重建控制文件的话,丢失的数据比较多。------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716