ORA-16000: database open for read-only access

  • From: sumit Tyagi <dba.tyagisumit@xxxxxxxxx>
  • To: Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 31 May 2014 11:27:37 +0530

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
Redo thread mounted by this instance: 1
Oracle process number: 42
Unix process pid: 4557, image: oracle@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*

Other related posts: