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.