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
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.
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.
The Oracle Database File System (DBFS) is a feature that creates a standard file system interface on top of files and directories that are stored in database tables. DBFS is similar to NFS in that it provides a shared network file system that looks like a local file system. Like NFS, there is a server... Continue Reading →