Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle DB connection problem

Oracle DB connection problem

From: Chris <chris_at_nospam.com>
Date: Fri, 5 Jul 2002 10:23:01 +0100
Message-ID: <2zdV8.98$xB2.50@news-srv1.fmr.com>


Hi everyone

I'm getting the following Oracle db error connection message sporadically trying to connect to the db from the server. It did work some times (1st & 4th) but other times failed (2nd & 3rd) - Any ideas?

Thanks
Chris

$ sqlplus username/password_at_dbname

SQL*Plus: Release 8.1.5.0.0 - Production on Wed Jul 3 11:58:06 2002  (c) Copyright 1999 Oracle Corporation. All rights reserved.

 ERROR:
ORA-12537: TNS:connection closed

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name: ^C

$ sqlplus username/password_at_dbname

SQL*Plus: Release 8.1.5.0.0 - Production on Wed Jul 3 11:58:32 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options

PL/SQL Release 8.1.5.0.0 - Production
SQL> exit

$ sqlplus username/password_at_dbname

SQL*Plus: Release 8.1.5.0.0 - Production on Wed Jul 3 12:04:34 2002

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options

PL/SQL Release 8.1.5.0.0 - Production
SQL> exit

$ sqlplus username/password_at_dbname

SQL*Plus: Release 8.1.5.0.0 - Production on Wed Jul 3 12:04:49 2002

 (c) Copyright 1999 Oracle Corporation. All rights reserved.

ERROR:
ORA-12537: TNS:connection closed
Enter user-name: Received on Fri Jul 05 2002 - 04:23:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US