Re: 9i Windows 2000 Server to Linux Migration
- From: Sha - Apps DBA <orasharad@xxxxxxxxx>
- To: M K Jain <mahendrabjain@xxxxxxxxx>
- Date: Tue, 27 Jul 2010 13:09:29 +0530
Hi Mahendra,
Thanks for your reply.
In your migration,
1. Did you also migrated the database on different OS.
2. Is there any precaution we need to take when we are importing the dmp
file created in windows server.
3. Was there any issue when you imported the dmp file created in 9i to 10g.
Please also share if any other issue you have faced.
Regards,
SHA
On Mon, Jul 26, 2010 at 9:14 PM, M K Jain <mahendrabjain@xxxxxxxxx> wrote:
> I have migrated DB from 9i to 10g on RAC and followed these steps
>
>
> 1. Take export of only required schemas from 9i and copy .dmp to linux
> server using SCP
> 2. Identify tablespaces and size being used by the schemas in 9i
> 3. Install and bring up the RAC instance (Preferable ASM)
> 4. Disable archivelog (if enabled)
> 5. Create tablespaces in RAC DB
> 6. Create schemas in RAC DB, giving quotas on tablespace
> 7. Import the schemas.
> 8. Enable archivelog (if required)
>
>
> Thank&Regards,
> Mahendra B Jain
>
> ----- Original Message -----
> *From:* Sharad Nautiyal <orasharad@xxxxxxxxx>
> *To:* oracle-l@xxxxxxxxxxxxx
> *Sent:* Monday, July 26, 2010 3:13 PM
> *Subject:* 9i Windows 2000 Server to Linux Migration
>
> Hi All,
>
> We have Oracle 9.2.0.8 running on Windows 2000 server and our plan is to
> migrate it to Linux Server also upgrade it to 10g with RAC.
>
> Please let me know if anyone has already done it.
>
> We are planning to perform below steps :
> 1. Take export of 9i database from windows 2000 server.
> 2. scp the dmp file to Linux Server.
> 3. lay down Oracle 10g binaries for RAC on Linux.
> 4. Bring up only one node in non-RAC mode.
> 5. Then import the 9i dmp file on Linux on 10g Oracle home.
> 6. Bring up the database in non-RAC mode. Check all the schemas.
> 7. Enable RAC.
>
> Please let me know about your opinion on the plan described above with
> consequences.
>
> Thanks,
> Sha
>
>
Other related posts:
