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

Thread: os upgrade

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    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,

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    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 and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  3. #3
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Thanks for the info friend,

    Do you think it holds true also when upgrading the OS to 5L?


    Thanks

  4. #4
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    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,

  5. #5
    Join Date
    Sep 2002
    Posts
    376
    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.

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    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,

  8. #8
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  9. #9
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    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
  •  


Click Here to Expand Forum to Full Width