Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> WEBDB wants SYS password and TNS alias

WEBDB wants SYS password and TNS alias

From: Jim Lewis <pojpl_at_ais.ucla.edu>
Date: 2000/04/13
Message-ID: <8d4saj$c7l$2@carroll.library.ucla.edu>#1/1

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 Thu Apr 13 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US