?
Solved

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

Posted on 2014-10-15
10
Medium Priority
?
5,267 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 78

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 78

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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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 78

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 78

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
IF you are either unfamiliar with rootkits, or want to know more about them, read on ....
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.
Suggested Courses
Course of the Month12 days, 21 hours left to enroll

578 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