This content has been marked as final. Show 3 replies
I think the order of your oracle homes may be an issue
You may be able to change these from oracle universal installer.
start \ all programs \ An Oracle Home \ Installation products \ Universal installer
If you click Installed Products button then choose Environment Path you may be ableto change oracle home path.
Beware of changes you make in case you have to revert.
Please note if you have installed 'instant client' it may not register under this and path might need to be changed manually.
I am not sure if this is useful pointers.
examing the path command in a cmd window might help.
My advice is to deinstall "Oracle 11g ODAC and Oracle Developer Tools for Visual Studio".
If you really need ODAC on a server machine, install the same version as the server, and in the same Oracle Home.
Then apply the Patch Set again (I assume that you have a Patch Set installed).
I'm currently in the environment that my server is also my dev computer (one computer for all).
I succeed to connect to the DB through pl/sql developer and through the listener. But I cant connect to the DB through Visual Studio 2008(ora 12154).
Here are the listener.ora and tnsnames.ora:
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\OracleDB\10G\IIDB)
(PROGRAM = extproc)
(GLOBAL_DBNAME = iidb)
(SID_NAME = iidb)
(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = NIR_CLIENT)(PORT = 1521)))
(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)))
iidb=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = NIR_CLIENT)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = iidb)(DATA_SOURCE = iidb)))
Edited by: user597097 on 08:46 20/04/2009
Copied the tnsnames.ora + sqlnet.ora from the db oracle_home\network\admin to the odp probider\network\admin
reset VS2008 and it worked
Edited by: user597097 on 11:18 20/04/2009