ORA-12645: Parameter does not exist
Problem:
You hit this error when connecting to database:
ORA-12645: Parameter does not exist.
It’s because DBA has inserted some lines related with ASO (Advanced Security Option).
Solution:
You must add those lines to your sqlnet.ora
No need to restart anything at client side. Just connect to your database.
Sample sqlnet.ora
—————–
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT= (SHA1) SQLNET.CRYPTO_CHECKSUM_CLIENT = requested SQLNET.ENCRYPTION_TYPES_CLIENT = (AES256) SQLNET.ENCRYPTION_CLIENT = requested SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA1,MD5) SQLNET.CRYPTO_CHECKSUM_SERVER = accepted SQLNET.ENCRYPTION_TYPES_SERVER = (AES256,RC4_256,RC4_128) SQLNET.ENCRYPTION_SERVER = accepted
For further reading:
http://docs.oracle.com/cd/E11882_01/network.112/e10746/asoappa.htm#ASOAG9771
Leave a comment