Home » RDBMS Server » Networking and Gateways » host name/ip
host name/ip [message #66026] Thu, 11 October 2001 10:07 Go to next message
George
Messages: 68
Registered: April 2001
Member
Could anybody tell me why the host name (IP) are different in the listener.ora and tnsnames.ora, I need the host name to configure the 9iAS, which one is right?

in listener.ora:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.107.83.25)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.107.83.25)(PORT = 2481))
)
)

*************
in tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.109.145.100)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)

Thanks

----------------------------------------------------------------------
Re: host name/ip [message #66030 is a reply to message #66026] Fri, 12 October 2001 23:44 Go to previous message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
sir,

you have to mension the same ip
address in the tnsnammes.ora file and the
listener.ora file.

k.sreenivasan

----------------------------------------------------------------------
Previous Topic: Re: Installation Of ORacle -8i Eterprise & D2k in a single system
Next Topic: Credential Retrival Error ---- Does anyone knows solution ??
Goto Forum:
  


Current Time: Thu Apr 18 23:45:22 CDT 2024