Help! Can't connect though everything seems OK!

From: Michael Ray <Michael.Ray_at_trw.com>
Date: Thu, 09 Nov 2000 21:06:38 -0800
Message-Id: <10675.121679@fatcity.com>

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

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 Received on Thu Nov 09 2000 - 23:06:38 CST