SWITCHOVER et démarrage automatique [Fait]

**mortimer.pw** · 23/03/2009, 13h14

Bonjour tout le monde,

J'essaye de mettre en place le Dataguard sur une 11g Entreprise (Red-Hat-5).

Lors du SWITCHOVER, j'obtiens ce message :

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
 
[oracle@ora01-ls-un0 ~]$ dgmgrl
DGMGRL for Linux: Version 11.1.0.6.0 - 64bit Production
 
Copyright (c) 2000, 2005, Oracle. All rights reserved.
 
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys;
Password:
Connected.
DGMGRL> switchover to "STBBPLS";
Performing switchover NOW, please wait...
New primary database "STBBPLS" is opening...
Operation requires shutdown of instance "BPLS" on database "BPLS"
Shutting down instance "BPLS"...
ORA-01109: database not open
 
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "BPLS" on database "BPLS"
Starting instance "BPLS"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 
Failed.
You are no longer connected to ORACLE
Please connect again.
Unable to start instance "BPLS"
You must start instance "BPLS" manually
Switchover succeeded, new primary is "STBBPLS"
DGMGRL> DGMGRL> [oracle@ora01-ls-un0 ~]$

Dans le fichier trace du Dataguard, j'ai ceci :

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
 
DG 2009-03-23-11:52:22        0 2 0 RSM detected log transport problem: log transport for database 'BPLS' has the following error.
DG 2009-03-23-11:52:22        0 2 0   ORA-12537: TNS:connection closed
DG 2009-03-23-11:52:22        0 2 0 RSM0: HEALTH CHECK ERROR: ORA-16737: the redo transport service for standby database "BPLS" has an error
DG 2009-03-23-11:52:22        0 2 0 NSV0: Failed to connect to remote database BPLS. Error is ORA-01034
DG 2009-03-23-11:52:22        0 2 0 NSV0: Failed to send message to site BPLS. Error code is ORA-01034.
DG 2009-03-23-11:52:22        0 2 682256059 DMON: Database BPLS returned ORA-01034
DG 2009-03-23-11:52:22        0 2 682256059       for opcode = CTL_GET_STATUS, phase = BEGIN, req_id = 2.1.682256059
DG 2009-03-23-11:52:22        0 2 682256059 Operation CTL_GET_STATUS canceled during phase 2, error = ORA-16778
DG 2009-03-23-11:52:22        0 2 682256059 Operation CTL_GET_STATUS canceled during phase 2, error = ORA-16778
DG 2009-03-23-11:53:22        0 2 0 RSM detected log transport problem: log transport for database 'BPLS' has the following error.
DG 2009-03-23-11:53:22        0 2 0   ORA-12537: TNS:connection closed
DG 2009-03-23-11:53:22        0 2 0 RSM0: HEALTH CHECK ERROR: ORA-16737: the redo transport service for standby database "BPLS" has an error
DG 2009-03-23-11:53:22        0 2 0 NSV0: Failed to connect to remote database BPLS. Error is ORA-01034
DG 2009-03-23-11:53:22        0 2 0 NSV0: Failed to send message to site BPLS. Error code is ORA-01034.
DG 2009-03-23-11:53:22        0 2 682256062 DMON: Database BPLS returned ORA-01034
DG 2009-03-23-11:53:22        0 2 682256062       for opcode = CTL_GET_STATUS, phase = BEGIN, req_id = 2.1.682256062
DG 2009-03-23-11:53:22        0 2 682256062 Operation CTL_GET_STATUS canceled during phase 2, error = ORA-16778
DG 2009-03-23-11:53:22        0 2 682256062 Operation CTL_GET_STATUS canceled during phase 2, error = ORA-16778
DG 2009-03-23-11:54:13  1001000 3 682257251 DMON: Entered rfm_get_chief_lock() for CTL_SWITCH, reason 0
DG 2009-03-23-11:54:13  1001000 3 682257251 DMON: chief lock convert for switchover
DG 2009-03-23-11:54:13        0 2 0 DMON: Updated MIV to 49, writing metadata to "/u01/app/oracle/product/11.1.0/db_1/dbs/dr1STBBPLS.dat"

Avez-vous déjà rencontré ce problème ?

Merci pour vos réponses.

**orafrance** · 23/03/2009, 15h08

As tu changer le listener de chaque noeud pour ajouter le service DGMGRL ?

cf la doc : http://download-west.oracle.com/docs...l.htm#BABECEJC

**mortimer.pw** · 23/03/2009, 15h38

Bonjour Orafrance,

Oui.

Fichier Listener.ora côté Primary :

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
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ora01)(PORT = 1521))
    )
  )
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = BPLS)
      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
      (SID_NAME = BPLS)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = STBBPLS)
      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
      (SID_NAME = BPLS)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = BPLS_DGMGRL
      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
      (SID_NAME = BPLS)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = STBBPLS_DGMGRL
      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
      (SID_NAME = BPLS)
    )
  )

Fichier Listener.ora côté Standby :

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
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ora02)(PORT = 1521))
    )
  )
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC=
      (GLOBAL_DBNAME=STBBPLS)
      (ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1)
      (SID_NAME=BPLS)
    )
    (SID_DESC=
      (GLOBAL_DBNAME=BPLS)
      (ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1)
      (SID_NAME=BPLS)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = STBBPLS_DGMGRL
      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
      (SID_NAME = BPLS)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = BPLS_DGMGRL
      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
      (SID_NAME = BPLS)
    )
  )

Merci pour ton aide.

**orafrance** · 23/03/2009, 15h45

le SID Name ne doit pas être le même il me semble.

**mortimer.pw** · 23/03/2009, 16h01

Le SID_NAME ne doit-il pas correspondre au nom de la BDD ?
Ne doit-il pas être identique sur les 2 machines ?
Je ne trouve pas d'exemple bien clair sur le contenu des fichiers Listener.ora et Tnsnames.ora pour la mise en place du Dataguard avec 2 machines.
Merci de m'aider.

**orafrance** · 23/03/2009, 16h32

Non, c'est le DB_UNIQUE_NAME avec des noms d'instances différents... enfin, pour ma part, je préfère avoir deux instances différentes.

Exemple :
Listener de la Primary

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = PRIM)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = PRIM)
)
(SID_DESC =
(GLOBAL_DBNAME = PRIM_DGMGRL)
(SERVICE_NAME = PRIM_DGMGRL)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = PRIM)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PRIM_HOST.iter.org)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

Celui de la Standby

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = STDBY)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = STDBY)
)
(SID_DESC =
(GLOBAL_DBNAME = STDBY_DGMGRL)
(SERVICE_NAME = STDBY_DGMGRL)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = STDBY)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = STDBY_HOST.iter.org)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

TNSNAMES des deux:

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
STDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = STDBY_HOST.iter.org)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = STDBY)
    )
  )
 
PRIM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = PRIM_HOST.iter.org)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PRIM)
    )
  )

TNSNAMES du serveur broker (pour le fast-start failover)

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
STDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = STDBY_HOST.iter.org)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = STDBY)
    )
  )
 
PRIM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = PRIM_HOST.iter.org)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PRIM)
    )
  )
 
STDBY_DGMGRL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = STDBY_HOST.iter.org)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = STDBY_DGMGRL)
    )
  )
 
PRIM_DGMGRL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = PRIM_HOST.iter.org)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PRIM_DGMGRL)
    )
  )

**mortimer.pw** · 23/03/2009, 17h25

Je ne comprend plus trés bien.
Peux-tu m'éclairer sur les différentes dénominations : DB_NAME, DB_UNIQUE_NAME, SID, SID_NAME, GLOBAL_DBNAME ?

**mortimer.pw** · 24/03/2009, 15h39

Bonjour,

J'ai trouvé mon problème, il manquait une parenthése à droite de DGMGRL dans les fichiers Listener.ora.

Merci encore pour ton aide Orafrance.

SWITCHOVER et démarrage automatique [Fait]

Administration Oracle

Vue hybride

Discussions similaires

Partager

Partager