Problem Having decided to move our Oracle databases to the cloud, we now want to build equivalent VMs as database servers. This is simple enough when we have only one or a very small number of databases. But this can…Read More >
After a recent upgrade Users cannot work with the forms application anymore; it has been a few weeks since an upgrade to Forms 12c. The usual suspects have been investigated. The database is not waiting on forms transactions The application…Read More >
Are there any questions? Crickets, absolute silence… Your meeting would have had one person speaking most of the time (you). The themes may have varied, but let us assume that it was about the need to “pull up” or otherwise…Read More >
The customer called us to cancel And now you have to break this news to the team. This is never an easy meeting. If you have read my previous post about emotional artifacts that manifest in High-Stress remote meetings, you…Read More >
How we got here When there is a high-stress emergency, why is it not enough to create a group of the best-skilled people and let them figure out what to do? What is all this emotional intelligence mumbo-jumbo? The classical…Read More >
Picture this: You are asked to join an urgent client meeting on a bridge call because the client is having production issues. You listen in on the crowded call, there are many participants on mute, and most of them have…Read More >
After setting up dg4odbc to connect to a SQL Server database (read ‘Tips on Using dg4odbc on 64-bit Linux’), I spent last week trying to get refreshes of materialized views to work in 11g, using the same DDL as in 8i. So, to those three tips, I now add #4: check the statements that use a WHERE … IS NOT NULL across the remote database link to ANSI-compliant databases.Read More >
I recently imported the contents of an Oracle 8i database into an 11g database. After following the instructions for a typical setupI set up a database link to a remote SQL Server database, and called it SQLSERVER.. It turned out that dg4odbc has “hard coded” the quotes and this will need to be changed in odbc.ini. I should have looked more closely at the installation instructions — yes, the example shows QuotedId=Yes.Read More >
© Copyright 2020 Pythian Group Inc. ® ALL RIGHTS RESERVED.
PYTHIAN®, LOVE YOUR DATA®, and ADMINISCOPE® are trademarks and registered trademarks owned by Pythian in North America and certain other countries, and are valuable assets of our company. Other brands, product and company names on this website may be trademarks or registered trademarks of Pythian or of third parties. Use of trademarks without permission is strictly prohibited.