CODEWITHSUNDEEP
oracle-database
Oliver Lim
Oliver Lim

Reputation: 51

install oracle client 64bit with pre-installed oracle client 32bit

need to ask currently my 64bit win8 is installed 32bit oracle client (sqlplus etc). everything working fine. however this times i am doing some ssrs and need to connect to a oracle db,and thus i have to install 64bit oracle client.

i have downloaded

Version 12.1.0.2.0 Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications

from http://www.oracle.com/technetwork/topics/winx64soft-089540.html

and i have set the PATH to the downloaded "instantclient_12_1"

when i run the ssrs reports, it shows TNS could not resolve etc. so it should be able to run the oracle client 64bit but couldn't locate the tnsnames.ora and so i copied the tnsnames.ora from the 32bit oracle client to the "instantclient_12_1" folder. but it still not working.

*i have rebooted the pc *have set the PATH to the tnsnames folder as well

kindly advise is there any steps did wrong? would like to prefer steps which require less installation of files. because once this is working on my laptop. i will apply the same to the production server.

Upvotes: 0

Views: 577

Answers (1)

user2672165
user2672165

Reputation: 3049

Make sure that the environment variable TNS_ADMIN is set in your environment. It shall contain the path to TNSNames.ora.

Upvotes: 2

Related Questions