Re: WEBDB wants SYS password and TNS alias

This is a Oracle-beaty! The tnsnames.ora is not the one in Oracle 8i-directory.
Instead, it's the one on WebDB's network/admin. You have to manually configure this
(from another window) before entering the SYS-password and net_service_name.
Great Oracle!
/Håkan W

Jim Lewis wrote:

> 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 Fri Apr 14 2000 - 00:00:00 CDT