This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Jan 1, 2013 2:02 AM by Madhu.149 RSS

SQL>startup  Error:ORA-03113: end-of-file on communication channel

Madhu.149 Newbie
Currently Being Moderated
Hello All,

Oracle 11g 11.2.0.2 Expression Edition

I made the number of processes to 1 by issuing the below command.
SQL> alter system set processes = 1;
SQL>shutdown immediate
I am getting the below error when I issued startup command.
SQL> startup;
ORA-03113: end-of-file on communication channel
alert log:
Fri Dec 28 14:09:24 2012
PMON started with pid=2, OS id=2984 
Fri Dec 28 14:09:24 2012
PSP0 started with pid=3, OS id=5788 
Fri Dec 28 14:09:25 2012
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.
Process GEN0 submission failed with error = 20
USER (ospid: 4780): terminating the instance due to error 444
Fri Dec 28 14:09:25 2012
VKTM started with pid=4, OS id=1676 at elevated priority
Instance terminated by USER, pid = 4780
How to startup my database again?
  • 1. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Error: ORA 20 Text: maximum number of processes exceeded
    Cause: An operation requested a resource that was unavailable. The maximum number of processes is specified by the initialization parameter PROCESSES. When this maximum is reached, no more requests are processed. Action: Try the operation again in a few minutes. If this message occurs often, shut down Oracle, increase the PROCESSES parameter in the initialization parameter file, and restart Oracle.



    Increase Process , Why you set the process =1
  • 2. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Madhu.149 Newbie
    Currently Being Moderated
    I changed the number of processes to 100 but even, I am getting the same error
    SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 14:50:51 2012
    
    Copyright (c) 1982, 2010, Oracle.  All rights reserved.
    
    Connected to an idle instance.
    
    SQL> startup mount pfile='D:\pfile.ora';
    ORA-03113: end-of-file on communication channel
    SQL>
    Edited by: Madhu.149 on Dec 28, 2012 2:52 PM
  • 3. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Post alert log (50 lines ), post Pfile that you mount from it .
  • 4. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Madhu.149 Newbie
    Currently Being Moderated
    alert log:
    Starting up:
    Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production.
    Using parameter settings in server-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\INITXE.ORA
    System parameters with non-default values:
      processes                = 6
      sessions                 = 32
      spfile                   = "C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DBS\SPFILEXE.ORA"
      memory_target            = 1G
      control_files            = "C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF"
      compatible               = "11.2.0.0.0"
      db_recovery_file_dest    = "C:\oraclexe\app\oracle\fast_recovery_area"
      db_recovery_file_dest_size= 10G
      undo_management          = "AUTO"
      undo_tablespace          = "UNDOTBS1"
      remote_login_passwordfile= "EXCLUSIVE"
      dispatchers              = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
      shared_servers           = 4
      job_queue_processes      = 4
      audit_file_dest          = "C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP"
      db_name                  = "XE"
      open_cursors             = 300
      diagnostic_dest          = "C:\ORACLEXE\APP\ORACLE"
    Fri Dec 28 14:06:59 2012
    PMON started with pid=2, OS id=2248 
    Fri Dec 28 14:06:59 2012
    PSP0 started with pid=3, OS id=3700 
    Fri Dec 28 14:07:00 2012
    VKTM started with pid=4, OS id=4492 at elevated priority
    Fri Dec 28 14:07:00 2012
    ORA-00020: No more process state objects available
    VKTM running at (10)millisec precision with DBRM quantum (100)ms
    ORA-20 errors will not be written to the alert log for
     the next minute. Please look at trace files to see all
     the ORA-20 errors.
    Process GEN0 submission failed with error = 20
    USER (ospid: 6076): terminating the instance due to error 444
    Instance terminated by USER, pid = 6076
    Fri Dec 28 14:09:07 2012
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    Picked latch-free SCN scheme 2
    Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
    Autotune of undo retention is turned on. 
    IMODE=BR
    ILAT =10
    LICENSE_MAX_USERS = 0
    SYS auditing is disabled
    Starting up:
    Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production.
    Using parameter settings in server-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\INITXE.ORA
    System parameters with non-default values:
      processes                = 6
      sessions                 = 32
      spfile                   = "C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DBS\SPFILEXE.ORA"
      memory_target            = 1G
      control_files            = "C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF"
      compatible               = "11.2.0.0.0"
      db_recovery_file_dest    = "C:\oraclexe\app\oracle\fast_recovery_area"
      db_recovery_file_dest_size= 10G
      undo_management          = "AUTO"
      undo_tablespace          = "UNDOTBS1"
      remote_login_passwordfile= "EXCLUSIVE"
      dispatchers              = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
      shared_servers           = 4
      job_queue_processes      = 4
      audit_file_dest          = "C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP"
      db_name                  = "XE"
      open_cursors             = 300
      diagnostic_dest          = "C:\ORACLEXE\APP\ORACLE"
    Fri Dec 28 14:09:24 2012
    PMON started with pid=2, OS id=2984 
    Fri Dec 28 14:09:24 2012
    PSP0 started with pid=3, OS id=5788 
    Fri Dec 28 14:09:25 2012
    ORA-00020: No more process state objects available
    ORA-20 errors will not be written to the alert log for
     the next minute. Please look at trace files to see all
     the ORA-20 errors.
    Process GEN0 submission failed with error = 20
    USER (ospid: 4780): terminating the instance due to error 444
    Fri Dec 28 14:09:25 2012
    VKTM started with pid=4, OS id=1676 at elevated priority
    Instance terminated by USER, pid = 4780
    pfile.ora
    xe.__db_cache_size=239075328
    xe.__java_pool_size=4194304
    xe.__large_pool_size=12582912
    xe.__oracle_base='C:\oraclexe\app\oracle'#ORACLE_BASE set from environment
    xe.__pga_aggregate_target=427819008
    xe.__sga_target=645922816
    xe.__shared_io_pool_size=75497472
    xe.__shared_pool_size=306184192
    xe.__streams_pool_size=0
    *.audit_file_dest='C:\oraclexe\app\oracle\admin\XE\adump'
    *.compatible='11.2.0.0.0'
    *.control_files='C:\oraclexe\app\oracle\oradata\XE\control.dbf'
    *.db_name='XE'
    *.DB_RECOVERY_FILE_DEST_SIZE=10G
    *.DB_RECOVERY_FILE_DEST='C:\oraclexe\app\oracle\fast_recovery_area'
    *.diagnostic_dest='C:\oraclexe\app\oracle\.'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=XEXDB)'
    *.job_queue_processes=4
    *.memory_target=1024M
    *.open_cursors=300
    *.processes=100
    *.remote_login_passwordfile='EXCLUSIVE'
    *.sessions=80
    *.shared_servers=4
    *.undo_management='AUTO'
    *.undo_tablespace='UNDOTBS1'
  • 5. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    *.processes=100
    Try to increase it again , seems you have lot of opened Process ,

    Also Refer to
    ORA-00020: maximum number of processes ... exceeded
  • 6. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Madhu.149 Newbie
    Currently Being Moderated
    I increased processes to 1000. but again getting same error
    SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 15:09:14 2012
    
    Copyright (c) 1982, 2010, Oracle.  All rights reserved.
    
    Connected to an idle instance.
    
    SQL> startup mount pfile='D:\pfile.ora';
    ORA-03113: end-of-file on communication channel
    SQL> startup mount pfile='D:\pfile.ora';
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    SQL>
    Edited by: Madhu.149 on Dec 28, 2012 3:11 PM
  • 7. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Rob_J Journeyer
    Currently Being Moderated
    Hi,

    Your alert log says that the parameter processes is set to 6? Or is that from a different time?
    How did you create that Pfile? Did you use the create pfile from spfile command or just copy the contents from the spfile?
  • 8. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Do the following :
    Set ORACLE_SID=XE
    sqlplus / as sysdba
    SQL> startup mount pfile='D:\pfile.ora';
  • 9. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Madhu.149 Newbie
    Currently Being Moderated
    I had a backup of pfile.
    So, I am using that backup file.

    I have not copied from spfile

    The only problem is the number of processes is less even to startup the database?

    So, How to startup the database in this scenario?
  • 10. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Madhu.149 Newbie
    Currently Being Moderated
    C:\>Set ORACLE_SID=XE
    
    C:\>sqlplus / as sysdba
    
    SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 15:17:42 2012
    
    Copyright (c) 1982, 2010, Oracle.  All rights reserved.
    
    Connected to an idle instance.
    
    SQL> startup mount pfile='D:\pfile.ora';
    ORA-03113: end-of-file on communication channel
    SQL>
  • 11. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Rob_J Journeyer
    Currently Being Moderated
    If this is on a Windows machine, stop and start the service.
    Is it still stating that the processes=6 in the alert log? If so, that's the problem, but I'm not sure why it would be picking up a different parameter if you are explicitly specifying a parameter file with the correct number of processes in it. Is there definitely only 1 line for processes in the pfile? Is what you posted above the complete contents of your pfile?
  • 12. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Madhu.149 Newbie
    Currently Being Moderated
    Tried.. But same error.

    Is what you posted above the complete contents of your pfile?
    Yes it is the complete pfile.
  • 13. Re: SQL>startup  Error:ORA-03113: end-of-file on communication channel
    Rob_J Journeyer
    Currently Being Moderated
    And is it still saying that processes=6 in the alert log for the time that you try to start it up?
1 2 Previous Next

Legend

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