Re: Oracle and the Web driving me nuts, suggestions?

Thanks, the LOCAL environment variable did the trick! Funny the support folks didn't think of that (or me, for that matter...).

I'm sure once I get an example going I will be happier. I did get a copy of Webdb, but have not installed it yet. That's next on my list.

Gord.

TurkBear <johng_at_mm.com> wrote in message news:384f8dea.3618032_at_super.news-ituk.to...
> Try Oracle's WebDb - its a subset ( sort of) of the OAS package and is
simpler
> to set up and use...
>
> As for OAS, most of the frustration you are experiencing is in the
> 'infrastructure' that Oracle requires ( SqlNet, Listeners, etc) , but
these are
> only needed once for most Oracle stuff, particularly if you use the same
release
> version of the tools..( All 8.1.x.x or 8.0.x.x or 7.3.x.x ) since each
needs its
> own oracle home - I have 3 Oracle homes on my client and, with few
exceptions,
> Oracle handles it well but it does add 'overhead' to the maintenance of
the
> common files...
>
> The most common error when installing the PL/SQL toolkit is a failure to
connect
> as SYS since you are not given the chance to specify which instance to
connect
> to - ( no @tnsalias is given) - to avoid this add a environment variable (
> TWO_TASK in most unix/linux systems, LOCAL in Netware/NT ) specifying the
> connect string e.g. TWO_TASK=mytnsalias - this should help ...
>
> But there is no question that Oracle is complicated...thats the price you
pay
> for power and flexibility....
>
> Just my 2c
>
> hih,
>
>
> "Gordo" <gcoulman_at_ccinet.ab.ca> wrote:
>
> >Is it just me, or is Oracle Application Server waaaaay too complicated?
> >
> >First, you have to build an application server, then install OAS, then
> >figure out the TNS business, then install the PL/SQL toolkit, then create
a
> >DAD, then a cartridge, then write a PL/Sql procedure, oops forgot the
> >Listener, then figure out what the URL is going to look like, try about
two
> >dozen of them to figure it out.
> >
> >That's if everything goes right. If it goes wrong, the PL/sql toolkit
won't
> >install because of some obscure Sqlnet error that Oracle Support can't
> >figure out. Of course the database has to be upgraded, because versions
> >under 7.3.4 don't support the web toolkit... On NT, don't forget service
> >pak 5. And if you have Developer 6 installed, it has to go in first, in
the
> >default Oracle home. But oh yes, OAS can't be in the same home as
> >Developer. Dang, install OAS all over again... Uh oh, now the reports
> >cartridge doesn't work, because it has to be in the default oracle
home....
> >
> >Ahhhhhhhhhhh!!!!!! There must be an easier way!!!!
> >
> >OAS on Sun?? Linux?? Perl maybe?? Microsoft Access?? MSql?? Sybase???
> >Cold Fusion?? I'll take any and all advice at this point.
> >
> >Frustrated in the North
> >
>
>
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News
==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers
==----- Received on Wed Dec 08 1999 - 17:46:29 CST