How old is your version of toad?
Shane Borden
sborden76@xxxxxxxxx
Sent from my iPhone
On Jan 29, 2021, at 12:40 PM, Scott Canaan <srcdco@xxxxxxx> wrote:
I’ve set up my sqlnet.ora with the following entries:
SQLNET.CRYPTO_CHECKSUM_CLIENT = REQUIRED
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT= (SHA512)
The server has the following settings:
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER= (SHA512)
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT= (SHA512)
SQLNET.CRYPTO_CHECKSUM_CLIENT = REQUIRED
SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED
If I connect via SQL*Plus, it works and I get the SHA512 value:
NETWORK_SERVICE_BANNER
--------------------------------------------------------------------------------
TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
Encryption service for Linux: Version 19.0.0.0.0 - Production
AES256 Encryption service adapter for Linux: Version 19.0.0.0.0 - Production
Crypto-checksumming service for Linux: Version 19.0.0.0.0 - Production
SHA512 Crypto-checksumming service adapter for Linux: Version 19.0.0.0.0 –
Production
If I try to connect via TOAD, it fails with an ORA-12560 error. If I change
the REQUIRED to REQUESTED, it connects, but doesn’t choose an adapter. If I
add SHA1 to the types list, it will connect and use that one. Is TOAD not
compatible with anything above SHA1 (I tried SHA256 as well with the same
results)?
As far as I can see, it is configured correctly, so why doesn’t TOAD like it?
I didn’t find anything on their website about it.
Scott Canaan ‘88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco@xxxxxxx | c: (585) 339-8659
CONFIDENTIALITY NOTE: The information transmitted, including attachments, is
intended only for the person(s) or entity to which it is addressed and may
contain confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and
destroy any copies of this information.
