RE: Help! Can't connect though everything seems OK!

From: Molina, Gerardo <Gerardo.Molina_at_schwab.com>
Date: Thu, 9 Nov 2000 22:23:05 -0800
Message-Id: <10675.121683@fatcity.com>

Did you try stopping/starting the listener?

-----Original Message-----
From: Michael Ray [mailto:Michael.Ray_at_trw.com] Sent: Thursday, November 09, 2000 9:10 PM To: Multiple recipients of list ORACLE-L Subject: Help! Can't connect though everything seems OK!

I just got called into work. It seems all the sudden nobody can connect to one instance even though it is running.

The listener is running fine. It shows no errors in listener.log and shows it making my conneciton yet SQL*Plus hangs on my PC and generates no trace info at all even though I set the level to support (it does trace if I connect to another instance).

The names server is running fine since I can connect to any of the other databases and I can get to the listener on the problem one.

The database is running because people already connected are still using it. Nothing shows in the alert log and there are no trace files.

It was obviously working earlier and I'm the only one who can make any changes to anything. This is a 7.3.4 database on NT4 Sp5.

Any suggestions are welcome!

Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Michael Ray
  INET: Michael.Ray_at_trw.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Nov 10 2000 - 00:23:05 CST