Re: ORA-16000: database open for read-only access
- From: Adam Musch <ahmusch@xxxxxxxxx>
- To: Jared Still <jkstill@xxxxxxxxx>
- Date: Mon, 2 Jun 2014 13:13:16 -0500
An Active Data Guard database is opened, just opened for read only and in
managed recover mode. The OP used ADG, so I presumed it was Active Data
Guard, as mine is.
On Mon, Jun 2, 2014 at 1:09 PM, Jared Still <jkstill@xxxxxxxxx> wrote:
>
> On Mon, Jun 2, 2014 at 11:03 AM, Adam Musch <ahmusch@xxxxxxxxx> wrote:
>
>> I recently started tripping that error (11.2.0.3) with a query that was
>> using the MATERIALIZE hint. I don't know if queries with common table
>> expressions but that materialize without the hint can also cause that error.
>
>
>
> CTE's will always fail on queries in when oracle is mounted but not opened.
>
> Probably the same applies here.
>
>
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> Sr Oracle DBA at Pythian
> Pythian Blog http://www.pythian.com/blog/author/still/
> Oracle Blog: http://jkstill.blogspot.com
> Home Page: http://jaredstill.com
>
--
Adam Musch
ahmusch@xxxxxxxxx
Other related posts:
