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 :
The format of the tnsnames in the database version varies from the one provided with 6i. dont copy it from the DB Home. you'll find a sample in your dev6i home, copy that to the dev6i/network/admin dir and modify the tcp sample provided in the sample.
If you find it difficult, use the Net Easy configuration for your dev6i home.
but , I have found another thing, when I start SQL*plus (witch come with oracle8i) and host string = Oracle ( sid with which my database is started) , it does't work also!!!
but, when I start sql with no host string, it works!!!
Reply With Quote
Bookmarks