Linux Error :113 No route to host

[Chris Hewitt]

On Fri, 2005-07-01 at 09:35, drumil narayan wrote:
> --- Chris Hewitt <rhil at manordata.uklinux.net> wrote:
> 
> > PS Bottom posting is preferred here (put your
> > comments at the end). I'll
> > reorder this.
> > > 
> > On Thu, 2005-06-30 at 11:05, drumil narayan wrote:
> > > --- Chris Hewitt <rhil at manordata.uklinux.net>
> > wrote:
> > > 
> > > > On Wed, 2005-06-29 at 14:14, drumil narayan
> > wrote:
> > > > > Hello,
> > > > > 
> > > > > I installed oracle 10.1.0.2 on RHEL 4.0
> > > > successfully.
> > > > > It was working fine.
> > > > > 
> > > > > Suddenly, it had started giving following
> > error,
> > > > > while trying to connect oracle database from
> > any
> > > > > windows client or on server it self..
> > > > > 
> > > > > TNS-12560:TNS: protocol Adapter Error
> > > > > TNS - 00530 : Protocol Adapter Error
> > > > > Linux error :113 : No route to host
> > > > > 
> > > > > any clues will be appreciated..Drumil
> > > > 
> > > > Drumil,
> > > > 
> > > > It looks like your networking has changed.
> > Picking
> > > > the Oracle host from
> > > > your tnsnames.ora file that you are trying to
> > get
> > > > to, can you ping it?
> > > > If so, can you tnsping it?
> > > > 
> > > > Either the networking on your computer has
> > changed
> > > > or something between
> > > > you and the host you are trying to get to. Is
> > the
> > > > host up and running,
> > > > is there a firewall change?
> > > > 
> > > > It sounds like it will be one of these.
> > > > 
> > > > Regards
> > > > 
> > > > Chris
> > > > 
> > > Hi Chris,
> > > 
> > > its pinging to and from othere clients.
> > > its tnspinging on server correctly.
> > > its not tnspinging from clients. 
> > > On server am able to database with and without
> > connect
> > > string.
> > > 
> > > what could be the problem..thanx in
> > advance..Drumil
> > 
> > I need to get this clear. The computer with RHEL on
> > is the database
> > server? On the server, you can connect to the
> > database (e.g. using
> > sqlplus) giving it the tnsnames.ora entry (not just
> > the default blank
> > entry)?
> > 
> > >From other (client) computers you can ping the
> > server, and tnsping the
> > server? Is this tnsping using the server hostname or
> > an entry in
> > tnsnames.ora?
> > 
> > If you can successfully tnsping from a client using
> > a tnsnames.ora entry
> > then you should be able to connect to the database.
> > 
> > The no route to host error I think can only be one
> > of the things I said.
> > It does seem like something in your networking has
> > changed, these things
> > do not happen by themselves. What can you think of
> > that has changed?
> > 
> > Regards
> > 
> > Chris
> > 
> thanx Chris,
> 1) yes the computer with RHEL on is database server
> 2) on this server I am able to connect to the database
> using sqlplus with entry in tnsnames.ora and without
> it..so my listener is listening to database
> 3) this is why tnsping is true on RHEL 4
> 4) i executed tnsping with tnsping tnsnames.ora entry
> on database server which was correctly tnspinged
> 5) the same entry was copied into clients tnsnames.ora
> 6) tnsping fails from clients
> 7) previously the server was taking nearly 20 minutes
> to just bootup, so we called the support engineer, he
> stopped some services, after that it was booting up in
> 3 minutes.
> 8) can you inform me which are the services required
> to start if its oracle database installed on RHEL
> 
> thanx in advance..Drumil
Drumil,

As you say your support person changed some services you might ask what
they did. That seems to be the root of your problem. I've not used
Oracle on RHEL so I'm not going to be the best person to answer that.
There are specific linux Oracle mailing lists but talking to the support
engineer about the changes I feel is best initially.

Regards

Chris