Data Migration 7.3 to 9i R2 ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Data Migration 7.3 to 9i R2 ?

  1. #1
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108

    Data Migration 7.3 to 9i R2 ?

    Hi
    1>I have a data about 6 gb in oracle database 7.3.3.0.0. workgroup edition with distributed option , now i want to migrate the database in to 9iR2 enterprise edition ?
    if i take the export of 7.3 W E withDE then import into 9iR2EE.
    wil, it work .
    or do i have to follow the path 7.3->8.0.5->8.0.6->8.1.7->9.2
    please suggest
    and plateform is window NT,
    2> How can i estimate the size of dmp file on windows please provide the steps.
    SOnu

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    If you are doing export/import then you can directly export from Oracle7.3 and import into Oracle9i.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108
    Hi Adewri
    my question is still the same
    1>if i take the export of 7.3 Workstation with Distributed Environment then import into 9i R2 Enterprise Edition.
    wil, it work .
    2> How can i estimate the size of dmp file on windows please provide the steps.
    3> can we implement Oracle parallel server on 7.3 Workstation with distributed environment? If yes can i get some link r any white paper for implementing this thing? or do you have any steps for that.

    Please have a look on both the 3 questions.
    Sonu

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by sonuji_in
    Hi Adewri
    my question is still the same
    1>if i take the export of 7.3 Workstation with Distributed Environment then import into 9i R2 Enterprise Edition.
    wil, it work .
    Yes it will work. You need to pre-create the tablespaces in the 9i databases. Then use oracle7.3 exp utility to export and Oracle9i import utility ro import.

    You need to create a migration testing environment if possible. Do a sample database export and import and then run existing applications to see if there are any possible glitch, if there are then look for the solutions or available patches on metalink. Then when you are sure that everything has been resolved, do the final upgrade.


    2> How can i estimate the size of dmp file on windows please provide the steps.
    In windows i have no idea, in unix yes its possible.


    3> can we implement Oracle parallel server on 7.3 Workstation with distributed environment? If yes can i get some link r any white paper for implementing this thing? or do you have any steps for that.

    Please have a look on both the 3 questions.
    Sonu
    OPS on workstations ?? i didn't get that. If you just read the concepts of RAC (OPS in 8i and earlier) that might give you a clear picture. For RAC you need to have atleast 3 nodes. Two for Oracle Software and instances and one to store the shared database.

    Refer to http://tahiti.oracle.com for more documentations.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by adewri
    For RAC you need to have atleast 3 nodes. Two for Oracle Software and instances and one to store the shared database.

    Refer to http://tahiti.oracle.com for more documentations.
    Why 3 Amar? RAC needs minimum two nodes and a shared disk array.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by SANJAY_G
    Why 3 Amar? RAC needs minimum two nodes and a shared disk array.
    My mistake, i said 3 including the shared node as well...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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