Background I like Google News as it offers an aggregated snapshot of the days trending news. I caught a wind of Linus Torvalds take on the ZFS File System and his reticence to merge it into Linux Core. The reason he cited is Oracle' litigious posture. Jim Salter's Response Link Introduction Last Monday in the … Continue reading Ars Technica – Jim Salter :- Linus Torvalds on ZFS File System – Rebuttal
Background Reviewing some SQL and wanted to point out a tiny dissimilarity between database platforms. Data Our test table is Oracle's SCOTT.EMP Here is what the data looks like :- Substring/Substr The HIREDATE is the only well formatted fixed length string. Its format is DD-MMM-YY. Query Oracle SQL Output Explanation Oracle relies on Substr to … Continue reading ANSI Standards – Database – Substring
Background Towards a couple of sample Oracle Database sample exercises that we have in mind wanted to make sure that our all purpose database client, DBeaver, is able to communicate with an Oracle Database. Preparation Oracle Java Version Objective The version of JDBC Client that we need will be based on the version of … Continue reading DBeaver – Database Connection Configuration – Oracle – Oracle JDBC Driver
Background Back in 2011, 5 years ago now, I posted about an error message I was experiencing. The error message reads "Oracle – 11G – Client – SQL Developer (64-bit) – Error – WARNING: Could not find jvm.cfg!". And, it is available here. Last Week In the last week I have received a couple … Continue reading SQL Developer – Cannot find a Java SE SDK installed at path
Introduction In the thick of converting from a legacy database to a new system and thank goodness the legacy system has well defined relationship mappings (Primary Key and Foreign Keys). And, this will help my familiarization. It always helps to look at a diagram and make sure that my relationships are maintained in the new DB. Potential … Continue reading Database – Modeling – Oracle SQL Developer Data Modeler (v 3.3)
Tried installing Oracle 11G/R2, but failing saying that it could not move orandce11.dbl.dll: INFO: moving 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll.dbl' to 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll' INFO: moving 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll.dbl' to 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll' INFO: Exception thrown from action: moveFile Exception Name: FileNotFoundException Exception String: File not found E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll.dbl Exception Severity: 2 INFO: Exception handling set to prompt user with options to Retry Ignore User Choice: … Continue reading Oracle – 11 G/R2 Client – Install – Error moving orandce11.dll.dbl
Introduction When the SQL Developer that is bundled with 64-bit Oracle 11G Client is launched, one is prompted for the location of java.exe. As the SQL Developer is running on a 64-bit system, the more natural choice is to go with 64-bit Java run-time. Doing so will be a mistake and if one would have done … Continue reading Oracle – 11G – Client – SQL Developer (64-bit) – Error – WARNING: Could not find jvm.cfg!