Results 1 to 2 of 2

Thread: Ora-12154:

  1. #1
    Join Date
    Dec 2003
    Location
    India
    Posts
    33

    Unanswered: Ora-12154:

    Hi,
    Please help me to find out the connection issue.
    I couldnt connect to the database(oracle 9i) using toad, showing the following error

    *** First assume we have a valid install and registry
    Building Oracle HOMES List
    HOME Name OraHome92 added to list.
    HOME Name OraHome9ias added to list.
    Found multiple homes, searching each HOMEx for valid PATH
    searching in SOFTWARE\ORACLE\HOME0
    Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path!
    searching in SOFTWARE\ORACLE\HOME1
    Oracle_Home found in SOFTWARE\ORACLE\HOME1 IS in system path!
    ***
    Oracle home is set to c:\oracle\ora9ias
    Bin path is set to c:\oracle\ora9ias\bin\


    *** Now, force a check of the \ORACLE registry root and ignore multiple homes
    ***
    Oracle home is set to D:\oracle\ora92
    Bin path is set to D:\oracle\ora92\bin\
    oci.dll found
    Using: D:\ORACLE\ORA92\BIN\oci.dll

    ************************************************** **

    Thanks
    Papps...

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    This isn't actually an error message from TOAD. What TOAD is telling you is how it tried to find the database you told it to find.

    My guess would be that you are trying to connect to a database that is listed in the TNSNAMES.ORA located in your OraHome92\network\admin directory, but is NOT found in the OraHome9ias\network\admin directory. According to the output, the 9ias home is set to be the default -- usually happens to the product installed last.

    One way around this is to add an environment variable called TNS_ADMIN. This will tell Oracle client products to look in the particular directory listed by the variable for files such as TNSNAMES.ORA and SQLNET.ORA -- so in your case you would set TNS_ADMIN=C:\oracle\ora92\network\admin

    JoeB

Posting Permissions

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