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\
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