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.
[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
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?
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.
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?
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..