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