Home » RDBMS Server » Server Administration » patching 12c database in read only mode ? (sun, Oracle 12c)
patching 12c database in read only mode ? [message #670116] Fri, 08 June 2018 10:24 Go to next message
krish96
Messages: 74
Registered: October 2012
Member
Hello,

we have a 12cr2 database which is in Read only mode and its a standalone .. Could you please let me know if i can apply patches to this database ? or do we need to change it to read-write to patch ..

Thanks in advance ..

Re: patching 12c database in read only mode ? [message #670117 is a reply to message #670116] Fri, 08 June 2018 10:46 Go to previous messageGo to next message
gazzag
Messages: 929
Registered: November 2010
Location: Bristol, UK
Senior Member
If the patch is an operating system one just to the ORACLE_HOME, yes. If there is a database element to it (SQL scripts) then no.
Re: patching 12c database in read only mode ? [message #670118 is a reply to message #670117] Fri, 08 June 2018 10:51 Go to previous messageGo to next message
krish96
Messages: 74
Registered: October 2012
Member
Yes patch will be applied to ORACLE_HOME and then to database as well ..
Re: patching 12c database in read only mode ? [message #670119 is a reply to message #670118] Fri, 08 June 2018 11:01 Go to previous messageGo to next message
gazzag
Messages: 929
Registered: November 2010
Location: Bristol, UK
Senior Member
Then database needs to be open read-write.
Re: patching 12c database in read only mode ? [message #670121 is a reply to message #670119] Fri, 08 June 2018 12:39 Go to previous messageGo to next message
krish96
Messages: 74
Registered: October 2012
Member
if database is read write mode and if there are some application based tablespaces are locked (for not allowing users do changes in database) will database still able to patch or no ?


SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE
Re: patching 12c database in read only mode ? [message #670145 is a reply to message #670121] Mon, 11 June 2018 03:23 Go to previous message
gazzag
Messages: 929
Registered: November 2010
Location: Bristol, UK
Senior Member
Yes, you can patch like that.
Previous Topic: DB Links may stop working after June 2019
Next Topic: ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions
Goto Forum:
  


Current Time: Mon Jun 25 07:28:30 CDT 2018