Re: WEBDB wants SYS password and TNS alias

pojpl_at_ais.ucla.edu (Jim Lewis) wrote:

>Dipak Patel <dpatel_at_uakron.edu> wrote:

>>Jim,
>>This probably won't help you much, but I am having exactly the same
>>problem on NT. I have been trying to find solution to this for quite some
>>time now. If you find a solution, could you please share it with me? And
>>I will do the same.

>>Thanks,
>>Dipak
>>dpatel_at_uakron.edu

>Well, I found a way to get this thing to work, but note that I'm
>running this on RedHat Linux, not NT.

>The problem is not really that the SYS password and/or TNS alias is
>wrong. The WEBDB install tries to connect to the Oracle8i database --
>and that message will pop up if the attempt to connect fails, even if
>the SYS password and the TNS alias are correct and the connection
>failure is due to something else.

>It seems like WEBDB will only work if the TNS_ADMIN environment
>variable is set to the path to the tnsnames.ora file that is in the
>WEBDB home directory tree!

>The base Oracle8i install creates a directory to hold the tnsnames.ora
>and other network config files:

> $ORACLE_HOME/network/admin

>The WEBDB install also creates a directory to hold ITS OWN
>tnsnames.ora and other network config files:

> $ORACLE_BASE/webdb_home/network/admin

>on my machine.

>Now, even if the tnsnames.ora files in the two locations are
>absolutely identical, I can only get the base Oracle8i listener to
>start (lsnrctl start) if the TNS_ADMIN environment variable is set to
>the base Oracle8i path :

> $ORACLE_HOME/network/admin

>and I can only get the WEBDB to work (wdbstart .....) if the TNS_ADMIN
>environment variable is set to the WEBDB path:

> $ORACLE_BASE/webdb_home/network/admin (on my machine)

>NOTE that this is true even though the tnsnames.ora files in the two
>different locations are absolutely identical.

>Looks like the TNS_NAMES environment variable is used for things other
>than the location of the tnsnames.ora file!

Sorry. The above should say TNS_ADMIN, not TNS_NAMES.

>>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 Tue Apr 18 2000 - 17:48:31 CEST