Re: Get oracle database to work over the LAN
From: Elias Asfaw-Kirby <elias_at_icpsr.umich.edu>
Date: Wed, 27 Nov 2002 10:51:19 -0500
Message-ID: <OR5F9.1271$ho1.86488_at_news.itd.umich.edu>
Date: Wed, 27 Nov 2002 10:51:19 -0500
Message-ID: <OR5F9.1271$ho1.86488_at_news.itd.umich.edu>
This is not a complete answer but should help to focus on the problem more:
- If I remember correctly PE oracle only supports 1 connection, so you're probably using that machine as a client (SqlPlus) + Make sure you have an entry in tnsnames.ora that points at your server
- Your Oracle 9i is probably your server. (I haven't used this yet but concepts are probably the same) + Make sure you have a listener configured
Try to connect from PE to 9i using Sql+Plus and attack the problems from there.
Elias Asfaw-Kirby
-- --- "Gaz" <gonkowonko_at_freeuk.com> wrote in message news:24cc4785.0211080305.665c3a46_at_posting.google.com...Received on Wed Nov 27 2002 - 16:51:19 CET
> Basically i have oracle on my computer and also another computer on my
> LAN has oracle on it. We want to set up a database on one computer so
> that both computers can edit and view it. Everything i try doesnt seem
> to work. Prob something little ive missed out
> Can anyone give me all the details on how to set up oracle over a
> network?
> We are both running WIndows XP??
> One machine has 8 personal edtion and the other 9i enterprise edition.
> Any information would be greatly appreciated
>
> CHEERS
>
> GAZ