Re: Q: Using Oracle on a TCP/IP Network
Date: 1996/03/01
Message-ID: <4h70n8$769_at_castle.nando.net>#1/1
Mike Emeigh <emeighm_at_bah.com> wrote:
>I'm not an Oracle *pro*, so I thought I'd solicit some advice
>from some people who are :)
>We've got an Oracle 7.1.6 database server residing on a SParc20
>running Solaris 2.5, and we're trying to be able to access it
>across our internal TCP/IP network. I have SQL*Net V2 installed
>on both the client machines and the server machine, as well as
>the TCP/IP adapter.
>How do I set up the TNSNAMES.ORA and LISTENER.ORA files to
>recognize the IP address of the Oracle server? Does it work to
>set HOST=nnn.nn.nnn.nnn? The examples I've seen in the
>documentation use named hosts, but there's no explanation of how
>those names are mapped to IP addresses.
>We're also looking at doing something similar in a Windows NT
>environment, so I'd also like to know what (if anything) we'd
>have to do differently there.
>Please copy me via E-mail on any reply you post to the
>newsgroup, as my provider sometimes takes a couple of days to
>receive posts. TIA for any assistance.
Mike--
Here's a sample (annotated) of an entry in TNSNAMES.ORA:
S5919T.tru.com = <===where S5919T is the alias name
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcpcom.tru.com) <== not sure?
(PROTOCOL = TCP)
(Host = s5919t.tru.com) <==actual host name
(Port = 1521) <==default sqlnet port
)
)
(CONNECT_DATA = (SID = STRI) <==instance name )
)
+------------------------------------------------------------+ | Chris Fischer cfischer_at_nando.net | | Sr. Systems Analyst Work: (919)676-0062 | | Toys "R" Us | +------------------------------------------------------------+Received on Fri Mar 01 1996 - 00:00:00 CET