Yoseph,
As with any major migration, there may be problems. You should test both the
migration process itself and all applications before you attempt to run the
migration proper. Testing is critical and all too often ignored. Get you
application users to test their own apps on the new environment and sign off
that it all works OK. If they are not ALL happy, don't migrate. With that
many apps, you may be better of phasing them over to the new system rather
than running a big bang, if the apps structure allows this.

LMT's are fine on 10G (as indeed they are on 9i). For RAC, you should also
use SEGMENT SPACE MANAGEMENT AUTO for all tablespaces so you don't need to
use freelists/freelist groups (this is for better performance). UNIFORM
extent size is also a good move to avoid unusable space in tablespaces
(fragmentation). The large block sizes are not a risk.

For the data migration, export/import will do the job, but you can use the
migration to restructure that database if you wish (move tables/indexes
between tablespaces/new tablespaces/etc)... all the stuff you put off due to
the long outage that may be required!

Try to build the schemas in advance of the migration, and then import with
"ignore=y" to bypass the "table already exists" errors.

You may also want to look at pulling the data over a database link for
relatively small tables (insert as select)

I had a few issues with packages not compiling under 10G. There are some
"error conditions" that used to be ignored but no longer are in 10G, so you
may need a few package corrections (maybe procedures too), but you will need
to try them out to confirm. I had three out of 1000 packages I needed to
revise and another I rewrote completely (something I had actually wanted to
do for ages...opportunity presents itself!).

You may get no issues or different issues. Decent testing will reveal the
problems, most of them anyway!

HTH
John.



-----Original Message-----
From: YIF [mailto:oracledba-ezmlmshield-x20455003.[Email address protected]
Sent: 29 April 2006 07:50
To: LazyDBA Discussion
Subject: Migrating from oracle 9i to 10g Cluster

Dear All
I'm in the process of upgrading our Oracle 9i Standalone database to
Oracle 10R2 RAC.
Has anyone upgraded to 10g and had some issues, one of my plans is to go
with Locally Managed Tablespaces.
large Block Size.
Export from 9i and Import it in the new 10g Cluster

We have 32 applications using our existing database, those apps heavily
using Packages ,Stored Procedures, Functions and Triggers.
Will there be any migration issues on 10g.

Any input will be highly appreciated

Regards




///\\
(@ @)
+--oOO--(_)--Ooo--+
|Yoseph I Fahed|
+-----------------+
|__|__|
|| ||
ooO Ooo




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.

Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.

SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.


Oracle LazyDBA home page