WEBDB wants SYS password and TNS alias

From: Jim Lewis <pojpl_at_ais.ucla.edu>
Date: Thu, 13 Apr 2000 16:22:35 GMT
Message-ID: <8d4s84$c7l$1_at_carroll.library.ucla.edu>



[Quoted] [Quoted] I'm trying to install WEBDB 2.2 on top of Oracle8i on RedHat 6.1.

[Quoted] 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.

[Quoted] [Quoted] 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 Thu Apr 13 2000 - 18:22:35 CEST

Original text of this message