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

From: Adam Musch <ahmusch_at_gmail.com>
Date: Mon, 2 Jun 2014 13:03:48 -0500
Message-ID: <CAH4ZrrvdNsJ3EHkNE2GvvDhs6j5hWxEy0=YWC1nDqjvZUtzgLw_at_mail.gmail.com>

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.

On Mon, Jun 2, 2014 at 12:58 PM, Jared Still <jkstill_at_gmail.com> wrote:

>
> On Fri, May 30, 2014 at 10:57 PM, sumit Tyagi <dba.tyagisumit_at_gmail.com>
> wrote:
>
>> please help on the below ORA reported on the physical standby ( ADG)
>> oracle 11.2.0.3.0
>
>
> You may want to check for logon triggers that are calling an invalid
> procedure.
> Someone may be trying to directly compile invalid procedures.
>
>
> 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

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

Received on Mon Jun 02 2014 - 20:03:48 CEST