OraFAQ Forum: Linux » upgrading database to 11gR2

Home » Infrastructure » Linux » upgrading database to 11gR2 (Oracle 11.1.0.6.0, OEL 5)

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

upgrading database to 11gR2 [message #596287]

Thu, 19 September 2013 22:30

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?

Report message to a moderator

Re: upgrading database to 11gR2 [message #596291 is a reply to message #596287]

Fri, 20 September 2013 01:10

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

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

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?

Report message to a moderator

Re: upgrading database to 11gR2 [message #596500 is a reply to message #596496]

Tue, 24 September 2013 01:13

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

Senior Member
Account Moderator

Quote:

what patch file i need to apply

Search on MOS for "time zone patch".

Report message to a moderator

Re: upgrading database to 11gR2 [message #596507 is a reply to message #596500]

Tue, 24 September 2013 04:44

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?

Report message to a moderator

Re: upgrading database to 11gR2 [message #596511 is a reply to message #596507]

Tue, 24 September 2013 05:05

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

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.

Report message to a moderator

Re: upgrading database to 11gR2 [message #596515 is a reply to message #596511]

Tue, 24 September 2013 05:12

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?

Report message to a moderator

Re: upgrading database to 11gR2 [message #596522 is a reply to message #596515]

Tue, 24 September 2013 06:06

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

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.

Report message to a moderator