Re: Oracle needs to be restarted to accept new connections

From: DavidDublin <davidcotter_at_gmail.com>
Date: 2 Nov 2005 08:01:36 -0800
Message-ID: <1130947296.667375.243020@z14g2000cwz.googlegroups.com>

Matthias Hoys wrote:
> Maybe there's something wrong with your DNS, or your network configuration.
> Try changing the hostname with the (public) IP address of the server in
> tnsnames.ora and see if this helps.

I restarted tnslistener and then tnsping returned immediately. But when I tried to start up sqlplus it would not connect for five minutes. When I restarted the db all was well. There does not seem to be any strain on the server at all.

I will look into network problems thanks. Received on Wed Nov 02 2005 - 10:01:36 CST