Oracle Database Migration from non-cdb to pdb - components issue
We decide to create a new CDB container instance with version 12.2.0.1 in order to plug into non-cdb database which is converted to pdb.
The task is very simple, we have to create a new pluggable database with NOCOPY option due to the fact that all data files are in place and we don't need to use COPY option because all datafiles are on the correct location.
Preliminary information:
AIX OS
Oracle 12.2 GI infrastructure
Oracle 12.1 Database as Primary with two instances as RAC
AIX OS
Oracle 12.1 Database as Physical Standby database with a single instance on Oracle Restart - ASM
This is what customer consider as an option for DR and I am not going to comment!
Error:
ORA-16598: Oracle Data Guard broker detected a mismatch in configuration
Purpose of this post is to share how you can debug ONS - FAN events notification if you need to setup Weblogic / Data Source to be aware of the ONS FAN events
ONS is a very useful option if you are using Oracle RAC architecture but the prior actual configuration of GridLink in the Weblogic make sure that your ONS working from the local and remote side because it may lead to an issue in the Weblogic and high CPU utilization
Also, check Metalink for a bug related to the jdbc driver and ONS feature because it may require to patch Weblogic prior to implementing it.
Please check the below reference link in order to get familiar with ONS and what has been changed in 18c compared to 12c
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 )
- 1
- 2