Problem deploying .net web app\Oracle 10g

Posted on 2007-07-30
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 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...
Question by:c_law
    LVL 22

    Accepted Solution

    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


    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"


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


    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 the new ORAOPS10.dll needs to be copied over into the apps-virtual-directory\bin.

    Author Comment

    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?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now