Intermittent ORA-12514 error connecting to SCAN listeners

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. Read More

Converting an ACFS General Purpose filesystem to an Oracle Home filesystem

I recently came across a scenario whereby we had created our ACFS filesystems as General Purpose filesystems using asmca, but then discovered that we needed these filesytems to be available prior to the database starting up and that we should have registered them as Oracle Home filesystems. This post details how we went about converting the filesystem without any loss of data. Read More