Re: WebDB Can't login

Hi,

It sounds like you are having the same problem I did at first.

You need to add an entry to the TNSNAMES.ORA file for Net80 which is the network component that WebDB uses.

I.e. in (my case) \Oracle\WebDB\Net80\Admin add something like:

WEBDB.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = yourhostname)
          (Port = 1521)
        )

I did this to resolve my TNS issue but I still can't login.

In article <3780425B.7016B3D9_at_hookedREMOVE_THIS.net>, dwkunkel_at_hookedREMOVE_THIS.net says...
>
>
>
>Dale Wityshyn wrote:
>
>> I finally got webdb installed on my NT machine with Oracle 8.1.5.
>>
>> I have them installed in separate ORACLE_HOMES.
>>
>> I initially was getting a TNS error and fixed it by configuring the proper
>> TNSNAMES.ORA file for Net80.
>>
>> Now when I try to connect to http://myhost/WebDB/ I get the login prompt
>> and try to login as WEBDB/WEBDB or SYS but end up getting a page saying
>> "Database Log In Failed.".
>>
>> I can log in just fine with sqlplus.
>>
>> Any suggestions?
>>
>> Thanks in advance.
>>
>> Dale Wityshyn
>
>I'm having similar problems with WebDB on an Oracle 8.1.5 NT database. I have
>them installed in separate ORACLE_HOMEs. When I start WebDB using
>http://hostname/WebDB/, I get the login prompt but then get kicked out with
>the error message "Database Log In Failed TNS could not resolve service name.
>Verify that the TNS name in the connectstring entry of the DAD for this URL is
>valid". I would really appreciate any advice anyone might have on how to setup
>the tnsnames.ora file. The weird thing is that I installed WebDB for Solaris
>into an Oracle 8.0.5 database and it worked the first time.
>
>Thanks,
>Dave Kunkel
>
>
Received on Mon Jul 05 1999 - 18:06:31 CEST