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.ora                s.a.b. 
*.ora                    s.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: peter.lee_at_honeywell.com

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: ListGuru_at_fatcity.com (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: SinardyXing_at_bkgcomsvc.com

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: ListGuru_at_fatcity.com (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).