Listener RAC Oracle 10g

[mahieus]

Bonjour,

Est-ce que quelqu'un peut m'expliquer ceci :

Code :

1
2
3
4
5
6
7
8
 
LISTENER_W2K8ORAV10A =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = W2K8ORAV10A-VIP)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.91)(PORT = 1521)(IP = FIRST))
    )
  )

A savoir que le service suivant est désactivé sur le RAC :

Code :

OracleASM_HOMETNSListenerLISTENER_W2K8ORAV10A

Les utilisateurs peuvent se connecter aux bases de données.
Est-ce que ce service est important pour le fonctionnement du RAC ?

Pour information, les datas et logs sont sur une partition ASM.

Merci.

[ojo77]

L'extrait de fichier vient d'où ? listener.ora ? tnsnames.ora ?

Que donne comme résultat l'instruction

Code :

lsnrctl STATUS LISTENER_W2K8ORAV10A

?

[mahieus]

L'extrait de fichier vient de listener.ora

voici ce que donne l'instruction :

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
118
119
120
121
122
123
124
125
126
127
128
 
lsnrctl STATUS LISTENER_W2K8ORAV10A
 
LSNRCTL FOR 64-bit Windows: Version 10.2.0.4.0 - Production ON 08-APR-2011 14:55:01
 
Copyright (c) 1991, 2007, Oracle.  ALL rights reserved.
 
Connecting TO (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=W2K8ORAV10A-VIP)(PORT=1521)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR FOR 64-bit Windows: Version 10.2.0.4.0 - Production
Start Date                23-MAR-2011 17:57:54
Uptime                    15 days 19 hr. 57 min. 11 sec
Trace Level               admin
Security                  ON: LOCAL OS Authentication
SNMP                      OFF
Listener Parameter File   d:\app\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File         D:\traces\listener.log
Listener Trace File       D:\traces\trace1.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=W2K8ORAV10A.somme.LOCAL)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+asm1", STATUS READY, has 1 handler(s) FOR this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+asm1", STATUS READY, has 1 handler(s) FOR this service...
Service "ASEF" has 2 instance(s).
  Instance "asef1", STATUS READY, has 2 handler(s) FOR this service...
  Instance "asef2", STATUS READY, has 1 handler(s) FOR this service...
Service "ASEF_XPT" has 2 instance(s).
  Instance "asef1", STATUS READY, has 2 handler(s) FOR this service...
  Instance "asef2", STATUS READY, has 1 handler(s) FOR this service...
Service "ASEINFO" has 1 instance(s).
  Instance "aseinfo1", STATUS READY, has 2 handler(s) FOR this service...
Service "ASEINFO_XPT" has 1 instance(s).
  Instance "aseinfo1", STATUS READY, has 2 handler(s) FOR this service...
Service "ASEP" has 1 instance(s).
  Instance "asep1", STATUS READY, has 2 handler(s) FOR this service...
Service "ASEP_XPT" has 1 instance(s).
  Instance "asep1", STATUS READY, has 2 handler(s) FOR this service...
Service "ASET" has 2 instance(s).
  Instance "aset1", STATUS READY, has 2 handler(s) FOR this service...
  Instance "aset2", STATUS READY, has 1 handler(s) FOR this service...
Service "ASET_XPT" has 2 instance(s).
  Instance "aset1", STATUS READY, has 2 handler(s) FOR this service...
  Instance "aset2", STATUS READY, has 1 handler(s) FOR this service...
Service "ASTREP" has 2 instance(s).
  Instance "astrep1", STATUS READY, has 2 handler(s) FOR this service...
  Instance "astrep2", STATUS READY, has 1 handler(s) FOR this service...
Service "ASTREP_XPT" has 2 instance(s).
  Instance "astrep1", STATUS READY, has 2 handler(s) FOR this service...
  Instance "astrep2", STATUS READY, has 1 handler(s) FOR this service...
Service "ASTRES" has 2 instance(s).
  Instance "astres1", STATUS READY, has 2 handler(s) FOR this service...
  Instance "astres2", STATUS READY, has 1 handler(s) FOR this service...
Service "ASTRES_XPT" has 2 instance(s).
  Instance "astres1", STATUS READY, has 2 handler(s) FOR this service...
  Instance "astres2", STATUS READY, has 1 handler(s) FOR this service...
Service "ASTRET" has 2 instance(s).
  Instance "astret1", STATUS READY, has 2 handler(s) FOR this service...
  Instance "astret2", STATUS READY, has 1 handler(s) FOR this service...
Service "ASTRET_XPT" has 2 instance(s).
  Instance "astret1", STATUS READY, has 2 handler(s) FOR this service...
  Instance "astret2", STATUS READY, has 1 handler(s) FOR this service...
Service "DEM" has 1 instance(s).
  Instance "dem1", STATUS READY, has 2 handler(s) FOR this service...
Service "DEMXDB" has 1 instance(s).
  Instance "dem1", STATUS READY, has 1 handler(s) FOR this service...
Service "DEM_XPT" has 1 instance(s).
  Instance "dem1", STATUS READY, has 2 handler(s) FOR this service...
Service "GABO" has 1 instance(s).
  Instance "gabo1", STATUS READY, has 8 handler(s) FOR this service...
Service "GABOT" has 1 instance(s).
  Instance "gabot1", STATUS READY, has 3 handler(s) FOR this service...
Service "GABOT_XPT" has 1 instance(s).
  Instance "gabot1", STATUS READY, has 3 handler(s) FOR this service...
Service "GABOXDB" has 5 instance(s).
  Instance "gabot1", STATUS READY, has 1 handler(s) FOR this service...
  Instance "gafor1", STATUS READY, has 1 handler(s) FOR this service...
  Instance "gafor2", STATUS READY, has 1 handler(s) FOR this service...
  Instance "gapro1", STATUS READY, has 1 handler(s) FOR this service...
  Instance "garec1", STATUS READY, has 1 handler(s) FOR this service...
Service "GABO_XPT" has 1 instance(s).
  Instance "gabo1", STATUS READY, has 8 handler(s) FOR this service...
Service "GAFOR" has 2 instance(s).
  Instance "gafor1", STATUS READY, has 2 handler(s) FOR this service...
  Instance "gafor2", STATUS READY, has 2 handler(s) FOR this service...
Service "GAFOR_XPT" has 2 instance(s).
  Instance "gafor1", STATUS READY, has 2 handler(s) FOR this service...
  Instance "gafor2", STATUS READY, has 2 handler(s) FOR this service...
Service "GAPRO" has 1 instance(s).
  Instance "gapro1", STATUS READY, has 3 handler(s) FOR this service...
Service "GAPRO_XPT" has 1 instance(s).
  Instance "gapro1", STATUS READY, has 3 handler(s) FOR this service...
Service "GAREC" has 1 instance(s).
  Instance "garec1", STATUS READY, has 3 handler(s) FOR this service...
Service "GAREC_XPT" has 1 instance(s).
  Instance "garec1", STATUS READY, has 3 handler(s) FOR this service...
Service "MAR" has 1 instance(s).
  Instance "mar1", STATUS READY, has 2 handler(s) FOR this service...
Service "MARXDB" has 1 instance(s).
  Instance "mar1", STATUS READY, has 1 handler(s) FOR this service...
Service "MAR_XPT" has 1 instance(s).
  Instance "mar1", STATUS READY, has 2 handler(s) FOR this service...
Service "OASIS" has 1 instance(s).
  Instance "oasis1", STATUS READY, has 2 handler(s) FOR this service...
Service "OASIS1XDB" has 1 instance(s).
  Instance "oasis1", STATUS READY, has 1 handler(s) FOR this service...
Service "OASIS_XPT" has 1 instance(s).
  Instance "oasis1", STATUS READY, has 2 handler(s) FOR this service...
Service "ORPHEE" has 1 instance(s).
  Instance "orphee1", STATUS READY, has 2 handler(s) FOR this service...
Service "ORPHEET" has 1 instance(s).
  Instance "orpheet1", STATUS READY, has 2 handler(s) FOR this service...
Service "ORPHEET_XPT" has 1 instance(s).
  Instance "orpheet1", STATUS READY, has 2 handler(s) FOR this service...
Service "ORPHEE_XPT" has 1 instance(s).
  Instance "orphee1", STATUS READY, has 2 handler(s) FOR this service...
Service "PROGMIG" has 1 instance(s).
  Instance "progmig1", STATUS READY, has 2 handler(s) FOR this service...
Service "PROGMIG_XPT" has 1 instance(s).
  Instance "progmig1", STATUS READY, has 2 handler(s) FOR this service...
Service "PROGOS" has 1 instance(s).
  Instance "progos1", STATUS READY, has 2 handler(s) FOR this service...
Service "PROGOS_XPT" has 1 instance(s).
  Instance "progos1", STATUS READY, has 2 handler(s) FOR this service...
The command completed successfully