Forum OpenACS Q&A: upgrading oracle 8.1.6 to 8.1.7
I need to upgrade a Sun server that is running Oracle 8.1.6 to 18.104.22.168
and this machine is running ACS 3.x as well. I need to preserve the
content of that tablespace ... What would people recommend? Is an
export form 8.1.6 importable in 8.1.7? Or should I think of something
This is not a trivial process, and I recommend doing the database migration by hand--my experience with the GUI migrator was that it had memory leaks and failed in the middle of the migration.
Is 22.214.171.124 the latest for Sun? We're up to 126.96.36.199 on Linux...
188.8.131.52 is the one I got updated but I will check metalink to see if I can get the latest for Sun.
I will have a look at the migration steps, do you have any pointer for it, besides http://www.akadia.com/services/ora_migrate_816_to_817.html (got it from Google).?
I don't know if this applies to Solaris, but the 184.108.40.206 patch for Linux causes problems with the INSO filters for interMedia, and I haven't heard of a fix being made available. 220.127.116.11 was ok here, so you might want to check carefully if you need the INSO filters (that is, the capability to index things like Word docs via interMedia).
Just to reply to my own question, http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a86632/toc.htm has a lot of information about migrating.
Janine, you say you use "export/import", is the format compatible then? I just want to make sure and not find myself with an "un-importable export file"...
I would clarify the import/export thing here. In my experience, you can get problems if you do the import using a different version than your export. So, ideally you should export using version 18.104.22.168 of exp and re-import using the same version of imp. Of course, this may mean installing 22.214.171.124 to achieve this! (I may be mistaken on this - it may only be when importing back to an earlier version that problems arise, maybe going forward is ok, but I have seen problems with imports between versions.)
older versions of exp. One gotcha to watch out for is character sets
(i.e. you can't import an 8859-1 encoded DB into a utf8 DB without some very
evil tricks -- Branimir wrote up some notes on what he had to do to get
things to work in that case).
I am downloading Oracle 8.1.7 now ... :( sloooooow ...
The problem I had was exporting from Oracle 8.1.6 on Solaris and trying to import on 8.1.7 on Linux ... so I will do a complete backup of my 8.1.6, install a fresh Oracle 8.1.7 on solaris and try to import the exported file from 8.1.6 ...
If that doesn't work, I will try to do the "migration from 8.1.6 to 8.1.7" .. but everything I read about it shows me that it's not as simple as the export/import :)
The only problem is that the machine running Oracle 8.1.6 (Sun) is isolated and I can't use SQLNet to connect to it ... I just can transfer the files via sftp ... but I will give that a try with my other development machine
126.96.36.199 Intermedia INSO filter problems on Linux, please?
Also, do you need the INSO filters in order to index PDF files with
Intermedia? I don't recall off-hand, although I should check, and I
suspect the answer is yes.