Thursday, 25 October 2012

Oracle Client Install For Window XP 32bit or 64bit

Note: 

These steps require Administrative Privileges on your personal computer. 
If your account does not have Administrative Privileges (or you are unsure) please contact your local help desk for someone to come and run this install on your pc as the Administrator.

Download Oracle Client from here
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html?ssSourceSiteId=ocomen

How to tell whether it is 32bit or 64bit window..
http://windows.microsoft.com/en-US/windows-vista/32-bit-and-64-bit-Windows-frequently-asked-questions


Find Correct Window Version (32bit or 64bit).  Download “Instant Client Package – Basic”


1. Create the directory “C:\instantclient_11_2”
      Right click “Start” -> Explore
       Click “Local Disk (C:)”
       Right click on the right hand side -> New -> Folder -> type “instantclient_11_2” then hit enter

2.     Drag and drop downloaded file into the “C:\instantclient_11_2” folder in the open file explorer

3. Unzip all of the zipped files.
          Right click on each zip file -> Extract All -> Next
     ***  Extract to “C:\”
                  NB:  files will get put in C:\instantclient_11_2

4. Go to:  Start -> right click My Computer -> Properties -> Advanced -> Environment Variables
   System variables -> Path -> Edit
      add “C:\instantclient_11_2;” to the beginning of the value -> OK
   System variables -> New
      Variable name: “TNS_ADMIN”
      Variable value: “C:\instantclient_11_2”


5.  You will need to create sqlnet.ora and tnsnames.ora
Entry.  Your database administrator DBA will able to provide these files. (In text)


Thanks.

No comments:

Post a Comment