![]() 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. after installing 32-bit Oracle client software on a 64-bit Windows. 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) There is no control over this path name at install time because the SQL Server. I have installed Oracle 11gr2 64bit enterprise edition and then installed Toad 10.5 Trial. 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. No you dont need to install client as you have already installed the database. 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: ![]() You have two choices for configuring the network. 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. Skipping the one-click installation may save you time because Ive found it still has some warts. For my experience, I installed on a 32-bit system and one on a 64-bit system. Environment: Oracle 10g/11g, PL/SQL, TOAD, Sun Solaris, AIX, Netezza, informatica, SVN. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |