Re: Web Gateway ?!

In article <1995Jun17.092656.11460_at_news.snu.ac.kr> yoon_at_arirang.snu.ac.kr (Park Yoon Na) writes:
> 'm trying to set up WOW gateway.
> Being a complete novice to oracle,I got confronted with details which
> might be very basic.
> Sorry if my questions will be too ignorant,but hope someone will give
> an answer.
>
>
> 1) can't startup orasrv. it says
> orasrv: SERVICES file lookup failure
>
> my /etc/services has 'orasrv 1525/tcp' entry and proper file
> permission.

Could be any number of problems. The most common errors with sqlnet v1:

a) no orasrv entry in /etc/services
b) no oracle_sid entry in /etc/oratab
c) orasrv not running setuid root
d) $ORACLE_HOME/bin not in path

>
> 2) TNS_ADMIN
> my system doesn't have tnsalias.ora in $ORACLE_HOME/network/admin.
> where's tnsalias.ora come from?

The file is tnsnames.ora and it is generated by the Oracle Network Manager for SQL*Net v2 descriptors. You may also create it manually.

>
> 3) WOW_UID
> is there any problem if it's set to just 'scott/tiger'?
>
> for example, in www_manager/oraweb_at_p:www, prefix p is for what?
>

You may use any Oracle account. You may use multiple Oracle accounts (you'll need one WOW shell script for each). The p: driver is the Unix pipe driver which looks up the ORACLE_SID (www) in /etc/oratab.

> 4) TWO_TASK
> it's set to www. www has to be defined anywhere else?

In tnsnames.ora. If you are connecting to a database on the same node as your web server, just remove TWO_TASK and TNS_ADMIN -- you don't need them. All you need is ORACLE_HOME, ORACLE_SID, and WOW_UID.

>
> --yoon yoon_at_arirang.snu.ac.kr
>
> ~
>

--

Magnus Lonnroth					Phone	(415) 506-9851
Senior Product Manager
Internet Products, Server Technologies
Oracle Corporation