connection to standby DB of Dataguard
Hi,
on 10g R2 on WIN 2003 ,I have created my standby following 374069.1 metalink note. Now in alertlog of my primary I have this error :
Code:
1
2
3
4
5
6
| PING[ARCo]: Heartbeat failed to connect to standby 'AUX'. Error is 12514.
Mon Sep 24 13:59:52 2007
Error 12514 received logging on to the standby
Mon Sep 24 13:59:52 2007
Errors in file c:\oracle\product\10.2.0\admin\prod\bdump\prod_arco_184.trc:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor aux |
Here is my tnsnames.ora on primary server(where PROD DB is) :
Code:
1
2
3
4
5
6
7
8
9
|
AUX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.14)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AUX)
)
) |
And following is listener.ora on Standby server (AUX):
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
|
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = aux)
(ORACLE_HOME= C:\oracle\product\10.2.0\db_1)
)
) |
And when I ping AUX on Primary server :
Code:
1
2
3
4
5
|
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.14)(PORT = 1522)) (CONNECT_DATA = (S
VICE_NAME = PROD)))
OK (30 msec) |
And the services on standby server :
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 24-SEPT.-2007 14:11:49
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connexion Ó (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
RÚcapitulatif services...
Le service "PLSExtProc" comporte 1 instance(s).
L'instance "PLSExtProc", statut UNKNOWN, comporte 1 gestionnaire(s) pour ce service...
Gestionnaire(s) :
"DEDICATED" Útabli : 0 refusÚ : 0
LOCAL SERVER
Le service "aux" comporte 1 instance(s).
L'instance "aux", statut UNKNOWN, comporte 1 gestionnaire(s) pour ce service...
Gestionnaire(s) :
"DEDICATED" Útabli : 0 refusÚ : 0
LOCAL SERVERHave you any idea of the cause and solution of the error I have in alertlog ?
Many thanks.
