Bonjour,

J'ai lu les posts précédents liés à cette erreur mais je n'y trouve pas de solution fonctionnant pour mon cas.
Je prends en main l'administration de ce système donc je ne suis pas encore très rodé, je vous remercie par avance de vos réponses.
La base possède 2 instances. L'erreur apparait depuis 3 jours alors qu'à priori aucun fichier de paramètrage n'a été modifié.

L'erreur se produit lors d'un lancement de sqlplus (donc pas de connexion possible) alors que l'application métier par java continue d'accéder à la base.
Le soucis opérationnel c'est que les batchs utilisent sqlplus et donc plantent.
Je poste dessous les
listener.ora
tnsname.ora
lsnrctl services

Dans le lsnrctl services, j'ai des handler en state blocked ça peut venir de là ?

tnsping BDDEX fonctionne.

listener.ora

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
# Generated by Oracle configuration tools.

LISTENER_TOTO =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = toto-vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1521)(IP = FIRST))
    )
  )

SID_LIST_LISTENER_TOTO =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = dir)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_NAME = RMAN)
      (ORACLE_HOME = dir)
      (SID_NAME = RMAN)
    )
  )
tnsname.ora

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
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
LISTENERS_BDDEX =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = toto-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = titi-vip)(PORT = 1521))
  )

BDDEX =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = toto-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = titi-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = BDDEX)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 200)
        (DELAY = 5)
      )
    )
  )

RMAN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = toto-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RMAN)
    )
  )

BDDEX2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = titi-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = BDDEX)
      (INSTANCE_NAME = BDDEX2)
    )
  )

BDDEX1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = toto-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = BDDEX)
      (INSTANCE_NAME = BDDEX1)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
lsnrctl services

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
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
LSNRCTL for Solaris: Version 10.2.0.3.0 - Production on 18-NOV-2009 14:13:51
 
Copyright (c) 1991, 2006, Oracle.  All rights reserved.
 
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "RMAN" has 2 instance(s).
  Instance "RMAN", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
  Instance "RMAN", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "RMAN_XPT" has 1 instance(s).
  Instance "RMAN", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "BDDEX" has 2 instance(s).
  Instance "BDDEX1", status READY, has 2 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:183 refused:0 state:blocked
         LOCAL SERVER
      "DEDICATED" established:3 refused:0 state:blocked
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=jupiter)(PORT=1521))
  Instance "BDDEX2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:112 refused:0 state:blocked
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=mercure)(PORT=1521))
Service "BDDEX_XPT" has 2 instance(s).
  Instance "BDDEX1", status READY, has 2 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:183 refused:0 state:blocked
         LOCAL SERVER
      "DEDICATED" established:3 refused:0 state:blocked
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=jupiter)(PORT=1521))
  Instance "BDDEX2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:112 refused:0 state:blocked
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=mercure)(PORT=1521))
The command completed successfully