Bonjour à tous,
Je viens vers vous pour un problème sur lesquel je me casse les dents
J'aimerais mettre en place une configuration Dataguard avec en primary un RAC (2 noeuds, ASM) et en standby une base standalone (fichiers NTFS).
Voici un peu plus de détails sur la configuration :
- toutes les machines sont en Windows 2003 R2 64bits
- Oracle 10g 10.2.0.4
- utilisation de l'outil Dataguard Broker
- mode archivelog activé
- primary database : TST (instances tst1 et tst2)
- standby database : TSTDG
Avant toute chose je tiens à préciser que la fonction Dataguard fonctionne très bien, les log transitent bien de la primary vers la standby. Le switchover en mode manuel fonctionne également bien.
On en vient à ce qui ne fonctionne pas :
- le switchover via l'outil DGBroker.
J'ai une jolie erreur :
Voici le contenu de mes listener.ora :OCIServerAttach failed -1
.. Detailed OCI error val is 12514 and errmsg is 'ORA-12514: TNS:listener does not currently know of service requested in connect descriptor'
- Sur les noeuds 1 et 2 du RAC -primary database- (au bémol près des petites modifications -> "1" devient "2") :
Bon je ne vais pas en mettre plus pour ne pas trop surcharger le post. J'ai sous la main tout ce qu'il faut si besoin (tsnames, pfile, log etc.).
LISTENER_TSTRAC1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TSTRAC1vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = TSTRAC1)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
SID_LIST_LISTENER_TSTRAC1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = tst1)
(GLOBAL_DBNAME = tst_dgmgrl)
(ORACLE_HOME = E:\ora10g\product\10.2.0\db_1)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\ora10g\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
- Sur la standby :
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = tstdg)
(GLOBAL_DBNAME = tstdg_dgmgrl)
(ORACLE_HOME = E:\ora10g\product\10.2.0\db_1)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\ora10g\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = NTSRVDataguard.relaish_dns.fr)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
Résultats de la commande lsnrctl status :
- Sur le noeud 1 (primary) :
LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 12-MAY-2010 16:01
:07
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_TSTRAC1
Version TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Produ
ction
Start Date 11-MAY-2010 16:01:31
Uptime 0 days 23 hr. 59 min. 36 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\ora10g\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File E:\ora10g\product\10.2.0\db_1\network\log\listener_tst
rac1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.2.91)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.2.89)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+asm1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+asm1", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "TST" has 2 instance(s).
Instance "tst1", status READY, has 2 handler(s) for this service...
Instance "tst2", status READY, has 1 handler(s) for this service...
Service "TST_DGB" has 2 instance(s).
Instance "tst1", status READY, has 2 handler(s) for this service...
Instance "tst2", status READY, has 1 handler(s) for this service...
Service "TST_XPT" has 2 instance(s).
Instance "tst1", status READY, has 2 handler(s) for this service...
Instance "tst2", status READY, has 1 handler(s) for this service...
Service "tstXDB" has 2 instance(s).
Instance "tst1", status READY, has 1 handler(s) for this service...
Instance "tst2", status READY, has 1 handler(s) for this service...
Service "tst_dgmgrl" has 1 instance(s).
Instance "tst1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
- Sur le noeud 2 (primary) :
LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 12-MAY-2010 16:02
:32
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_TSTRAC2
Version TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Produ
ction
Start Date 11-MAY-2010 16:02:11
Uptime 1 days 0 hr. 0 min. 21 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\ora10g\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File E:\ora10g\product\10.2.0\db_1\network\log\listener_tst
rac2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.2.92)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.2.90)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+asm2", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+asm2", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "TST" has 2 instance(s).
Instance "tst1", status READY, has 1 handler(s) for this service...
Instance "tst2", status READY, has 2 handler(s) for this service...
Service "TST_DGB" has 2 instance(s).
Instance "tst1", status READY, has 1 handler(s) for this service...
Instance "tst2", status READY, has 2 handler(s) for this service...
Service "TST_XPT" has 2 instance(s).
Instance "tst1", status READY, has 1 handler(s) for this service...
Instance "tst2", status READY, has 2 handler(s) for this service...
Service "tstXDB" has 2 instance(s).
Instance "tst1", status READY, has 1 handler(s) for this service...
Instance "tst2", status READY, has 1 handler(s) for this service...
Service "tst_dgmgrl" has 1 instance(s).
Instance "tst2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
- sur la standby :
LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 12-MAY-2010 16:04
:36
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=NTSRVDataguard.relaish_d
ns.fr)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Produ
ction
Start Date 11-MAY-2010 16:04:01
Uptime 1 days 0 hr. 0 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\ora10g\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File E:\ora10g\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=NTSRVDataGuard.relaish_dns.fr)(PORT=
1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "TSTDG_DGB" has 1 instance(s).
Instance "tstdg", status READY, has 1 handler(s) for this service...
Service "TSTDG_XPT" has 1 instance(s).
Instance "tstdg", status READY, has 1 handler(s) for this service...
Service "tstXDB" has 1 instance(s).
Instance "tstdg", status READY, has 1 handler(s) for this service...
Service "tstdg" has 1 instance(s).
Instance "tstdg", status READY, has 1 handler(s) for this service...
Service "tstdg_dgmgrl" has 1 instance(s).
Instance "tstdg", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Résultat de la commande crs_stat -t :
Name Type Target State Host
---------------------------------------------------------
ora....T1.inst application ONLINE ONLINE tstrac1
ora....T2.inst application ONLINE ONLINE tstrac2
ora.TST.db application ONLINE ONLINE tstrac2
ora....SM1.asm application ONLINE ONLINE tstrac1
ora....C1.lsnr application ONLINE ONLINE tstrac1
ora....ac1.gsd application ONLINE ONLINE tstrac1
ora....ac1.ons application ONLINE ONLINE tstrac1
ora....ac1.vip application ONLINE ONLINE tstrac1
ora....SM2.asm application ONLINE ONLINE tstrac2
ora....C2.lsnr application ONLINE ONLINE tstrac2
ora....ac2.gsd application ONLINE ONLINE tstrac2
ora....ac2.ons application ONLINE ONLINE tstrac2
ora....ac2.vip application ONLINE ONLINE tstrac2
Dernières précisions :
- les tnsping fonctionnent (dans tous les sens)
- je ne peux pas accéder à la primary depuis la machine standby lorsque la base est offline (sqlplus /@tst1 as sysdba me renvoie une erreur)
Une remarque :
- j'ai lu dans la doc d'Oracle que dans le cas d'un RAC en primary toutes les instances sont arrêtées sauf une. Dans mon cas les deux instances sont arrêtées, aucune ne reste online.
Voilà j'attends vos demandes de précisions.
En espérant que quelqu'un puisse m'aider, merci à tous.
Rida
Partager