Re: WebDB connected to Oracle 8i on different machines?

Yes, you can have Oracle db server and WebDB listener on different machines. In my opinion it is strongly recommended. WebDB listener comes with Oracle Net*8 Client, so connecting a remote db is not a problem.

Anyway, if you are positive, that your db is accessible remotely via Net*8 and the Oracle Net*8 client on WebDB is correctly set up ($TNS_ADMIN, tnsnames.ora, sqlnet.ora), then open your tnsnames.ora file in text-editor. I'm sure, that the tnsname entry for your db is taking more than one line. I don't know how to call it -- is it feature or bug -- but the tnsname entry must take only ONE line in the tnsnames.ora file.

HTH,
Juhan

amagus_at_my-deja.com wrote:
>
> 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?
>
> Any help would be appreciated. Thanks.
>
> Jantz
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
+-----------------+
|NB! Please remove|
|   .NICHT-SPAM   |
|  when replying  |
|    to get my    |
|     *REAL*      |
| e-mail address! |
|                 |
|  Cheers, Juhan  |
+-----------------+