OraFAQ Forum: Server Administration » patching 12c database in read only mode ?

Home » RDBMS Server » Server Administration » patching 12c database in read only mode ? (sun, Oracle 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

patching 12c database in read only mode ? [message #670116]

Fri, 08 June 2018 10:24

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 ..

Report message to a moderator

Re: patching 12c database in read only mode ? [message #670117 is a reply to message #670116]

Fri, 08 June 2018 10:46

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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.

Report message to a moderator

Re: patching 12c database in read only mode ? [message #670118 is a reply to message #670117]

Fri, 08 June 2018 10:51

krish96
Messages: 74
Registered: October 2012

Member

Yes patch will be applied to ORACLE_HOME and then to database as well ..

Report message to a moderator

Re: patching 12c database in read only mode ? [message #670119 is a reply to message #670118]

Fri, 08 June 2018 11:01

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Then database needs to be open read-write.

Report message to a moderator

Re: patching 12c database in read only mode ? [message #670121 is a reply to message #670119]

Fri, 08 June 2018 12:39

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

Report message to a moderator

Re: patching 12c database in read only mode ? [message #670145 is a reply to message #670121]

Mon, 11 June 2018 03:23

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Yes, you can patch like that.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 21:31:27 CST 2025