Problem connecting through DBADMIN

[Dinesh Shenoy]

I have sporadic issues while testing my connecting to my Oracle7
database
through the DBADMIN application. While sometimes I can, others I get
database.majorErrorCode = 1001
[SERVERERROR] Error from Server: Error
while trying to retrieve text for error
ORA-01001
database.minorErrorCode = 0
esprd01

Pls help !

Dinesh

[Jim Martin]

ORA-01001 is almost always a problem with the SQL*Net listener. I've had
this problem myself, and here is what I found:

1. Oracle's error description for this is totally out of whack with what is
happening. I believe they call it an invalid cursor. They are wrong, or
Netscape is wrong. Someone is wrong.

2. This problem means that your connection has been lost. Check to make sure
that there is a valid ORACLE_HOME variable, a TNSNAMES entry, and all the
usual good stuff.

I can't tell you why you would only get this some of the time, but I think
if you do a little digging, you will see that this is definitely the case.

Jim Martin, B.Sc.
Director, Strategic Web Services
Klay Information Management Consulting Ltd.
(403) 263-6463 (phone)
(403) 263-6437 (fax)
http://www.kimc.com
Brainbench 'Most Valuable Professional' for JavaScript
http://www.brainbench.com

Dinesh Shenoy <dsh...@csu.org> wrote in message
news:3999797D...@csu.org...