Re: ORA-16000: database open for read-only access
- From: Adam Musch <ahmusch@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Mon, 2 Jun 2014 13:03:48 -0500
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@xxxxxxxxx> wrote:
>
> On Fri, May 30, 2014 at 10:57 PM, sumit Tyagi <dba.tyagisumit@xxxxxxxxx>
> 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@xxxxxxxxx
Other related posts:
