Re: Remote Access ORACLE database

In article <8m0vt0$1r91_at_imsp212.netvigator.com>,   "Jack Tong" <jacktong_at_hkstar.com> wrote:
> I do try to ping the machine, but how to ping the database? I just
 do't
> know how. Would you tell me how?
>
> "Luis Octavio de Urioste" <tavo_at_gulf.net> ¼¶¼g©ó¶l¥ó
> news:so7ahd7mo0b182_at_corp.supernews.com...
> > It seems to me that you have a protocol problem, I think on your
 workstation
> > you are running BEQUEATH (Local Machine) and whe you try to connect
 from
 the
> > Lap Top (the client) it does not know how to reach the host.
> >
> > Have you tried Ping-ing the host machine, and the database ?
> >
> > Good Luck
> >
> > Tavo
> > "Raymond Wong" <raymond.wong_at_hk.origin-it.com> wrote in message
> > news:8lsar9$pff1_at_imsp212.netvigator.com...
> > > Dear all,
> > >
> > > I got a problem and hope that you guys would kindly help.
> > >
> > > I have installed ORACLE 8i on my NT workstation (hostname =
 ntwkstat).
 I
> > > set up the TNSNAME.ORA so that the Global DB Name is
 oracle.ntwkstat.
 Then
> > > I started the database using DBA Studio and then started the
 listener
> > > (lsnrctl start).
> > >
> > > Then I installed Developer 2000 on the same machine. Since the
 ORACLE_HOME
> > > is different, I copied the session "oracle.ntwkstat = ...." to the
> > > TNSNAMES.ORA in developer 2000. I used SQL*Plus to test it and
 it runs
> > > fine.
> > >
> > > However, when I installed ORACLE 8i Client on my notebook and
 copied the
> > > same session of TNSNAMES.ORA to the Client's TNSNAMES.ORA, it
 didn't
 work.
> > > SQL*Plus just report ORA-12535 TNS: operation timed out.
> > >
> > > What's the problem??
> > >
> > >
> > >
> > >
> >
> >
>
>

tnsping<xx> (where xx is the version on NT if below 8i) <servicename>

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.