This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Jan 1, 2013 2:02 AM by Madhu.149 Go to original post RSS
  • 15. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Rob_J Journeyer
    Currently Being Moderated
    Not much else I can suggest really. If you are 100% sure that the files you are using are correct but the alert log is telling you that the processes parameter is set to 6 that means it's reading a different file to start the database.

    I'd recommend double checking everything because something is not right. It'll be something simple. Are you doing the work directly from the server and not your desktop machine?
  • 16. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    John Spencer Oracle ACE
    Currently Being Moderated
    According to the excerpt from the alert log you posted, your startup at Fri Dec 28 14:06:59 2012 is
    Using parameter settings in server-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\INITXE.ORA
    as is the second startup you show at Fri Dec 28 14:09:24 2012.

    These two appear to correspond with the startups you did immediately before posting. The time stamps from the alert log in your original post are Fri Dec 28 14:09:24 2012 and it appears that it was your second attempt to startup the database.

    Can you post the contents of the alert log from the time of your attempts to startup with pfile='D:\pfile.ora' at Fri Dec 28 15:09:14 2012 and Fri Dec 28 15:17:42 2012.

    John
  • 17. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Madhu.149 Newbie
    Currently Being Moderated
    The problem is now resolved.

    I had a backup of spfile. I copied to spfile destination by replacing the earlier one.
    After system restart, I issued startup command.
    Its working fine.

    But I dont know, why the problem resolved only after system restart?
  • 18. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    imran khan Journeyer
    Currently Being Moderated
    can you post :

    SQL> show parameter spfile


    If you can undo the copy and then try to restart the instance in nomount state and post the result of above command then we can re-look to it and rectify the issue.

    Also post the result of the following as well:

    SQL> show parameter process

    Regards,
    imran Khan
  • 19. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Madhu.149 Newbie
    Currently Being Moderated
    SQL> show parameter spfile
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    spfile                               string      C:\ORACLEXE\APP\ORACLE\PRODUCT
                                                     \11.2.0\SERVER\DBS\SPFILEXE.OR
                                                     A
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    aq_tm_processes                      integer     0
    cell_offload_processing              boolean     TRUE
    db_writer_processes                  integer     1
    gcs_server_processes                 integer     0
    global_txn_processes                 integer     1
    job_queue_processes                  integer     4
    log_archive_max_processes            integer     4
    processes                            integer     80
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points