Updating tnsnames

Ora Client11g_home1 ( ORACLE_HOME: C:\app\C39293\product.2.0\client_1 ORACLE_HOME_NAME: Ora Client11g_home1 ORACLE_HOME_KEY: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_Ora Client11g_home1 ORACLE_SID: NLS_LANG: AMERICAN_AMERICA.

At command prompt execute SET TNS_ADMIN and see if it reports "TNS_ADMIN=C:\Windows\TNS" If it does, then all Tools should be using that

WE8MSWIN1252 SQLPATH:c:\oracle\product203_32bit\CLIENT_1\dbs LOCAL: Client DLL:c:\oracle\product203_32bit\CLIENT_1\bin\TNSNames.ora: SQLNet.ora: LDAP.ora: Login.sql: GLogin.sql:c:\oracle\product203_32bit\CLIENT_1\sqlplus\admin\In system PATH: Yes Q1: Is Ora Client11g_home1 my 64 bit home or do I have two Oracle clients installed?

Q2: Why doesn't 32 bit TOAD use the tns in location #1 instead of only using the one in location #3?

Visit Stack Exchange Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Sign up to join this community Anytime you change Oracle's or files, does the system require a reboot?

In my instance, I only have the Oracle client installed on the machine I'm referring to, but out of curiosity what would it mean for an Oracle server installation? A change shouldn't require a reboot but some applications will read and parse the at startup to be able to present a drop-down list of servers to the user, for example, and will cache whatever was read when the application started up rather than re-reading the file.

Search for updating tnsnames:

updating tnsnames-49updating tnsnames-82

However, TOAD seems to only recognize the file in location #3 and it did not recognize the file in location 2 at all!

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating tnsnames”

  1. You can find much more information about your privacy choices in our privacy policy. Even if you choose not to have your activity tracked by third parties for advertising services, you will still see non-personalized ads on our site.