views:

37

answers:

0

I have configured ssl through net manager after added ewallet which is in READY mode. I even restarted the all the database services. But I am not able to figure the reason the listener not working. Need advise and let me know if you need anyother log or config files..

sqlnet.log:

Fatal NI connect error 28750, connecting to: (DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS=(PROTOCOL=TCPS)(HOST=kcr-PC)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sal)(SERVER=DEDICATED)(CID=(PROGRAM=C:\oracle\dbase\11.1.0\jdk\jre\bin\java.exe)(HOST=KCR-PC)(USER=kcr))))

VERSION INFORMATION: TNS for 32-bit Windows: Version 11.1.0.7.0 - Production Time: 14-SEP-2010 21:05:15 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: TNS:protocol adapter error ns secondary err code: 0 nt main err code: 540 TNS-00540: SSL protocol adapter failure Oracle error 1: 28750 ORA-28750: unknown error nt secondary err code: 0 nt OS err code: 0

listener.ora

SSL_CLIENT_AUTHENTICATION = FALSE

WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = C:\Users\kcr\Oracle\WALLETS) ) )

LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCPS)(HOST = kcr-PC)(PORT = 1521))

sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (BEQ, TCPS)

SSL_VERSION = 3.0

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SSL_CLIENT_AUTHENTICATION = FALSE

WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = C:\Users\kcr\Oracle\WALLETS) ) )

SSL_CIPHER_SUITES= (SSL_RSA_EXPORT_WITH_RC4_40_MD5)

tnsname.ora:

SAL2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = kcr-PC)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = sal) ) )