Watch Your FRA!
Now the FRA may sound like a magical area that should never run into storage-related issues—but that could not be farther from the truth.
Schemas, Databases and Instances—Defined and Discussed
What is a schema as opposed to a database as opposed to an instance? And how do schemas differ between Oracle and MSSQL? Or between Oracle and PostgreSQL? Or between PostgreSQL and MongoDB?These terms are very important when planning a database architecture, so let’s explore them.
Which Edition of Oracle RDBMS is Right for My Business?
Do I really need Oracle Enterprise Edition? Do I need Oracle Enterprise Edition in order to have a standby database? What version of Oracle do I need? Oracle’s editions and features can be a bit overwhelming. This post shares some key information that I hope will make your choice easier.
Oracle Active Data Guard Replication Error with Cisco Firewall: Root Cause and Workaround
One of our customers had issues over the past several months with Oracle Active Data Guard replication to a standby server. The database on the standby server would intermittently fall out of sync with the database on the primary server, and log files were not consistently shipping to the standby server.
Time to Validate Your Database Backup
Another new client, Another bad backup I originally wrote this post in July but I am updating it today because it is so important. Yesterday we did an initial Oracle Database Health Check for another new client and found yet again that their backups are useless. This time the client was taking backups regularly, but […]
Oracle In-memory Database—Speed and Simplicity Meet Up. Have you tried it out yet?
One of the major announcements Oracle made during the Open World was the launch of Oracle In Memory Database Option. The In-Memory option to Oracle Database 12c is 100 percent compatible with existing applications and leverages all existing Oracle Database functionality. At first look, some key benefits jump out: Though this is a paid option, […]
Using the Data Dictionary to find hidden data in SQL Server
A client asked me recently how he could find a string in his SQL Server database without knowing what table or column it was in. The string was a translation of a code that appeared on one of the UI screens. This was a packaged CRM database and he had no documentation on the schema. […]
MySQL Parser Deficiencies
MySQL is a very popular database for many applications. But the parser has some important deficiencies that developers need to be aware of. The parser is inconsistent and not robust in the way that it enforces statement syntax. This may lead to ambiguity and application defects that are very difficult to find. I include one […]
Oracle Editioning — Upgrading database applications while in use
Among the features introduced in Oracle 11g is Edition Based Redefinition. This feature enables us to have multiple active versions of database objects in order to facilitiate online application upgrades. Prior to this release, if an application used stored procedures or triggers, upgrades required database downtime in order to redefine database objects. This new feature […]
Critical Oracle Security and Stability Flaw Discovered
Infoworld today announced that they have been researching a flaw in oracle that can result in the inability to restore your database. Large oracle shops with interconnected databases are most at risk. The problem revolves around oracle’s SCN (system change number). The number has a limit that if exceeded, can render a database unusable, even […]
