1 2 Previous Next 19 Replies Latest reply: Jan 1, 2013 4:02 AM by Madhu.149 RSS

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

    Madhu.149
      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
          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
            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
              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
                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
                  *.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
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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