From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Upgrading 8.0.5 to 8.1.6 Date: Sun, 04 Mar 2001 00:28:01 +0100 Message-ID: Reply-To: postbus@sybrandb.demon-verwijderdit.nl References: <3aa1315b.2019166237@192.168.0.10> X-Newsreader: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@nl.demon.net NNTP-Posting-Host: sybrandb.demon.nl X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78 X-Trace: beta-news.demon.nl 983661954 beta-news:69199 NO-IDENT sybrandb.demon.nl:212.238.21.78 Lines: 60 On Sat, 03 Mar 2001 18:06:42 GMT, cschofie@nospam.home.com (Chris S) wrote: >I have read the Oracle docs on this, and I conclude that I have two >choices in my situation - > >1) do a full export; uninstall; install 816; full import >or >2) go through the migration process. > >I'm very familiar with (1) and it has worked in the past. I'm >interested in understanding more about (2). From what I read, I still >uninstall 805 first, but I retain the datafiles, then after installing >816, I run various scripts in server manager. > >My question is - at the end of this process, I'm guessing that all my >tablespaces will be named according to the 8.0.5 method - (user_data, >etc), and the tablespace settings will still retain the defaults in >place for 8.0.5. So if I want a 'pure' 8.1.6 environment, I really >need to do the export/imort method? > >It also seems like I need to manually move my database storage files >'out of' the old 8.0.5 area and into the new 8.1.6 area - that is, if >my files were in 'd:\orant\database', they'll still be there even >though the default 8.1.6 storage area is 'd:\ora8i\oradata' (or >similar). To achieve this, I'll need to edit the various files to >re-point to the new locations. Is this true, and if so, are there any >tricks to make it relatively foolproof? Of course, I could leave them >where they are, but that's undesirable for me. > >Thanks, Chris. >=========== >Remove 'nospam' from email to reply - Thanks Sorry to say so (and I just verified this in the online docs) you can't *migrate* an Oracle 8.0 database to Oracle 8i, you can only *upgrade* As the database format didn't change from 8.0 to 8i, the only thing that will happen is datadictionary upgrade scripts will be run. Refer to http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a86632/migupgra.htm#19511 for further clarification and please read it carefully. You're only going to upgrade, which you can do manually. So, the migration and upgrade utility is not going to do *anything* to your database files. If you now have your database files in ORACLE_HOME dependent directories, like d:\orant\database, this is your opportunity to move them, though it is definitely not required, as using the migration tool, you migrate and upgrade a database in situ, so you won't have 2 databases at the same time (which is of course the biggest problem of this method: if something does go wrong, you can restore a backup). In all previous releases of Oracle on NT after my first install, I never created files in %ORACLE_HOME%\database, just because of this problem. Hth, Sybrand Bakker, Oracle DBA