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

Thread: Different Oracle Homes

  1. #1
    Join Date
    May 2002
    Posts
    1
    Well, I recently downloaded and installed Oracle 8i. I was able to log into SQL/Plus with a username and password without ahost string.

    Then I downloaded Oracle Forms Builder 6i and Oracle Table Builder 6i and installed them, but I installed them to a differnet Oracle Home because of installation issues.

    Now I cannot use Forms or Reports Builder to connect to my tables because they require a Host String to log in or a Database name. What should my host string be so I can see my tables?

  2. #2
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    host string should be in tnsnames.ora
    check tnsnames.ora in network/admin of oracle home directory

  3. #3
    Join Date
    Feb 2002
    Location
    Dallas , Texas
    Posts
    158
    Make a new servive name refering to your own machine and DB sid.It will work fine then.
    As Kumud said the file is in Network->Admin->tnsnames.ora

    Take Care.

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