I would try first to verify that it's a listener problem. Try
connecting directly by setting oracle_sid and connection without @sid.
Does that hang also?

This is a real shot in the dark, but check your
ORA_<SID>_SHUTDOWN_TIMEOUT reg param. Is it set to a high enough value.
The default is only 30 seconds which may not give the database time to
shutdown cleanly which means recovery will run when the system reboots
if there were active transactions when you shutdown.


-----Original Message-----
From: Oracle DBA Help [mailto:[Email Address Removed]
Sent: Thursday, August 28, 2003 5:33 PM
To: LazyDBA.com Discussion
Subject: listener problems?


Hi all,
I am running a 9.2.0.3 on Win2k Advanced server. Everytime I reboot the
server, I have a hard time connecting to the database. What happens is
it always seems to hang when trying to connect. The database is open
andrunning, based on the alert.log, and the listener seems to be ok,
when I do a tnsping is normal, and checking status seems good.
I resolve the issue by restarting all the oracle services(Database, MTS
recovery, Agent, Listener). Now...this not something I want to do,
every time machine is rebooted (either by user or "blackout").
Now there's nothing unusual in the alert log, and the listener log
didn't show any problems. Any one encounter this probleme.

It's win2k Advanced server w/ service pack 4.

FYI it's a test db, so I'm not too overly concerned about it, b/c it's
not happening to our production database. However our production db is
on service pack 2. So I was curious to see if anyone has encountered
this, and if so, is it the service pack, or something else?
Thanks,
X
Oracle LazyDBA home page