2 Replies Latest reply: Nov 3, 2012 4:20 PM by Srini Chavali-Oracle RSS

    Connect Toad freeware with Oracle express Edition, How?

    Nico van de Kamp
      Hello,

      Although I know that people will raise the question this is Oracle and use SQL developer... Ok I do that and that is working fine. But on my work they work with TOAD so I like to work with TOAD as well and I want get some knowledge about Toad, TNSNAMES etc.

      I've put the issue on TOAD forum as well, but till now I don't have received an answer.

      I want to teach/learn myself Oracle by working with the Oracle express edition. I have downloaded the SQL Developer and I can work with it, which means I can create a connection.


      Errors when I try to work with TOAD are:
      If i try to make a connection:
      - "No valid clients found. You need at least one 64-bit client properly configured"

      If I click on TNSNames editor:
      - Access violation in address xxxxxxx at module TOAD.exe"

      I have installed oracle at D:\ORACLE_HOME. In this directory is also a TNSNAMES.ORA file.

      I have installed the express edition with the installer. I have first installed the Oracle express edition and later TOAD.

      I'm working on my local machine with:
      - windows 7 Home
      - Oracle 32 bit client:

      - Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
      - PL/SQL Release 11.2.0.2.0 - Production
      - "CORE 11.2.0.2.0 Production"
      - TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
      - NLSRTL Version 11.2.0.2.0 - Production

      - TOAD 64-bit freeware.

      *Questions:*
      *- Are there certain environment variables necessary? Does TOAD expect Oracle at a certain directory?*
      *- Is it necessary to add something to the PATH environment variable?*
      *- 32-bit Oracle client will working with the 64-bit TOAD freeware?*

      Nico
        • 1. Re: Connect Toad freeware with Oracle express Edition, How?
          Srini Chavali-Oracle
          >
          I'm working on my local machine with:
          - windows 7 Home
          - Oracle 32 bit client:
          >

          Home versions of Windows are not certified/supported to run Oracle software - so things may or may not work as advertised - pl use a supported OS.

          HTH
          Srini
          • 2. Re: Connect Toad freeware with Oracle express Edition, How?
            orafad
            Nico van de Kamp wrote:

            I've put the issue on TOAD forum as well, but till now I don't have received an answer.
            Yes, correct, visit toadworld.com. This is not the proper forum.


            >
            Errors when I try to work with TOAD are:
            What version toad? Is it 11.6 x64?
            If i try to make a connection:
            - "No valid clients found. You need at least one 64-bit client properly configured"
            Listen to that message. A 64-bit program requires 64-bit libraries.

            I have installed the express edition with the installer. I have first installed the Oracle express edition and later TOAD.

            I'm working on my local machine with:
            - windows 7 Home
            Home editions are not supported, sorry.
            - Oracle 32 bit client:
            What is it - Client or Server?
            - Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
            >
            - TOAD 64-bit freeware.
            Perhaps easiest way out is to remove 64-bit Toad and install the 32-bit one instead.

            >
            Questions:
            - Are there certain environment variables necessary? Does TOAD expect Oracle at a certain directory?
            - Is it necessary to add something to the PATH environment variable?
            - 32-bit Oracle client will working with the 64-bit TOAD freeware?
            All these should be directed elsewhere, e.g. at some Toad forum, maybe at toadworld.com.