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
Error:
Fix
Add on file sqldeveloper.conf following parameter -> AddVMOption -Xmx4096M and restart SqlDeveloper
Have fun
Exporting..... takes time in some case :)
Error:
UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3905
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5203
ORA-06512: at line 1
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