Re: ORA-16000: database open for read-only access

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 3 Jun 2014 12:35:01 +0100
Message-ID: <CABe10sY5ApK8BZmx2Y6+-U-Ms6=HTN3hruQTdShvYgyudPWEbg_at_mail.gmail.com>

Again we are guessing. You ought to check http://docs.oracle.com/cd/E11882_01/server.112/e25494/start.htm#ADMIN13176 for restrictions on read only databases, as well as for locally vs system managed temp tablespaces for the users in question. .

On Tue, Jun 3, 2014 at 12:20 PM, sumit Tyagi <dba.tyagisumit_at_gmail.com> wrote:

> _at_Adam yes it is Active data guard opened in read only mode .But we are not
> using any query with MATERIALIZE hint.
>
>
> On Mon, Jun 2, 2014 at 11:43 PM, Adam Musch <ahmusch_at_gmail.com> wrote:
>
>> 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_at_gmail.com> wrote:
>>
>>>
>>> On Mon, Jun 2, 2014 at 11:03 AM, Adam Musch <ahmusch_at_gmail.com> 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_at_gmail.com
>>
>
>
>
> --
>
> *--*
> *BR*
> *Sumit Tyagi*
> *+91-7829543355 <%2B91-7829543355>*
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 03 2014 - 13:35:01 CEST