Using Oracle Data Migration Assistant
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Using Oracle Data Migration Assistant

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Dear Moderators and Members
    I am trying to upgrade a database from 8.1.6 to 8.1.7 using the migration assistant. When I select the database to be upgraded, the GUI returns the following error:

    Upgrade cannot proceed because of the "job_queue_processes parameter(s) does not have 0 (zero) value: job_queue_processes

    I uncommented it from init.ora file, tried again and it still gave the same error. Please help...I recall Marist (Jeff) indicated in one mail he has used this tool with great success, wonder if Jeff can comment on my error. Thanks in advance.

    roukie-dba

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Yes, I have used this tool many times with great success.

    After you changed the job_queue_processes parameter did you bounce your database?

    [Edited by marist89 on 07-26-2001 at 03:08 PM]
    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
    Jun 2001
    Location
    NY
    Posts
    226
    Jeff
    Thanks men, it is running now. I will keep you informed of the final results.
    roukie-dba

  4. #4
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    MARIST
    thanks for your help, the migration completed successfully!!!
    roukie-dba

  5. #5
    Join Date
    Jul 2000
    Location
    Chennai,India
    Posts
    5
    Job Queue Processes parameter should be set to 0 while because no jobs should be running while migrating the database

  6. #6
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Sriram
    Thanks for that information, I appreciate it!!!
    roukie-dba

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