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)
Patch 10.1 to 10.2 - just an RDBMS upgrade or import/export required? [message #296825] Tue, 29 January 2008 03:20 Go to next message
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
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 Go to previous messageGo to next message
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]

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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
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 Go to previous messageGo to next message
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?
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 Go to previous message
Michel Cadot
Messages: 64152
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
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:
  


Current Time: Sat Dec 10 11:07:48 CST 2016

Total time taken to generate the page: 0.12562 seconds