OraFAQ Forum: Server Administration » Upgrading from Standard to Enterprise

Home » RDBMS Server » Server Administration » Upgrading from Standard to Enterprise

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Upgrading from Standard to Enterprise [message #275414]

Fri, 19 October 2007 19:10

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

Report message to a moderator

Re: Upgrading from Standard to Enterprise [message #275416 is a reply to message #275414]

Fri, 19 October 2007 19:19

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Upgrading from Standard to Enterprise [message #275457 is a reply to message #275414]

Sat, 20 October 2007 08:26

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?

Report message to a moderator

Re: Upgrading from Standard to Enterprise [message #275461 is a reply to message #275414]

Sat, 20 October 2007 09:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can an RMAN backup suffice?
What happens when you try?

Report message to a moderator

Re: Upgrading from Standard to Enterprise [message #275465 is a reply to message #275457]

Sat, 20 October 2007 09:39

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Upgrading from Standard to Enterprise [message #275469 is a reply to message #275465]

Sat, 20 October 2007 10:03

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...

Report message to a moderator

Re: Upgrading from Standard to Enterprise [message #277086 is a reply to message #275414]

Sun, 28 October 2007 14:27

seethem
Messages: 41
Registered: September 2007

Member

Michael,anyone... any ideas?

Report message to a moderator

Re: Upgrading from Standard to Enterprise [message #277088 is a reply to message #277086]

Sun, 28 October 2007 14:34

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Upgrading from Standard to Enterprise [message #277089 is a reply to message #275414]

Sun, 28 October 2007 14:57

BlackSwan
Messages: 26766
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 04:37:35 CST 2024