'Oracle SSL error in sqlnet.ora giving an error
I have configured the oracle wallet at server side, checked listenmer is listening on port 2484 if sqlnet.ora is not configured, but once sqlnet.ora is configured with wallet location, listener is not starting and getting the error:
TNS-12560: TNS:protocol adapter error
TNS-00583: Valid node checking: unable to parse configuration parameters
tnsping on SSL is not working.
so if sqlnet.ora we are not putting listener.ora is working fine and up and running.
we are putting this content in sqlnet.ora with wallet location for SSL
WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=D:\oracle\Ora12c\product\12.2.0\dbhome_1\BIN\wallet)))NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES,HOSTNAME)SQLNET.AUTHENTICATION_SERVICES=(TCPS,NTS,NONE)SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIREDSQLNET.ENCRYPTION_TYPES_CLIENT=(AES256)SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1)#sqlnet.fallback_authentication = TRUESSL_CLIENT_AUTHENTICATION=FALSE
names.default_zone=MPM
below s the configuration file sqlnet.ora
WALLET_LOCATION=
(SOURCE=
(METHOD=FILE)
(METHOD_DATA=
(DIRECTORY=D:\oracle\Ora12c\product\12.2.0\dbhome_1\BIN\wallet)
)
)
NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES,HOSTNAME)
SQLNET.AUTHENTICATION_SERVICES=(TCPS,NTS,NONE)
SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIRED
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256)
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1)
#sqlnet.fallback_authentication = TRUE
SSL_CLIENT_AUTHENTICATION=FALSE
NAMES.DAFAULT_DOMAIN=NPT
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
