ORA-16000: database open for read-only access

From: sumit Tyagi <dba.tyagisumit_at_gmail.com>
Date: Sat, 31 May 2014 11:27:37 +0530
Message-ID: <CAFW4NVxDAnbv_sZFvbkhBeY8EA4eC+QUBTn_8m-8a4znFELiPA_at_mail.gmail.com>

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

Received on Sat May 31 2014 - 07:57:37 CEST