Re: Help - Can't connect

Bob-

If BEQ works, why screw with tcp/ip on a local instance? Bequeath is using a pipe connection and bypasses sql*net. If you really want to debug the tcp/ip sql*net stuff, you certainly can do sql*net tracing from the client side by setting the sqlnet.ora parameter trace_level_client= 16. This will produce a .trc file in the directory indicated by trace_directory_client, which should be fully qualified. You can then either read the .trc file with an editor and some imagination, or you can use the trcasst.exe utility found on $ORACLE_HOME/bin. If you have Oracle7, you will just have to brute-force your way through the file. It can get big, but it will describe errors in some detail. You may find that you are missing a listener or don't have something configured properly.

But, if the BEQ thing works, why bother with all of this, unless you are just totally geeked out like the rest of us. :)

Roger

Roger Snowden
Sr. Systems Engineering Specialist
Oracle Corporation
rsnowden_at_NOTus.oracle.com <-- to reply, remove the obvious.

Bob wrote:
>
> Hi,
>
> I'm a college student with a beginners knowledge of Oracle. Recently I
> received the Oracle8 Personal Edition and Developer 2000 CDs. I
> installed both on a single computer with moderate success (no network,
> Windows95, 64MB memory, Pentium). The Oracle8 Personal Edition program
> group and Oracle for Windows 95 program group are functioning properly.
> I can connect to the database using the default passwords and all
> appears to be OK. The Oracle Developer 2000 program group is another
> story. Whenever I try to connect to the database using for instance the
> Form Builder, the computer "hangs". I've checked my connections in
> Oracle Net8 Easy Configuration and tested each of the protocols. The
> TCP/IP tries to dial out and fails the test, but the Bequeath (local
> database) protocol does succeed in the connect test.
>
> Can anyone help me with my connection problem???? Thanks for any help,
> and happy holidays to all.
>
> Bob Karrow
> rkarrow_at_adnc.com
Received on Sat Dec 19 1998 - 11:59:48 CST