-
Encrption not work on 9i - ORA-12657
Oracle 9i(9.2.0.1) on Sun Solaris 9
sql+(v9.2.0.2)connection failed. Please see sqlnet.ora for both client and server below.
************
* CLIENT
************
SQLNET.ENCRYPTION_TYPES_CLIENT = (RC4_56, RC4_128, DES, DES40)
128, DES, DES40)
sqlnet.encryption_client = required
trace_level_client=16
trace_file_client=c:\temp\mytrace.trc
**************************
* SERVER SUN SOLARIS 9
**************************
sqlnet.crypto_seed="fewkpfrepgomrepogmropegjerpogjpejvvmmrpm"
sqlnet.encryption_server = accepted
SQLNET.ENCRYPTION_TYPES_SERVER = (RC4_56, RC4_128, DES, DES40)
-------------
trace file look like
[13-JAN-2004 09:04:30:968] -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
[13-JAN-2004 09:04:30:968] Successful parameter table load
[13-JAN-2004 09:04:30:968] -> PARAMETER TABLE HAS THE FOLLOWING 13-JAN-2004 09:04:30:968] SQLNET.AUTHENTICATION_SERVICES = (NTS)
[13-JAN-2004 09:04:30:968] sqlnet.encryption_client = required
[13-JAN-2004 09:04:30:968] trace_file_client = c:\temp\mytrace.trc
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
[13-JAN-2004 09:04:30:968] Log stream will be "F:\ORA92NEW\BIN\sqlnet.log"
[13-JAN-2004 09:04:30:968] Log stream validation not requested
[13-JAN-2004 09:04:30:968] --- LOG CONFIGURATION INFORMATION ENDS ---
[13-JAN-2004 09:04:30:968] nrigbni: Unable to get data from navigation file tnsnav.ora
[
Last edited by james_cc; 01-14-2004 at 06:11 PM.
-
I got it to work on a different Win2k box. The NT client where I was testing early probably had too many Oracle version installs and so got confused.
--------------------------------------
It's not what the world does to you that matters. It's how you respond...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|