Ora-03113 Error
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 20

Thread: Ora-03113 Error

  1. #1
    Join Date
    Jan 2003
    Location
    Caçador (SC) - Brazil
    Posts
    56

    Ora-03113 Error

    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!!
    Adilsom José Musskopf
    Live like each of your days was the last.

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Check the alert.log file. It might give u some info on why its faling.

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Jan 2003
    Location
    Caçador (SC) - Brazil
    Posts
    56
    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. !!
    Adilsom José Musskopf
    Live like each of your days was the last.

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Feb 2003
    Posts
    17
    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

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    whats the listener got to do with starting a database?

  7. #7
    Join Date
    Feb 2003
    Posts
    17
    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

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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

  9. #9
    Join Date
    Feb 2003
    Posts
    17
    whats difference between start database and open databse in ur prespective?

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    when you 'start' a database you mount it and then its opened.

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width