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
Solved

Oracle Database Upgrade

Posted on 2016-10-21
13
72 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 500 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

839 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