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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 3 Jun 2014 12:36:30 +0100
Message-ID: <CABe10sYMVrq2j_O7h8YpT_nun_ZSYJba07f56uU2408AJ4zEAg_at_mail.gmail.com>

mea culpa. I didn't see the original mail (so just as guilty as not reading the docs). JIT compilation won't be allowed on a read-only database.

On Tue, Jun 3, 2014 at 12:35 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

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

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

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

Received on Tue Jun 03 2014 - 13:36:30 CEST