Re: ORA-16000: database open for read-only access
- From: Timur Akhmadeev <timur.akhmadeev@xxxxxxxxx>
- To: "dba.tyagisumit@xxxxxxxxx" <dba.tyagisumit@xxxxxxxxx>
- Date: Fri, 6 Jun 2014 12:22:30 +0400
Hi
The error comes from MMON which runs some java which is being natively
compiled by JIT
Possible causes:
* the java code itself tries to run something which tries to modify the DB
* JIT tries to write compiled code version into the DB
Depending on the stack trace which you may get on 16000 error, you can
either
* not do anything with it - if the java code indeed tries to update the
database
* turn off JIT with
http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams098.htm -
if the database tries to write something due to JIT
In any case the error stack is the first thing you need to get
On Thursday, June 5, 2014, sumit Tyagi <dba.tyagisumit@xxxxxxxxx> wrote:
> Dear all,
>
> Thanks for the information . We are checking the java packages / methods
> for invalidation . Most probably this is the issue . we are getting same
> issue for some other packages also lets c:
>
> **** 2014-06-05 11:45:54.036*
>
> **** SESSION ID:(8.18551) 2014-06-05 11:45:54.036*
>
> **** CLIENT ID:() 2014-06-05 11:45:54.036*
>
> **** SERVICE NAME:(SYS$BACKGROUND) 2014-06-05 11:45:54.036*
>
> **** MODULE NAME:(MMON_SLAVE) 2014-06-05 11:45:54.036*
>
> **** ACTION NAME:(JAVAVM JIT slave action) 2014-06-05 11:45:54.036*
>
>
>
> *joez_compile_method beginning compile of method
> sun/security/pkcs/PKCS7.getContentInfo*
>
> *Reading CompilerOptions...*
>
>
>
> **** 2014-06-05 11:45:55.358*
>
> *joxjitexe(1) caught: 16000; Aborting*
>
> *joxjitexe(2) caught: 16000;*
>
> *ORA-16000: database open for read-only access*
>
>
>
>
> On Tue, Jun 3, 2014 at 7:34 PM, Kim Berg Hansen <kibeha@xxxxxxxxx> wrote:
>
> Hiya
>
> 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@xxxxxxxxx
> @kibeha
>
>
>
>
> On Sat, May 31, 2014 at 7:57 AM, sumit Tyagi <dba.tyagisumit@xxxxxxxxx>
> 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@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
>
> --
>
> *--*
> *BR*
> *Sumit Tyagi*
> *+91-7829543355*
>
--
Regards
Timur Akhmadeev
Other related posts:
