I just installed ODAC for Oracle Client on a windows server, that runs a sql server database, for developers to connect a web app to an Oracle/Unix database. The install states to run SQL scripts located in the $ORACLE_HOME\ASP.NET\SQL directory after the install. I'm not sure where to run them? On the ORACLE DB on the Unix server? If someone could bring me up to speed I would appreciate it. Thanks.
You'd run them on the Oracle database server, but they're only needed if you're using the Oracle Providers for ASP.NET.
If you're just installing the software so you can use OLEDB with SQL Server Linked Server for example, you don't need them. What you DO need to run though if that is the case is the oramtsadmin.sql script which creates the objects used by the Oracle MTS Recovery Service (if you dont already have those objects created on the database) as SQLServer uses distributed transactions for the Oracle connections I believe.
If I do run the scripts, do you know what user they should be run as? The developer are using ASP.NET for connectivity.
Why there is no Oracle Expert answer this simple question? ?
After ODAC 126.96.36.199.20 installation completed, there is a message in the last screen:
*"Run the SQL script located in c:\app\Administrator\product\11.1.0\client_1\ASP.NET\SQL directory for a new installation or an upgrade of Oracle Providers for ASP.NET"*
The question is: How to run these 9 SQL scripts ?
In SQL*Plus, which oracle user should I connect to in order to run these 9 scrips, including:
I just ran the Setup program for ODAC v11.1.7. At the end of a successfull install, it advised me to run the SQL scripts.
Looking through the files, I determined that you need to execute only one file, "InstallAllOracleASPNetProviders.SQL" which calls the other scripts.
The first script it refers to runs fine. (InstallOracleASPNetCommon.SQL)
But the second script refers to a function that does not exist. Even if I correct it, it runs into errors creating the synonyms!