Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Oracle Database Upgrade

Posted on 2016-10-21
13
Medium Priority
?
96 Views
Last Modified: 2016-10-25
Can anyone provide steps to upgrade manually from Oracle Database 12.1.0.1 to Oracle 12.1.0.2?
0
Comment
Question by:lium1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 41854618
I've found the steps provided in the provided documentation to be pretty simple to follow.

There should be a readme or html file included that will have the necessary steps.
0
 

Author Comment

by:lium1
ID: 41859096
SlightWV, where is that documentation?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 41859098
When you downloaded the patch/patchset/??? and unzipped/untarred/???  There should be a README or install.htm file or something similar.

There should also be installation instructions on the Oracle Support site where you downloaded the patch.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

Author Comment

by:lium1
ID: 41859111
slightwv, I am looking for documentation/steps to upgrade Oracle Database version 12.1.0.1 to 12.1.0.2. Not for patching, just for upgrading in GI Oracle RAC.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 41859121
12.1.0.1 to 12.1.0.2 might be a complete release.  It might not be.  I don't know.

Exactly what did you download to get the 12.1.0.2 files?
0
 

Author Comment

by:lium1
ID: 41859160
I haven't download 12.1.0.2 files. Perhaps, I am not explaining very well. I am trying to upgrade the current version 12.1.0.1 to 12.1.0.2 and I need some document and steps to follow.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 41859206
>>I haven't download 12.1.0.2 files

OH, that explains why you cannot locate the readme/install guide.

You will need to log into Oracle Support and locate the correct software for your OS.  My guess is that 12.1.0.2 will be a patchset.

Once you get that, it should come with the installation guide I've been mentioning.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 41859224
I just searched and it looks like 12.1.0.2 is patchset number 21419221.

Once in Oracle Support click the patch for your OS and you will see a README file that should have the installation instructions.
0
 

Author Comment

by:lium1
ID: 41859282
It is not about applying a patch set for 12.1.0.2. It is to upgrade from 12.1.0.1 to 12.1.0.2.
Below is the link that I got it from creating Service Request to Oracle to Upgrade GI Home to 12.1.0.2.

https://docs.oracle.com/database/121/CWLIN/procstop.htm#CEGFEAEF

And for Database upgrade, follow the note ( Doc ID 1932762.1 ). If it is upgrading a cluster database, then need to modify the SPFILE or initORACLE_SID.ora files.set the CLUSTER_DATABASE initialization parameter to false. After the upgrade, set this initialization parameter back to true.

I am looking for something other that what I was provided by Oracle Support.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 41859299
>>It is not about applying a patch set for 12.1.0.2.

12.1.0.2 is considered a patch set when looking for the software.  That is the only way to get the binaries to do the install.  There is no "Download 12.1.0.2 here" link other than looking for the patchset.

When you get the correct binaries, it comes with the installation guide that has the necessary steps.

>>from creating Service Request to Oracle to Upgrade GI Home to 12.1.0.2.

OK, it looks like they pointed you to the documents to perform the upgrade.

>>I am looking for something other that what I was provided by Oracle Support.

That documentation will be the best method to follow.

If you want a copy/paste set of steps to blindly follow, good luck.  You may find some steps on the Internet that others have followed but if you just use those, you can get into a lot of trouble with things not going exactly right.  Not every Oracle install is exactly the same so what works for one installation may not work in another.

You need to understand your system and then perform the necessary steps in the Oracle provided documentation.

If you are uncomfortable with that, you might look at hiring a local Consultant to come in and assist you with the upgrade.
0
 

Author Comment

by:lium1
ID: 41859356
Are you talking about the documentation the best method to follow be the one provided by Oracle to me or the one you suggested patchset number 21419221?
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 41859362
There should be a specific install guide that comes with the download.

Unfortunately, if you log into Oracle Support and look at the README for that patchset you get:
7 Installation and Upgrade

Review Oracle Database Readme and your platform-specific Oracle Database Release Notes before installing Oracle software. For new installations, refer to the appropriate installation guide for the product you are installing.

See "How to Upgrade to Oracle Grid Infrastructure 12c Release 1" in Oracle Grid Infrastructure Installation Guide for details about performing Oracle Clusterware and Oracle Automatic Storage Management upgrades. See Oracle Database Upgrade Guide for complete information about planning and executing Oracle Database upgrades.

Oracle installation guides and release notes for each platform, the readme, and the upgrade guide are available at

Looks like the link Oracle Support provided you in the SR is pretty much what you get.
0
 

Author Closing Comment

by:lium1
ID: 41859384
Thanks slightwv!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question