so you have them both on the same machine?
have you configured developer with the net configuration assistant? if so, did you use the test button?
is that all of the error message?
yes on the same machine
yes i used net configuration assistant but there is nothing given as test
error message is TNS Adapter error
this is the error in net configuration assistant :
Connecting...ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
The test did not succeed.
ok here's what i got after a bit searching : Net configuration assistant -> Local Net Service Name configuration -> gave all necessary details ( i was stuck at global database name earlier) -> Test Succeeded
But Still I cannot connect SQL*PLUS to oracle 11g. which i can with sqlplus 184.108.40.206.0
well, there might be other problems, but if you have the inclination, what is the value of your PATH environment variable, and do you have a TNS_ADMIN variable? can you show the output of tnsping?
you have at least 2 different oracle homes on your machine (1 for the db and 1 for dev suite). So you may even have 2 netcas.
the developer suite will by default work with its copy of netca, sqlplus, and tnsnames.ora. so when you say the test succeded, did you use the netca that is in the developer suite? Or did you mean the one in the 11g db if there is one?
there is an order in which developer and sqlplus will look for the tnsnames. i think it starts with the current directory, then the default directory (network\admin\tnsnames.ora), then whatever TNS_ADMIN points to and so on...
I'm just concerned that you have configured the right one and are in fact using it. So that means it's dependent on which program exactly you're using (developer or oracle 11g), the PATH settings, the TNS_ADMIN settings and possibly other things
you can also try to open a command line, cd to the bin subdirectory in the developer suite home directory. then from there you can try the tnsping.
might also be worth your while to go to the 11g bin subdirectory in its home directory, then run lsnrctl status
btw, what version of devsuite 10g are you using? I am not altogether certain it is certified on win 7 without a patch as I am only using xp.
so just take what i say with a lot of salt as i may be driving you up the wrong tree.