During the BGOUG event I have discovered a lot of new features which should be tested and validated and this make me drive to install new version of Oracle 12cR2 :)
You can simple download - Oracle Database 12c Release 2 Enterprise Edition and Oracle Database 12c Release 2 Standard Edition from following link -> http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
In order to install Oracle Software there are requirement to install Linux or other supported OS/platform and configure as per the vendor pre-requisites
Very useful starting point for all required pre-requisites - https://oracle-base.com/articles/12c/oracle-db-12cr2-installation-on-oracle-linux-6-and-7
In the past days some of my colleagues just ask me... "Do you know where i can find Jan PSU for 11.2.0.4 database" ???
Hmm... Good question it should be in the Metalink.. BUT Oracle set "there's no database/GI PSU for this cycle", check the below Metalink
Will there be a Jan 2017 11.2.0.4 Database/Grid Infrastructure PSU? (Doc ID 2224560.1)
After a lot of work today, i try to get some time to share very short finding which is very useful in order to prevent the max process on ASM instance.
There was an issue with one of the newly created Oracle GI 12c - 12.1.0.2 due to massive migration and ASM instance report error ORA-00020: maximum number of processes. This problem lead to a lot of unnecessary communication for downtime in order to fix ASM instance by adding more processes :)
Prior starting the upgrade process our recommendation is to create RMAN full backup or GRP ( Guaranteed Restore Point )
Keep in mind that GRP is not supported solution in Standard Edition but with some tricks you will be able to use it ( check this post )
Required action:
- Create new Oracle Home with the new version 12.2.0.1
- Install only software of the new version 12.2.0.1 ( you can check how to do this in the related link )
- Install all required patches as per the recommendation from Oracle Metalink for the major version 12.2.0.1 ( you will be able to find in the related posts )
I am going to present a way how-to dowload Oracle Database 12c Standard Edition - 12.1.0.2
Maybe there is a question .. why i need to add such post? Normally it's should be simple, Go to Oracle Website and download or from Oracle Metalink Support....yes but no :)