ORA-03135: connection lost contact linux下,oracle启动差不多一两分钟,就失去连接,报ORA-03135: connection lost contact.我在SQLNET.ORA中加下这段SQLNET.EXPIRE_TIME =2也会失去连接。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1.网络不稳定2.ORACLE--bug有贴出来ALTER 日志看看 Sun Jul 31 18:16:18 2011Errors in file /u01/app/oracle/oracle/product/10.2.0/db_1/admin/orcl/bdump/orcl_pmon_4096.trc:ORA-00600: internal error code, arguments: [4194], [21], [6], [], [], [], [], []Sun Jul 31 18:16:18 2011PMON: terminating instance due to error 472Instance terminated by PMON, pid = 4096 上面的日志不要看,看这个日志Sun Jul 31 15:27:00 2011Errors in file /u01/app/oracle/oracle/product/10.2.0/db_1/admin/orcl/bdump/orcl_pmon_3851.trc:ORA-00600: internal error code, arguments: [4193], [280], [288], [], [], [], [], []Sun Jul 31 15:27:01 2011Errors in file /u01/app/oracle/oracle/product/10.2.0/db_1/admin/orcl/bdump/orcl_pmon_3851.trc:ORA-00600: internal error code, arguments: [4193], [280], [288], [], [], [], [], []PMON: terminating instance due to error 472Instance terminated by PMON, pid = 3851 Errors in file /u01/app/oracle/oracle/product/10.2.0/db_1/admin/orcl/bdump/orcl_pmon_3851.trc:ORA-00600: internal error code, arguments: [4193], [280], [288], [], [], [], [], []---------------这里2点,第一:ORA 600 [4193]的错误,第二:把你的TRACE文件orcl_pmon_3851.trc贴出来 Errors in file d:\u01\oracle\admin\nxdb\bdump\nxdb_qmn0_836.trc:ORA-00600: internal error code, arguments: [4193], [933], [936], [], [], [], [], []原因分析:查看:d:\u01\oracle\admin\nxdb\bdump\nxdb_qmn0_836.trcREDO RECORD - Thread:1 RBA: 0x00011c.00000b26.0010 LEN: 0x0048 VLD: 0x02SCN: 0x07ba.15347b7a SUBSCN: 1 06/24/2011 03:03:31CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ: 0 OP:23.1 Block Written - afn: 2 rdba: 0x00800059(2,89) scn: 0x07ba.1532f003 seq: 0x01 flg:0x04 Block Written - afn: 2 rdba: 0x00800162(2,354) scn: 0x07ba.152e0868 seq: 0x02 flg:0x04问题原因:UNDO里的数据存在不一致导致的,可以通过重建UNDO表空间来解决此问题.处理过程:SQL> create undo tablespace undotbs2 datafile 'D:\U01\ORACLE\ORADATA\NXDB\UNDOTBS02.DBF' size 1677721600;create undo tablespace undotbs2 datafile 'D:\U01\ORACLE\ORADATA\NXDB\UNDOTBS02.DBF' size 1677721600*ERROR 位于第 1 行:ORA-00604: 递归 SQL 层 1 出现错误ORA-00607: 当更改数据块时出现内部错误ORA-00600: 内部错误代码,参数: [4193], [933], [936], [], [], [], [], []SQL> create undo tablespace undotbs2 datafile 'D:\U01\ORACLE\ORADATA\NXDB\UNDOTBS02.DBF' size 200m;表空间已创建。SQL> alter system set undo_tablespace=undotbs2 scope=both;系统已更改。SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> startupORACLE 例程已经启动。Total System Global Area 1276192972 bytesFixed Size 456908 bytesVariable Size 738197504 bytesDatabase Buffers 536870912 bytesRedo Buffers 667648 bytes数据库装载完毕。数据库已经打开。SQL> show parameter undoNAME TYPE VALUE------------------------------------ ----------- ------------------------------undo_management string AUTOundo_retention integer 10800undo_suppress_errors boolean FALSEundo_tablespace string UNDOTBS2SQL> drop tablespace undotbs1 including contents and datafiles;表空间已丢弃。ok,到此问题处理完毕. 重新建UNDO表空间,问题就解决了,谢谢zftang。出现这种情况是否跟服务器被断电或者用shutdown abort有关呢? 在oracle 中联合做主键的问题??请大家帮帮忙,谢谢 包内的过程函数调用该包内的函数怎么调用啊 听牛人们讲,千万不要在生产库上做logminer,不是什么原因? 一个关于oracle表插入问题,望有兴趣的进来看看,谢谢了~~ 简单的左连接问题 Oracle 读取 xml视图 问一个简单的SQL语法问题,各位高手多多帮忙啊(20分) linux下安装oracle 8 ,安装界面为乱码 如何在Redhat Linux7.2下安装Oracle8i数据库? 求助查询语句 oracle登陆问题 这个SQL如何优化?
2.ORACLE--bug
有贴出来ALTER 日志看看
Errors in file /u01/app/oracle/oracle/product/10.2.0/db_1/admin/orcl/bdump/orcl_pmon_4096.trc:
ORA-00600: internal error code, arguments: [4194], [21], [6], [], [], [], [], []
Sun Jul 31 18:16:18 2011
PMON: terminating instance due to error 472
Instance terminated by PMON, pid = 4096
Sun Jul 31 15:27:00 2011
Errors in file /u01/app/oracle/oracle/product/10.2.0/db_1/admin/orcl/bdump/orcl_pmon_3851.trc:
ORA-00600: internal error code, arguments: [4193], [280], [288], [], [], [], [], []
Sun Jul 31 15:27:01 2011
Errors in file /u01/app/oracle/oracle/product/10.2.0/db_1/admin/orcl/bdump/orcl_pmon_3851.trc:
ORA-00600: internal error code, arguments: [4193], [280], [288], [], [], [], [], []
PMON: terminating instance due to error 472
Instance terminated by PMON, pid = 3851
ORA-00600: internal error code, arguments: [4193], [280], [288], [], [], [], [], []---------------这里2点,第一:ORA 600 [4193]的错误,第二:把你的TRACE文件orcl_pmon_3851.trc贴出来
ORA-00600: internal error code, arguments: [4193], [933], [936], [], [], [], [], []原因分析:
查看:d:\u01\oracle\admin\nxdb\bdump\nxdb_qmn0_836.trcREDO RECORD - Thread:1 RBA: 0x00011c.00000b26.0010 LEN: 0x0048 VLD: 0x02
SCN: 0x07ba.15347b7a SUBSCN: 1 06/24/2011 03:03:31
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ: 0 OP:23.1
Block Written - afn: 2 rdba: 0x00800059(2,89)
scn: 0x07ba.1532f003 seq: 0x01 flg:0x04
Block Written - afn: 2 rdba: 0x00800162(2,354)
scn: 0x07ba.152e0868 seq: 0x02 flg:0x04
问题原因:
UNDO里的数据存在不一致导致的,可以通过重建UNDO表空间来解决此问题.处理过程:
SQL> create undo tablespace undotbs2 datafile 'D:\U01\ORACLE\ORADATA\NXDB\UNDOTB
S02.DBF' size 1677721600;
create undo tablespace undotbs2 datafile 'D:\U01\ORACLE\ORADATA\NXDB\UNDOTBS02.D
BF' size 1677721600
*
ERROR 位于第 1 行:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-00607: 当更改数据块时出现内部错误
ORA-00600: 内部错误代码,参数: [4193], [933], [936], [], [], [], [], []SQL> create undo tablespace undotbs2 datafile 'D:\U01\ORACLE\ORADATA\NXDB\UNDOTB
S02.DBF' size 200m;表空间已创建。SQL> alter system set undo_tablespace=undotbs2 scope=both;系统已更改。SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。Total System Global Area 1276192972 bytes
Fixed Size 456908 bytes
Variable Size 738197504 bytes
Database Buffers 536870912 bytes
Redo Buffers 667648 bytes
数据库装载完毕。
数据库已经打开。
SQL> show parameter undoNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 10800
undo_suppress_errors boolean FALSE
undo_tablespace string UNDOTBS2
SQL> drop tablespace undotbs1 including contents and datafiles;表空间已丢弃。ok,到此问题处理完毕.
出现这种情况是否跟服务器被断电或者用shutdown abort有关呢?