急问高手!!!!!!

clytcn

系统内存有多大
oracle可是分配了1G啊

duskyblue

把sqlnet .ora中的NＴＳ一项注释掉　　　　　　　　　

swz_19981018

我觉得如果数据库的实例启动了，而且数据库也装载成功了的话，那么就不用怀疑初始化文件和控制文件有问题了，我感觉是数据库的net8配置的问题，你可以检查一下......

greencup

也是吧，检查一下listener.ora和tnsnames.ora文件看看

Handynew

ORA-03113: end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.

Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.

lxd_sh

看一下这篇文章
http://www.puschitz.com/OracleOnLinux.shtml

其中有关于ORA-03113: end-of-file on communication channel

的解决方法

rollingpig

try

startup nomount pfile=……

alter database mount

alter database open


may see more err msg

zhalee

上次也有人问我，我跟他说可能是关于NET8的问题，后来他自己就解决了，我问他是怎么解决的，他说杀过毒就数据库就能启动了。具体这个问题我也没碰到，上面的方法你做下参考吧!