Re: Problem with NET80

Depending on your global names setting, you may have to use:

tnsping desi.world

hth,

Francesco Dini <dini.f_at_adr.it> wrote:

>This is my tnsnames.ora:
>#
># Installation Generated Net8 Configuration
># Version Date: Oct-27-97
># Filename: Tnsnames.ora
>#
>extproc_connection_data =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = <oracle_sid>))
> (CONNECT_DATA = (SID = extproc))
> )
>
><oracle_sid> =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= arsigip)(Port= 1521))
> (CONNECT_DATA = (SID = <oracle_sid>))
> )
>ARP.WORLD=
> (DESCRIPTION =
> (SDU = 32768)
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = SAP.WORLD)
> (PROTOCOL = TCP)
> (HOST = arsigip)
> (PORT = 1527)
> )
> )
> (CONNECT_DATA =
> (SID = ARP)
> (GLOBAL_NAME = ARP.WORLD)
> )
> )
>
>dmdro=
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = TCP.world)
> (PROTOCOL = TCP)
> (HOST = dmdro.adr.it)
> (PORT = 1521)
> )
> )
> (CONNECT_DATA =
> (SID = dmdro)
> (GLOBAL_NAME = dmdro.world)
> )
> )
>
>desi.world= (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = TCP.world)
> (PROTOCOL = TCP)
> (HOST = proxyuno.adr.it)
> (PORT = 1521)
> )
> )
> (CONNECT_DATA =
> (SID = desi)
> (GLOBAL_NAME = desi.world)
> )
> )
>
>Why this:
>arsigip1:oraarp 40> tnsping dmdro
>
>TNS Ping Utility for HPUX: Version 8.0.4.0.0 - Production on 01-FEB-00
>17:28:21
>
>(c) Copyright 1997 Oracle Corporation. All rights reserved.
>
>Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=dmdro)(PORT=1521))
>OK (140 msec)
>
>and
>
>arsigip1:oraarp 41> tnsping desi
>
>TNS Ping Utility for HPUX: Version 8.0.4.0.0 - Production on 01-FEB-00
>17:28:41
>
>(c) Copyright 1997 Oracle Corporation. All rights reserved.
>
>TNS-03505: Failed to resolve name
>
>
>
>Both listeners are running.
>More:
>I cannot connect with sqlplus towards both instances.
>Why?

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Feb 01 2000 - 13:41:48 CST