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