RE: Upgrade to 10G from 9i best practices
- From: "Jesse, Rich" <Rich.Jesse@xxxxxx>
- To: <AGUERRA@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Nov 2006 15:36:30 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Guerra, Abraham J
Sent: Thursday, November 16, 2006 2:21 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
