Re: Web Server v3.0.1 - connecting to local DB v8.0.3

In article <6sa0t8$8di$1_at_news.sas.ab.ca>, suisum_at_freenet.edmonton.ab.ca wrote:

>You can't connect Web Application server to database as local (BEQ). You
>must connect it through SQL*Net. You may try to connect to Designer/2000.
>You should have the same problem. The proper way to use SQL*Net to set the
>interface between two application.

Well this is what I did.

1. Went to SQL*Net and defined an alias to my local machine e.g.

machinename -> machinename.domain.edu, ORCL and Named Pipes

2) If I try connecting with SQLPLUS to system/user_at_machinename

everything works OK.

3) When I try to create a new DAD and put machinename in SQL*Net V2 Service I get

OWS-05566: DAD vuksandad submission failed due to error 12203 ORA-12203: TNS:unable to connect to destination

Any clues ?

>: I have a problem connecting to my v8.0.3 local DB via Web application
>: server v3.0.1. Here is the current configuration:
>
>: NT v4.0 Workstation (not connected to a network)
>: Oracle enterprise ed, v8.0.3
>: Net8 installed + Sql*Net v2.3.3, connection via BEQ
>: Local Listener running..
>
>: The error:
>
>: OWS-05566: DAD DBA submission failed due to error 12154
>: ORA-12154: TNS:could not resolve service name

>: when trying to create a DAD to my local DB (called seca)
>
>: I have tried, like the doco says, installing the sql*net 7.3 cartridge
>: (although how do config it?) and selecting remote DB connection you can
>: supposedly connect to an 8 local DB.
>
>: I am getting desperate and any ideas, ie. reg settings or anything, would
>: be great. Why the heck would oracle release Net8 when their other products
>: dont support it. The only good thing is that it keeps oracle experts
>: employeed.
Received on Mon Sep 28 1998 - 16:23:33 CDT