I have installed Oracle Database 11g. Now I want to install Devsuite 10g for forms developement. However after installing I have the following problems :
My previous sqlplus 126.96.36.199.0 can connect with the database, however the sql*plus provided in DevSuite shows the following error : TNS Protocol Adapter Error
My machine configurations : Windows 7, 4GB RAM, i5
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 188.8.131.52.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