Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2014-10-15
10
Medium Priority
?
4,831 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 2000 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 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

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 77

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 77

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

721 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