Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 103
  • Last Modified:

Oracle Database Upgrade

Can anyone provide steps to upgrade manually from Oracle Database 12.1.0.1 to Oracle 12.1.0.2?
0
lium1
Asked:
lium1
  • 7
  • 6
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
lium1Author Commented:
SlightWV, where is that documentation?
0
 
slightwv (䄆 Netminder) Commented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
lium1Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
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
 
lium1Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
>>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
 
slightwv (䄆 Netminder) Commented:
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
 
lium1Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
>>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
 
lium1Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
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
 
lium1Author Commented:
Thanks slightwv!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now