I do not dispute any experiences reported in this thread, however I
had absolutely no problems installing 9i and creating a database on a
Win2K machine with SP2. Everything went smoothly, and I even had (and
still have) 8.1.6.3.8 installed and running on this same machine. The
only problem I noticed was an issue of speed: DDL, DML and queries
took quite a bit of time to complete in the 9i database. I patched
the software to 9.0.1.2.0 and restarted the database. It was like a
miracle had occurred -- 9i was running better than 8i on the same
machine. I still have both versions running on my PC -- unfortunately
my PC is used as a mini 'test bed' for anyone in the company who needs
an Oracle database to check code, table structure, and the like, which
makes it interesting, to say the least, to get work done some days.
mwilliams1227_at_yahoo.com (Mike Williams) wrote in message news:<72165b76.0203211331.12ee412c_at_posting.google.com>...
> We've been attempting an 8i to 9i upgrade for some time now (Win2K
> SP2). After several attempts on our development sever, we finally
> completed the upgrade after completely uninstalling 8i, reinstalling,
> restoring the database, installing the 9i software, doing a complete
> standard edition install and upgrading with the data migration
> assistant. Many, many problems along the way (migration assistant
> hangs server first try, Oracle Text not installed in a custom install,
> manual DB upgrade works but ruled out after it takes two days). Oracle
> support recommended we do not use Export/Import for more than 2 GB of
> data (?).
>
> Fair enough. That's why we test. So... We move on to our test
> server. Use the same procedure as our dev box. Hangs halfway through
> the ODMA. Nothing but a big mess on my server. After practicing my
> deep breathing exercises, reinstall, clean the machine up, decide to
> try EXP/IMP. Reinstall, run the ODCA to create starter scripts for
> database creation, get to the last screen, no option to create
> starter scripts. Select the HELP button and you get information on
> how to create scripts, you just can't do it. (Be sure you have all
> patches installed before trying to create a database). Create the
> database, tablespaces manually and import. Seems to work, but I'm not
> exactly getting the warm fuzzies. Lots of testing ahead.
>
> I can't tell you how much I'm looking forward to the production
> upgrade. For various reasons (Oracle bug fixes), we are tied to this
> upgrade, though I'm more than a little nervous after the problems
> we've had. Some of the Oracle documentation issues we came across
> would have been comical if they hadn't wasted so much of our time. (Is
> it Oracle Text, Intermedia Text, Context or UltraSearch? Answer: All
> of the above, depending on where you look in the Oracle 9i
> Documentation.)
>
> I believe I've seen something about a Release 2 on this group in
> May(?).
>
> Good luck.
>
> Mike Williams
>
>
> "Wyrm" <afdng_at_wyrm.demon.co.uk> wrote in message news:<1016725823.21996.0.nnrp-14.c29f1e83_at_news.demon.co.uk>...
> > Hi.
> >
> > Further to an earlier thread where I was having problems installing Oracle
> > 9i and creating a database on Win2k SP2. These are my findings.
> >
> > I did a complete clean reinstall of Win2k plus SP2.
> > The installation (Software Only) of 9i went OK.
> > However, when I tried to create a database using the Database Configuration
> > Assistant it crashed on the last step and rebooted the server. The database
> > had not been created properly and could not be seen by Enterprise Manager.
> > Does this happen on other systems?
> >
> > I really can't afford the time to create the database again - it took
> > several hours to try to create this one - so I'm going to wipe 9i and use 8i
> > (8.1.7) instead.
> > I was able to install 8i and configure a database on another Win2k SP2
> > server in less time than 9i took to fail to create a database alone!
> > Evidently 9i still has issues and until a Service Pack (or updated version)
> > is released for it, I can't see myself using it (or recommending it) on
> > Win2k SP2.
> > Does anyone know if there is a new version in the pipeline?
> >
> > Laurence Mee.
Received on Fri Mar 22 2002 - 08:19:46 CST
