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))
)
(CONNECT_DATA =
(SID = orcl)
)
)
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 the
Oracle 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.
>
> Sorry, that message was for another newsgroup. Anyhelp on the question is
> much appreciated.
>
> Yaw.
>
>
> "Yaw" <yawi_at_bigpond.com> wrote in message
> news:9gtW7.14467$wD1.82553_at_news-server.bigpond.net.au...
> > My question is with Oracle8i. I have downloaded the Oracle8i Personal
> > Edition from the Oracle website, and have just successfully setup Oracle
> so
> > that I can log on to SQL*Plus remotely on my home LAN. However, now I
am
> > interested to expand that. So that I can log on to SQL*Plus from
another
> > network, say my next door neighbour, connecting through a different ISP.
> >
> > My questions are as follows:
> > 1. Is such a setup possible? If so, where do you think I can find the
> > documentation to help me. As so far, I've been quite unsuccessful.
> >
> > 2. Would the above setup ever work where: The machineA is the machine
> with
> > Windows2000 with internet connection sharing turned on. MachineB contai
ns
> > Oracle8i server, which connects via the internet through machineA. If
> so,
> > is "port forwarding" part of the solution?
> >
> >
> > Thanks for your help to this query.
> >
> > Yaw
> >
> >
>
>
- WAS CANCELLED BY =======:
Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news2.euro.net!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r
From: "Ted Martin" <martinted_at_sympatico.ca>
Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server
Subject: cmsg cancel <jm8Y7.6465$AS4.1160021_at_news20.bellglobal.com>
Control: cancel <jm8Y7.6465$AS4.1160021_at_news20.bellglobal.com>
Date: Wed, 2 Jan 2002 01:36:45 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.jm8Y7.6465$AS4.1160021_at_news20.bellglobal.com>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009944117 21023 166.102.15.34 (2 Jan 2002 04:01:57 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 2 Jan 2002 04:01:57 GMT
X-No-Archive: yes
Comment: Dude, where's my NewsAgent?
Xref: news.uni-stuttgart.de control:40277512
autocancel
Received on Mon Dec 31 2001 - 19:34:01 CST