Linux Error :113 No route to host

[drumil narayan]

--- 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


		
__________________________________________________________
How much free photo storage do you get? Store your friends 'n family snaps for FREE with Yahoo! Photos http://in.photos.yahoo.com