3 Replies Latest reply: Apr 20, 2009 1:20 PM by user597097 RSS

    Cant connect to PL/SQL developer - Probably because multiply clients

    user597097
      Hi all,
      I have oracle 10G DB for windows(I have xp pro sp3).
      Recently I installed the "Oracle 11g ODAC and Oracle Developer Tools for Visual Studio".
      And it asked me for oracle home and base. I gave the same base as the DB but different home.

      Know I trying to connect the db through pl/sql developer and I got


      "Initialization error
      Could not locate OCI dll

      OracleHomeKey SOFTWARE\ORACLE\KEY_ORA_ODP_HOME
      OracleHome_Dir c:\OracleDB\10g\ODP?

      My guess is multiply clients, but I dont know how to fix that.
      In addition I get the following error while installing both the DB and the above tool(only ignore helped).

      "ole initialization or ocx load error while registering ocx"
        • 1. Re: Cant connect to PL/SQL developer - Probably because multiply clients
          75407
          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.
          • 2. Re: Cant connect to PL/SQL developer - Probably because multiply clients
            Laurenz Albe
            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).

            Yours,
            Laurenz Albe
            • 3. Re: Cant connect to PL/SQL developer - Probably because multiply clients
              user597097
              What patch?

              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:

              listener.ora:

              SID_LIST_LISTENER =
              (SID_LIST =
              (SID_DESC =
              (SID_NAME = PLSExtProc)
              (ORACLE_HOME = C:\OracleDB\10G\IIDB)
              (PROGRAM = extproc)
              )
              (SID_DESC =
              (GLOBAL_DBNAME = iidb)
              (ORACLE_HOME =C:\OracleDB\10G\IIDB)
              (SID_NAME = iidb)
              )
              )

              LISTENER =
              (DESCRIPTION_LIST =
              (DESCRIPTION =
              (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = NIR_CLIENT)(PORT = 1521)))
              (ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)))
              )
              )


              TNSNAMES:

              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

              Solved:

              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