Bonjour,
OS Linux CnetOS
Oracle 11.2.0.3.0
Total System Global Area 8,5515E+98 bytes
Fixed Size 2245480 bytes
Variable Size 2,7179E+91 bytes
Database Buffers 5,8049E+92 bytes
Redo Buffers 26501120 bytes

Lors de lancement des traitements batche, la base de donner s'arrete d'une maniere annormale, ci-dessous quelques informations du fichier Alert.log:
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Thread 1 advanced to log sequence 13755 (LGWR switch)
  Current log# 1 seq# 13755 mem# 0: /uat3/UAT2DB/LOG/log_1aUAT2.dbf
  Current log# 1 seq# 13755 mem# 1: /uat2bis/uat3/UAT2DB/LOG/log_1bUAT2.dbf
Tue Apr 21 20:45:07 2015
Time drift detected. Please check VKTM trace file for more details.
Tue Apr 21 20:45:17 2015
System state dump requested by (instance=1, osid=29777 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /ora01/app/oracle/product/11.2.0/dbhome_1/dbs/diag/rdbms/uat2/UAT2/trace/UAT2_diag_29787.trc
Tue Apr 21 20:45:17 2015
PMON (ospid: 29777): terminating the instance due to error 471
Instance terminated by PMON, pid = 29777
Tue Apr 21 21:04:59 2015
Starting ORACLE instance (normal)
voici un extrait du fichier : UAT2_diag_29787.trc

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
 
*** 2015-04-21 20:45:24.756
     fname=/uat3/UAT2DB/DATA/IDX_CONTROL_1_UAT2.dbf
     fno=35 lblksz=8192 fsiz=5760
    ----------------------------------------
    SO: 0x25304d958, type: 10, owner: 0x25f978aa0, flag: INIT/-/-/0x00 if: 0x1 c: 0x1
     proc=0x25f978aa0, name=FileOpenBlock, file=ksfd.h LINE:6448, pg=0
    (FOB) 0x25304d958 flags=2050 fib=0x25550fc28 incno=0 pending i/o cnt=0
     fname=/uat3/UAT2DB/DATA/IDX_CENTRAL_1_UAT2.dbf
     fno=34 lblksz=8192 fsiz=12160
    ----------------------------------------
    SO: 0x25304d838, type: 10, owner: 0x25f978aa0, flag: INIT/-/-/0x00 if: 0x1 c: 0x1
     proc=0x25f978aa0, name=FileOpenBlock, file=ksfd.h LINE:6448, pg=0
    (FOB) 0x25304d838 flags=2050 fib=0x25550f600 incno=0 pending i/o cnt=0
     fname=/uat3/UAT2DB/DATA/IDX_B2K_TEMP_1_UAT2.dbf
     fno=33 lblksz=8192 fsiz=8704
    ----------------------------------------
    SO: 0x25304d718, type: 10, owner: 0x25f978aa0, flag: INIT/-/-/0x00 if: 0x1 c: 0x1
     proc=0x25f978aa0, name=FileOpenBlock, file=ksfd.h LINE:6448, pg=0
    (FOB) 0x25304d718 flags=2050 fib=0x25550eff0 incno=0 pending i/o cnt=0
     fname=/uat3/UAT2DB/DATA/IDX_B2K_SYSTEM_1_UAT2.dbf
     fno=32 lblksz=8192 fsiz=7568
    ----------------------------------------
    SO: 0x25304d5f8, type: 10, owner: 0x25f978aa0, flag: INIT/-/-/0x00 if: 0x1 c: 0x1
     proc=0x25f978aa0, name=FileOpenBlock, file=ksfd.h LINE:6448, pg=0
    (FOB) 0x25304d5f8 flags=2050 fib=0x25550e9c8 incno=0 pending i/o cnt=0
     fname=/uat3/UAT2DB/DATA/IDX_ACCT_TRANS_1_UAT2.dbf
     fno=31 lblksz=8192 fsiz=76144
    ----------------------------------------
    SO: 0x25304d4d8, type: 10, owner: 0x25f978aa0, flag: INIT/-/-/0x00 if: 0x1 c: 0x1
     proc=0x25f978aa0, name=FileOpenBlock, file=ksfd.h LINE:6448, pg=0
    (FOB) 0x25304d4d8 flags=2050 fib=0x25550e3b8 incno=0 pending i/o cnt=0
     fname=/uat3/UAT2DB/DATA/IDX_ACCT_MASTER_1_UAT2.dbf
     fno=30 lblksz=8192 fsiz=21160
Je pense que c'est un problème de mémoire, mais ça reste à confirmé.