RE: ASO Checksumming Parameters
Thanks for the follow up. I set TNS_ADMIN a different way; I will check into this method. BTW - I mentioned the server trace because it also provides information--sometimes more detailed--about the failing client connection. Debi At 06:28 PM 11/19/2002 -0800, you wrote: Thanks. I had run adapters and things look okay. I had not run a trace on the server, but connecting via sql*net on the server worked. However, for a remote client, the listener.trc file complained about missing parameters. I did some digging and located info about the ENVS parameter for listener.ora e.g. ENVS = 'TNS_ADMIN=/opt/oracle/dbserver/9.0.1/network/admin' Once this was set the remote connections began working as well. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 19, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Ian, I would turn on server tracing to see if you get more info about what is failing; also check what adapters on installed the server. Debi At 03:04 PM 11/19/2002 -0800, you wrote: I'm looking at configuring ASO. I have sqlnet.ora file on both the client and the server which looks like trace_level_client=16 sqlnet.encryption_server=accepted sqlnet.encryption_client=requested sqlnet.encryption_types_server=(RC4_40) sqlnet.encryption_types_client=(RC4_40) sqlnet.crypto_seed = -kdje83kkep39487dvmlqEPTbxxe70273 sqlnet.crypto_checksum_server=accepted sqlnet.crypto_checksum_client=requested sqlnet.crypto_checksum_types_server = (MD5) sqlnet.crypto_checksum_types_client = (MD5) SQLNET.AUTHENTICATION_SERVICES=(NONE) SQLNET.AUTHENTICATION_REQUIRED=FALSE sqlnet.fips_140 = true - -- I've been getting 12645 , parameter not found errors. The trace file has been very helpful specifiying the missing parameter until now. Now all that seems relevant is nacomdp: exit nacomus: exit nacomus: entry nacomus: servicecrypto-checksumming # of fields6 ORACLE error 12645. and nacomer: error 12645 received from crypto-checksumming service nacomer: failed with error 12645 snauicomparehash: failed with error 12645 snauicomparehash: exit na_client: returning status: connection in progress any idea what is wrong or missing? The client is 9.0.1.3 and the server is 9.0.1.4 both on Solaris 8 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deborah Lorraine INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deborah Lorraine INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
Re: ASO Checksumming Parameters
Ian, I would turn on server tracing to see if you get more info about what is failing; also check what adapters on installed the server. Debi At 03:04 PM 11/19/2002 -0800, you wrote: I'm looking at configuring ASO. I have sqlnet.ora file on both the client and the server which looks like trace_level_client=16 sqlnet.encryption_server=accepted sqlnet.encryption_client=requested sqlnet.encryption_types_server=(RC4_40) sqlnet.encryption_types_client=(RC4_40) sqlnet.crypto_seed = -kdje83kkep39487dvmlqEPTbxxe70273 sqlnet.crypto_checksum_server=accepted sqlnet.crypto_checksum_client=requested sqlnet.crypto_checksum_types_server = (MD5) sqlnet.crypto_checksum_types_client = (MD5) SQLNET.AUTHENTICATION_SERVICES=(NONE) SQLNET.AUTHENTICATION_REQUIRED=FALSE sqlnet.fips_140 = true --- I've been getting 12645 , parameter not found errors. The trace file has been very helpful specifiying the missing parameter until now. Now all that seems relevant is nacomdp: exit nacomus: exit nacomus: entry nacomus: servicecrypto-checksumming # of fields6 ORACLE error 12645. and nacomer: error 12645 received from crypto-checksumming service nacomer: failed with error 12645 snauicomparehash: failed with error 12645 snauicomparehash: exit na_client: returning status: connection in progress any idea what is wrong or missing? The client is 9.0.1.3 and the server is 9.0.1.4 both on Solaris 8 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deborah Lorraine INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ASO Checksumming Parameters
Thanks. I had run adapters and things look okay. I had not run a trace on the server, but connecting via sql*net on the server worked. However, for a remote client, the listener.trc file complained about missing parameters. I did some digging and located info about the ENVS parameter for listener.ora e.g. ENVS = 'TNS_ADMIN=/opt/oracle/dbserver/9.0.1/network/admin' Once this was set the remote connections began working as well. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 19, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Ian, I would turn on server tracing to see if you get more info about what is failing; also check what adapters on installed the server. Debi At 03:04 PM 11/19/2002 -0800, you wrote: I'm looking at configuring ASO. I have sqlnet.ora file on both the client and the server which looks like trace_level_client=16 sqlnet.encryption_server=accepted sqlnet.encryption_client=requested sqlnet.encryption_types_server=(RC4_40) sqlnet.encryption_types_client=(RC4_40) sqlnet.crypto_seed = -kdje83kkep39487dvmlqEPTbxxe70273 sqlnet.crypto_checksum_server=accepted sqlnet.crypto_checksum_client=requested sqlnet.crypto_checksum_types_server = (MD5) sqlnet.crypto_checksum_types_client = (MD5) SQLNET.AUTHENTICATION_SERVICES=(NONE) SQLNET.AUTHENTICATION_REQUIRED=FALSE sqlnet.fips_140 = true --- I've been getting 12645 , parameter not found errors. The trace file has been very helpful specifiying the missing parameter until now. Now all that seems relevant is nacomdp: exit nacomus: exit nacomus: entry nacomus: servicecrypto-checksumming # of fields6 ORACLE error 12645. and nacomer: error 12645 received from crypto-checksumming service nacomer: failed with error 12645 snauicomparehash: failed with error 12645 snauicomparehash: exit na_client: returning status: connection in progress any idea what is wrong or missing? The client is 9.0.1.3 and the server is 9.0.1.4 both on Solaris 8 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deborah Lorraine INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).