I have installed oracle 8i (SID = ORACLE) in the home "oracle/ora81", and the oracle dev6i in the home "oradev6i", therefore in two different oracle_homes.
I have copied the file tnsnames.ora from oracle/ora81/network/admin TO oradev6i/net80/admin
when I try to connect to database from forms builder with the sid "ORACLE" I have the followong message :
ORA-12203 TNS:UNABLE TO CONNECT TO DESTINATION
what's the problem please ?