Solved

need to install 32-bit client on 64-bit machine, for PL/Sql Developer

Posted on 2014-10-15
10
3,755 Views
Last Modified: 2014-10-16
I have Oracle 11g on a home computer (64-bit Windows 7), and I'm trying to run PL/Sql Developer from Allround Automations. So I downloaded what seems to be 32-bit client from here: Instant Client downloads for Windows (first option). So I unzipped the files, but there's no setup file ?

Oracle Client 32-bit files
So I just unzipped the files and they are sitting there, no "installation" as far as I can tell. When running PL/SQL Developer it now says "TNS: Connect timeout occurred".

But Sql Developer works ok.

PL/Sql developer preferences for the OCI library is pointing to E:\Program Files\Oracle32\instantclient_12_1\oci.dll, where I placed the 32-bit files.
0
Comment
Question by:Gadsden Consulting
  • 6
  • 4
10 Comments
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 total points
ID: 40383389
Instant client has no install.   That is why it is 'instant' (some parts like ODBC do but not the main files).

SQL Developer doesn't need an Oracle client.  It uses the JDBC Thin connection.

>>"TNS: Connect timeout occurred"

99.999% of the time this is a firewall issue.

Check the tnsnames.ora file in the 32Bit oracle home. Make sure it is correct.
0
 

Author Comment

by:Gadsden Consulting
ID: 40383396
slightwv - thanks.

>>99.999% of the time this is a firewall issue.
- I installed PL/Sql Developer on the same machine as Oracle.

>>Check the tnsnames.ora file in the 32Bit oracle home.
- I don't see anything remotely resembling tnsnames - no "Network" folder, "Admin" - nothin' . . . .

Does the first screen shot above look like a 32-bit client home ?
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40383403
>>- I don't see anything remotely resembling tnsnames - no "Network" folder, "Admin" - nothin' . . . .

It is in the fine print of the Instant Client readme.  You need to manually create the network\admin folder and copy a sqlnet.ora and tnsnames.ora file into it
or
set the environment variable TNS_ADMIN to a folder containing a good version of the files.

>>Does the first screen shot above look like a 32-bit client home ?

Resembles an instant client install.

You might want to grab the sqlplus add-on to the same version(separate download).  Unzip it into the same folder and test connections/etc... using sqlplus.  Then move onto GUI's and other tools/programs.
0
 

Author Comment

by:Gadsden Consulting
ID: 40383413
Whoa, look at that :-)

>>set the environment variable TNS_ADMIN to a folder containing a good version of the files.
-- done, and connected !!!

Thanks a lot :-)

(now I'm good at home and at work, more or less) . . .
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40383418
For what it's worth:  I never use TNS_ADMIN.  I have local copies of the tnsnames.ora and sqlnet.ora files in every ORACLE_HOME.

That way, if I ever uninstall some old version, I don't accidentally crash everything.  It also helps if you want some tools to look in some places and other tools to look in other places.
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 

Author Comment

by:Gadsden Consulting
ID: 40383421
ok, good tip. I'm kind on shaky on my home setup, as I've never loaded Oracle before, until about 4 months ago. It's working generally ok but I'm still finding my way around. I'll have some more posts relating to D.B. management (at home).

But the TNS_ADMIN did the trick, I'm now good to go with PL/Sql Developer.

As I stretch my legs and expertise, I'll apply your suggestions.
0
 

Author Comment

by:Gadsden Consulting
ID: 40383943
I've requested that this question be closed as follows:

Accepted answer: 0 points for Gadsden Consulting's comment #a40383396
Assisted answer: 250 points for slightwv's comment #a40383403
Assisted answer: 250 points for slightwv's comment #a40383418

for the following reason:

I set up the environment variable TNS_ADMIN and it worked like a champ :-)
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40383424
Oracle only seems confusing to outsiders.  Once you get used to it, it sort of makes sense!!!
0
 

Author Comment

by:Gadsden Consulting
ID: 40383944
please undo the acceptance of this question so I can close it properly. I made a mistake by clicking on my own answer as the solution.
0
 

Author Closing Comment

by:Gadsden Consulting
ID: 40383947
environment variable TNS_ADMIN did the trick.
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now