-
os upgrade
Hi Friends,
OS AIX 4.3.2
DB Oracle 8.1.5
We are planning to upgrade our OS to 4.3.3
and eventually to 5L.
Is it possible without affecting the Database?
Or do I have to perform some relinking?
Thanks,
-
Re: os upgrade
Hi,
There is absolutely no need to relink the Oracle executables when you upgrade your O/S from 4.3.2 to 4.3.3.In our company, we upgraded IBM AIX Version 4.3.0 to 4.3.3 without affecting our oracle database.Also if you are planning to upgrade your O/S to 4.3.3,you upgrade your Oracle database to 8.1.7.4 as the support for oracle 8.1.5.0 has now been stopped and lot of bugs have been found on Oracle 8.1.5.0,so if possible upgrade your Oracle database to 8.1.7.4.0
Regards,
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
oracle-support@indiatimes.com
-
Thanks for the info friend,
Do you think it holds true also when upgrading the OS to 5L?
Thanks
-
Hi,
OS aix 4.3.2 upgrade to 5l
DB Ora 8.1.5 migrate to 9i
We are also planning to migrate our DB to
higher version and at the same time upgrade
our os.
In case migration-upgrade is not possible
then we have to fresh install both OS and DB.
We have a 400GB-size database and we are planning
to use sqlloader rather than export/import (since its much
faster, am i right?).
My problem is how to convert the data (100M+ rows) to text file
without corrupting it. Especially when you have raw or lob columns. Unlike export/import conversion is automatic.
Can you share me extract programs in unix that convert DB to csv
txt files?
I got one in mind like:
spool txt.file
select col1||','||col2||','||.... from table1;
Is this ok?
Or can you share your experience in migrating large DBs?
Thanks,
-
hi,
If time is the criteria, then you can go for database migration assistant, which will be very fast.
If you have ample of time, then export/import is the best option since you get a chance to reorganize your data while importing and also you can change your block size if you want during the import and also chained rows are removed during the process.
Well as far as i know, sql*loader is not a preffered way for migration.
-
Originally posted by kris123
We have a 400GB-size database and we are planning
to use sqlloader rather than export/import (since its much
faster, am i right?).
You are right about the part "since its much faster", but have you given a thought how will you create a flat file for a 400GB database, and how many control files (of the sql*loader) will you create for that...
If on the same machine use DBMA (database mig. assist)
Amar
"There is a difference between knowing the path and walking the path."
-
Thanks friends,
We have around 30 tables > 10M rows and
2000+ tables < 10M rows. I thought it might be
a good strategy to use sqlloader for the former
and exp/imp on the latter.
My worry is that my extract program might not convert
the tables correctly to text files.
Has anyboby extracted/converted large tables (unix)into text files?
For DBMA, I just thought its not an option since i'm fresh installing
9i, for the fact that OS will also be fresh installed. Or has anybody
fresh install an OS and yet able to upgrade a DB from a lower OS version? I think it is used only to upgrade a database, updating data dict. without touching/moving tables and the OS. (am i right?)
Thanks,
-
Try this
http://www.dbasupport.com/forums/sho...threadid=34267
i have done this across OS with same versions but not between OS with different versions. You can try it out and see if it works... I feel it should work as there is not much change is the File System structures between 4.3.3 and 5L.
HTH
Amar
"There is a difference between knowing the path and walking the path."
-
Thanks Amar, for the procedure.
I surely need it later, with DBMA.
I hope migrating our aix 4.3.2 to 4.3.3 then to 5l
will not affect our 8.1.5 database, so we can migrate it
to 8.1.7 and then to 9i without exp/imp.
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
|