Oracle Error 12645
[message #349378] Sat, 20 September 2008 18:41 casttree Messages: 83Registered: August 2008 Member I saw a bug which have ora-12645 exception. Looks like it is related with encryption setting in Database connection "oracle.net.encryption_client = request ", from oracle doc, looks it should be OK as long as the encryption setting of other side is not set as "rejected". ANy suggestions to avoid the ora-12645 execptions ? Thanks, Quote: java.sql.SQLException: Io exception: Oracle Error ORA-12645 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:327) at oracle.jdbc.driver.PhysicalConnection.
CRYPTO_CHECKSUM_CLIENT=requested, CRYPTO_CHECKSUM_SERVER, CRYPTO_CHECKSUM_SERVER=accepted, CRYPTO_CHECKSUM_TYPES_CLIENT, CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1), CRYPTO_CHECKSUM_TYPES_SERVER, ENCRYPTION_CLIENT, ENCRYPTION_CLIENT = requested, ENCRYPTION_SERVER, ENCRYPTION_SERVER=accepted, ENCRYPTION_TYPES_CLIENT, ENCRYPTION_TYPES_CLIENT=(AES256), ENCRYPTION_TYPES_SERVER, err, error, MD5, ORA, ora error, ora-00600, ORA-07445, ORA-12645, ORA-12645: Parameter does not exist, oracle, oracle as, oracle as a service, oracle dba, Oracle Error, oracle for, oracle for linux, oracle in, Oracle on LINUX, Oracle on http://www.orafaq.com/forum/t/126610/ UNIX, Oracle on Windows, Oracle Product, oracle sql, oracle with, Parameter does not exist, patch, Performance, pl/sql, RC4_128), RC4_256, requested, Security, sha1, sql oracle, sqlnet, SQLNET.CRYPTO_CHECKSUM_CLIENT=requested, SQLNET.CRYPTO_CHECKSUM_SERVER=accepted, SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1), SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER, SQLNET.ENCRYPTION_CLIENT = requested, SQLNET.ENCRYPTION_SERVER=accepted, SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256), SQLNET.ENCRYPTION_TYPES_SERVER, sqlnet.ora Problem: You hit this error when https://doganay.wordpress.com/2012/09/10/ora-12645-parameter-does-not-exist/ 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 Share this:PrintEmailLinkedInFacebookTwitterGoogleLike this:Like Loading... Related Filed under ORACLE ← ACL PRIVILEGE TOROLE ORA-01480: trailing null missing from STR bindvalue → Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website Yo
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive https://www.experts-exchange.com/questions/23739016/Oracle-Client-Install-Error-12645.html Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers http://psoug.org/oraerror/ORA-12645.htm Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Oracle Client Install Error 12645 Want to Advertise Here? Solved Oracle Client Install Error 12645 Posted oracle error on 2008-09-17 Oracle Database 2 Verified Solutions 5 Comments 727 Views Last Modified: 2013-12-19 I'm trying to install Oracle 10g Client on a machine. When I connect to a 9i database, I receive an error of ORA-12645: Parameter does not exist however, I can connect to a 10g database. On a different machine, I can connect oracle error 12645 to both 9i and 10g databases. I am using the same sqlnet.ora file on the machine that I can connect to both 9i and 10g. On the machine that I can connect to both 9i and 10g, I had first installed 9i and then installed 10g. On the machine where I can't connect to both I tried: - It had already had 9i... I tried installing 10g. (When I installed 10g, I couldn't connect to a 9i database) - I uninstalled 9i and 10g and intalled 10g - I reinstalled 9i and 10g Any help is appreciated!!! 0 Question by:kwieckii Facebook Twitter LinkedIn Google Best Solution bykwieckii LOG_FILE_CLIENT = sqlnet.log NAME.DEFAULT_ZONE = world NAMES.DEFAULT_DOMAIN = world TRACE_DIRECTORY_SERVER = /opt/app/oracle/network/admin/trace LOG_DIRECTORY_CLIENT = c:\oracle\ora81\network\admin Go to Solution 5 Comments LVL 7 Overall: Level 7 Oracle Database 6 Message Expert Comment by:fluglash2008-09-17 show what you have in sqlnet.ora file 0 Message Accepted Solution by:kwieckii2008-09-18 LOG_FILE_CLIENT = sqlnet.log NAME.DEFAULT_ZONE = world NAMES.DEFAULT_DOMAIN = world TRACE_DIRECTORY_SERVER = /opt/app/oracle/network/admin/trace LOG_DIRECTORY_CLIENT = c:\or
Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-12645 Error Description: Parameter does not exist. Error Cause: A sqlnet.ora parameter from which a value was needed does not exist. Action: Set the parameter in the parameter file. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 68 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?