Bonjour,

J'ai un souci avec ma config DG BROKER:


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
DGMGRL> show database verbose 'TSTBY';
Database - TSTBY
  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   (unknown)
  Apply Lag:       (unknown)
  Real Time Query: OFF
  Instance(s):
    TSTBY
  Properties:
    DGConnectIdentifier             = 'TSTBY'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ARCH'
    DelayMins                       = '0'
    Binding                         = 'OPTIONAL'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '8'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'TST, TSTBY'
    LogFileNameConvert              = 'TST, TSTBY'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'TSTBY'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Server)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TSTBY_DGMGRL)(INSTANCE_NAME=TSTBY)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = 'USE_DB_RECOVERY_FILE_DEST'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'
Database Status:
DGM-17016: failed to retrieve status for database "TSTBY"
ORA-16664: unable to receive the result from a database
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
Le problème vient de:
 StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S72SDEIGCWD)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SIGC9BKP_DGMGRL)(INSTANCE_NAME=SIGC9BKP)(SERVER=DEDICATED)))'
Le listener ecoute sur le port 1522:

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
$ tnsping TSTBY
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 27-MAY-2013 16:43:01
Copyright (c) 1997, 2011, Oracle.  All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =server)(PORT = 1522))) (CONNECT_DATA = (SERVICE_NAME = SIGC9BKP)))
OK (10 msec)
Comment mettre à jour le port d'ecoute dans la config DG Broker ?

Merci.