title: How to acess locally installed Oracle 11 g throught PL/SQL Developer 9
body: <p>I need to develop in PL SQL using PL/SQL developer but I don't have idea how to make both oracle 11g and pl/sql developer work in the same machine because pl/sql developer need 32 bit  oracle client installed when oracle did not require client when we work in local machine.
  This is what I did:</p>
  
  <p>1) I installed oracle 11g 64 bit Enterprise on drive d:\
  2) Then I installed oracle client 32 bit on drive c:(pl/sql developer can work only with 32 bit version of oci.dll)
  3) After I went to the client_home%->Network->Admin folder and corrected tnsname.ora file and wrote there my connection setting which was copied from my oracle 11 g home_dir..tnsnames.ora</p>
  
  <pre><code>    MyOracle =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
          (CONNECT_DATA =
            (SERVICE_NAME = orcl)
  )
  </code></pre>
  
  <p>After I installed PL/SQL developer in c:\plsqldev\ and rebooted my machine.</p>
  
  <p>So now  I can connect to my database with sql*plus located in my oracle database directory , but when I try to connect to my oracle with my client sql*plus it says tns protocol error when I try to connect using pl/sql developer it says could not resolve the connection identifier specified. What should I do? Could you help me please</p>
  
  <p><strong>Added:</strong>
  I erased TNSNAMES parameter from NAMES.DIRECTORY_PATH (in both - server and client sqlnet.ora files) and now when i login it says: ora-12154 tns could not resolve the connect identifier specified , but it still sucessfully connecting to DB when i try to connect with SERVER - s sql*plus.</p>
  
  <p>Here is my config files:</p>
  
  <pre><code>**servers listener.ora **
  
          SID_LIST_LISTENER =
        (SID_LIST =
          (SID_DESC =
            (SID_NAME = CLRExtProc)
            (ORACLE_HOME = D:\app\Light\product\11.2.0\dbhome_1)
            (PROGRAM = extproc)
            (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Light\product\11.2.0\dbhome_1\bin\oraclr11.dll")
          )
        )
  
      LISTENER =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
            (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
          )
        )
  ADR_BASE_LISTENER = D:\app\Light
  </code></pre>
  
  <p><strong>servers  sqlnet.ora</strong></p>
  
  <pre><code>SQLNET.AUTHENTICATION_SERVICES= (NONE)
  
  NAMES.DIRECTORY_PATH= (HOSTNAME)
  </code></pre>
  
  <p><strong>servers  tnsname.ora</strong></p>
  
  <pre><code> LISTENER_ORCL =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  
  
      ORACLR_CONNECTION_DATA =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          )
          (CONNECT_DATA =
            (SID = CLRExtProc)
            (PRESENTATION = RO)
          )
        )
  
      ORCL =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = orcl)
          )
        )              
  </code></pre>
  
  <h2><strong>Clients sqlnet.ora</strong></h2>
  
  <pre><code>SQLNET.AUTHENTICATION_SERVICES= (NONE)
  
  NAMES.DIRECTORY_PATH= (HOSTNAME)
  </code></pre>
  
  <p><strong>Clients tnsnames.ora</strong></p>
  
  <pre><code>    ORCL =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
        (SERVICE_NAME = orcl)
      )
    )
  </code></pre>
  
  <p><strong>ADD:</strong> 
  Yess!)) Finally i found the solution: :)
  We need to use server's config file instead of clients one -  but the oci.dll(32bit) must be taken from clients directory. I will describe the basic steps - how i made pl/sql developer 10.0.2 work with locally installed Oracle 11.2 x64:</p>
  
  <p>1) Fist we need to install Oracle (I installed it to d:\app)  </p>
  
  <p>2)Then wee need to download and install oracle <strong>instant</strong> client (i founded that there are not any config files (not even network->admin directory) in the instant client , just needed dll's like oci.dll and etc.. note: the first time i've choosen "administrator" one which have it's own config file inside, seems this kind of client is needed only for remote access to Oracle). I installed(unpacked) my instant client  to c:\app\ ;</p>
  
  <p>3) Open PL/SQL developer , go to tools->preferences->connection and set the "Oracle Home" filed to the home directory of your instant client (I puted c:\app), but usually it already exist in the drop down list and we just need to click the drop down list and choose OraClient11g_home1_32bit , by this way i set the oci library path(choosen from drop down list). Click apply and exit from pl/sql developer;</p>
  
  <p>4) Now we need to create two environment variables(the fist one will show the path to folder with connection configs , the second the language(if i'm not right please correct me)) -> </p>
  
  <ul>
  <li><p>TNS_ADMIN = %SERVER_HOME%\NETWORK\ADMIN\ (i puted D:\app\Light\product\11.2.0\dbhome_1\NETWORK\ADMIN)</p></li>
  <li><p>TNS_LANG = AMERICAN_CIS.CL8MSWIN1251</p></li>
  </ul>
  
  <p>5) Reboot (optionally) and then start pl/sql developer - there must be three connection alias , i choosed orcl , entered my login ,password and hiited OK and everything worked )));</p>
  
  <p>Thank's to everyone who answered in this topic, hope it'll help someone</p>