Solved

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

Posted on 2014-10-15
10
4,073 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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
 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

First some basics on Windows 7 Backup.  It has 2 components one is a file based backup which is stored in .zip files each zip is split at around 200 Megabytes and there is the Image Backup which is as the name implies a total image of the partition …
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

791 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