From: "Spammy Nono" Newsgroups: comp.databases.oracle.server References: <8pc4u5$8j6$1@nnrp1.deja.com> Subject: Re: WebDB connected to Oracle 8i on different machines? Lines: 46 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Message-ID: Date: Sat, 9 Sep 2000 15:25:58 +0200 NNTP-Posting-Host: 212.151.115.20 X-Complaints-To: news-abuse@swip.net X-Trace: nntpserver.swip.net 968505994 212.151.115.20 (Sat, 09 Sep 2000 15:26:34 MET DST) NNTP-Posting-Date: Sat, 09 Sep 2000 15:26:34 MET DST Organization: A Customer of Tele2 my reply at below... wrote in message news:8pc4u5$8j6$1@nnrp1.deja.com... > > > I'm an Oracle newbie and was wondering if anyone > could help me with a problem I'm having > connecting WebDB 2.2 installed on TurboLinux from > one machine to an Oracle 8.1.6 database installed > on another Linux machine. > > I have the Oracle 8.1.6 setup with TNS Listener > running with the listener.ora set correctly (I > think). When I install WebDB on the other Linux > box, I get to the screen where it asks for the > SYS password and TNS alias, and this is where I > can't get pass the install. > > I setup the tnsnames.ora with a TNS alias > pointing to the Oracle server (using TCP, etc) > and setup the TNS_ADMIN variable accordingly. > Having done all this, I can't get pass the SYS > password/TNS alias screen. I was told you can > have WebDB and the Oracle database on different > machines, so am I setting it up wrong or am I > completely missing something? > WebDB is mainly a bunch of PL/SQL packages, right? Then my guess is you would need a database for WebDB itself, and then the database(s) that contain your application data could obviously be located on other machines. Regards, /Fad > Any help would be appreciated. Thanks. > > Jantz > > > > Sent via Deja.com http://www.deja.com/ > Before you buy.