ORA-16000: database open for read-only access
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-lReceived on Sat May 31 2014 - 07:57:37 CEST