CKPT fails on startup with Error 220
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: CKPT fails on startup with Error 220

  1. #1
    Join Date
    Jul 2002
    Posts
    2

    Question

    Hi

    I have an NT 4 server which has just been through a hardware upgrade (extra CPU and extra RAM and new network card). The IP Config had to be re-setup and now the OracleServiceSID service startups up OK but the instance and database (version 8.1.6) fail to startup.

    The Alert log contains the following :
    CKPT: terminating instance due to error 220

    The CKPT Trace file contains :

    *****************************
    Dump file d:\oracle\8.1.6/admin/bdump\demoCKPT.TRC
    Fri Jul 19 12:33:21 2002
    ORACLE V8.1.6.1.0 - Production vsnsta=0
    vsnsql=e vsnxtr=3
    Windows NT Version 4.0 Service Pack 6, CPU type 586
    Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production
    Windows NT Version 4.0 Service Pack 6, CPU type 586
    Instance name: demo

    Redo thread mounted by this instance: 0

    Oracle process number: 5

    Windows thread id: 257, image: ORACLE.EXE


    *** SESSION ID:(4.1) 2002-07-19 12:33:21.078
    error 220 detected in background process
    *************************************

    Any ideas on what may be wrong?

    Thanks

  2. #2
    Join Date
    Jul 2002
    Posts
    2
    The problem was with one of my control files - when I removed it from the control_files list in my init.ora the database started up OK.
    Paul

  3. #3
    Join Date
    Jun 2002
    Posts
    73
    Yes the problem should be in your control files , but don't be afraid just copy the correct control file and rename in init.ora , all will be fine.


    From the Airliner......in the skies.
    You cannot succeed if you fear to face challenges.
    MAS
    BE(CS) , OCP 8/8i.



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