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 databaseLe listener ecoute sur le port 1522:
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2Le problème vient de: StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S72SDEIGCWD)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SIGC9BKP_DGMGRL)(INSTANCE_NAME=SIGC9BKP)(SERVER=DEDICATED)))'
Comment mettre à jour le port d'ecoute dans la config DG Broker ?
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)
Merci.
Partager