Re: Strange problem

Are you seeing this behaviour if you set

_datafile_write_errors_crash_instance = FALSE (not default) since this is what I do

Thanks
Fairlie

Sent from my iPhone

> On 1 May 2017, at 6:22 AM, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
>
> Hi!
>
> I am having a strange problem with an Oracle 12.1.0.2 instance on SUN Solaris 11.3 (SPARC):
>
> ORA-01110: data file 7: '/oradata/DEV/datafiles/data01b.dbf'
> 2017-04-28 23:05:11.723000 -04:00
> Flush retried for xcb 0x5c0e98a90, pmd 0x5c3faa538
> Errors in file /app/oradev/diag/rdbms/oradev/DEV/trace/DEV_pmon_465049.trc:
> ORA-00372: file 7 cannot be modified at this time
> ORA-01110: data file 7: '/oradata/DEV/datafiles/data01b.dbf'
> 2017-04-28 23:05:18.756000 -04:00
> Flush retried for xcb 0x5c0e98a90, pmd 0x5c3faa538
> Errors in file /app/oradev/diag/rdbms/oradev/DEV/trace/DEV_dbw0_465083.trc:
> ORA-00372: file 7 cannot be modified at this time
> ORA-01110: data file 7: '/oradata/DEV/datafiles/data01b.dbf'
> USER (ospid: 465083): terminating the instance due to error 372
> System state dump requested by (instance=1, osid=4295432379 (DBW0)), summary=[abnormal instance termination].
> System State dumped to trace file /app/oradev/diag/rdbms/oradev/DEV/trace/DEV_diag_465073_20170428230518.trc
> 2017-04-28 23:05:23.820000 -04:00
> Instance terminated by USER, pid = 465083
> 2017-04-29 10:58:13.293000 -04:00
> Starting ORACLE instance (normal) (OS id: 44563)
> CLI notifier numLatches:29 maxDescs:1355
> All SGA segments were allocated at startup
> When I restart the instance all files are available. The instance is patched with the January 2017 PSU, soon to be patched with April 2017 PSU. Here are the relevant versions:
>
> SunOS sun02 5.11 11.3 sun4v sparc sun4v
>
> -bash-4.4$ sqlplus / as sysdba
>
> SQL*Plus: Release 12.1.0.2.0 Production on Sun Apr 30 16:15:43 2017
>
> Copyright (c) 1982, 2014, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
> With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
> The underlying file system is, of course, ZFS. When the instance is restarted, all the files are available and there is nothing in the V$RECOVER_FILE. I opened SR with Oracle, but as this is a development system, they are taking their time. Has anyone seen this before and, if yes, what would be the solution? The system crashes during nightly batches, which load a lot of data and are write intensive.
>
>
>
>
>
> --
> Mladen Gogala
> Oracle DBA
> Tel: (347) 321-1217

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