-
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
-
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."
-
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
-
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."
-
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"
-
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."
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
|