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...
by XTIVIA | Feb 18, 2021 | Blog, SQL Server
Every environment is configured differently; however, we have all experienced alerts being triggered due to unfavorable performance. Oftentimes, before our root cause analysis begins, the issue has resolved itself and/or someone may have rebooted. Although current...
