Scripting: Is the DB DataGuarded?

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 →

ORA-1089 reported by a database link

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.

Blog at WordPress.com.

Up ↑