Solved

Oracle Database Upgrade

Posted on 2016-10-21
13
42 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 76

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 76

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
 

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 76

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

 
LVL 76

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 76

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 76

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 76

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

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.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

759 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now