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

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.
Gadsden ConsultingIT SpecialistAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
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
Gadsden ConsultingIT SpecialistAuthor Commented:
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
slightwv (䄆 Netminder) Commented:
>>- 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Gadsden ConsultingIT SpecialistAuthor Commented:
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
slightwv (䄆 Netminder) Commented:
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
Gadsden ConsultingIT SpecialistAuthor Commented:
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
Gadsden ConsultingIT SpecialistAuthor Commented:
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
slightwv (䄆 Netminder) Commented:
Oracle only seems confusing to outsiders.  Once you get used to it, it sort of makes sense!!!
0
Gadsden ConsultingIT SpecialistAuthor Commented:
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
Gadsden ConsultingIT SpecialistAuthor Commented:
environment variable TNS_ADMIN did the trick.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.