Discussion :

[yLaplace]

bonjour,
j'ai vu des sujets similaires mais ça ne m'a pas permit de résoudre mon problème.

J'ai deux serveurs red hat 6 sur une j'ai Oracle 11.2.1 appelé rhel6 et l'autre j'ai oracle 11.2.4 appelé rhel664

rhel6 pas de souci avec Win Xp se connecte sans problème

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DB11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rhel6.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB11G)
)
)

# sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /u01/app/oracle


# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rhel6.localdomain)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /u01/app/oracle

rhel664 Win XP ne peut se connecter ora 012560

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DB11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rhel664.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB11G)
)
)

# sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /u01/app/oracle

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rhel664.localdomain)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /u01/app/oracle

Win XP

tnsname

DB11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.155)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB11G)
)
)


DB11G_R664 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.155)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB11G)
)
)

C:\>tnsping DB11G

TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 01-MAR-2
017 11:22:41

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:\Oracle\Ids10g\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.
1.155)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB11G)
))
OK (0 msec)

C:\>ping 192.168.1.251

Envoi d'une requête 'ping' sur 192.168.1.251 avec 32 octets de données*:

Réponse de 192.168.1.251*: octets=32 temps<1ms TTL=64
Réponse de 192.168.1.251*: octets=32 temps<1ms TTL=64
Réponse de 192.168.1.251*: octets=32 temps=4 ms TTL=64
Réponse de 192.168.1.251*: octets=32 temps<1ms TTL=64

Statistiques Ping pour 192.168.1.251:
Paquets*: envoyés = 4, reçus = 4, perdus = 0 (perte 0%),
Durée approximative des boucles en millisecondes :
Minimum = 0ms, Maximum = 4ms, Moyenne = 1ms

C:\>tnsping DB11G_R664

TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 01-MAR-2
017 11:24:33

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:\Oracle\Ids10g\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.
1.251)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB11G)
))
TNS-12560: TNS:protocol adapter error

C:\>

[yLaplace]

j'ai desactiver le firewall et c'est passé
merci