Printable View
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!!
Check the alert.log file. It might give u some info on why its faling.
regards
anandkl
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. !!
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....
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
whats the listener got to do with starting a database?
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
did you ready what you wrote?
Therefore his database is not started, it is being opened - no listener being usedQuote:
My serious problem is that on my W2k server, I try to start my 8i DB,
whats difference between start database and open databse in ur prespective?
when you 'start' a database you mount it and then its opened.
A database is not 'started' unless it is fully open
davey23uk
i'm sorry dude. Then talking about Listener Log does not make sence. u r right.
My dears:
I am sure that your intend is to teach everyone of us about all on Oracle, and these posts really clear my about what did you want to say, but, my problem still exists, and I am not getting fix it.
My Instance is OK, my DB is MOUNTED, but, when process of OPEN is started, I get this error. Is possible for anyone of you had a lingt on the end of tunnel for me?? I am really nervous and your help will be very important. Alone I don´t get to fix, and I need your help.
I´ve read a lot of articles in this lasts hours, but nothing about my problem!!
Please, help a boy to come back to his 3 little boys, that are waiting him to play!! (Two of then are twins)!!
Hi Just mount the database
startup mount
Once its mounted recovere database
recover database;
During the process of recovery if everything goes fine then DB will open other wise you might get an error which might help in further diagonsis
regards
anandkl
if you are having trouble, raise a tar with support. If someone who knew this read it - they would answer
Hi.
Thanks by your post!!
During recover process, same message:
ORA-03113: end-of-file on communication channel
!!!!
Is there any tip??
I would thank you!!
Hm, did you read my post at the begining of this thread? have you search Metalink? Have you verified if your instance is performing crash recovery during startup? Have you run dbverify through your database files?Quote:
Originally posted by Adilsom Musskop
Is there any tip??
No? So why are you complaining and moaning? Do your part of the job first, then come back with the results, and only then start moaning again.
Some of your indexes are corrupt - that's very probably the culprit of your problems. And dropping the offending index tablespace will probably be the cure.
Be sure that my part I done!!
I did look for in all possible ways, but every article I read, didn´t mention my exactly problem. For this reason I tried to find a help in that forum, where, I supose, people came to find help, and other came to do help!!
I ask: Who haven´t faced a time, a situatuion that can´t undertand, and needed a help?? If I am here, it´s because I supose the intent of a forum is to interchange experiences. In this moment, I am needing a help; in other, I may help someone with things that I know. That is the life!!
I am not an expert, I am only trying to learn, and think that here is a good place to do this!!
I will repeat my problem, to see if someone has experienced this and know what to do: My DB can get to MOUNT, but not OPEN. I created another DB on this same server, and this works good. Maybe, like say Jmodic, a index tablespace is corrupted, but I dont know how can I drop a tablespace in a closed database!!
Please, a help will be very welcome!!
Thanks a lot!!
Do u understand english, if yes then do what ever Jurij has suggested ..
Ora-600 is a serious error. If you have a CSI, your best bet is to log a TAR with Oracle Worldwide Support. Also look these notes on metalink:
ORA-3113 - End-of-file on communication channel
[NOTE:1013680.102] NT: ORA-3113: WHEN STARTING A DATABASE [NOTE:1022429.6] ORA-3113 AT STARTUP AFTER ENABLING ARCHIVING [NOTE:131522.1] Instance Startup on NT with 8.1.X
which may help you diagnose the problem.
Thanks to all your goodwill!!
I will analyze all replies and try do fix my proble with then!!
Later, when OK, I will post what have I done!!!
See you later!!!