Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle8i external log possible?
Hi,
If you have a fixed IP address on the PC hosting your Oracle RDBMS, all you
need to do is
setup, on the client (i.e. your neighbour's using a different IP) a TNSNAMES
entry citing your host's IP address in the (HOST = ...) part of the ADDRESS
spec. For example:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 1.2.3.4) (PORT = 1521))
where "1.2.3.4" would be the IP address of the PC running your Oracle database. Note that the CONNECT_DATA should match that used in your LISTENER.ORA file of your Oracle machine. I'm using ORCL as the SID of theOracle database only because that is the default of the seed database that Oracle creates upon installation.
Oh, you'll need to have the Oracle Client software on the "remote" client - even for ODBC connections.
Hope this helps
Ted
"Yaw" <yawi_at_bigpond.com> wrote in message
news:JcuW7.14530$wD1.82765_at_news-server.bigpond.net.au...
> Ack. Outlook Express playing up.
>
>
> >