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 ----------------------------------- --------------------------------------------------------------------------- ARCHIVELOG READ ONLY WITH APPLY PHYSICAL STANDBY
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
