[ORA-04031][USER: guest] : quelques explications
Bonjour à tous,
Oracle 9i standard édition release 9.2.0.7
1/ Sur notre serveur web, je découvre ce matin une erreur ORA-0401
Citation:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","unknown object","joxs heap init","ioc_allocate_pal")
Est-ce selon vous un problème de dimensionnement de la SHARED_POOL ?
2/ je poursuis l'analyse du fichier Alert.log, et qu'est ce que je découvre : un user GUEST a procédé à un redimensionnement de la JAVA_POOL et à procéder au redémarrage de la base.
Sauf que ce user GUEST je le connais pas !!!!!!! User interne Oracle ?
Extrait du fichier AlertWeb.log
Code:
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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
| Errors in file d:\oracle\admin\web\udump\web_ora_1576.trc:
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","unknown object","joxs heap init","ioc_allocate_pal")
Tue Mar 25 09:08:02 2008
ALTER SYSTEM SET java_pool_size='8388608' SCOPE=SPFILE;
Tue Mar 25 09:08:02 2008
ALTER SYSTEM SET java_pool_size='8388608' SCOPE=SPFILE;
Tue Mar 25 09:08:02 2008
ALTER SYSTEM SET pga_aggregate_target='20971520' SCOPE=SPFILE;
Tue Mar 25 09:08:05 2008
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 4
All dispatchers and shared servers shutdown
Tue Mar 25 09:08:07 2008
ALTER DATABASE CLOSE NORMAL
Tue Mar 25 09:08:07 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Mar 25 09:08:07 2008
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 823
Successful close of redo thread 1
Tue Mar 25 09:08:07 2008
Completed: ALTER DATABASE CLOSE NORMAL
Tue Mar 25 09:08:07 2008
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Mar 25 09:08:13 2008
Starting ORACLE instance (normal)
Tue Mar 25 09:08:13 2008
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 54525952
large_pool_size = 8388608
java_pool_size = 8388608
control_files = D:\oracle\oradata\WEB\CONTROL01.CTL, D:\oracle\oradata\WEB\CONTROL02.CTL, D:\oracle\oradata\WEB\CONTROL03.CTL
db_block_size = 4096
db_cache_size = 33554432
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 8
fast_start_mttr_target = 0
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 900
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = WEB
dispatchers = (PROTOCOL=TCP) (SERVICE=WEBXDB)
job_queue_processes = 10
hash_join_enabled = FALSE
background_dump_dest = D:\oracle\admin\WEB\bdump
user_dump_dest = D:\oracle\admin\WEB\udump
core_dump_dest = D:\oracle\admin\WEB\cdump
sort_area_size = 524288
db_name = WEB
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 20971520
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Mar 25 09:08:16 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Oracle Data Guard is not available in this edition of Oracle.
Tue Mar 25 09:08:17 2008
/* OracleOEM */ ALTER DATABASE MOUNT
Tue Mar 25 09:08:21 2008
Successful mount of redo thread 1, with mount id 2933944449
Tue Mar 25 09:08:21 2008
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Tue Mar 25 09:08:21 2008
/* OracleOEM */ ALTER DATABASE OPEN
Tue Mar 25 09:08:22 2008
Thread 1 opened at log sequence 823
Current log# 1 seq# 823 mem# 0: D:\ORACLE\ORADATA\WEB\REDO01.LOG
Current log# 1 seq# 823 mem# 1: D:\ORACLE\ORADATA\WEB\REDO011.LOG
Successful open of redo thread 1
Tue Mar 25 09:08:22 2008
SMON: enabling cache recovery
Tue Mar 25 09:08:22 2008
Successfully onlined Undo Tablespace 1.
Tue Mar 25 09:08:22 2008
SMON: enabling tx recovery
Tue Mar 25 09:08:22 2008
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN |
Quelqu'un peut-il m'apporter une explication sur l'erreur ORA et surtout sur ce user GUEST qui a procédé à des modifications de paramétres d'initialisation sans que je l'ai autorisé ???
çà m'inquiété cette affaire :cry::cry:
Merci d'avance pour votre aide
