RE: Some 9i Questions - Help!

"How the CIO Stole Christmas" ...

The Grinch would be jealous!

We upgraded a small-ish production database to 9i in August 2001 on Solaris 2.8. Took no more than 1.5 - 2 days as I recall. Much more time to read the manuals though. Look at this list's archive and MetaLink for bugs and gotchas. Overall, I've really enjoyed using 9i but I'm sure you can find some serious horror stories and gotchas to provide as evidence for waiting until after New Years to upgrade.

Happy Holidays.

david

David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110
Durham, NC 27703
Tel. (919) 941-4645
Fax (919) 474-0735
Email mailto:dwagoner_at_arsenaldigital.com Web http://www.arsenaldigital.com/  

• NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.

-----Original Message-----
Sent: Friday, November 30, 2001 12:52 PM To: Multiple recipients of list ORACLE-L

An edict just came down from our CIO that we should upgrade all our databases to 9i by the end of the year (he's decided it's important that we always be on the latest release of all software).

Aside from the fact that other than a small play database we haven't done any testing yet, aside from the fact that to do this I'd have to cancel all my holiday plans with friends and family to work every weekend in December
(probably plus Christmas and New Years) to meet this arbitrary deadline, I'm
still nervous about upgrading to such a relatively new release (I wasn't intending to consider it until late next year).

So, one question and one request.

1. When was 9i first released for Solaris (I haven't been able to find this information after poking around the Oracle website)?
2. Could anyone please post any 9i horror stories you've had? I know about the Managed Rollback Segment problem, but since that feature is optional it doesn't give me a lot of ammunition.

If this was a better job market I'd be contacting my headhunter right now.

Jay Miller

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Wagoner
  INET: dwagoner_at_arsenaldigital.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).