Home » Infrastructure » Linux » upgrading database to 11gR2 (Oracle 11.1.0.6.0, OEL 5)
upgrading database to 11gR2 [message #596287] Thu, 19 September 2013 22:30 Go to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi Michel, how to upgrade oracle database from 11.1.0.6.0 version to 11.2.0.2.0, iam having already a database in version 11.1.0.6.0, what will be the steps? will i have to install Oracle 11gR2(in parallel to 11gR1 oracle home) first using runInstaller?
icon10.gif  Re: upgrading database to 11gR2 [message #596291 is a reply to message #596287] Fri, 20 September 2013 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just follow the Upgrade Guide.

Regards
Michel

[Updated on: Fri, 20 September 2013 01:12]

Report message to a moderator

Re: upgrading database to 11gR2 [message #596496 is a reply to message #596291] Tue, 24 September 2013 00:20 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi Michel, Iam trying upgradation using dbua, after installing 11.2.0.1.0, it's prompting for time-zone is in old version, and corresponding to do patching after upgradation, what patch file i need to apply, or, it's asking for updating time_zone using DBMS_DST package, what kind of steps needed to be executed after upgradation?
icon2.gif  Re: upgrading database to 11gR2 [message #596500 is a reply to message #596496] Tue, 24 September 2013 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
what patch file i need to apply


Search on MOS for "time zone patch".

Re: upgrading database to 11gR2 [message #596507 is a reply to message #596500] Tue, 24 September 2013 04:44 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
is that possible to apply direct upgradation from 11.2.0.1.0 to 11.2.0.3.0 without applying patches & PSU's?
icon5.gif  Re: upgrading database to 11gR2 [message #596511 is a reply to message #596507] Tue, 24 September 2013 05:05 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The upgrade is applying a patch in itself (although not through OPatch), so I don't know what to answer. Wink
Yes, you can upgrade from 11.2.0.1 to 11.2.0.3 without other patch... unless the installer requires some.

Re: upgrading database to 11gR2 [message #596515 is a reply to message #596511] Tue, 24 September 2013 05:12 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi Michel, look at these zip-files, are they 'runInstaller' files when extracted?

for #11.2.0.2
p10098816_112020_Linux-x86-64_1of7.zip
p10098816_112020_Linux-x86-64_2of7.zip

for #11.2.0.3
p10404530_112030_Linux-x86-64_1of7.zip
p10404530_112030_Linux-x86-64_2of7.zip

how to download the above zip files?

icon2.gif  Re: upgrading database to 11gR2 [message #596522 is a reply to message #596515] Tue, 24 September 2013 06:06 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

They are full delivery of Oracle rdbms (you should have 7 files for each as their names say) and, yes, they must be installed using the installer which is packed in them.
Note that you do not need to install 11.2.0.1 or 11.2.0.2 to install 11.2.0.3.


Re: upgrading database to 11gR2 [message #596581 is a reply to message #596522] Wed, 25 September 2013 00:56 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi Michel, Are those zip-files available only through Metal-link?

icon14.gif  Re: upgrading database to 11gR2 [message #596584 is a reply to message #596581] Wed, 25 September 2013 01:29 Go to previous message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes.
Previous Topic: about Neat command failure in linux
Next Topic: sda7 is 100% used
Goto Forum:
  


Current Time: Sat Aug 02 03:10:53 CDT 2014

Total time taken to generate the page: 0.08629 seconds