Re: migriate the oracle9204 throught copying datefile between different linux.

yoke wang wrote:
> > Regrettably this is NOT true. All database files are O/S dependent.
> > consequently a platform swap requires the exp/imp juggle.
> >
> > The O/P will fail miserably thanks to your advice.
>
> But I don't think RedFlag DC Server4.1(2.4.21-9.30AX
> smp) and RedHat Advanced Server3.0(update 3 kernel 2.4.21-20 smp) are
> two different OS in essential.It just likes the relationship of
> Redhat9 and Redhat Advanced Server.
> The only differece is the kernel,and I installed oracle9204 with
> the same install disks(both using gcc 296).And the datafiles are on a
> ext3 filesystem on the Disk Array.
> I want to know how many risk for this case and what they are on
> earth.
> BTW,Must I reintall the oracle if I upgrade the kernel?
>
> Thanks.

Not sure which part of the posts upstream you don't understand,

1. Datafiles are OS dependant.
2. You can copy datafiles across ONLY if you know that OS and Oracle versions are identical.
3. If you are not sure then do the full export/import. It's not a difficult process... really.

It seems like you want someone in this NG to give blessings to your adventure.

Take Frank's advise. If you are asking about these things... then you should not be administering the move.

Regards
/Rauf Received on Thu Apr 07 2005 - 04:00:57 CDT