Unable to load oci.dll

[CJF]

I have Oracle 9.2.0.1 client and Oracle data provider 9.2.0.4 installed on a
Windows 2003 Enterpriser server. I've granted the aspnet user rights to
read and execute files under the oracle home folder. In fact, for testing
purposes I removed those security settings and added the acccount as a local
administrator and I still get the "Unable to load oci.dll" error. I do not
have impersonation turned on. The aspnet account is the account being used.

Is there something different about Windows 2003 security?

Help?

Thx, Chris

 

[CJF]

I've also confirmed that I can connect to Oracle using sqlplus. I have also
uninstalled odp.net and reinstalled and rebooted with no success. Chris

 

[Paul Clement]

¤ I have Oracle 9.2.0.1 client and Oracle data provider 9.2.0.4 installed on a
¤ Windows 2003 Enterpriser server. I've granted the aspnet user rights to
¤ read and execute files under the oracle home folder. In fact, for testing
¤ purposes I removed those security settings and added the acccount as a local
¤ administrator and I still get the "Unable to load oci.dll" error. I do not
¤ have impersonation turned on. The aspnet account is the account being used.
¤
¤ Is there something different about Windows 2003 security?

In 2003 Server ASP.NET runs under the Network Service account:

HOW TO: Secure an ASP.NET Application by Using Windows Security
http://support.microsoft.com/default.aspx?scid=kb;en-us;315736


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[CJF]

So how does one allow "network service" to access the oracle bin folder?
This is not a user account accessible to change permissions on in the user
management console of 2003. What's the point of there being the aspnet
account if it's not being used? It's still present. I see Paul's url link
mentions the "network service" user account, but it doesn't mention anything
about managing permissions with this account.

Thanks,
Chris

 

[CJF]

ok, so I was able to add the "network service" account to the oracle folder
and grant permissions so that the oci.dll file could be loaded.
Unfortunetly, it didn't change the result.
Anyone else deal with this situation? Windows 2003 + asp.net + oracle
access = "unable to load oci.dll"

Thx,Chris

 

[Miha Markic [MVP C#]]

Hi,

Does network service have read access to all folders in path to oci.dll?
It should have read privilege on Oracle, ora92 folders and on its bin
folder.

 

[Paul Clement]

¤ ok, so I was able to add the "network service" account to the oracle folder
¤ and grant permissions so that the oci.dll file could be loaded.
¤ Unfortunetly, it didn't change the result.
¤ Anyone else deal with this situation? Windows 2003 + asp.net + oracle
¤ access = "unable to load oci.dll"

OK, lets back up a second. What is the authentication setting for your web application? Basic, NT,
Anonymous (none)?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[CJF]

Hi,
The IIS security is set to anonymous. The asp.net authentication type is
forms.
On my XP desktop, aspnet has read and execute permissions to the oracle bin
folder and it works fine
On the 2003 server, "network service" and "aspnet" have read and execute
permissions to the oracle bin folder and it fails.

I experimented by removing all acl settings for these accounts and placing
them in the local administrator's group. I still can't get the oracle files
to load (unable to load dll (oci.dll)). I also experimented by giving the
anonymous account (iusr_machinename) read and execute privleges to the bin
folder and it didn't help.

Thanks for giving me your time with this issue. Chris

 

[Miha Markic [MVP C#]]

Hi CJF,

Try this: from within asp.net application code try to read the oci.dll
(hardcode the path) file and see if exception is thrown.

 

[Paul Clement]

¤ Hi,
¤ The IIS security is set to anonymous. The asp.net authentication type is
¤ forms.
¤ On my XP desktop, aspnet has read and execute permissions to the oracle bin
¤ folder and it works fine
¤ On the 2003 server, "network service" and "aspnet" have read and execute
¤ permissions to the oracle bin folder and it fails.
¤
¤ I experimented by removing all acl settings for these accounts and placing
¤ them in the local administrator's group. I still can't get the oracle files
¤ to load (unable to load dll (oci.dll)). I also experimented by giving the
¤ anonymous account (iusr_machinename) read and execute privleges to the bin
¤ folder and it didn't help.
¤
¤ Thanks for giving me your time with this issue. Chris

You might want to try dumping out the authenticated user ID to the WebForm just to verify the
account that is being used:

System.Security.Principal.WindowsIdentity.GetCurrent.Name.Split("\"c)(1)


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[CJF]

Hey thanks for all the suggestions.
I did another complete uninstall and installed the latest ODP.net classes
(9.2.04) and was finally able to get things working, keeping the security
for the aspnet and network services account as read and execute on oracle's
bin folder.

Thanks again, Chris

 

[Eric Norberg]

This was fixed on my PC by granting full access to the Everyone group to
the directory containing OCI.DLL.