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

Thread: not able to connect to database - multiple oracle home

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    Hi!
    I have oracle 8.1.7 installed , I installed discoverer in new oracle home which has oracle 8.0.6.
    I am able to connect to 8.1.7 through sqlplus 8.1.7
    But I am not able to connect through sqlplus806 ???
    And finaly oracle discoverer not connecting

    I check all TNSNAMES.ora tnsentry is there.
    and through netassist connect test is successful
    on all homes
    oracle/ora817/network/admin
    oracle/ora806/net80/admin

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Make sure the entry reffering to that server is in all the tnsnames.ora available.

    And then it should work
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    I am just confused, how you determine that which tnsnames.ora it is using.
    I want to connect to oracle817 database only and that entry is already there.
    How can I direct discoverer that use this TNSNAMES.ora only

  4. #4
    Join Date
    Aug 2001
    Posts
    390
    Oracle will default to use the newer version TNSnames. you need to be careful when you use the right utility for the right database or else it' won't work


Posting Permissions

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


Click Here to Expand Forum to Full Width