Oracle9i Database:Switching from 'READ ONLY' mode to 'READ WRITE' mode

if i am running Oracle 9i, and i open the database with the command "ALTER DATABASE OPEN READ ONLY". How do i switch the database to "READ WRITE" without shutting it down first.

Thanks
samudimuAsked:
Who is Participating?
 
Pradeepgv03Connect With a Mentor Commented:
Hi,
I dont think this is possible.

-Pradeep
0
 
shahidnsConnect With a Mentor Commented:
Hello,
Pradeep is write, it is not possible to open the database in read write mode, when the database is open in read only mode. Both these modes are modified version of alter database open.

You may refer to this link, to be more convinced.
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:53859429056177

Regards.
Shahid.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.