This all worked for me and hope it helps you as well. You need to have a TNS_ADMIN entry in the Environment Variables that points to the directory that the tns_names.ora file lives. Note: When using the Basic Lite version of the Oracle Instant Client, you should not set the ORANLS10 (or ORANLS11 ) variable. You also need to make sure the following is included in the 'path' of the Environment Variables:Ĭ:\app\Oracle\product\12.2.0\client_1 C:\app\Oracle\product\12.2.0\client_1\bin (or wherever your path is loacted) Install all C:\app\Oracle\product\12.2.0\client_1 odac (the path is where you installed the above client to) To install the above you must open a Administator Command Prompt and change to the path that you extracted the files to. Note: in my case I change the default path of the install to C:\app\Oracle\product\12.2.0\client_1 but it doesn't matter where you put it.Īfter installing the client I had to install the following: (IT WILL NOT WORK WITHOUT THIS!) In my case I installed the following Oracle Client on my respective installs: It's the same install on each except you must use the matching bit version of the Oracle products that matches the PowerBI Desktop bit version. Then we check Windows Task Manager and search for the process of sqlplus.For my experience, I installed on a 32-bit system and one on a 64-bit system. For Windows only, you can instead set the value of the oraclehome. Some developers or DBA use Oracle instant clients to connect to databases, they don't contain tnsping. Before creating a link to an Oracle server, you must tell Advanced Server where to.
What? You don't have tnsping? Oh, it's possible. Now we know our Oracle client is 32-bit and release 12.2.0.1.0. Used EZCONNECT adapter to resolve the aliasĪttempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))) All rights reserved.Ĭ:\app\client\Administrator\product\12.2.0\client_1\network\admin\sqlnet.ora Here is the trick to know the release and bit version of the Oracle client.
In such moment, we have to make sure that we are using 32-bit Oracle client. For example, some plain old application suites should be installed into the database only by 32-bit of Oracle clients.
In some situations, we need to know whether our Oracle client is 32-bit or 64-bit in order to use the right tool to do our job.
0 kommentar(er)
