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:
a. 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.
b. 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.
c. Someone reported corruption during export of a tablespace that used Label
Security.
3. Say goodbye to Server Manager, say hello to logging in as "<USER> as
sysdba" instead.
4. 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:[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
