sessions inactives après shutdown immediate
Bonjour,
faisant shutdown immediate pour arrêter la base et ensuite redémarrer, il reste encore des sessions inactives. je dois faire shutdown abort pour qu'ils disparaissent. Avez-vous une idée ? Est-ce que les objets bloqués peuvent être une raison ?
D'avance merci.
ORACLE RDBMS Version: 8.1.7.4.0.
Voici la partie d'alertolog :
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
|
EMN0 started with pid=18
Wed Aug 2 05:00:06 2006
Shutting down instance (transactional)
All transactions complete. Performing immediate shutdown
License high water mark = 82
Wed Aug 2 05:00:14 2006
ALTER DATABASE CLOSE NORMAL
Wed Aug 2 05:00:14 2006
SMON: disabling tx recovery
Wed Aug 2 05:01:17 2006
SMON: disabling cache recovery
Wed Aug 2 05:01:18 2006
Thread 1 closed at log sequence 5713
Wed Aug 2 05:03:13 2006
Completed: ALTER DATABASE CLOSE NORMAL
Wed Aug 2 05:03:13 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
archiving is disabled
Wed Aug 2 05:03:17 2006
ARCH shutting down
ARC0: Archival stopped
Wed Aug 2 05:09:27 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.4.0.
System parameters with non-default values:
processes = 215
shared_pool_size = 419430400
...........................................
..........................................
EMN0 started with pid=17
Wed Aug 2 18:57:29 2006
Shutting down instance (transactional)
Wed Aug 2 19:29:47 2006
Shutting down instance (abort)
License high water mark = 70
Instance terminated by USER, pid = 21948
Wed Aug 2 19:29:47 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.4.0.
System parameters with non-default values:
processes = 215 |
