Hello,
I am trying to install ODAC 32 bit for Microsoft report Builder use. Previously I was able to download ODAC from Oracle site that is about 580k in size but that file link is removed and replaced with a smaller version less than 100MB.
After installation and I tried to connect to report builder I get error ORA-12154. Does anyone know how to resolve this.
Alternatively, if you have link to the previous ODAC file download on this link Additional Oracle .NET and Visual Studio ODAC Downloads with size of 580k please share with me. Installation steps with that file is known to me. I am not sure why the link to 18.3 file is removed. link to xcopy is there but have not used that before
Thanks
Ora-12154 means that the TNS identifier (in other words, the value that's in the "database" dropdown on Toad's login window) could not be found in the tnsnames.ora file.
Most likely what happened is that now that you've installed a new Oracle client, Toad is using that client, and the tnsnames.ora file that came with that client does not have the values that are the tnsnames.ora file of your old Oracle client.
You can tell Toad (and other programs) where to find tnsnames.ora file by specifying the folder where it resides with a TNS_ADMIN environment variable. I like to use a folder that is separate from all of my Oracle clients. This folder is used for TNSNames.ora, SQLNet.Ora, and LDAP.ora (if you have it)
During installation I specified directory C:\oracle32\product\18.0.0\client_1\Network\Admin for installation. Can you please show with example or screen shot how to point toad to this tnsnames.ora file
During installation I specified directory C:\oracle32\product\18.0.0\client_1\Network\Admin for installation
Since you have no TNS_ADMIN environment folder specified, Toad is using the TNSNames file of your installed Oracle client. Now you have at least 2 clients installed and only one of them has the TNSNames info you need to connect to your DB.
Find the TNSNames folder that you were using before you installed ODAC
Copy it to some generic location (I like D:\Oracle\TNSAdmin)
In your windows search box (on the task bar), type in "environment variables"
That will open the dialog from my prior screen shot.
Click "new" at the bottom to add the environment variable
Thanks John. This worked. I took the tnsnames.ora file into the admin folder and was able to connect.
