?
Solved

Problem deploying .net web app\Oracle 10g

Posted on 2007-07-30
4
Medium Priority
?
1,814 Views
Last Modified: 2013-12-18
I am trying to deploy a .NET Oracle web application developed in VS2005 to a customer machine via a Deploy project.
I am getting the following error on the customer machine when the app is installed and run.

'Exception: System.ApplicationException: Error - CreateDatagrid Unable to find an entry point named 'OpsConGetAttributes in DLL OraOps10.dll' at .......

I have included Oracle.DataAccess.dll version 10.2.0.100 in the installation and it all appears to be installed in the correct locations.
How can I resolve this problem or what steps can I take to trouble shoot it?
I have carried out test installations on a box with a full 10g client installed in house with no issues so I presume it is likely to be an Oracle Version problem...
0
Comment
Question by:c_law
2 Comments
 
LVL 22

Accepted Solution

by:
Helena Marková earned 1000 total points
ID: 19598061
Here are some tips from Oracle MetaLink's Note:312298.1:
....
1. Usually this is an access privilege issue which is documented in Note 215255.1 "Unable to Connect to Database with Oracle Client Software". If that does not resolveNote 215255.1 "Unable to Connect to Database with Oracle Client Software". If that does not resolve the issue reboot the machine after giving all authenticated users IUSR, ASPNET, IWAM, anonymous,  etc to have at a least a READ access to the oracle home on the Web Server machine

OR

2. Missing Oracle software which documented in Note 239722.1 "Deploying VB.NET Application Fails With Unhandled Exception: System.DllNotFoundException: Unable to load DLL OraOps9.dll"

OR

3. Make sure the $ORACLE_HOME\bin is in the PATH statement.

OR

4. Workaround: If for some unclear reasons the issue persists, the following workaround may be employed.

     A. Copy the ORAOPS10.dll from the $ORACLE_HOME\bin folder on Web Server  machine to the IIS 6.0 applications virtual directory \bin folder.

     B. Reboot the machine.

Note: Step 4 workaround requires manual maintenance of the ORAOPS10.dll. If the Oracle client software gets updated on the machine with a new or patched ODP.net the new ORAOPS10.dll needs to be copied over into the apps-virtual-directory\bin.
0
 

Author Comment

by:c_law
ID: 19598106
I will get the customer to try these.

"Unable to find an entry point named 'OpsConGetAttributes in DLL OraOps10.dll' at ......." I originally thought this was a versionign problem as it was not saying "Cannot find ORaOps.dll which I have had in the past?
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to recover a database from a user managed backup
Suggested Courses
Course of the Month16 days, 17 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question