Labels

.net (1) *nix (1) administration (1) Android (2) Axis2 (2) best practice (5) big-data (1) business-analysis (1) code re-use (1) continuous-integration (1) Cordova-PhoneGap (1) database (2) defect (1) design (3) Eclipse (7) education (1) groovy (2) https (2) Hudson (4) Java (1) JAX-RS (2) Jersey (3) Jetty (1) localization (1) m2eclipse (2) MapForce (1) Maven (12) MySQL (1) Nexus (4) notes (4) OO (1) Oracle (4) performance (1) Perl (1) PL/SQL (1) podcast (1) PostgreSQL (1) requirement (1) scripting (1) serialization (1) shell (1) SoapUI (1) SQL (1) SSH (2) stored procedure (1) STS (2) Subclipse (1) Subversion (3) TOAD (3) Tomcat (4) UML (2) unit-testing (2) WAMP (1) WAS (3) Windows (3) WP8 (2) WTP (2) XML (4) XSLT (1)

Monday, October 11, 2010

Getting TOAD running without tnsnames.ora, etc.

  1. Download/install TOAD
  2. Download/install Oracle Instant Client
  3. Know your database server's Host IP, Port number, and SID for desired database
  4. When you attempt to connect using TOAD, fill in the "Direct" tab with the information from previous step and select to connect using Instant Client (may already be the default)
Additional note:  Although I am using 64-bit Windows 7, the 64-bit version of the Instant Client did not appear to work (an error about "unable to load oci.dll" within TOAD).  However, the 32-bit version worked fine.
    Posted by at No comments:
    Labels: ,
    Subscribe to: Posts (Atom)