RE: Upgrade to 10G from 9i best practices

Hey Abraham,

While not a "best practices" list, I do have a list of potential "gotchas" that I wasn't aware of before tackling 10.2.0.2.0. Here's the shortlist of what I have so far, based on what I've seen on AIX:

• Performance issues for ALL_SYNONYMS. See Metalink notes 377037.1 and 364822.1.
• Add parameters to listener.ora and sqlnet.ora on the DB server as per Metalink 345197.1 to avoid ORA-3136 errors in alert log.
• Metalink note 392673.1: SQL can execute in wrong schema -- DANGER!!!!
• Add SUBSCRIBE_FOR_NODE_DOWN_EVENT_lsnrname=OFF in listener.ora to prevent "WARNING: Subscription for node down event still pending" messages in listener's logfile.
• Need to manage the Recycle Bin (e.g. invalid object queries).
• Why the errors in $ORACLE_HOME/log/{nodename}/css.log? No cluster, no RAC, no daemon is running.
• BUG 5089217 o Causes some hierarchical queries to ORA-600 with [qkacon:NFswrwo] (generic form is [qkacon:xxxxxxx]) o Workaround is to alter system set "_optimizer_connect_by_cost_based" = false
• BUG 4239737 o Abstract: ORA-600 [KGHSTACK_FREE1] when adding multiple tempfiles to temp tablespace. o Workaround: add one tempfile at a time. o Workaround test is pending recreation of migration DB.

I'm adding to it almost every day. The last one is an open SR for us yet, but I'm fairly confident the workaround will work for us once I get the chance to test it.

HTH! GL! Rich

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Guerra, Abraham J Sent: Thursday, November 16, 2006 2:21 PM To: oracle-l_at_freelists.org
Subject: Upgrade to 10G from 9i best practices

Hello all,

This Tuesday I'm planning to test my first upgrade from 9i (9.2.0.7) to 10g (10.2.0.2) in HPUX. Is there a best practice out there that I should look into or just follow DBUA?

Thanks in advance,

Abraham Guerra
Oracle DBA
American Family Insurance

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l