Ora-03113 Error

[Adilsom Musskop]

Hi, all!

My serious problem is that on my W2k server, I try to start my 8i DB, but I´m getting a ORA-03113 error "end-of-File on communication channel" after BD is mounted. When it tries to Open, I get this error.
Can someone help me??
On my SQLNET.ORA file, I´ve tried to change SQLNET.AUTHENTICATION_SERVICES, FROM "(NTS)" TO "NONE", but it doesn´t work!!
Please

Really thanks!!

[anandkl]

Check the alert.log file. It might give u some info on why its faling.

regards
anandkl

[Adilsom Musskop]

For Test, I´ve created another BD on same server, and it starts OK!
On my udump directory, i´ve found this message: "ksedmp: internal or fatal error
ORA-00600: codigo de erro interno, argumentos: [711], [1], [1015398872], [U¤ÿ€”], [], [], [], []
Current SQL statement for this session:
/* OracleOEM */ ALTER DATABASE OPEN " and nothing else!

Please, help, I´m loosing a lot of hair trying to fix it. !!

[jmodic]

Found couple of simmilar bug reports on metalink (ORA-600 [711][...]) on open database operation, most of them on the older releases, though. But they are all related to corrupted index tablespaces. here are two example bug numbers from metalink: 856652, 1341922.

Is your database trying to perform instance recovery during ALTER DATABASE OPEN? Ie, do you see any messages "Beginning crash recovery.." in your alert file after "alter database open"?

If so, you might want to run dbverify over your database datafiles to see if any of them is corrupted. The hits from metalink make me belive that you'll find some of the files that hold database indexes to be corrupted....

[ljayanth]

Adilsom Musskop

Its an ora-00600 error its better consult oracle support. sent then the trace file.

and if ut listener is in log mode.....sent it aslo to them they can help you better on this.

jayanth

[davey23uk]

whats the listener got to do with starting a database?

[ljayanth]

the database is started but he said
"My serious problem is that on my W2k server, I try to start my 8i DB, but I´m getting a ORA-03113 error "end-of-File on communication channel" after BD is mounted."

thats why i asked to send listener log

[davey23uk]

did you ready what you wrote?

My serious problem is that on my W2k server, I try to start my 8i DB,

Therefore his database is not started, it is being opened - no listener being used

[ljayanth]

whats difference between start database and open databse in ur prespective?

[davey23uk]

when you 'start' a database you mount it and then its opened.

A database is not 'started' unless it is fully open