Oracle and the Web driving me nuts, suggestions? 
Author Message
 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

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,

Quote:

>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.***.com/       The Largest Usenet Servers in the World!
------== Over 73,000 Newsgroups - Including  Dedicated  Binaries Servers ==-----


Wed, 18 Jun 1902 08:00:00 GMT
 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.


Quote:
> 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

> 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,


> >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

==-----


Wed, 18 Jun 1902 08:00:00 GMT
 Oracle and the Web driving me nuts, suggestions?
It is complicated and if you use the product now, you'll just have to work
around the problems you encounter.  Keep watching Oracle's ftp and patch
sites.  Corrections and upgrades are being released.  Things will probably
sort themselves out better over the next year.

Van


Quote:
> 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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. DTS from ASP security driving me nuts!

2. Driving me nuts!!

3. SQL Error 2417 driving me nuts

4. Triggers drive me NUTS!

5. I'm sure it something simple but it's driving me nuts :-(

6. Synax problem driving me nuts

7. HELP: isql is driving me nuts!

8. Index Tuning Wizard Driving me NUTS

9. Please Help, this is driving me nuts !!

10. SUB QUERY driving me NUTS!

11. This query is driving me nuts - please help !!

12. Stored Procedure Problem --- Driving me nuts!


 
Powered by phpBB® Forum Software