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

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 - 11:08:09 CST