When I changed the browser from Edit->Preferences->Runtime. The output was different for different browsers, i.e I tested the same with 3 major browsers, the Internet Explorer (IE6.0), Mozilla Fire Fox, Opera. The first two resulted in error. i.e something undesired output the Mozilla Fire Fox output was a blank white screen and the Internet explorer output was something strange URL and the a few lines of HTML code too was there, but the third the output was something OK, it showed the screen but there was an error Ora-12560: TNS Protocol adapter error. I Googled many times and even hours to find a solution. Finally I found somewhere the solution to solve the problem.
It was that just copy the 3 .ora files (i.e. tnsnames.ora, listener.ora, sqlnet.ora) from Oracle database home settings to oracle developer suite settings directory, i.e. for e.g. c:\oracle\ora92\network\admin to c:\oracle\10gds\network\admin. where c:\oracle\ora92 is ORACLE_HOME. Then restarted the services (or simply reboot the system) and it was ok. When I run the project it was asked for the database user, password ans the database. I filled all hr, hr and orcl (the SID). This time it was working everything was fine this time.
So the first issue was because there was spaces in the folder name, whether it is Internet explorer (IE) or Mozilla Fire Fox, but for opera there was no spaces in the installed path and sure in its executable file name too.
The second issue was because of some missing/invalid settings specified in sqlnet.ora, listener.ora and tnsnames.ora.
Note :-
- Avoid spaces during installation of browsers (e.g. use InternetExplorer or IE instead of Internet Explorer).
- Copy the files tnsnames.ora, listener.ora, sqlnet.ora from ORACLE_HOME/network/admin folder to ORACLE10GDS_HOME/network/admin folder. ORACLE10GDS_HOME is home directory for Oracle 10g Developer Suite.
