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

Thread: Instance crashes!!!

  1. 03-14-2001, 07:48 AM #1
    siroracle
    siroracle is offline Junior Member
    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...
    Reply With Quote Reply With Quote
  2. 03-14-2001, 08:14 AM #2
    rotem_fo
    rotem_fo is offline Hangin Around,,,
    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.
    Reply With Quote Reply With Quote
  3. 03-14-2001, 08:19 AM #3
    siroracle
    siroracle is offline Junior Member
    Join Date
    Sep 2000
    Posts
    78
    thanx! :)
    Reply With Quote Reply With Quote
  4. 03-14-2001, 09:37 AM #4
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width