Home » RDBMS Server » Server Administration » Need help in migrating Oracle database from windows 2003 server to 2012 server (Windows server 2003, Oracle database 9i)
Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644077] Wed, 28 October 2015 00:36 Go to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
Hi,

My environment is oracle database 9i in windows server 2003, Since windows 2003 support is ended We want to move it to Windows 2012.

Please give me a plan, Which step need to do first database upgrade or windows upgrade, What are the things need to be consider in Oracle database level ?

Any help would be much appreciated.

Thanks,
Viswa
Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644083 is a reply to message #644077] Wed, 28 October 2015 01:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No database upgrade, export the database, create your new server with the new version of OS and Oracle, create a new database and import the dump.

Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644084 is a reply to message #644083] Wed, 28 October 2015 01:41 Go to previous messageGo to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
But 9i database is not supported in Windows server 2012 right? So we need to install a 11g database software and create a new database and import the full 9i database using impdp in newly created Windows 2012. Am i right ?

Thanks,
Viswa

[Updated on: Wed, 28 October 2015 01:47]

Report message to a moderator

Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644086 is a reply to message #644084] Wed, 28 October 2015 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No.
You export your 9i database using exp and import it using imp in a new 11gR2 database.

Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644088 is a reply to message #644086] Wed, 28 October 2015 02:11 Go to previous messageGo to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
Yes , What are the thing need to considered when doing import in 9i database I mean the options in impdp. And Is this recommended to do in production?

Thanks,
Viswa
Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644089 is a reply to message #644088] Wed, 28 October 2015 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

There is NO impdp in 9i and you do NOT import in 9i database.

Quote:
And Is this recommended to do in production?


You must FIRST test on a test server.

The steps are simple (assuming you do not change the server which seems to me highly risky):
1/ export 9i database with exp
2/ upgrade the OS
3/ install 11gR2 Oracle
4/ create a 11gr2 database
5/ import the dump generated in 1/ with imp into the new database
6/ drop all objects related to 9i database

[Updated on: Wed, 28 October 2015 02:15]

Report message to a moderator

Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644090 is a reply to message #644089] Wed, 28 October 2015 02:19 Go to previous messageGo to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
Sorry I meant to say expdp instead i typed impdp.

Ok So datapump is not available in 9i we have to do full database import using imp in source 9i database.

And one general question: If we can do migrate database objects over different versions of databases what is the point of upgrading databases ? In all the upgrade scenarios we can do export and import right?

Thanks,
Viswa

[Updated on: Wed, 28 October 2015 02:23]

Report message to a moderator

Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644092 is a reply to message #644090] Wed, 28 October 2015 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Bugs fixed, improvement of optimizer, new features, support...

Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644093 is a reply to message #644092] Wed, 28 October 2015 02:35 Go to previous messageGo to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
Thanks, In my case if I want to upgrade the database as well what will be the steps to follow?

Thanks,
Viswa
Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644094 is a reply to message #644093] Wed, 28 October 2015 02:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why do you want this?

Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644095 is a reply to message #644094] Wed, 28 October 2015 02:41 Go to previous messageGo to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
As you said I want to use the new features and utilize oracle support as well.

Thanks,
Viswa
Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644096 is a reply to message #644095] Wed, 28 October 2015 02:45 Go to previous messageGo to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
Scope of the project is Some of our Customers is moving from Windows server 2003 to Windows server 2012. If they have installed oracle databases in their windows we need to guide them about Oracle things. Our customers might not have DBA's with them

Thanks,
Viswa
Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644098 is a reply to message #644095] Wed, 28 October 2015 02:53 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
viswanatheee55@gmail.com wrote on Wed, 28 October 2015 07:41
As you said I want to use the new features and utilize oracle support as well.

Thanks,
Viswa


I do not understand what did you mean. However, you should consider:

1- If there is an installed Oracle 11gr2 on the new OS - Windows new version, must use Emport utility from 9i, export whole database or all of user schemas, then, use Import utility from 11gr2 on the new OS, to import database or all of user schemas into.

2- If there is not an installed Oracle 11gr2 on the new OS-Windows new version. You might to upgrade Oracel 9i to 11gr2, but remember: Oracle does not support directly upgrade from 9i to 11gr2. So that, if you want to do this progression tasks, you must upgrade from 9i to 10gr2 (with at-least 10.2.0.4 patchset), then, continue to upgrade 10.2.0.4 to 11.2.0.x. RMAN is the best utility in this scenario.

So, let do the examine:
+ How many datafile from 9i?
+ How much size of datafile from 9i?
+ How many user schema in 9i Database exists?

If your 9i database is small (less than 400gb, including system, sys, .. datafiles size), Import/Export utility is the best choice option.
If your 9i database is big (more than 500gb), so, you can do the upgrade 2 tasks (9i -> 10g, 10g ->11g).
If your 9i database has got many java resources built in, complicated processing from another Database, consideration carefull.

Regards!

[Updated on: Wed, 28 October 2015 02:55]

Report message to a moderator

Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644099 is a reply to message #644098] Wed, 28 October 2015 02:58 Go to previous messageGo to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
If your 9i database is big (more than 500gb), so, you can do the upgrade 2 tasks (9i -> 10g, 10g ->11g).

I will go with your plan 2

So the upgrade has to be done in Windows server 2003 and take a backup then clone the database to upgraded Windows server 2012. Please correct me if I am wrong.

Thanks,
Viswa

[Updated on: Wed, 28 October 2015 03:08]

Report message to a moderator

Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644100 is a reply to message #644099] Wed, 28 October 2015 03:08 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
viswanatheee55@gmail.com wrote on Wed, 28 October 2015 07:58

So the upgrade has to be done in Windows server 2003 and take a backup then clone the database to upgraded Windows server 2012.

Thanks,
Viswa


Remember: Always do the test before.

- Backup full Database 9i
- Restore in the new server with new installed 10gr2 (upgraded patchset 10.2.0.4). Using Database Upgrade option to upgrade 9i to 10g. Post completion requirement tasks.
- Backup full database 10g.
- Restore into the new server with new installed 11gr2 (ASM, Grid Infrastructure). Using Database Upgrade option to upgrade from 10g to 11gr2. Post completion requirement tasks.

Good luck!


Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644101 is a reply to message #644100] Wed, 28 October 2015 03:11 Go to previous messageGo to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
Restore in the new server in sense, Can you bit explain more
Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644102 is a reply to message #644101] Wed, 28 October 2015 03:12 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
I assume there are 2 seperate servers (same platform, same OS) in this case.
Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644103 is a reply to message #644102] Wed, 28 October 2015 03:15 Go to previous messageGo to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
No we have a Windows server 2003 with 9i database, Task is to upgrade 2003 to Windows server 2012. 9i is not supported in Windows server 2012, So we want to upgrade the database as well.

Thanks,
Viswa
Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644104 is a reply to message #644103] Wed, 28 October 2015 03:19 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
If there is only one server in case, you must do carefully.

Take an full backup, copy thoses backupset into the other media, then, install new ORACLE_HOME into seperate directories. Upgrade Oracle before upgrade OS.
I were not you, then, I were not be in your case. All of words can be told: Always has got a full backup.

Good luck!
Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644105 is a reply to message #644104] Wed, 28 October 2015 03:25 Go to previous messageGo to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
Yes we will definitely take a full backup in separate disk.

If the windows server 2003 is 32 bit, Windows Server 2012 supports only 64-bit processor architectures. A server running 32-bit processors is not supported.

After upgraded to 64 bit Windows server 2012, Will the clone from backup (taken from 32 bit 2003 11g upgraded database) works?

Thanks,
Viswa
Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644108 is a reply to message #644105] Wed, 28 October 2015 04:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Once again use export/import and you will not have any problem.
If you don't want to do this then you need to hire someone more skilled to safely do it, you will not be able to do it.

Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644109 is a reply to message #644108] Wed, 28 October 2015 04:21 Go to previous messageGo to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
Anyway I am not going to do. I just want to know how?
Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644110 is a reply to message #644109] Wed, 28 October 2015 04:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Given your level this will waste hours for us to explain you in details until you understand it will work.
This wasted time will not be spent for others who really need help and not ask just by curiosity.
If you want to know it then study the documentation, make tests and tests and then publish how you succeeded to make it. Smile

Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644111 is a reply to message #644110] Wed, 28 October 2015 04:36 Go to previous messageGo to next message
viswanatheee55@gmail.com
Messages: 15
Registered: October 2015
Location: Chennai
Junior Member
Thanks Michel.
Re: Need help in migrating Oracle database from windows 2003 server to 2012 server [message #644120 is a reply to message #644096] Wed, 28 October 2015 06:49 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
viswanatheee55@gmail.com wrote on Wed, 28 October 2015 08:45
Scope of the project is Some of our Customers is moving from Windows server 2003 to Windows server 2012. If they have installed oracle databases in their windows we need to guide them about Oracle things. Our customers might not have DBA's with them

Thanks,
Viswa


Gosh, that doesn't sound promising ... it would be fair if you just tell them that you don't know how to do that. They will, of course, pay for your services, expecting that you know what you are doing. Obviously, you don't. Aren't you afraid, at least a little bit? I wouldn't dare to mess up someone's database, but hey, that's me. Maybe you're bolder than me, or (as our people use to say) dumber than me. Can't decide.
Previous Topic: setup consolidation
Next Topic: ORA-38802: edition does not exist
Goto Forum:
  


Current Time: Thu Mar 28 12:30:42 CDT 2024