Bonjour,
Voila mon problème :
J'ai un serveur Oracle 10g (qui contient plusieurs bases) et un client Oracle 8i qui communique en SQL*Net par le port 1521 et j'aimerais me connecter à la base LNP en TCPS (donc TCP avec SSL) avec le port 2484.
Voila pour l'instant ce que j'ai fait :
- fichier listener.ora du serveur :
DIAG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.100) (PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DIAG)
)
)
DIAGDSL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.100) (PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DIAGDSL)
)
)
LNP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.100) (PORT = 1521))
(ADDRESS = (PROTOCOL = TCPS) (HOST = 192.168.2.100) (PORT = 2484))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LNP)
)
)
COMP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.100) (PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = COMP)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.100)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCPS)(HOST = 192.168.2.100)(PORT = 2484))
)
(CONNECT_DATA =
(SID = PLSExtProc)
)
)
OSS.SOURCE.MY_WALLET =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /products/oracle/network/admin/wallet)
)
)
- fichier tnsnames.ora du serveur :
- fichier sqlnet.ora :COMP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = COMP)
)
)
LNP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.100)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCPS)(HOST = 192.168.2.100)(PORT = 2484))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LNP)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.100)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCPS)(HOST = 192.168.2.100)(PORT = 2484))
)
(CONNECT_DATA =
(SID = PLSExtProc)
)
)
OSS.SOURCE.MY_WALLET =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /products/oracle/network/admin/wallet)
)
)
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0
SSL_CIPHER_SUITES = (SSL_RSA_EXPORT_WITH_RC4_40_MD5)
- fichier tnsnames.ora du client :
- fichier sqlnet.ora du client :LNP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = 192.168.2.100)(PORT = 2484))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LNP)
)
)
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (HOSTNAME, TNSNAMES)
Le problème est que je n'arrive pas à me connecter à la base LNP, j'obtiens avec SQL*Plus :- Voila ce que j'ai avec la commande lsnrctl status :ERROR : ORA : 12541: TNS : Pas de Listener
Donc si quelqu'un a déja configuré SSL dans Oracle ou si est intéressé par cette config, votre aide est la bienvenue.LSNRCTL> statu
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
Start Date 10-MAY-2006 11:14:44
Uptime 0 days 5 hr. 26 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /products/oracle/network/admin/listener.ora
Listener Log File /products/oracle/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=loifushi)(PORT=1521)))
Services Summary...
Service "COMP" has 1 instance(s).
Instance "COMP", status READY, has 1 handler(s) for this service...
Service "COMPXDB" has 1 instance(s).
Instance "COMP", status READY, has 1 handler(s) for this service...
Service "COMP_XPT" has 1 instance(s).
Instance "COMP", status READY, has 1 handler(s) for this service...
Service "LNP" has 1 instance(s).
Instance "LNP", status READY, has 1 handler(s) for this service...
Service "LNPXDB" has 1 instance(s).
Instance "LNP", status READY, has 1 handler(s) for this service...
Service "LNP_XPT" has 1 instance(s).
Instance "LNP", status READY, has 1 handler(s) for this service...
The command completed successfully
Merci d'avance.
Partager