ora-03113 end of on communication
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: ora-03113 end of on communication

  1. #1
    Join Date
    Oct 2001
    Location
    GA, USA
    Posts
    79

    ora-03113 end of on communication

    Hi Guys,


    I am getting ora-03113 error while starting database using svrmgrl
    and i am getting ORA-01092: ORACLE instance terminated. Disconnection forced error on sql*plus

    please trough some valuable input.

    Thanks
    Circumstances do not rise to meet our expectation. Embrace what you actually get. Open your eyes. See things for what they really are Thereby sparing yourself the pain of false attachements.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I would bet you need to look at your kernal parameters.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Oct 2001
    Location
    GA, USA
    Posts
    79
    My environment is windows 2000 and i am running on my local pc. I you can guide me where do i have to look for kernal parameters?


    Thanks
    Circumstances do not rise to meet our expectation. Embrace what you actually get. Open your eyes. See things for what they really are Thereby sparing yourself the pain of false attachements.

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    where is the alert log? Can Oracle write to the
    bdump dest? Do the permissions/space allow this
    on your filesystem?

    steve
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Oct 2001
    Location
    GA, USA
    Posts
    79
    istributed_transactions = 10
    instance_name = des85
    service_names = des85
    sort_area_size = 65536
    sort_area_retained_size = 65536
    db_name = des85
    open_cursors = 400
    ifile = C:\oracle\admin\des85\pfile\initdes85.ora
    os_authent_prefix =
    optimizer_mode = RULE
    job_queue_processes = 1
    job_queue_interval = 60
    parallel_max_servers = 5
    background_dump_dest = C:\oracle\admin\des85\bdump
    user_dump_dest = C:\oracle\admin\des85\udump
    max_dump_file_size = 10240
    oracle_trace_collection_name=
    PMON started with pid=2
    DBW0 started with pid=4
    RECO started with pid=8
    My trace log file

    LGWR started with pid=5
    SNP0 started with pid=3
    CKPT started with pid=6
    SMON started with pid=7
    Thu Oct 24 12:46:35 2002
    alter database mount exclusive
    ***
    Corrupt block relative dba: 0x00000003 (file 0, block 3)
    Fractured block found during controlfile block read
    Data in bad block -
    type: 21 format: 2 rdba: 0x00000003
    last change scn: 0xefff.0000069c seq: 0x1 flg: 0x04
    consistency value in tail: 0x069c0501
    check value in block header: 0xabfe, computed block checksum: 0x0
    spare1: 0x0, spare2: 0x0, spare3: 0x0
    ***
    LGWR: terminating instance due to error 227
    Thu Oct 24 12:47:03 2002
    Instance terminated by LGWR, pid = 1148


    Please help or any suggestion
    Circumstances do not rise to meet our expectation. Embrace what you actually get. Open your eyes. See things for what they really are Thereby sparing yourself the pain of false attachements.

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Your controlfile is corrupt.

    If you have multiplexed controlfiles try starting your instance by using only one of them at a time (try each one of them), hoping that not all of them are corrupt.

    If that doesn't work, try recreating your controlfile.

    If that doesn't work, call Oracle Support.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  7. #7
    Join Date
    Oct 2001
    Location
    GA, USA
    Posts
    79
    Thanks for reply

    following are my controle file location. can i use second control file to start database ? if yes the how please guide me for that or suggestion cause i am relatively very new to recovery kind a thing.

    processes = 150
    shared_pool_size = 7637094
    large_pool_size = 614400
    java_pool_size = 32768
    control_files = C:\oracle\oradata\des85\control01.ctl, C:\oracle\oradata\des85\control02.ctl, C:\oracle\oradata\des85\control03.ctl
    db_block_buffers = 2796


    Again thanks for reply
    Circumstances do not rise to meet our expectation. Embrace what you actually get. Open your eyes. See things for what they really are Thereby sparing yourself the pain of false attachements.

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