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

I would guess for some reason the method java/security/spec/DSAParameterSpec.getQ has become invalidated on your primary database. Then when some code on your Active Data Guard standby tries to use this method, the database attempts an automatic recompilation, which is not allowed in the read-only standby database.

We have had similar issues with views becoming invalid in primary, and thus in standby shortly after.
See blogposts we wrote with example:
http://dspsd.blogspot.dk/2013/09/active-data-guard-and-invalidations.html http://www.bluegecko.dk/oracle/challenges-with-object-invalidation-and-ora-04045-in-active-data-guard-standby-database/

The only solution we could find was to manually recompile our views on the primary, so that the Active Data Guard standby would never have to attempt automatic recompilation/revalidation of invalid objects.

I am not quite sure this can be the same issue with java stored procedures, but I would guess it could.
Try checking for invalid java objects on the standby, and then recompile those objects on the primary (which then will be propagated in VALID state to the standby.)

Regards

Kim Berg Hansen

http://dspsd.blogspot.com
kibeha_at_gmail.com
_at_kibeha

On Sat, May 31, 2014 at 7:57 AM, sumit Tyagi <dba.tyagisumit_at_gmail.com> wrote:

> Dear Experts , please help on the below ORA reported on the physical
> standby ( ADG) oracle 11.2.0.3.0 .
>
>
> *ALERT LOG ENTRY:*
> Sat May 31 05:11:01 2014
> Errors in file
> /oracle/app/product/11.2.0/diag/rdbms/xxxxxxrpt/xxxxxx/trace/xxxxxx_
> *m000_4524.trc:*
> ORA-16000: database open for read-only access
> Sat May 31 05:11:10 2014
> Errors in file
> /oracle/app/product/11.2.0/diag/rdbms/xxxxxxrpt/xxxxxx/trace/xxxxxx_
> *m000_4557.trc:*
> ORA-16000: database open for read-only access
> Sat May 31 05:12:04 2014
>
> *TRACE FILE ENTRY:*
> [oracle_at_reporting-srvr trace]$ cat
> /oracle/app/product/11.2.0/diag/rdbms/xxxxxxrpt/xxxxxx/trace/xxxxxx_m000_4557.trc
>
> Trace file
> /oracle/app/product/11.2.0/diag/rdbms/xxxxxxxx/xxxxxxx/trace/xxxxxxx_m000_4557.trc
> Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
> Production
> With the Partitioning, Automatic Storage Management, OLAP, Data Mining
> and Real Application Testing options
> ORACLE_HOME = /oracle/app/product/11.2.0/db_1
> System name: Linux
> Node name: reporting-srvr
> Release: 2.6.18-238.el5
> Version: #1 SMP Sun Dec 19 14:22:44 EST 2010
> Machine: x86_64
> Instance name: xxxxxx
> Redo thread mounted by this instance: 1
> Oracle process number: 42
> Unix process pid: 4557, image: oracle_at_reporting-srvr (M000)
>
>
> *** 2014-05-31 05:11:09.495
> *** SESSION ID:(770.3233) 2014-05-31 05:11:09.496
> *** CLIENT ID:() 2014-05-31 05:11:09.496
> *** SERVICE NAME:(SYS$BACKGROUND) 2014-05-31 05:11:09.496
> *** MODULE NAME:(MMON_SLAVE) 2014-05-31 05:11:09.496
> *** ACTION NAME:(JAVAVM JIT slave action) 2014-05-31 05:11:09.496
>
> joez_compile_method beginning compile of method
> java/security/spec/DSAParameterSpec.getQ
> Reading CompilerOptions...
>
> *** 2014-05-31 05:11:10.832
> joxjitexe(1) caught: 16000; Aborting
> joxjitexe(2) caught: 16000;
> ORA-16000: database open for read-only access
>
>
> *--*
> *BR*
> *Sumit Tyagi*
> *+91-7829543355*
>

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