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

From: sumit Tyagi <dba.tyagisumit_at_gmail.com>
Date: Tue, 3 Jun 2014 17:39:36 +0530
Message-ID: <CAFW4NVzBf0WhXN7jFPAyivmHvU5PukfqOgqqHoQw=rSUTO+q0A_at_mail.gmail.com>

Dear All,

please find the original mail:

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

On Tue, Jun 3, 2014 at 5:06 PM, Niall Litchfield <niall.litchfield_at_gmail.com
> wrote:

> mea culpa. I didn't see the original mail (so just as guilty as not
> reading the docs). JIT compilation won't be allowed on a read-only
> database.
>
>
> On Tue, Jun 3, 2014 at 12:35 PM, Niall Litchfield <
> niall.litchfield_at_gmail.com> wrote:
>
>> Again we are guessing. You ought to check
>> http://docs.oracle.com/cd/E11882_01/server.112/e25494/start.htm#ADMIN13176
>> for restrictions on read only databases, as well as for locally vs system
>> managed temp tablespaces for the users in question. .
>>
>>
>> On Tue, Jun 3, 2014 at 12:20 PM, sumit Tyagi <dba.tyagisumit_at_gmail.com>
>> wrote:
>>
>>> _at_Adam yes it is Active data guard opened in read only mode .But we are
>>> not using any query with MATERIALIZE hint.
>>>
>>>
>>> On Mon, Jun 2, 2014 at 11:43 PM, Adam Musch <ahmusch_at_gmail.com> wrote:
>>>
>>>> An Active Data Guard database is opened, just opened for read only and
>>>> in managed recover mode. The OP used ADG, so I presumed it was Active Data
>>>> Guard, as mine is.
>>>>
>>>>
>>>> On Mon, Jun 2, 2014 at 1:09 PM, Jared Still <jkstill_at_gmail.com> wrote:
>>>>
>>>>>
>>>>> On Mon, Jun 2, 2014 at 11:03 AM, Adam Musch <ahmusch_at_gmail.com> wrote:
>>>>>
>>>>>> I recently started tripping that error (11.2.0.3) with a query that
>>>>>> was using the MATERIALIZE hint. I don't know if queries with common table
>>>>>> expressions but that materialize without the hint can also cause that error.
>>>>>
>>>>>
>>>>>
>>>>> CTE's will always fail on queries in when oracle is mounted but not
>>>>> opened.
>>>>>
>>>>> Probably the same applies here.
>>>>>
>>>>>
>>>>>
>>>>> Jared Still
>>>>> Certifiable Oracle DBA and Part Time Perl Evangelist
>>>>> Sr Oracle DBA at Pythian
>>>>> Pythian Blog http://www.pythian.com/blog/author/still/
>>>>> Oracle Blog: http://jkstill.blogspot.com
>>>>> Home Page: http://jaredstill.com
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Adam Musch
>>>> ahmusch_at_gmail.com
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> *--*
>>> *BR*
>>> *Sumit Tyagi*
>>> *+91-7829543355 <%2B91-7829543355>*
>>>
>>
>>
>>
>> --
>> Niall Litchfield
>> Oracle DBA
>> http://www.orawin.info
>>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

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

Received on Tue Jun 03 2014 - 14:09:36 CEST