Skip to content
September 10, 2012 / doganay

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: