DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: multiple tnsnames.ora

  1. 05-03-2003, 09:13 PM #1
    sadiq
    sadiq is offline Junior Member
    Join Date
    Mar 2003
    Posts
    34

    multiple tnsnames.ora

    A client has SQL Plus, Toad & D2K intalled. I have added new db service in tnsnames.ora & I can connect to db through sql plus but while connecting through Toad I get tnsname protocol error. This might be because since multiple tnsnames.ora file is created, the file used is not the one in which the db service is added. Can I now which tnsnames.ora file is being used & can I restrict to use a specific tnsnames.ora file.
    Reply With Quote Reply With Quote
  2. 05-04-2003, 02:02 AM #2
    akhadar
    akhadar is offline Advisor
    Join Date
    May 2001
    Posts
    736
    What do u mean by SQLPLUS,TOAD&D2K ?
    I think SQLPLUS is installed as a part of Client installation.If there is another seperate isntallation for D2K naturally it too will have TNSNAMES.ORA file.Copy the contents of TNSNAMES.ORA from Client directory into D2K TNSNAMES.ORA
    Reply With Quote Reply With Quote
  3. 05-05-2003, 04:52 AM #3
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Toad will pick it up from the windows registry..so in the windows registry set the TNS_ADMIN variable to the one you want the client to use.That should solve it

    regards
    Hrishy
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width