Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Read only database permanently

rootsmanFeb 4 2013 — edited Feb 4 2013
Hi guys!

I would like to know is it possible to set existing Oracle database to be Read Only by default, after each startup?

I know that i can do it manually by issuing command alter database open read only, but i would like to put database as read only each time after startup, without typing previous command.

Can i maybe alter some parameters in init file or similar?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2013
Added on Feb 4 2013
11 comments
979 views