Let’s have a look at the steps used for the error ORA-16000

ORA-16000: database open for read-only access

SQL>  select log_mode,open_mode , database_role from v$database;
LOG_MODE             OPEN_MODE                                       DATABASE_ROLE
----------------------------------- ---------------------------------------------------------------------------

If we got the above output then your database is physical standby which is READ ONLY mode. You can only select when the database is in Read only mode. If you want to do any changes then you need to change mode to READ WRITE and recreate your standby database. Else do the changes on primary database which will reflect the changes on Standby database.

Thought of the Day!

“There’s a wonderful saying that’s dead wrong. ‘Why did you climb the mountain? ‘I climbed the mountain because it was there.’ That’s utter nonsense. You climbed the mountain because you were here and you were curious if you could do it. You wondered what it would be like.” – Larry Ellison

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp


About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.