OraFAQ Forum: Server Administration » Patch 10.1 to 10.2 - just an RDBMS upgrade or import/export required?

Home » RDBMS Server » Server Administration » Patch 10.1 to 10.2 - just an RDBMS upgrade or import/export required? (Oracle 10.1.0.1 on Solaris)

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

Patch 10.1 to 10.2 - just an RDBMS upgrade or import/export required? [message #296825]

Tue, 29 January 2008 03:20

n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris

Member

Hi,

I've got to upgrade a couple of 10.1.0.1 databases to 10.2.0.3

I was wondering if this upgrade would require an import/export of the databases, or if it just requires an upgrade of the RDBMS after the patch are applied?

Thanks in advance

Nicolas

Report message to a moderator

Re: Patch 10.1 to 10.2 - just an RDBMS upgrade or import/export required? [message #296840 is a reply to message #296825]

Tue, 29 January 2008 04:03

mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai

Member

1. Export/Import across databases
2. Patching
3. Upgradation

All three are different process having different purposes. It is normally much safe to go for upgradation when moving across different releases of databases. Patching across releases should be avoided as far as possible.

Regards

Manjit Kumar [mkbhati]

Report message to a moderator

Re: Patch 10.1 to 10.2 - just an RDBMS upgrade or import/export required? [message #296868 is a reply to message #296825]

Tue, 29 January 2008 06:40

n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris

Member

Hi Manjit,

thanks for the reply.

Can you tell me what difference you make between upgradation and patching?

thanks again,

Nicolas

Report message to a moderator

Re: Patch 10.1 to 10.2 - just an RDBMS upgrade or import/export required? [message #296882 is a reply to message #296868]

Tue, 29 January 2008 07:03

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Upgradation when you change the version, patching when you apply a pacth or patchset.

Regards
Michel

Report message to a moderator

Re: Patch 10.1 to 10.2 - just an RDBMS upgrade or import/export required? [message #296884 is a reply to message #296825]

Tue, 29 January 2008 07:05

n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris

Member

Ok.

So, in 10.1 from 10.2 it's an upgrade and I should perform an export/import

From 10.2.0.2 to 10.2.0.3 it's a patch and export/import is not required.

Is that right?

Report message to a moderator

Re: Patch 10.1 to 10.2 - just an RDBMS upgrade or import/export required? [message #296893 is a reply to message #296884]

Tue, 29 January 2008 07:18

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is right but in first case you can also use upgrade assistant (dbua).

Regards
Michel

Report message to a moderator

Previous Topic:	Metrics "Database Time Spent Waiting (%)" is at 49.71505 for event class "Network&quo
Next Topic:	Create DB using commands instead of DBCA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 20:01:39 CDT 2024