DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-03113: end-of-file on communication channel while using /PAE switch for VLM

  1. #1
    Join Date
    Aug 2000
    Posts
    21

    ORA-03113: end-of-file on communication channel while using /PAE switch for VLM

    Hi
    I am trying to make my oracle database use more than 4GB of RAM.

    I am using the following on a 32 bit machine with 8CPU's and 8GB RAM
    Windows 2003 datacenter edition OS
    Oracle 10gR2 database


    I have changed the following things

    1) Included the in boot.ini file with this /PAE
    2) Added the registry parameter AWE_WINDOW_MEMORY with 1GB in bytes
    3) the init.ora is as follows
    ------------------------------------------------------
    USE_INDIRECT_DATA_BUFFERS=TRUE
    db_block_size=8192
    DB_BLOCK_BUFFERS=524288
    _db_block_lru_latches=128
    SGA_TARGET=0
    #_enable_NUMA_optimization=false
    AQ_TM_PROCESSES=0
    java_pool_size=157286400
    large_pool_size=157286400
    shared_pool_size=260170137
    pga_aggregate_target=203423744
    background_dump_dest='D:\oracle\db\admin\GS\bdump'
    compatible='10.2.0.3.0'
    control_files='D:\oracle\oradata\GS\control01.ctl','D:\oracle\oradata\GS\control02.ctl','D:\oracle\o radata\GS\control03.ctl'
    core_dump_dest='D:\oracle\db\admin\GS\cdump'
    #
    db_domain=''
    db_file_multiblock_read_count=8
    db_name='GS'
    dispatchers='(PROTOCOL=TCP) (SERVICE=GSXDB)'
    job_queue_processes=10
    open_cursors=300
    #
    processes=300
    remote_login_passwordfile='EXCLUSIVE'
    sessions=335
    undo_management='AUTO'
    undo_tablespace='UNDOTBS1'
    user_dump_dest='D:\oracle\db\admin\GS\udump'
    #
    -----------------------------------------------------

    I got the following error when I startup the database

    ----------------------------------------------------
    D:\>sqlplus /nolog

    SQL*Plus: Release 10.2.0.3.0 - Production on Tue Mar 25 15:29:51 2008

    Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

    SQL> conn sys as sysdba
    Enter password:
    Connected to an idle instance.
    SQL> startup
    ORACLE instance started.

    Total System Global Area 4890558464 bytes
    Fixed Size 1372176 bytes
    Variable Size 589959152 bytes
    Database Buffers 4294967296 bytes
    Redo Buffers 4259840 bytes
    Database mounted.
    ORA-03113: end-of-file on communication channel

    SQL>

    ----------------------------------------------------------


    I have tried with different pga_aggregate_target sizes but couldn't startup the database.

    Any Idea/clue will be helpful.

    NOTE : For me this is necessary because at any point of time 2000 users will be trying to connect to the single instance of this database, and few users are unable to connect.

    Thanks in advance.
    BSR

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    May I ask why do you think ORA-03113 is related to PGA size?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

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