Oracle Database Migration from non-cdb to pdb - components issue
We decide to create a new CDB container instance with version 22.214.171.124 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.
If you are trying to load the script in Oracle Sql Developer near to 100MB you may need to change the memory parameter in the configuration file sqldeveloper.conf - location sqldeveloper\bin
Add on file sqldeveloper.conf following parameter -> AddVMOption -Xmx4096M and restart SqlDeveloper
DataPump - Export - Import - 12.1 - ORA-31623: a job is not attached to this session via the specified handle
Exporting..... takes time in some case :)
Oracle 12.2 GI infrastructure
Oracle 12.1 Database as Primary with two instances as RAC
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!
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