RE: To Users of 9i

From: David Wagoner <dwagoner_at_arsenaldigital.com>
Date: Tue, 25 Sep 2001 07:41:24 -0700
Message-ID: <F001.00397AF8.20010925064527@fatcity.com>

We've been using 9i in production since August 20, 2001 on *one* of our databases. So far, we are happy with it and haven't had any recurring problems. However, that database doesn't require many of the new 9i features that could be bug-prone, so we have the advantage of gradual implementation of new features as they are time-tested. Here are my recommendations based on our short experience:

1. Be prepared to read several pounds of documentation, most importantly the Migration Guide.
2. Research the known 9i bugs and issues on MetaLink and the Oracle-L list:
3. Be sure to read the MetaLink doc on the upgrade/install bug. You have to set a parameter in init.ora before installation and then remove it afterwards.
4. We decided not to use the new Undo Tablespace feature of 9i based on a posting on this list in which someone encountered a corrupted Undo tablespace and had serious problems. Still using Rollback Segments until the Undo TS is more robust.
5. Someone reported corruption during export of a tablespace that used Label Security.
6. Say goodbye to Server Manager, say hello to logging in as "<USER> as sysdba" instead.
7. The 8.1.7 version of OEM that runs on Windows doesn't work with 9i databases, although the new OEM for Windows release is scheduled for today (25-SEP-01) according to Oracle. Apparently, this is not an issue for OEM running on Solaris.

Anyone else have anything to contribute to this list of 9i problems?

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-0755
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: Monday, September 24, 2001 7:45 PM To: Multiple recipients of list ORACLE-L

Friends :

Does anyone use the 9i database ?

Are you happy using it ?

Is it running ok ?

What kind of problem does it have ? Bugs ?

What do you think putting it in production environment ?

Regards

Eriovaldo

---

Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Eca Eca
  INET: ecaeser_at_hotmail.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). Received on Tue Sep 25 2001 - 09:41:24 CDT