Enough of ORA-12640. Please help.

Andurin · #1 (**permalink**) 02-27-07, 07:54

Hello to all,
First I want to start with my faulting server description:

(Lets name this machine as Machine91)
Oracle 10g release 10.2.0.2.0
MS Windows 2003 Enterprise Edition with service pack 1 and IIS 6.0

I've a web application (ASP.NET application) gives the following error when ever I try to login (that checks my password and username etc. from an oracle database).
"ORA-12640: Authentication adapter initialization failed."

Ok, I have a solution for this problem which is:
The original entry in sqlnet.ora file :
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Changing this one to:
SQLNET.AUTHENTICATION_SERVICES = (NONE).

But I simply don't want to use it. Because. This web project works without problem if I place and configure it on my local machine which is a Windows XP professional with IIS 5.1. The same web application successfully connects to the oracle database (that database server is the same server that I mentioned above *Machine91 ) and logins to the program...

What is the difference ? why Machine91's IIS can not connect to the Oracle DB on it self and give "ORA-12640: Authentication adapter initialization failed." error ?

Any ideas ?

Thank you very much.

Note: If more information is needed for you to answer I can give additional information. Please just ask.

LKBrwn_DBA · #2 (**permalink**) 02-27-07, 11:01

The most common cause of permission problems when you are trying to run ASP pages is the fact that the IIS users do not have read & execute access on the %ORACLE_HOME% directory and subdirectories (%ORACLE_HOME%\bin in particular).

You may need to do a SQL*Net trace to identify the source of your error. To enable SQL*Net tracing, in the sqlnet.ora file add the following lines:

trace_level_client=16
trace_file_client=cli
trace_directory_client=d:\temp
trace_unique_client=true
trace_timestamp_client=ON

Andurin · #3 (**permalink**) 02-27-07, 11:49

Ok I've done the thing as you say.
Now how am I supposed to diagnose this error using the trace file I got from the error. I mean It seems quite long, is there some software that does this for me, or should I look some specific sentence like

Quote:

.
.
.
(7416) [27-ŞUB-2007 18:35:02:284] Attempted load of system pfile source D:\oracle\product\10.2.0\network\admin\sqlnet.ora
(7416) [27-ŞUB-2007 18:35:02:284] Parameter source loaded successfully
(7416) [27-ŞUB-2007 18:35:02:284]
(7416) [27-ŞUB-2007 18:35:02:284] Attempted load of local pfile source c:\windows\system32\inetsrv\sqlnet.ora
(7416) [27-ŞUB-2007 18:35:02:284] Parameter source was not loaded
.
.
.

The original file is very long (69 KB) this is just a sample..

Can you please give more detailed information about diagnosing the error.

LKBrwn_DBA · #4 (**permalink**) 02-27-07, 12:18

If there is an error, it should be recorded in the trace file -- Unfortunately, ORA-12640 is a somewhat generic error. If you are using the Microsoft ODBC Driver for Oracle, try instead using the Oracle ODBC Driver which may lead to a more informative error.

Have you checked/granted read & execute permissions on %ORACLE_HOME% and all sub-folders?

Also check out the logs under %ORACLE_HOME%\network\log.

Good luck!

PS: There is no software I know of that will diagnose this error.

Andurin · #5 (**permalink**) 02-28-07, 05:14

Going still crazy about this error.
I've already changed the permissions of oracle home directory and all it's subdirectories including BIN. I also checked the files one by one

The ASP.NET Machine Account has rights to read open execute whatever privileges to access to the oracle directory. I compare my two machines ( My Local Machine and Server Machine) and they have the same asp.net account privileges to all sub directories of oracle home.
And we're already using Oracle ODBC driver...

Configuration #1:

My Local machine running IIS 5.1( and my web application) and has oracle 10.1.0 installed (but not running an instance)
Server Running Oracle 10.2.0.2.0 installed (and running the instance needed by my application)

Authentication succeeds and web application works

Configuration #2:

Server Running IIS 6.0 (and my web application) and has oracle 10.2.0.2.0 installed (and running instance needed by my application)

Authentication service fails to start or initialize what ever and my application does not work ?!

ok now, please forgive me for this one. This is not a "play on my home" project. So that i should do this

Would anyone please check this trace log file that my error created.
There are some specific points that "ERROR" and "Oracle error" words occur. Might be helpful while skimming.

[DT] represents DATE and TIME string. I've replaced them with [DT] to shorten load...

Code:

.
.
.
[DT] nacomap: Packet length	158
	 # of services	4
	 Error sent?	FALSE
[DT] nacomap: Version transmitted: Oracle Advanced Security: Oracle Advanced Security for 32-bit Windows: Version 10.2.0.2.0 - Production
[DT] nacomps: entry
[DT] nacomps: service	supervisor
	 # of fields	3
	 	       ORACLE error	0
[DT] nacomps: 	data length	4
		data type	version stamp
[DT] nacomps: 	data length	8
		data type	raw data
[DT] nacomps: 	data length	18
		data type	raw data
[DT] nacomps: service	authentication
	 # of fields	5
	 	       ORACLE error	0
[DT] nacomps: 	data length	4
		data type	version stamp
[DT] nacomps: 	data length	2
		data type	2 byte numeric
[DT] nacomps: 	data length	2
		data type	status
[DT] nacomps: 	data length	1
		data type	1 byte numeric
[DT] nacomps: 	data length	3
		data type	string
[DT] nacomps: service	encryption
	 # of fields	2
	 	       ORACLE error	0
[DT] nacomps: 	data length	4
		data type	version stamp
[DT] nacomps: 	data length	12
		data type	raw data
[DT] nacomps: service	crypto-checksumming
	 # of fields	2
	 	       ORACLE error	0
[DT] nacomps: 	data length	4
		data type	version stamp
[DT] nacomps: 	data length	3
		data type	raw data
[DT] nacomps: exit
[DT] nacomap: exit
[DT] nacomsn: sending 158 bytes
[DT] nsnasend: entry
[DT] nsnasend: bytes to send: 158
[DT] nsdo: entry
[DT] nsdo: cid=0, opcode=67, *bl=158, *what=1, uflgs=0x22, cflgs=0x3
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] nsdo: rank=64, nsctxrnk=0
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsdo: nsctx: state=8, flg=0x2400d, mvd=0
[DT] nsdo: gtn=32, gtc=32, ptn=10, ptc=2011
[DT] nsdo: 158 bytes to NS buffer
[DT] nsdoacts: entry
[DT] nsdofls: entry
[DT] nsdofls: DATA flags: 0x0
[DT] nsdofls: sending NSPTDA packet
[DT] nspsend: entry
[DT] nspsend: plen=168, type=6
[DT] nttwr: entry
[DT] nttwr: socket 1052 had bytes written=168
[DT] nttwr: exit
- some packet dump here-
[DT] nspsend: 168 bytes to transport
[DT] nspsend: normal exit
[DT] nsdofls: exit (0)
[DT] nsdoacts: flushing transport
[DT] nttctl: entry
[DT] nsdoacts: normal exit
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] nsdo: nsctxrnk=0
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsdo: normal exit
[DT] nsnasend: normal exit
[DT] nacompd: entry
[DT] nacompd: exit
[DT] nacomsn: exit
[DT] na_receive_packet: entry
[DT] nacomrc: entry
[DT] nsnareceive: entry
[DT] nsnareceive: buffer address: 0xe5f6ca8 bytes wanted: 2048
[DT] nsnareceive: calling NS to receive 2048 bytes into address 0xe5f6ca8
[DT] nsdo: entry
[DT] nsdo: cid=0, opcode=68, *bl=2048, *what=0, uflgs=0x0, cflgs=0x3
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] nsdo: rank=64, nsctxrnk=0
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsdo: nsctx: state=8, flg=0x2400d, mvd=0
[DT] nsdo: gtn=32, gtc=32, ptn=10, ptc=2011
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsrdr: entry
[DT] nsrdr: recving a packet
[DT] nsprecv: entry
[DT] nsprecv: reading from transport...
[DT] nttrd: entry
[DT] nttrd: socket 1052 had bytes read=163
[DT] nttrd: exit
[DT] nsprecv: 163 bytes from transport
[DT] nsprecv: tlen=163, plen=163, type=6
-some packet dump-
[DT] nsprecv: normal exit
[DT] nsrdr: got NSPTDA packet
[DT] nsrdr: NSPTDA flags: 0x0
[DT] nsrdr: normal exit
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsdo: *what=1, *bl=2048
[DT] nsdo: 153 bytes from NS buffer
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] nsdo: nsctxrnk=0
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsdo: normal exit
[DT] nsnareceive: received 153 bytes
[DT] nsnareceive: no more data to receive - returning
[DT] nsnareceive: normal exit
[DT] nsnareceive: total bytes received: 153
[DT] nacomrc: received 153 bytes
[DT] nacomrc: total data length: 153 bytes
[DT] nacomrc: Version received: Oracle Advanced Security: Oracle Advanced Security for 32-bit Windows: Version 10.2.0.2.0 - Production
[DT] nacomrc: Length	153
	 # of services	4
	 Error rec'd?	FALSE
[DT] nacomus: entry
[DT] nacomus: service	supervisor
	 # of fields	3
	 ORACLE error	0
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	supervisor
	 		   data type:	version stamp
	 data length:	4
[DT] nacomdp: exit
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	supervisor
	 		   data type:	status
	 data length:	2
[DT] nacomdp: exit
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	supervisor
	 		   data type:	raw data
	 data length:	14
[DT] nacomdp: exit
[DT] nacomus: exit
[DT] nacomus: entry
[DT] nacomus: service	authentication
	 # of fields	7
	 ORACLE error	0
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	authentication
	 		   data type:	version stamp
	 data length:	4
[DT] nacomdp: exit
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	authentication
	 		   data type:	status
	 data length:	2
[DT] nacomdp: exit
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	authentication
	 		   data type:	1 byte numeric
	 data length:	1
[DT] nacomdp: exit
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	authentication
	 		   data type:	string
	 data length:	3
[DT] nacomdp: exit
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	authentication
	 		   data type:	version stamp
	 data length:	4
[DT] nacomdp: exit
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	authentication
	 		   data type:	4 byte numeric
	 data length:	4
[DT] nacomdp: exit
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	authentication
	 		   data type:	4 byte numeric
	 data length:	4
[DT] nacomdp: exit
[DT] nacomus: exit
[DT] nacomus: entry
[DT] nacomus: service	encryption
	 # of fields	2
	 ORACLE error	0
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	encryption
	 		   data type:	version stamp
	 data length:	4
[DT] nacomdp: exit
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	encryption
	 		   data type:	1 byte numeric
	 data length:	1
[DT] nacomdp: exit
[DT] nacomus: exit
[DT] nacomus: entry
[DT] nacomus: service	crypto-checksumming
	 # of fields	2
	 ORACLE error	0
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	crypto-checksumming
	 		   data type:	version stamp
	 data length:	4
[DT] nacomdp: exit
[DT] nacomdp: entry
[DT] nacomdp: direction:	inbound
	 service:	crypto-checksumming
	 		   data type:	1 byte numeric
	 data length:	1
[DT] nacomdp: exit
[DT] nacomus: exit
[DT] nacomrc: exit
[DT] na_receive_packet: exit
[DT] na_csrd: entry
[DT] nas_ccn: entry
[DT] nacomrp: entry
[DT] nacomrp: exit
[DT] nas_gusl: exit
[DT] nas_ccn: exit
[DT] nau_ccn: entry
[DT] nau_rpv: entry
[DT] nacomrp: entry
[DT] nacomrp: exit
[DT] nau_rpv: Version received for 32-bit Windows: Version 10.2.0.2.0 - UNKNOWN
[DT] nau_rpv: Connection version for 32-bit Windows: Version 10.2.0.2.0 - UNKNOWN
[DT] nau_rpv: adapter version communication is supported by other process
[DT] nau_rpv: exit
[DT] nau_cga: entry
[DT] nacomrp: entry
[DT] nacomrp: exit
[DT] nacomrp: entry
[DT] nacomrp: exit
[DT] nacomrp: entry
[DT] nacomrp: exit
.
.

It continues on next msg
Thanks alot.
Onur

Andurin · #6 (**permalink**) 02-28-07, 05:15

Code:

[DT] nau_cga: client received negotiated adapter - type: auth. service name: NTS
[DT] nau_gse: entry
[DT] nau_fad: entry
[DT] nau_fad: searching for "NTS" adapter
[DT] nau_fad: 	supported adapter: "KERBEROS5"
[DT] nau_fad: 	supported adapter: "NTS"
[DT] nau_fad: exit
[DT] naunts: entry
[DT] naunts5: entry
[DT] naunts5: exit
[DT] naunts: exit
[DT] nau_gse: adapter initialization function failed
[DT] nau_gse: failed with error 12640
[DT] nau_gse: exit
[DT] nau_cga: failed with error 12640
[DT] nau_cga: exit
[DT] nau_ccn: failed with error 12640
[DT] nacomsd: entry
[DT] nacomfsd: entry
[DT] nacomfsd: exit
[DT] nacomsd: exit
[DT] nau_ccn: exit
[DT] na_csrd: failed with error 12640
[DT] na_csrd: exit
[DT] nacomer: error 12640 received from authentication service
[DT] nacomer: failed with error 12640
[DT] nacomsn: entry
[DT] nacomap: entry
[DT] nacomap: Packet length	21
	 # of services	1
	 Error sent?	TRUE
[DT] nacomap: Version transmitted: Oracle Advanced Security: Oracle Advanced Security for 32-bit Windows: Version 10.2.0.2.0 - Production
[DT] nacomps: entry
[DT] nacomps: service	authentication
	 # of fields	0
	 	       ORACLE error	12640
[DT] nacomps: exit
[DT] nacomap: exit
[DT] nacomsn: sending 21 bytes
[DT] nsnasend: entry
[DT] nsnasend: bytes to send: 21
[DT] nsdo: entry
[DT] nsdo: cid=0, opcode=67, *bl=21, *what=1, uflgs=0x22, cflgs=0x3
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] nsdo: rank=64, nsctxrnk=0
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsdo: nsctx: state=8, flg=0x2400d, mvd=0
[DT] nsdo: gtn=163, gtc=163, ptn=10, ptc=2011
[DT] nsdo: 21 bytes to NS buffer
[DT] nsdoacts: entry
[DT] nsdofls: entry
[DT] nsdofls: DATA flags: 0x0
[DT] nsdofls: sending NSPTDA packet
[DT] nspsend: entry
[DT] nspsend: plen=31, type=6
[DT] nttwr: entry
[DT] nttwr: socket 1052 had bytes written=31
[DT] nttwr: exit
-some packet dump-
[DT] nsdofls: exit (0)
[DT] nsdoacts: flushing transport
[DT] nttctl: entry
[DT] nsdoacts: normal exit
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] nsdo: nsctxrnk=0
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsdo: normal exit
[DT] nsnasend: normal exit
[DT] nacompd: entry
[DT] nacompd: exit
[DT] nacomsn: exit
[DT] na_client: failed with error 12640
[DT] na_client: exit
[DT] nadisc: entry
[DT] nacomtm: entry
[DT] nacompd: entry
[DT] nacompd: exit
[DT] nacompd: entry
[DT] nacompd: exit
[DT] nacomtm: exit
[DT] nas_dis: entry
[DT] nas_dis: exit
[DT] nau_dis: entry
[DT] naundiscon: entry
[DT] naun5disconnect: entry
[DT] naun5disconnect: exit
[DT] naundiscon: exit
[DT] nau_dis: exit
[DT] naeetrm: entry
[DT] naeetrm: exit
[DT] naectrm: entry
[DT] naectrm: exit
[DT] nagbltrm: entry
[DT] nau_gtm: entry
[DT] nau_gtm: exit
[DT] nagbltrm: exit
[DT] nadisc: exit
[DT] naconnect: failed with error 12640
[DT] naconnect: exit
[DT] nsnafinishconn: entry
[DT] nsnafinishconn: normal exit
[DT] nsnadoconn: error exit
[DT] nserror: entry
[DT] nserror: nsres: id=0, op=77, ns=12640, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[DT] nsnaconn: error exit
[DT] nsclose: entry
[DT] nstimarmed: entry
[DT] nstimarmed: no timer allocated
[DT] nstimarmed: normal exit
[DT] nttctl: entry
[DT] nttctl: entry
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsdo: entry
[DT] nsdo: cid=0, opcode=98, *bl=0, *what=0, uflgs=0x40, cflgs=0x2
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] nsdo: rank=64, nsctxrnk=0
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsdo: nsctx: state=8, flg=0x4009, mvd=0
[DT] nsbfr: entry
[DT] nsbaddfl: entry
[DT] nsbaddfl: normal exit
[DT] nsbfr: normal exit
[DT] nsbfr: entry
[DT] nsbaddfl: entry
[DT] nsbaddfl: normal exit
[DT] nsbfr: normal exit
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] nsdo: nsctxrnk=0
[DT] nsdo: normal exit
[DT] nsiocancel: entry
[DT] nsiofrrg: entry
[DT] nsbfr: entry
[DT] nsbaddfl: entry
[DT] nsbaddfl: normal exit
[DT] nsbfr: normal exit
[DT] nsiofrrg: exit
[DT] nsiocancel: exit
[DT] nsclose: closing transport
[DT] nttdisc: entry
[DT] nttdisc: Closed socket 1052
[DT] nttdisc: exit
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] snsbittrm_ts: entry
[DT] snsbittrm_ts: normal exit
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsclose: global context check-out (from slot 0) complete
[DT] nsnadisc: entry
[DT] nsnadisc: no native services in use - returning
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] nsopenfree_nsntx: nlhthdel from mplx_ht_nsgbu, ctx=f588c20 nsntx=f586878
[DT] nsiocancel: entry
[DT] nsiofrrg: entry
[DT] nsiofrrg: exit
[DT] nsiocancel: exit
[DT] snsbittrm_ts: entry
[DT] snsbittrm_ts: normal exit
[DT] snsbitts_ts: entry
[DT] snsbitts_ts: acquired the bit
[DT] snsbitts_ts: normal exit
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsmfr: entry
[DT] nsmfr: 1644 bytes at 0xf586878
[DT] nsmfr: normal exit
[DT] snsbitcl_ts: entry
[DT] snsbitcl_ts: normal exit
[DT] nsmfr: entry
[DT] nsmfr: 212 bytes at 0xf59dc70
[DT] nsmfr: normal exit
[DT] nsmfr: entry
[DT] nsmfr: 212 bytes at 0xf594898
[DT] nsmfr: normal exit
[DT] nladtrm: entry
[DT] nladtrm: exit
[DT] nsmfr: entry
[DT] nsmfr: 736 bytes at 0xf588c20
[DT] nsmfr: normal exit
[DT] nsclose: normal exit
[DT] nscall: error exit
[DT] nioqper:  error from nscall
[DT] nioqper:    ns main err code: 12640
[DT] nioqper:    ns (2)  err code: 0
[DT] nioqper:    nt main err code: 0
[DT] nioqper:    nt (2)  err code: 0
[DT] nioqper:    nt OS   err code: 0
[DT] niomapnserror: entry
[DT] niqme: entry
[DT] niqme: reporting NS-12640 error as ORA-12640
[DT] niqme: exit
[DT] niomapnserror: exit
[DT] niotns: Couldn't connect, returning 12640
[DT] niotns: exit
[DT] snsbittrm_ts: entry
[DT] snsbittrm_ts: normal exit
[DT] snsbittrm_ts: entry
[DT] snsbittrm_ts: normal exit
[DT] nsbfrfl: entry
[DT] nsbrfr: entry
[DT] nsbrfr: nsbfs at 0xf59d3f0, data at 0xf586ef0.
[DT] nsbrfr: normal exit
[DT] nsbrfr: entry
[DT] nsbrfr: nsbfs at 0xf59cb70, data at 0xf59f008.
[DT] nsbrfr: normal exit
[DT] nsbrfr: entry
[DT] nsbrfr: nsbfs at 0xf595880, data at 0xf56c008.
[DT] nsbrfr: normal exit
[DT] nsbfrfl: normal exit
[DT] nigtrm: Count in the NI global area is now 0
[DT] nrigbd: entry
[DT] nrigbd: exit
[DT] nigtrm: Count in the NL global area is now 0
[DT] nlse_term_audit: entry
[DT] nlse_term_audit: exit

Andurin · #7 (**permalink**) 03-05-07, 10:21

Now that I solved my problem. Here is a solution for this problem for those interested:
Setting up ODAC 1.0.1.0.4.0 to the Oracle server machine solved the problem.
Because my project has been developed using this version of oracle data access libraries. So publishing the project to another machine that does not have same version of oracle data access client Fails The Authentication adapter...

If you receive this kind of error, Check that:
1-ASPNET user has the rights to execute and read all %ORACLE_HOME%bin directory.
2-You are better be using Oracle data access drivers instead of Microsoft ODBC drivers.
3-ASP.NET application server and Oracle Database server has the same versions of Oracle.Data.Access clients libraries whatever installed.

Note: don't forget that the most important is number 3.

Internet Services

Web Development

Digital Marketing

Consumer Tech