Expand To Show Full Article
Oracle Error ORA-03254: unable to execute the sql in read only database - Developer Publish

Oracle Error ORA-03254: unable to execute the sql in read only database

Oracle Error Message

ORA-03254: unable to execute the sql in read only database

Reason for the Error

Unable to create a consistent snapshot of the object in a read only database. Transaction recovery must be performed before opening the database read only.

Solution

Open the database read write, allow dead transaction recovery to complete and then open the database read only.