My server rebooted itself and when it came back up, none of the databases or ASM had restarted. Everything is 18.104.22.168 or 22.214.171.124 with ASM being 126.96.36.199 – so Oracle Restart should have kicked in.
Sometimes an ASM instance hangs for no apparent reason and this causes problems when backing up the ASM Metadata. Running queries against
V$ASM_DISK and similar views may also hang. This blog post should go some way to helping diagnose the problem, and providing a fix. Continue reading Asmcmd or ASM Instance Backups or Queries Hang
Have you ever wanted a quick and easy way of converting all those database entries in your tnsnames.ora file, into something that Toad can use to populate the “sessions” grid? Read on. Continue reading Convert a Tnsnames.ora File to a Toad Session Import File
I have made available for free a utility that will parse a tnsnames.ora file and report back on anything that it doesn’t like such as duplicate entries, invalid characters, redefinitions of parameters, errors etc etc. Continue reading Tnsnames Checker Utility
Ever wanted to set a variable to the name of another variable, and from there, somehow get the value of the other variable? I did, recently, and this is what I had to do. Continue reading Shell Variable Indirection in a Database Build Script
There is, out there in Oracle Land, a silent database killer. You never know when it will strike and it affects all databases right up to and including 12c. When it strikes, it does so silently, there is no evidence of its passing, until it is far too late. Continue reading Beware of the Silent Database Killer!
The following error popped up in an RMAN backup which was attempting to delete archived logs that had been backed up twice, at least, and were created more than two days ago:
Continue reading RMAN Error ORA-15028: Archived Log Not Dropped.
It was a simple enough request, flashback this particular database to a guaranteed restore point. What could possibly go wrong? Continue reading Oracle RAC – Flashback Database
Have you ever wanted to use a tool to parse the manually typed up “stuff” that lives in a tnsnames.ora file, to be absolutely certain that it is correct? Ever wanted some tool to count all the opening and closing brackets match? I may just have the very thing for you. Continue reading Tnsnames.ora Parser
A simple exercise to refresh a schema in a test database caused no end of problems when it hung at 99% complete. The last message on screen indicated that it was importing the Materialized Views (yes, with a ‘Z’). After a long time, the DBA running the import killed it, cleaned out, and restarted the whole process. Exactly the same happened. Continue reading Impdp Hangs Importing Materialized Views
While checking out a dataguarded database prior to being handed over into production, I needed to test that both
dgmgrl could carry out a switchover and failover from the (stand-alone) primary db (ORCL_PDB) to the physical standby database (ORCL_SBY), and back again. Continue reading Interesting Data Guard Problem
The Oracle database allows the users to change their passwords as follows: Continue reading So, How Do You Change a User’s Password
In this, the second part of the Introduction to Oracle Datapump mini-series, we take a look at importing dump files using
impdp. If you missed the first part which concentrated on exporting with expdp, have a read of it here. Once again, the following is a quick introduction for people like me – running Oracle on Linux and slightly averse to change! 😉 Continue reading Introduction to Oracle Datapump – Part 2
Oracle Datapump, aka
impdp were introduced at Oracle 10g to replace the old faithful
imp utilities. Many DBAs around the world find that it’s hard to change from what we know like the back of our hand, to something new. We need to change because
exp is deprecated from 10g onwards and might even already have vanished from 12c – which I have to install as one of my upcoming tasks. The following is a quick introduction for people like me – running Oracle on Linux and slightly averse to change! 😉 Continue reading Introduction to Oracle Datapump – Part 1
A slight variation on the incremental backups. In this (short) article, I demonstrate the use of database file copy backups which are themselves updated on a regular basis to avoid having to restore and recover using numerous incremental backups. Continue reading Oracle RMAN for Beginners – Part 10