Upgrade from 8.1.6 to 8.1.7
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Upgrade from 8.1.6 to 8.1.7

  1. #1
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150

    Question

    Guys,

    Please help me with this, I need to upgrade an Oracle 8.1.6 to ver. 8.1.7 on the same machine (UNIX). Do you know of a better way of doing this aside from Export and Iimport. Better if you can direct me to some documentation regarding this.

    Thanks a lot guys,

    Ed

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    There are basically three ways to upgrade your database:
    1. upgrade from the command line (u0801060.sql)
    2. upgrade using odma
    3. export/import

    For beginners, I recommend using odma (Migration Assistant). It is a GUI based tool that basically does everthing for you.

    I would highly recommend reading [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a86632/toc.htm[/url] throughly before you attempt an upgrade.
    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
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150

    Smile

    [QUOTE][i]Originally posted by marist89 [/i]
    [B]There are basically three ways to upgrade your database:
    1. upgrade from the command line (u0801060.sql)
    2. upgrade using odma
    3. export/import

    For beginners, I recommend using odma (Migration Assistant). It is a GUI based tool that basically does everthing for you.

    I would highly recommend reading [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a86632/toc.htm[/url] throughly before you attempt an upgrade. [/B][/QUOTE]

    I know how to use the export/import, from your experience which do you think is easier and safer to perform, 1 or 2? Using # 2, Does it mean that I don't have to install anything, just by running the script I can upgrade 8.1.6 to 8.1.7. Where will I get the 'u0801060.sql', in the 8.1.7 CD?

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I personally advise you to use export/import if your dump file size is easily manageable by the OS on which you are running oracle.
    Reddy,Sam

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Personally, I upgrade using the u*** scripts. However, this is not for everybody. The u0801060.sql script will reside in the 8.1.7 $OH/rdbms/admin directory after you install 8.1.7.

    If you use odma, you have to install the 8.1.7 software in a different $ORACLE_HOME. Then, you run odma from the 8.1.7 $OH and it will ask you a bunch of questions and then perform the upgrade. It's really simple.

    For large databases, it runs much faster than an export/import.
    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."

  6. #6
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150
    I will be working first on a DEV database, surely the data is fairly small and I can do the export and import. But the idea is to familiarize myself with the upgrade procedure, because we have lots of database to upgrade, some are Development some are production database.

    Going back on the sql script, I just want to make this clear. I need to have a database running 8.1.7 and copy the script from there, then run it on the 8.1.6 database. Is that it?

    I really appreciate your prompt response, guys..

    Ed

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The whole procedure is outlined in [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a86632/migupgra.htm#19511[/url] under "Upgrade the Database Manually".
    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."

  8. #8
    Join Date
    Oct 2000
    Posts
    449
    After the upgrade from 816 to 817, there is also something like "Post Installation or After migration or upgrading" issues and specifically something about installing ODCI.jar and cartridgeservices.jar if you have the java option selected..
    Can anyone become more specific about this???http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a86632/migaftrm.htm#1247
    I created the db manually to 8.1.6 and then upgraded to 817 by following the http link enclosed by Jeff and so on.. Everything went well. I ran the script u08010601.sql..
    Thanks

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