Re: Migration:- Solaris 9.2.0.4 to 10.2.0.3
- From: "Jeffery Thomas" <jeffthomas24@xxxxxxxxx>
- To: david.cheyne@xxxxxxxxx
- Date: Fri, 1 Aug 2008 09:25:16 -0400
David --
Not quite identical to your scenario, but we just migrated a number of
databases from
Solaris 9 9.2.0.4 to Solaris 10 10.2.0.3. No major issues, but we
did run into a little
puzzler dealing with tables that contained columns that were
encrypted via DBMS_OBFUSCATION_TOOLKIT.
If these tables were part of a full export, the encrypted columns
would always come with varying and erroneous lengths that were not a
multiple of 8 bytes. We had to export/import these tables
individually and that worked fine.
We double-checked NLS_LANG on the import/exports, validated the data
for correct lengths in the source database and so forth - but could
not find a reason why a full export would fail but the individual
export would succeed.
We were able to reproduce this issue but as we had a fix, never did
raise a S/R for it.
Jeff
On Fri, Aug 1, 2008 at 7:15 AM, David cheyne <david.cheyne@xxxxxxxxx> wrote:
> Hi List,
>
> I'm in the throws of migrating a live system. We are updating our Sun boxes
> to v445's with Solaris 10 (coming from 8) and at the same time from 9i to
> 10g. I was wondering about a full import option to move the data, the DB is
> about 50Gb, so I don't think it's worth dragging it through datapump.
>
> I've imported a single schema (the applications data) into a 10g instance
> for testing; this worked fine. The main issues are in-house developments
> based around the live data. Developers have created tables, synonyms, views
> and database links (coming in from elsewhere) in their own schema, all of
> which accesses objects in the main schema; so plenty of scope for missing
> permissions synonyms and of course . . . tantrums! The people have also put
> tables and packages into the main schema (yes I know!) these again could be
> an issue, as they tend to access the developers own schema.
>
> SO after all of that mess, I think a one shot FULL import would be easier
> than trying to pick my way through that little lot. I intend to drop the
> two application schemas and reuse the already created instance for this.
>
> Does anybody know of issues with full imports from: Solaris 8 - 9.2.0.4 to
> Solaris 10 - 1.0.2.0.3? Or even problems afterwards. We do have problems
> importing tables with LOB's in but that is a known issue.
>
> Thanks for reading.
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~
> David Cheyne
> BA(hons.)
> Oracle Database Administrator
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
