From: cory@localhost.localdomain (Cory Phillips) Newsgroups: comp.databases.oracle.server Subject: Connection problems while trying to use Oracle client tools Reply-To: cory_h_phillips@yahoo.com Message-ID: User-Agent: slrn/0.9.5.4 (UNIX) NNTP-Posting-Host: host-216-39-196-19.mylinuxisp.com Date: 9 Sep 2001 01:49:42 -0600 X-Trace: news3.mylinuxisp.com 1000018182 host-216-39-196-19.mylinuxisp.com (9 Sep 2001 01:49:42 -0600) Lines: 46 Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!cpk-news-hub1.bbnplanet.com!news.gtei.net!newsfeed1.cidera.com!Cidera!news3.mylinuxisp.com!cory Xref: easynews comp.databases.oracle.server:117622 X-Received-Date: Sun, 09 Sep 2001 00:37:37 MST (news.easynews.com) I'm using Oracle 8.0.5 on a Linux platform and trying to use the client software on Windows 98 from Personal Oracle 8. Whenever I try to establish a connection using SQL/Plus, ODBC drivers, or tnsping, I get a Windows invalid page fault. Several people in this news group trying to help have suggested that it's my Oracle installation or the listener was not running, or a firewall was not allowing the connection. In an effort to prove that it's not my Oracle installation on the remote host, I downloaded the JDBC drivers and wrote a quick Java program and ran it from the same client that is having problems. From the Java program I hit the server using the SCOTT demo account and did a straight select off of the DEPT table. The results were it worked without a hitch. The Java program returned all rows and I included a sniplet from the listener log file showing the connection made by the Java program which I ran twice. 09-SEP-01 01:00:52 * (CONNECT_DATA=(SID=MYDB)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.128)(PORT=1037)) * establish * MYDB * 0 09-SEP-01 01:11:17 * (CONNECT_DATA=(SID=MYDB)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.128)(PORT=1038)) * establish * MYDB * 0 So now this isolates the problem a little further. I know now that it's not a problem with the listener configuration, network configuration, or firewall issues. When I try to use any of the client utilities that came with Personal Oracle 8 (SQL/Plus, tnsping, Oracle Navigator, ODBC), all I get is an invalid page fualt error from some unknown module. My server never gets a chance to see the connection. The listener does not record a connection and neither does my network logging software. I've installed the client software on two separate machines and ended up with the same results. However, SQL/Plus is able to use the BEQ-LOCAL protocol to attach to Peronal Oracle 8 running on the same client. All I can determine is my Oracle software that comes with Personal Oracle 8 is buggy. I really don't care about using SQL/Plus on the client. All I really wanted to do was use the ODBC drivers. -- Cory Phillips cory_h_phillips@yahoo.com