Home » RDBMS Server » Server Administration » Upgrading from Standard to Enterprise
Upgrading from Standard to Enterprise [message #275414] Fri, 19 October 2007 19:10 Go to next message
seethem
Messages: 41
Registered: September 2007
Member
I have a database in 10.2.0.1.0 standard.
I want to go to 10.2.0.3.0 enterprise.

Is export/import the only way to achieve this?


Phillip Lewis
Re: Upgrading from Standard to Enterprise [message #275416 is a reply to message #275414] Fri, 19 October 2007 19:19 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
>Is export/import the only way to achieve this?
I don't think so.
I'd create a new ORACLE_HOME using the EE version.
Shutdown the DB, change ORACLE_HOME variable, & start the DB.
Re: Upgrading from Standard to Enterprise [message #275457 is a reply to message #275414] Sat, 20 October 2007 08:26 Go to previous messageGo to next message
seethem
Messages: 41
Registered: September 2007
Member
Ok the bigger picture is that we want to migrate the environment to another server.

Can an RMAN backup suffice?
Re: Upgrading from Standard to Enterprise [message #275461 is a reply to message #275414] Sat, 20 October 2007 09:15 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
>Can an RMAN backup suffice?
What happens when you try?
Re: Upgrading from Standard to Enterprise [message #275465 is a reply to message #275457] Sat, 20 October 2007 09:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

the bigger picture is that we want to migrate the environment to another server.

And this is of course a too tiny information that does not worth you give us in the first post.

Regards
Michel
Re: Upgrading from Standard to Enterprise [message #275469 is a reply to message #275465] Sat, 20 October 2007 10:03 Go to previous messageGo to next message
seethem
Messages: 41
Registered: September 2007
Member
Point taken!

Please accept my apologies:

Background Information
=============================
* Currently the database is on Server A. [See the specs for server A below please.]
* We are interested in moving it to a RAC environment, Infrastructure 2. [Please see the specs for Infrastructure 2 below]
* The database has scores of tablespaces by design --> Actually, it is the database to support PeopleSoft Financials


Server A:
==============
* Single Node Oracle 10.2.0.1.0
* Standard edition
* windows enterprise x32 bit


Infrastructure 2:
=======================
* 2-node Oracle Rac 10.2.0.3.0
* Enterprise edition
* Windows enterprise x64 bit
* Other Oracle databases reside here.
* Purpose: Driving a DB Consolidation Initiative


Question
============
* What is the best method to migrate this environment?


I hope this posting was more lucid. I will work on being more transparent.

Cheers...
Re: Upgrading from Standard to Enterprise [message #277086 is a reply to message #275414] Sun, 28 October 2007 14:27 Go to previous messageGo to next message
seethem
Messages: 41
Registered: September 2007
Member
Michael,anyone... any ideas?
Re: Upgrading from Standard to Enterprise [message #277088 is a reply to message #277086] Sun, 28 October 2007 14:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
expdp/impdp or rman duplicate (but I'm not sure of this latter as you change your word size, of course the documentation says if this is possible and a quick look to restrictions on duplicate gives the answer in less than a minute).

Regards
Michel
Re: Upgrading from Standard to Enterprise [message #277089 is a reply to message #275414] Sun, 28 October 2007 14:57 Go to previous message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
>What is the best method to migrate this environment?
"BEST" is a function of what criteria is important to your organization.

The switch between 32 bit & 64 bit is documented in a Metalink Note.
Sorry that you'll have to Search for this note as I don't have its number memorized.

As I discovered from 1st hand experience, the DB will open after being cloned between different architectures; but throws errors when trying almost anything that worked previously.

I found the Note by using the errors as Search criteria in Metalink.

I suspect that you won't need to follow this Note if you use exp/imp.

So as always, there are trade offs. Pick your poison.

[Updated on: Sun, 28 October 2007 14:59] by Moderator

Report message to a moderator

Previous Topic: USER PRIVS Migration from 9i to 10g
Next Topic: Initialization Parameters {Dynamic / Static List}
Goto Forum:
  


Current Time: Mon Dec 05 07:04:12 CST 2016

Total time taken to generate the page: 0.12667 seconds