Help - Can't connect 
Author Message
 Help - Can't connect

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



Tue, 05 Jun 2001 03:00:00 GMT
 Help - Can't connect

Bob-

If BEQ works, why{*filter*}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

Quote:

> 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




Wed, 06 Jun 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. if you will promise Allahdad's swamp against cans, it will angrily depart the unit

2. CAN'T CONNECT, CAN'T STOP SQL - HELP

3. HELP: Replication Problem / OSQL can't connect to it's own server

4. Help needed on 'EXEC SQL CONNECT'

5. HELP: Can't shutdown/start instance even when I'm connected as SYSTEM/MANAGER

6. CAN'T CONNECT TO DATABASE SQL 6.5 PLEASE HELP

7. Help please - can't connect to SQL server anymore

8. Can't connect to SQL Server 7 on Win 2000 Server - help

9. sql 2000 on webhost - can connect but can't do anything - help

10. Help - can't connect to SQL server

11. Newbie - Can't connect -- help !

12. Help with SQL 6.5 Odd problem can't connect locally


 
Powered by phpBB® Forum Software