DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: ORA-03113: end-of-file on communication channel

  1. #11
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    ora-1331

    Hi

    This problem looks very unique. I think you might need the help from oracle. before that please give me following informations.

    1. Your operatin syste, with versions
    2. oracle database version.
    3. The value of PROCESS from the init parameter file
    4. the value of SEMMSL and SEMMNS from the /etc/system file if the OS is unix
    5. permissions of $ORACLE_HOME/bin if the OS is Unix

    Please post with this values,


    Reagrds


    Thomas P S
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  2. #12
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    most probably it's data dictionary corruption

    what it means is there is no FILE$ or V$DATAFILE entry for the tablespace number/relative file number oracle is beging asked to flush. In this case it's ts# 3

    do
    select * from ts$ where ts#=3
    select * from file$ where ts#=3
    select * from v$datafile where ts#=3
    select * from file$ where relfile#=3
    select * from v$datafile where rfile#=3

    Most probably is you would have to recover the database to a state prior to the corruption with point in time recovery.

    However verify this with suppor first

    Since you cannot startup the database, I would probably mount it, query v$datafile, offline tablespace 3 and try to open it

    [Edited by pando on 10-12-2002 at 11:04 AM]

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