Linux Error :113 No route to host

[drumil narayan]

--- Ted Potter <tpotter at techmarin.com> wrote:

> On Sat, 2005-07-02 at 05:23, Chris Hewitt wrote:
> > 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
> 
> not that I really know anything but
> 
> 1. What is the ip address of the oracle server ?
> 2. Can you ping that ip address from a windows
> client ?
> 
> The fact that you can get to the database from
> server itself would to me
> indicate the server is up and running. However that
> does not mean a
> client can reach it.
> 
> anyway my 2 cents...I have not used an oracle server
> since SCO xenix 
> 
Thanx Chiris thanx Ted,
Yes the samba service was off, when turned on the
problem was solved.

I would like to register to linux-oracle mailing
lists, can you inform me please..

thanx in advance..Drumil


		
_______________________________________________________
Too much spam in your inbox? Yahoo! Mail gives you the best spam protection for FREE! http://in.mail.yahoo.com