Re: How to tell if listener is up on HP-UX?

Hi,

Try to do following tests,
1. Test if listener is up with command lsnrctl status 2. If you can access DB from other machine with $sqlplus user/pass_at_connect_string
you can just cut and paste the connect string definition in the tnsnames.ora ($ORACLE_HOME\network\admin) file in this machine to tnsnames.ora in NT machine.
3. If you don´t have a DNS you have to define the HOST name in the hosts file in NT

   (%NT_root%\system32\drivers\etc). You should ping this host from NT.

I hope this help,

Best Regards,

Oscar Martins
oscar_at_mail.telepac.pt

John Emmerling <user95_at_nugnu.gsfc.nasa.gov> wrote in article <577lo1$1t3_at_post.gsfc.nasa.gov>...
> Hi:
>
> I am trying to use SQL*Net on Windows NT 3.51 to connect to an Oracle DB
> instance (on which I have a username and password) which is on an HP-UX
 host.
> My attempts to connect have so far failed. I tried using tnsping, and
 the
> response I got was "no listener" from TNS.
>
> I have tried to run tnsping on the HP-UX side, however I don't seem to be
> supplying the correct arguments. I don't have any special privilege on
 the
> HP-UX side (other than normal user), I have administrator rights on the
 NT
> side.
>
> I have some suspicion that the listener is not up on the HP-UX side,
 partly
> because the log file (lsnrctl.log) shows no recent entries, although the
> computer has re-booted fairly recently. Is there a daemon process I
 could
> check for before approaching the administrators?
>
> I can connect to the DB instance from other HP-UX hosts that are on the
 same
> LAN, however I am speculating that this is accomplished by means other
 than
> TNS (as you can see I am a newbie!).
>
>
> Additional questions:
>
> The listener.ora on the HP-UX side calls the listener by a name other
 than the
> default "LISTENER". Could this present a problem?
>
> Also, I am having trouble with the "community" stuff. On the HP-UX side,
> community was set to "ORATCP". On the NT side, should I use "ORATCP",
> "ORATCP.world", or what? Can I use a raw IP address for "HOST" (as there
 may
> be DNS problems?
>
> I would hugely appreciate any help!!
>
> Regards,
> --
> John Emmerling John.Emmerling_at_gsfc.nasa.gov
>
> --
> John Emmerling | Computer Sciences Corp.
> +1 301 497-2426 | Mission Integration Technology Group
> John.Emmerling_at_gsfc.nasa.gov | 1100 West St., rm 431
> | Laurel MD 20707 USA
>
Received on Mon Nov 25 1996 - 00:00:00 CET