by XTIVIA | Aug 20, 2021 | Blog, MySQL
Background When running a batch file on MySQL the login credentials must be taken from some file. The file choices are to use a clear-text options file or the more secure obfuscated login-file generated by the MySQL program mysql_config_editor (which comes installed...
by XTIVIA | Jun 24, 2021 | Blog, SQL Server
This checklist outlines the steps I took to migrate SQL Server Always On 2017 Enterprise to 2019 Enterprise edition. Having mixed versions of AG’s is a temporary solution meant for upgrading or migration purposes only and is not intended for long term use....
by XTIVIA | May 7, 2021 | Blog, Db2
Recently while applying a fixpack, I encountered this error: ERROR: An error occurred while setting DB2 runtime path. Contact a technical service representative. Setting DB2 library path :…….Failure DB2 Fix Pack Update log file finished at: Sat Aug 1...
by XTIVIA | Apr 12, 2021 | Blog, Oracle
The Oracle error ORA-04031: unable to allocate nn bytes of shared memory is telling us that Oracle tried to allocate a specific amount of memory for a process and it was unable to do so. I see this more often with legacy or very large and complex ETL processes. The...
by XTIVIA | Mar 25, 2021 | Blog, Oracle
This post has been updated from the original content here. When getting an ORA-12560 for an Oracle database on windows, there are a couple of things we should check before doing anything else. The error is telling us that we are trying to connect to the wrong...
by XTIVIA | Mar 4, 2021 | Blog, Oracle
This post has been updated from the original content here. The ORA-00257 error is a very common Oracle database error. The error is basically trying to tell us that we have run out of logical or physical space on our ASM diskgroup, mount, local disk, or...
