connexion à la base ORA-12505 et [Résolu]

[big1]

Bonjour,
quand je veux me connecter via RMAN j'ai erreur suivante :

Code :

1
2
3
4
5
6
7
8
C:\Documents AND Settings\artois>rman catalog rman/XXX@BDCAT target sys/XXX@OEADP
 
Recovery Manager: Release 9.2.0.5.0 - Production
 
Copyright (c) 1995, 2002, Oracle Corporation. ALL rights reserved.
 
RMAN-04005: error FROM target DATABASE:
ORA-12514: TNS:listener could NOT resolve SERVICE_NAME given IN connect descriptor

mais quand je fais TNSPING c'est OK :

Code :

1
2
3
4
5
6
7
8
9
tnsping OEADP
 
TNS Ping Utility FOR 32-bit Windows: Version 9.2.0.5.0 - Production ON 26-DEC-2006 11:44:26
Used parameter files:
C:\oracle\ora92\network\admin\sqlnet.ora
Used TNSNAMES adapter TO resolve the alias
Attempting TO contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = gaia)(PORT= 1521))) (CONNEC
T_DATA = (SERVICE_NAME = oeadp)))
OK (20 msec)

Dans OEM pour utiliser sqlplus j'ai encore

Code :

ORA-12505: TNS: listener could NOT resolve SID given IN connection description

Même aussi :

Code :

1
2
3
4
5
6
7
8
9
LSNRCTL SERVICES oeadp
 
LSNRCTL FOR 32-bit Windows: Version 9.2.0.5.0 - Production ON 26-DEC-2006 12:58:24
 
Copyright (c) 1991, 2002, Oracle Corporation. ALL rights reserved.
 
Connecting TO (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gaia)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=oeadp)))
The listener supports no services
The command completed successfully

Avez-vous une idée ?
D'avance merci.
PS : DB 9.2.0 sous WIN2000.

[orafrance]

http://www.developpez.net/forums/sho...ight=ORA-12505

[big1]

OK, merci résolu. Deux Listener en marche, l'empéchant l'un l'autre.