Oracle instant client

Dear all,

right now downloaded the instant client from http://www.oracle.com/technetwork/topics/winx64soft-089540.html

and I see this at the end of this page:

Installation Steps:

1. Download the appropriate Instant Client packages for your platform. All installations REQUIRE the Basic package.

2. Unzip the packages into a single directory such as "instantclient".
3. Set the library loading path in your environment to the directory in Step 2 ("instantclient"). On many UNIX platforms, LD_LIBRARY_PATH is the appropriate environment variable. On Windows, PATH should be used.

4. Start your application and enjoy.

however, PATH has been set and oracle client application like Toad for Oracle still can't find client, how come and how to solve this?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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:
Are you getting an error message?

What data access provider method does Toad use?
Did you install it?  The BASIC is just that:  Basic libraries.

Did you create the network/admin folder and copy the tnsnames.ora and sqlnet.ora files into it?
If not, you'll need an environment variable TNS_ADMIN that points to the location of those files.
0
sdstuberCommented:
are you using the same version of oracle client and Toad?

by "version"  I mean 32-bit  vs 64-bit.

32-bit Toad requires 32-bit client
64-bit Toad requires 64-bit client
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
marrowyungSenior Technical architecture (Data)Author Commented:
"Are you getting an error message?"

when open a toad for Oracle, it just say can't find oracle client. can't see why! I already also run the separate Oracle 12c client installation which add the PATH itself, reboot and still doesn't work.

for the PC at office, it works as someone install the client for me and Toad can see it.

"What data access provider method does Toad use?
 Did you install it?  The BASIC is just that:  Basic libraries."

basic one. someone good at oracle install it for me and he is in overseas .

"Did you create the network/admin folder and copy the tnsnames.ora and sqlnet.ora files into it?"

I don't, this probably the reason ! but you mean the client installation don't fix it for me?

"If not, you'll need an environment variable TNS_ADMIN that points to the location of those files. "

how to do it ?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

sdstuberCommented:
have you checked  32 bit vs 64 bit?
0
marrowyungSenior Technical architecture (Data)Author Commented:
no. how can I create the tnsnames.ora and sqlnet.ora myself ? is it ok ?
0
sdstuberCommented:
>>> no.

then do so,  if your bit lengths don't match, then you can't use the client with toad


>>> how can I create the tnsnames.ora and sqlnet.ora myself ?

any text editor  will do, there is nothing special about them

>>>> is it ok ?

yes
0
marrowyungSenior Technical architecture (Data)Author Commented:
"then do so,  if your bit lengths don't match, then you can't use the client with toad
"

probably !!

I am still wondering why installation steps don't talk about tnsnames.ora and sqlnet.ora  ?

but what should be inside these files ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
one question related to this:

inside the instant client 12.1 , I see a file called uidrvci.exe, what is it ? I tried to run it individually and nothing happened,  I am expecting some error message, but it doesn't!
0
sdstuberCommented:
>>> probably !!

I have no idea what you're trying to tell me with that.  Either you did or you did not check the bits of each. If you did not, then do so.  If you did, then what are the results?

>>>> I am still wondering why installation steps don't talk about tnsnames.ora and sqlnet.ora  

The instant client is for a "cookie-cutter" installation.  i.e. generic install - drop it in and go.
The configuration of tnsnames and sqlnet files aren't generic,  those contents will vary wildly between installs.  The rest of the steps,  (unzip, set path) are the same everywhere.

>>>  what should be inside these files ?

that sounds like a different question, but as a starter, copy the files from another working $ORACLE_HOME


>>> uidrvci.exe

it's undocumented because it's not for end user use

look on oracle support, there is a document there to explain that it's intentionally not documented
0
marrowyungSenior Technical architecture (Data)Author Commented:
">>> probably !!

 I have no idea what you're trying to tell me with that.  Either you did or you did not check the bits of each. If you did not, then do so.  If you did, then what are the results?"

I can try but not sure, 11gR2 client show me x86 can't be install on Windows 81.

"The instant client is for a "cookie-cutter" installation.  i.e. generic install - drop it in and go.
 The configuration of tnsnames and sqlnet files aren't generic,  those contents will vary wildly between installs.  The rest of the steps,  (unzip, set path) are the same everywhere."

what I mean it they should tell customer what to do at least, no need to do it for them. all those can be set on TOAD

"that sounds like a different question, but as a starter, copy the files from another working $ORACLE_HOME"

this is not, related. but good hints, this is also what I planned to do tomorrow.

"it's undocumented because it's not for end user use
"

do you know if there is problems when I run that myself ?
0
sdstuberCommented:
>>>> I can try but not sure, 11gR2 client show me x86 can't be install on Windows 81.


so - you have a 64bit client?  yes or no?
what is your toad?  64 bit or 32bit?

this really isn't a step you should skip and it should take you only a minute or two to confirm.   If they don't match you will get exactly the symptom you have described.  that is,  toad won't see the client.

If they do match, THEN you can start trying to diagnose other problems.

To use an analogy - you're asking mechanics to fix your car and you haven't bothered to bring your car for them to see it.




>>> do you know if there is problems when I run that myself ?

unless you call it with the correct parameters I don't think it will do anything at all.

there is no reason for you to even to try run it though.  Your best hope is it will do nothing.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"so - you have a 64bit client?  yes or no?"

yes!

"what is your toad?  64 bit or 32bit?"

I have both, I test a lot of TOAD, both 64 and 32 bits doesn't work. the oracle DBA told me sth true ! if I instlal Taod I need to install Oracle client !

however, if I use SQL developer and data moduler, I don't need, it has it's own client

"To use an analogy - you're asking mechanics to fix your car and you haven't bothered to bring your car for them to see it.
"

no , you think too much about me, I knew it is the instant client having problem and most likly the TNSName stuff, I tried that many time and this is the missing part.

"unless you call it with the correct parameters I don't think it will do anything at all.
"

I just double click that ! and it runs for a while and then follow by no message. I just worry about what modification it brings to my system

"there is no reason for you to even to try run it though.  Your best hope is it will do nothing. "

yes !
0
marrowyungSenior Technical architecture (Data)Author Commented:
what i check out today is: from toad, the client path is :

	SOFTWARE\WOW6432NODE\ORACLE (Oracle Root) 
  ORACLE_HOME_NAME:  
  ORACLE_HOME:  
  ORACLE_SID:  
  NLS_LANG:  AMERICAN_AMERICA.WE8MSWIN1252
  SQLPATH:  
  LOCAL:  
  Home directory  does not exist! 
  Home is not valid! 
SOFTWARE\WOW6432NODE\ORACLE\KEY_ORACLIENT11G_HOME1 
  ORACLE_HOME_NAME:  OraClient11g_home1
  ORACLE_HOME:  D:\app\xxxx\product\11.2.0\client_1
  ORACLE_SID:  
  NLS_LANG:  
  SQLPATH:  
  LOCAL:  
  D:\app\xxxx\product\11.2.0\client_1\Bin exists. 
  D:\app\xxxx\product\11.2.0\client_1\Bin is in PATH. 
  Client DLL:  D:\app\xxxx\product\11.2.0\client_1\oci.dll
  Client Version:  11.2.0.1.0
  Home is valid. 
SOFTWARE\WOW6432NODE\ORACLE\KEY_ORACLIENT12HOME1 
  ORACLE_HOME_NAME:  OraClient12Home1
  ORACLE_HOME:  D:\app\xxxx\product\12.1.0\client_1
  ORACLE_SID:  
  NLS_LANG:  
  SQLPATH:  
  LOCAL:  
  D:\app\xxxx\product\12.1.0\client_1\Bin exists. 
  D:\app\xxxx\product\12.1.0\client_1\Bin is in PATH. 
  Client DLL:  D:\app\xxxx\product\12.1.0\client_1\oci.dll
  Client Version:  12.1.0.0.0
  Home is valid. 

Open in new window


any items  in system path:

D:\app\xxxx\product\11.2.0\dbhome_1\bin;C:\ProgramData\Oracle\Java\javapath;C:\oraclexe\app\oracle\product\11.2.0\server\bin;;

Open in new window


so I don't see any TNS_ADMIN in the system variables but this PC work for my Toad x86.

so this mean ..... . ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
this time I change the PATH to point to my instant client folder, Toad now say  " you do not have any Oracle homes installed!"

what is it now ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
still figuring out why, tks anyway.
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.