I am in the middle of moving my blog posts away from WordPress and into Notion (a great note taking tool that allows me to make specific notes publicly viewable with ease). By moving my site to Notion I hope to reduce the barrier to writing new articles in the limited time available to me... Continue Reading →
Around 14 years ago, I switched from using Reflection to PuTTY because it was free and my employer at the time wouldn’t pay for such extravagance software purchases such as a simple terminal emulator! Since then I’ve become rather accustomed to the way PuTTY behaves, and find Reflections particularly annoying to use on the occasion that I visit a client who insists on using it.
However, it is possible to solve most of the biggest annoyances…
A number of older ScanSnap scanners released by Fujitsu are no longer supported and the official line from Fujitsu is to buy new hardware. However, the ScanSnap range isn't cheap and you can avoid spending a large sum by utilizing Compatibility Mode built into Windows to get your older scanner working with the latest versions of Windows.
This guide will show you how.
Over the years I have seen and maintained many kornshell scripts written by DBAs, and there are a number of programming styles that provoke strong reactions on who is doing it the "right" way.
In this article, I will explain the different ways in which functions can be defined in Kornshell and explain why I personally prefer one method over another.
Recently, all my files stored in Dropbox suddenly acquired a "dot underscore" file in addition to the original file, which was then synced to all other computers that were linked to my Dropbox account. This post describes what these files are, and how I resolved the issue.
I'm a longtime Windows user who recently purchased a Mac. Overall I'm very impressed with the machine, but it does have a learning curve, especially for the key bindings. As a DBA and programmer, I use the Home, End, PageUp, PageDown and CTRL keys extensively to quickly navigate code and text documents. And don't get me started... Continue Reading →
One of the most powerful features of Evernote is how quickly and easily you can add content to your notebooks. Sometimes however, this is both a blessing and a curse because there is no review process for removing old and outdated notes. Sometimes you come across a note that could do with more context around it as the original reason for writing/clipping it was not recorded at the time.
Well luckily, there is now a nice neat solution for reviewing your notes.
The behaviour of the pullup dependency as described in the Oracle documentation for CRS resources is counter-intuitive and so I decided to do some testing around it to see the results and reassure myself that the documentation was correct.
This article explains how to convert a list of values/readings into a graph to show month by month comparisons over several years as shown above.
Whilst developing some administrative functions within PL/SQL I needed to know whether the database that the code was being run in was part of an Oracle DataGuard setup, which you would think would be a trivial exercise. My first thought was that we could determine this via v$database. If the DATABASE_ROLE column in v$database contains STANDBY then we know... Continue Reading →
Two short and simple methods to create a URL which will direct someone straight to the recommendations section on your LinkedIn profile. This is useful for highlighting your existing recommendations and at the same time prompting the recipient to leave you a recommendation.
A step-by-step guide to resolving the "hanging sync" issue on the desktop Lightroom where edits made in the iPad app are not being successfully synced to the desktop although they are displaying correctly in Creative Cloud.
Users were complaining of ORA-12514: TNS:listener does not currently know of service requested in connect descriptor errors whilst connecting to a database on a RAC cluster. The cause was elusive, but was eventually tracked down to an unpublished bug relating to SCAN listener re-registration.
This is a subject that I am often asked about by developers and support teams changing application configuration details: What is the correct format of JDBC connection strings for the thin driver? Oracle's JDBC Thin driver uses Java sockets to connect directly to Oracle. It provides its own TCP/IP version of Oracle's SQL*Net protocol. Because it... Continue Reading →
Whilst investigating a user issue today, I came across an unusual occurrence of the "ORA-01031: insufficient privileges" error which was not caused to the usual suspects of missing grants and/or tablespace quota.
Oracle clients (and programs that use Oracle clients/drivers) will search for TNS configuration files such as sqlnet.ora and tnsnames.ora in the following order. Note that the first file to be found will be used -- so if there were files in both location 3 and location 5, then the one in location 3 would be found first... Continue Reading →
The unix command scp is very useful for transferring files between two hosts over a secure connection, but sometimes you need to kick off an scp command that will take several hours to complete and you want to disconnect and go home. Using "screen" One approach is to use the screen command (available only on linux AFAIK) to start the initial transfer, then... Continue Reading →
While refreshing a standby Database (11gR2) using “duplicate target database for standby” I recently encountered an error which one would normally associate with password files and/or the fact that the SYS password is not the same on the source and target databases.
It was neither
In my article How to backup your Evernote notes regularly I supplied a windows batch file that could be used with the Windows Scheduler to automatically backup your Evernote Notes. In use, however, it soon becomes annoying that the scheduler launches a DOS window to run the script right in the middle of the screen.
This article documents the technique for running a batch file minimized to the taskbar.
Recently, we encountered a strange problem whereby trying to issue a select over a database link caused an ORA-1089 "immediate shutdown in progress - no operations are permitted" error even though the source databases was up and fully operational.
An article describing the installation process for Oracle Database Access Components (ODAC) on Windows Server and details of common questions and errors encounted.
I don't know about anyone else, but I find it incredibly annoying that the Microsoft Word doesn't use F3 as the shortcut key for finding the next occurrence of something that you have previously searched for. Here's the correct (i.e. out of the box) shortcut for finding the next occurrence and how to change it to F3 in Word 2007 and above.
When performing a backup of a large database using RMAN, you often get asked "how is the backup progressing?" and "when it will complete?". Although the log produced by RMAN is detailed in almost every other aspect, there isn't any information recorded that will allow you to give a simple and straightforward answer to these questions
However, the information is available within the data dictionary.
As a DBA, it is generally a good idea to log all your activity when working on Unix/Linux servers. Logging provides an audit of changes that you have made to a system as well as being a valuable resource for notes and documentation.
This article describes how to log all PuTTY sessions and how to automtically maintain the resulting logfiles in a logical directory structure.