Instance crashes!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Instance crashes!!!

  1. #1
    Join Date
    Sep 2000
    Posts
    78

    Angry

    Hi,

    When I import a table about 500000 rows..This happened twice. The alert log file said that the instance was terminated by PMON duw to error 601 (lock conflict).

    Why this heppens?
    What should I do?

    I haave Oracle 8.1.5.0.0 on Linux

    Thanx...

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    This is a known Bug.
    You should not use MTS !!!
    shutdown the database, comment out the MTS parameters in the init.ora and restart the database.

  3. #3
    Join Date
    Sep 2000
    Posts
    78
    thanx! :)

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You don't need to disable MTS. Workaround is have another service name in tnsnames.ora as dedicated service and use that service(@xyz) whenever you import. Thats how you can import thru dedicated connection.
    Reddy,Sam

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