ORA-01092: ORACLE instance terminated. Disconnection forced.
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 5 123 ... LastLast
Results 1 to 10 of 48

Thread: ORA-01092: ORACLE instance terminated. Disconnection forced.

Hybrid View

  1. #1
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi friends,

    when starting my sql plus, oracle gives an error message
    ORA-01092: ORACLE instance terminated. Disconnection forced. When i tried starting the database from svrmgrl, it tries starting the database but gave an end-of-communication channel error message. what is the solution ?

    satishpc

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    is it NT or UNIX?

  3. #3
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    oh, so sorry for that. should have specified earlier. it is oracle 8i enterprise edition running on NT

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    you have to stop the database from services and start from services, then if the database is still not up try again from svrmgrl.
    I think you are experiencing problems with SGA, are you using MTS?
    Is it 8i?

  5. #5
    Join Date
    Apr 2007
    Posts
    2
    Hello

    I could not dind alert file in bdump folder
    SQL> startup nomount pfile=C:\oracle\admin\arundb\pfile\initarundb.ora
    ORACLE instance started.

    Total System Global Area 118255568 bytes
    Fixed Size 282576 bytes
    Variable Size 83886080 bytes
    Database Buffers 33554432 bytes
    Redo Buffers 532480 bytes
    SQL> SHOW PARAMETER DUMP

    NAME TYPE VALUE
    ------------------------------------ ----------- -----------------------------
    background_core_dump string partial
    background_dump_dest string C:\oracle\admin\arundb\bdump
    core_dump_dest string C:\oracle\admin\arundb\cdump
    max_dump_file_size string UNLIMITED
    shadow_core_dump string partial
    user_dump_dest string C:\oracle\admin\arundb\udump
    SQL> alter database mount;
    database mounted
    ----------------------
    now when i try to run alter database open i find error
    ORA-01092: ORACLE instance terminated. Disconnection forced
    i could not locate alert file to trouble shoot
    Please help

  6. #6
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi
    i tried both throught the services and svrmgrl. but it doesnt work. when starting from svrmgrl, it give the end-of-communication file problem. will reducing the SGA help ? it is oracle 8i. i am not using MTS
    waiting for ur reply

    satish

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    check your alert.log see if the instance was initiated at all. I said SGA because when I faced this problem in NT was because large pool was full but this was because I was using MTS and my large pool size were too small.
    When I start the db from svrmgrl I didnt get the error message you got, instead it simply says oracle not available and when i tried to shut it down it just hangs even with abort option however these shutdown and process were still recorded in alert.log I fixed it by shutting the db from services and start from either svrmgrl or services.

    I cant think of anything since our situation might be different

  8. #8
    Join Date
    Dec 2000
    Posts
    11

    Thumbs up

    HI,
    try to decrease the size of SGA and normally check alert.log in the background_dump_dest.

  9. #9
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi,

    here is my alert file. i think there might be a bad block. please interpret for me. this was working fine till yesterday.
    i dont even know whether i got the right part. if anyone needs any more info, please feel free to ask. thanks .

    satish

    here it is

    Tue Dec 12 20:02:10 2000
    starting up 1 shared server(s) ...
    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
    Tue Dec 12 20:02:11 2000
    alter database mount
    ***
    Corrupt block relative dba: 0x00000003 file=0. blocknum=3.
    Bad check value found during controlfile block read
    Data in bad block - type:21. format:2. rdba:0x00000003
    last change scn:0xffff.00001790 seq:0x1 flg:0x04
    consistancy value in tail 0x17901501
    check value in block header: 0x7b75, calculated check value: 0x2
    spare1:0x0, spare2:0x0, spare2:0x0
    LGWR: terminating instance due to error 227
    Instance terminated by LGWR, pid = 275
    Tue Dec 12 20:07:08 2000
    Starting ORACLE instance (force)
    License high water mark = 5
    Tue Dec 12 20:12:08 2000
    Instance terminated by USER, pid = 105
    Starting up ORACLE RDBMS Version: 8.1.6.0.0.
    System parameters with non-default values:
    processes = 59
    shared_pool_size = 5728640
    large_pool_size = 614400
    java_pool_size = 20971520
    control_files = D:\Oracle\oradata\finsati\control01.ctl, D:\Oracle\oradata\finsati\control03.ctl, D:\Oracle\oradata\finsati\control02.ctl
    db_block_buffers = 2048
    db_block_size = 8192
    compatible = 8.1.0
    log_archive_dest_1 = LOCATION=D:\Oracle\Ora81\RDBMS
    log_buffer = 32768
    log_checkpoint_interval = 10000
    log_checkpoint_timeout = 1800
    db_files = 1024
    db_file_multiblock_read_count= 8
    max_enabled_roles = 30
    remote_login_passwordfile= EXCLUSIVE
    global_names = TRUE
    distributed_transactions = 500
    instance_name = finsati
    service_names = finsati
    mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
    open_links = 4
    sort_area_size = 65536
    sort_area_retained_size = 65536
    db_name = finsati
    open_cursors = 100
    os_authent_prefix =
    query_rewrite_enabled = TRUE
    job_queue_processes = 4
    job_queue_interval = 10
    parallel_max_servers = 5
    background_dump_dest = D:\Oracle\admin\finsati\bdump
    user_dump_dest = D:\Oracle\admin\finsati\udump
    max_dump_file_size = 10240
    oracle_trace_collection_name=
    PMON started with pid=2
    DBW0 started with pid=3
    LGWR started with pid=4
    CKPT started with pid=5
    SMON started with pid=6
    RECO started with pid=7
    SNP0 started with pid=8
    SNP1 started with pid=9
    SNP2 started with pid=10
    SNP3 started with pid=11
    Tue Dec 12 20:12:12 2000
    starting up 1 shared server(s) ...
    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...



  10. #10
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    It seems you need to recreate the corrupted control file.

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