Discussion :

[ecureuilmasque]

Bjr,

J'ai "cassé" la config de mon entreprise Manager (11.1.0.6) par :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

emca -deconfig all db -repos drop

sur mes 2 instances (Prod et Test)

A la re-création en lisant les log j'obtiens une erreur sur SYSMAN (ORA-20001: SYSMAN already exists..)
Faut-il que je drop le schéma de SYSMAN avant de faire le :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

emca -config dbcontrol db -repos create (ou recreate c pareil d'ailleurs)

Si je passe par dbca j'obtiens :

Could not find appropriate listener for this database. configuring DB Control requires database to be registered with atleast one listener

- (Méchant assistant)

mon 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
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = prod)
      (ORACLE_HOME = D:\Ora11\product\11.1.0\db_1)
      (SID_NAME = prod)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = test)
      (ORACLE_HOME = D:\Ora11\product\11.1.0\db_1)
      (SID_NAME = test)
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Serveur)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

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
lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-FÉVR.-2010 15:56:17
 
Copyright (c) 1991, 2007, Oracle.  All rights reserved.
 
Connexion à (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Serveur)(PORT=1521)))
STATUT du PROCESSUS D'ECOUTE
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Production
Date de départ                       12-FÉVR.-2010 14:46:07
Durée d'activité                    0 jours 1 heures 10 min. 11 sec
Niveau de trace           off
Sécurité                  ON: Local OS Authentication
SNMP                      OFF
Fichier de paramètres du processus d'écoute     D:\Ora11\product\11.1.0\db_1\network\admin\listener.ora
Fichier journal du processus d'écoute             d:\ora11\diag\tnslsnr\serveur\listener\alert\log.xml
Récapitulatif d'écoute des points d'extrémité...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Serveur)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Récapitulatif services...              
Le service "prodXDB" comporte 1 instance(s).
  L'instance "prod", statut READY, comporte 1 gestionnaire(s) pour ce service...
Le service "prod_XPT" comporte 1 instance(s).
  L'instance "prod", statut READY, comporte 1 gestionnaire(s) pour ce service...
Le service "testXDB" comporte 1 instance(s).
  L'instance "test", statut READY, comporte 1 gestionnaire(s) pour ce service...
Le service "test_XPT" comporte 1 instance(s).
  L'instance "test", statut READY, comporte 1 gestionnaire(s) pour ce service...
Le service "prod" comporte 2 instance(s).
  L'instance "prod", statut UNKNOWN, comporte 1 gestionnaire(s) pour ce service...
  L'instance "prod", statut READY, comporte 1 gestionnaire(s) pour ce service...
Le service "test" comporte 2 instance(s).
  L'instance "test", statut UNKNOWN, comporte 1 gestionnaire(s) pour ce service...
  L'instance "test", statut READY, comporte 1 gestionnaire(s) pour ce service...
La commande a réussi

(J'comprends pas trop pourquoi il me voit 2 instances dont une sur "unknow" d'ailleurs)
Merci

[ecureuilmasque]

La solution (pour l'instant ça en fonctionne que sur la prod :

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
63
64
65
66
67
68
69
70
71
72
73
74
drop user sysman cascade;
drop user MGMT_VIEW cascade;
drop role MGMT_USER;
drop public synonym SETEMVIEWUSERCONTEXT;
drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
drop PUBLIC SYNONYM MGMT_AVAILABILITY;
DROP PUBLIC SYNONYM MGMT_SEVERITY_OBJ;
DROP PUBLIC SYNONYM MGMT_SEVERITY_ARRAY;
DROP PUBLIC SYNONYM MGMT_GUID_OBJ;
DROP PUBLIC SYNONYM MGMT_GUID_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_AVAIL_OBJ;
DROP PUBLIC SYNONYM SMP_EMD_TARGET_OBJ;
DROP PUBLIC SYNONYM SMP_EMD_TARGET_OBJ_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_DELETE_REC_ARRAY;
DROP PUBLIC SYNONYM MGMT_METRICS;
DROP PUBLIC SYNONYM MGMT_TARGETS;
DROP PUBLIC SYNONYM MGMT_TYPE_PROPERTIES;
DROP PUBLIC SYNONYM MGMT_TARGET_PROPERTIES;
DROP PUBLIC SYNONYM MGMT_METRICS_RAW;
DROP PUBLIC SYNONYM MGMT_CURRENT_METRICS;
DROP PUBLIC SYNONYM MGMT_STRING_METRIC_HISTORY;
DROP PUBLIC SYNONYM MGMT_LONG_TEXT;
DROP PUBLIC SYNONYM MGMT_METRICS_COMPOSITE_KEYS;
DROP PUBLIC SYNONYM MGMT_METRICS_1HOUR;
DROP PUBLIC SYNONYM MGMT_METRICS_1DAY;
DROP PUBLIC SYNONYM MGMT_METRIC_ERRORS;
DROP PUBLIC SYNONYM MGMT_CURRENT_METRIC_ERRORS;
DROP PUBLIC SYNONYM EMD_MNTR;
DROP PUBLIC SYNONYM MGMT_METRIC_COLLECTIONS;
DROP PUBLIC SYNONYM MGMT_COLLECTION_PROPERTIES ;
DROP PUBLIC SYNONYM MGMT_METRIC_THRESHOLDS;
DROP PUBLIC SYNONYM SMP_EMD_NVPAIR;
DROP PUBLIC SYNONYM SMP_EMD_NVPAIR_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_STRING_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_STRING_ARRAY_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_INTEGER_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_INTEGER_ARRAY_ARRAY;
DROP PUBLIC SYNONYM MGMT_DELTA_IDS;
DROP PUBLIC SYNONYM MGMT_DELTA_ID_VALUES;
DROP PUBLIC SYNONYM MGMT_DELTA_ENTRY;
DROP PUBLIC SYNONYM MGMT_DELTA_ENTRY_VALUES;
DROP PUBLIC SYNONYM MGMT_DELTA_VALUE;
DROP PUBLIC SYNONYM MGMT_DELTA_VALUES;
DROP PUBLIC SYNONYM MGMT_NAME_VALUE;
DROP PUBLIC SYNONYM MGMT_NAME_VALUES;
DROP PUBLIC SYNONYM ECM_UTIL;
DROP PUBLIC SYNONYM MGMT_DELTA;
DROP PUBLIC SYNONYM MGMT_TARGET_MEMBERSHIPS;
DROP PUBLIC SYNONYM MGMT_JOB;
DROP PUBLIC SYNONYM MGMT_JOB_PARAMETER;
DROP PUBLIC SYNONYM MGMT_JOB_TARGET;
DROP PUBLIC SYNONYM MGMT_JOB_SCHEDULE;
DROP PUBLIC SYNONYM MGMT_JOB_EXECPLAN;
DROP PUBLIC SYNONYM MGMT_JOB_EXEC_SUMMARY;
DROP PUBLIC SYNONYM MGMT_JOB_OUTPUT;
DROP PUBLIC SYNONYM MGMT_JOB_EXECUTION;
DROP PUBLIC SYNONYM MGMT_LOG;
DROP PUBLIC SYNONYM MGMT_ADMIN;
DROP PUBLIC SYNONYM MGMT_GLOBAL;
DROP PUBLIC SYNONYM MGMT_TARGET;
DROP PUBLIC SYNONYM MGMT_CREDENTIAL;
DROP PUBLIC SYNONYM MGMT_JOBS;
DROP PUBLIC SYNONYM MGMT_PREFERENCES;
DROP PUBLIC SYNONYM MGMT_USER;
DROP PUBLIC SYNONYM MGMT_SEVERITY;
DROP PUBLIC SYNONYM MGMT_CURRENT_SEVERITY;
DROP PUBLIC SYNONYM MGMT_PAF_PROCS_LATEST;
DROP PUBLIC SYNONYM MGMT_PAF_JOBS;
DROP PUBLIC SYNONYM MGMT_PAF$PROCEDURES;
DROP PUBLIC SYNONYM MGMT_PAF$INSTANCES;
DROP PUBLIC SYNONYM MGMT_PAF$STATES;
DROP PUBLIC SYNONYM MGMT_PAF$APPLICATIONS;
DROP PUBLIC SYNONYM MGMT_VIEW_UTIL;
DROP PUBLIC SYNONYM MGMT_MESSAGES;