Trouble Shooting PCs and Oracle

Most recent development (9/15/2003) is from John Daniels:

I found the solution (at least it works for me).  I spent a bunch of
time going through message posting on Sun's java developer forum and
found this representation of the url:

url =
"jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=ect-sun.ecst.csuchico.edu)(PORT=1521)))(CONNECT_DATA=(SID=ecstDB)(SERVER=DEDICATED)))";

I think it's the (SERVER=DEDICATED) that is the key piece. 

Thanks
John

Earlier windows attempts:
From Johnny Brown at Lutris, Columbus Ohio

Below is the discussion group that can be also seen at the java web sight. Got to www.java.sun.com put "JDBC Network Adapter failure" into the search area at the right hand top and click search. Once the search returns change the "Java(TM) Technology Site Search" to only have the "Java Discussion Forums" selected and search again. There will be many discussions about the problem all talking about Windows OS and Linux OS. The one that I found of interest is the 8th discussion. Here is a piece of it.

This may work also: http://forum.java.sun.com/thread.jsp?forum=48&thread=88594

So in summary, I tried this and it still did not work from my home machine. Try it there are school and let me know if it works out for you. The /etc/hosts file is under "C:\WINNT\system32\drivers\etc". Add the entry for: 132.241.6.18 tiglon.ecst.csuchico.edu And see if this works. I do not have much hope since it did not work for me but there may be firewall issues for me accessing CSU over the 1521 port. You should be inside the CSU firewall and should not have this issue. If you find out that you can access the database after making the change, the only way to resolve the issue is to have the network people open up port 1521 to allow access from the outside world. I will continue to beet on this problem and let you know what I find.

Went to http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/winsoft.html and downloaded oracle driver for windows NT (you need membership though - it is free)

Curious - exact same size...no help either

Sys ad now looking at traces.
Shows that oracle is seeing the connections from the PC. If you want to look yourself, it is in the file /opt/Oracle8i/products/8.1.7/network/trace
To actively see if yours is running, do the command
tail -f listener.trc

Watch this window and then try your java program. For mine, it shows that I am being seen by Oracle