On Fri, 25 Jun 1999 21:17:26 GMT, lauracampos_at_yahoo.com wrote:
Oracle defines a service name to connect from a client application
(OEM) to the database.
The service name in your case Tcp-loopback.world
is a collection of data to tell the application
1. which protocol to user (in your case tcp)
2. which server to connect to (ip address or host name)
3. which port to connect to
4. which datbase to connect to (SID)
So tnsping80 127.0.0.1 is not the right syntax. If you insist on
making a connection with 127.0.0.1 you have to change the tnsnames.ora
in.
127.0.0.1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Windows NT 4.0 and Oracle Enterprise Edition 8.0.5.0.0. I
>am having a problem when I try to tnsping80 an ip address. I have the
>default domain world in the sqlnet.ora file. On the server, I am trying
>to perform a tnsping80 to 127.0.0.1 (Local Loop Back) but, I get a
>"TNS-03505:Failed to resolve name" error. It works when I do a tnsping80
>on tcp-loopback.world but, not when I do a tnsping80 on 127.0.0.1. Here
>is what I have in the tnsnames.ora file:
>
>Tcp-loopback.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = 127.0.0.1)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jul 15 1999 - 15:00:55 CDT
