Re: Oracle Server IP Change

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<4184caea$0$22825$afc38c87_at_news.optusnet.com.au>...
> "s.kapitza" <skapitza_at_volcanomail.com> wrote in message
> news:26703915.0410310224.51509a27_at_posting.google.com...
> > "nbhiker" <not_at_likely.com> wrote in message
> > news:<U1Xgd.164737$Np3.6819219_at_ursa-nb00s0.nbnet.nb.ca>...
> >> Hi Folks,
> >>
> >> I've googled this to death and can't seem to find a resolution.
> >>
> >> I have installed oracle 8i on Solaris 8. All was working well until I
> >> changed the IP of the server (which is necessary), and now I am getting
> >> connection errors. I can no longer perform a successful tnsping
> >> (TNS-12545:
> >> Connect failed because target host or object does not exist). I have
> >> edited
> >> tnsnames.ora and listener.ora (and double-checked), and the server and
> >> the
> >> listener will start up with no probems, but I am still unable to connect.
> >> Oh, and I am connecting from the local machine (testing on the box
> >> itself,
> >> not remotely).
> >>
> >> Has anyone else run into thsi situation? Any help would be appreciated.
> >>
> >> Thanks
> >>
> >> nbhiker
> >
> > mybe you need to triple check.
> >
> > tnsping tell's you "target host does not exist" which means that your
> > tnsnames has an faulty host entry.
>
> It doesn't tell him that at all. Suppose his host entry was 'PICKLE'. That
> might be a perfectly valid entry: there's a server called PICKLE. He can see
> it, touch it, re-boot it. It's just a shame his DNS server cannot resolve
> the name 'PICKLE' to some meaningful IP address.
>
> Now: does that mean the host entry is faulty, or that the host resolution
> mechanism is faulty?
>
> Regards
> HJR
hi howard,

you are right, could have been also an resolution Problem. (didn't thought of that)

regards

s.kapitza Received on Sun Oct 31 2004 - 11:51:56 CST