Re: WEBDB wants SYS password and TNS alias

Håkan Wahlberg wrote:
>
> 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
>

Well, it only depends on your ORACLE_HOME and/or TNS_ADMIN values ...

Kari  

(Mr.) Kari Pannila

      Oracle DBA (OCP)
      TietoEnator Corp - Telecom
      kari.pannila_at_tietoenator.comX

PS. Delete X from my mail address , it (X) is only for SPAMMERS.

    Poista X mail-osoitteesta, se on SPAMmereita varten.

> 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 Sat Apr 15 2000 - 00:00:00 CDT