Re: WEBDB wants SYS password and TNS alias

From: Leo Van Nieuwenhuyse <leo.van.nieuwenhuyse_at_pandora.be>
Date: Sat, 15 Apr 2000 19:20:28 GMT
Message-ID: <0i3K4.89427$l35.182685_at_afrodite.telenet-ops.be>


Try to put your tnsname in the local variable: LOCAL=yourtnsname ;export LOCAL
Afterwards do not enter anything in the service name (just enter the password).

Jim Lewis <pojpl_at_ais.ucla.edu> schreef in berichtnieuws 8d4s84$c7l$1_at_carroll.library.ucla.edu...
> I'm trying to install WEBDB 2.2 on top of Oracle8i on RedHat 6.1.
>
> Oracle8i is running fine, and the NET8 config is fine too, apparently,
> allowing access to Oracle8i from client machines.
>
> Unfortunately, my attempts at installing WebDB are blocked at the
> point where it asks for the password for the SYS account and for a TNS
> alias. I enter the SYS password and the net_service_name from the
> tsnnames.ora file but an error message pops up saying I have entered
> either an invalid SYS password or an invalid TNS alias. Don't you
> just LOVE "either"-type error messages!
>
> Perhaps I don't understand just what a "TNS alias" is. Here is the
> contents of the tnsnames.ora file:
>
> OR8IDB =
> (DESCRIPTION =
> (SOURCE_ROUTE = OFF)
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP) (HOST = <ip address>)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = or8iDB)
> )
>
> When the WebDB install asks for the TNS alias, I give it OR8IDB.
>
> I have also tried adding another entry in the tnsnames.ora file,
> identical to the OR8IDB entry but with WEBDB in place of OR8IDB.
>
> In either case the WebDB install coughs up the "either invalid SYS
> password or invalid TNS alias" error. By the way, I am sure I'm
> typing in the correct SYS password. I've been very careful about
> that.
>
> Does anyone have a guess what I may be doing wrong here?
>
>
>
>
>
>
Received on Sat Apr 15 2000 - 21:20:28 CEST

Original text of this message