RE: Need help with an error ORA-12640
Hi Peter, I think you have to make sure that non - admin user have proper access right to sqlnet.ora(what is the last modified time) tnsnames.ora s.a.b. names.oras.a.b. *.oras.a.b. And of course make sure your listener is started, then check all those *.ora files -IP address, hostname, port (if you are using TCP) then try use tnsping [service_name] to hit the listener. Perhaps you can do a little bit RE to read the patch what kind of changes oracle made to your system, I am not sure about this one, but I think you install that patch with administrator account. You said you install patch then you cannot connect, if this is not Oracle Names Server then I think you can connect from client station because their parameter files are the working version. If this is Oracle Names Server, you client will get the latest changes too most likely cannot connect too. If is not ONS then you can reference your client machine setting. hope this can help you, good luck Sinardy -Original Message- Sent: 28 August 2003 14:19 To: Multiple recipients of list ORACLE-L Guru: I need help with an error ORA-12640. I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000. The sqlnet.authentication_services=(NTS) parameter is enabled and we do not want to change the sqlnet.authentication_services=(NONE). The custom SQL application is launched by a Domain User on the Oracle Server machine. If the Domain user has local administrative privileges, it works with no error. If the Domain user does not have local adminstrative privileges, it fails with the above error. I am at a lost to explain this. Does anyone has any idea? Thank you in advance. Pete -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee, Peter (AZ15) 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.net -- Author: Sinardy Xing 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: Need help with an error ORA-12640
How does the application connect to the database? username/password or '/'? Jared On Wed, 2003-08-27 at 23:19, Lee, Peter (AZ15) wrote: Guru: I need help with an error ORA-12640. I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000. The sqlnet.authentication_services=(NTS) parameter is enabled and we do not want to change the sqlnet.authentication_services=(NONE). The custom SQL application is launched by a Domain User on the Oracle Server machine. If the Domain user has local administrative privileges, it works with no error. If the Domain user does not have local adminstrative privileges, it fails with the above error. I am at a lost to explain this. Does anyone has any idea? Thank you in advance. Pete -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee, Peter (AZ15) 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.net -- Author: Jared Still 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: Need help with an error ORA-12640
Jarad: username/password Thank in advance, Pete -Original Message- Sent: Thursday, August 28, 2003 8:15 AM To: Multiple recipients of list ORACLE-L How does the application connect to the database? username/password or '/'? Jared On Wed, 2003-08-27 at 23:19, Lee, Peter (AZ15) wrote: Guru: I need help with an error ORA-12640. I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000. The sqlnet.authentication_services=(NTS) parameter is enabled and we do not want to change the sqlnet.authentication_services=(NONE). The custom SQL application is launched by a Domain User on the Oracle Server machine. If the Domain user has local administrative privileges, it works with no error. If the Domain user does not have local adminstrative privileges, it fails with the above error. I am at a lost to explain this. Does anyone has any idea? Thank you in advance. Pete -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee, Peter (AZ15) 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.net -- Author: Jared Still 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.net -- Author: Lee, Peter (AZ15) 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).
