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
This post has been added prior to 18.3 official notes which means that we are going to patch initial version of 18.0.0.0 with patch 28096386 in order to upgrade Software to 18.3 version
We will use software which doesn’t exist in delivery anymore but there are new version :)
Oracle Database Grid Infrastructure (Exadata and SuperCluster) 18.0.0.0.0 for Linux x86 - 64
V974952-01.zip Oracle Database Grid Infrastructure 18.0.0.0.0
Now this has been replaced by
Oracle Database Grid Infrastructure ( Linux and SuperCluster ) 18.0.0.0.0 for Linux x86 - 64
V978971-01.zip Oracle Database Grid Infrastructure 18.0.0.0.0
Environment:
Two Linux VM servers with OL7.5
First server -> AIXRAC1
Second server -> AIXRAC2
Hypervisor (Updated) ESXi-6.5.0-20170104001-standard (VMware, Inc.)
You can do the same with any other Hypervisors, just need to adapt disk creation and some of the configuration related to network and maybe udev rules
This morning start with the bug, unfortunately :(
I have to export one schema from one place and import to other place but when i try to import schema i face the below error
Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 4.2 in dump file "dbabg.dmp"
'Golden Home" methodology:
Golden Home is a very simple process for Oracle Software consolidation and maintenance process ( patching, upgrades etc.) this is suitable for environment with a lot of databases by using pre-defined home ( cloned oracle software ), Oracle Home is prepared with all necessary patches in order to speed-up patching activities and avoid complexity by just switching from old home with old patch level to a new home with new PSU or any other patch levels.
This process will be presented very soon in the blog by some of my colleagues
In my case, we face an issue with ORA-00600 [qcisSetPlsqlCtx:tzi init] - related to time zone files which are missing in the new home location due to the fact that in case of huge environment you should be aware of all specifics :)
If you try to start the database from the new Oracle Home with new PSU version during the open face database reporting error - ORA-00600 [qcisSetPlsqlCtx:tzi init]