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 databases being connected to was up and fully operational.

This turned out to be the result of Bug 13724193, affecting Oracle 11.2.0.3 and fixed in 12.1.

The problem manifests when a database link connects to a primary database that has not been restarted since it transitioned from being an “open read only” standby database to a primary database.

To resolve the issue, restart the primary database (!) that the database link connects to. There is no other workaround documented.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: