RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Boivin, Patrice J]

Here they are touting the benefits of Windows2000 Terminal Server... I
discovered that any script / reference to SQL Net causes a TCP protocol
error, and you can't copy / paste from a local file to one in the terminal
server window.

So, we still need a display for every windows2000 server.

I don't know if some of the problems have to do with Java via terminal
server.  I hear Microsoft pulled its Java download page for XP already.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


 -Original Message-
[mailto:[EMAIL PROTECTED]] 
Sent:   Thursday, July 18, 2002 5:35 PM
To: Multiple recipients of list ORACLE-L
Subject:        RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache

Good luck.  The "smooth" install is at a grinding halt at the moment, with
half the components throwing java exceptions all over the place.  Did I
mention java sucks?

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Freeman, Robert [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 3:10 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> I will see what I can do. Thanks Scott!
> 
> RF
> 
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> Oracle9i New Features (Oracle Press)
> Mastering Oracle8i  (Sybex)
> 
> Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> Cousin Eddie: Those were my mother's dying words. But I
> guess if your body's covered in third degree burns, and 
> your foot's caught in a bear trap, you tend to start talkin' 
> crazy.
> 
> 
> 
> -Original Message-
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 17, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Robert, 
> 
> After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
> get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type,
> and
> it seems to be a lot smoother, albeit more bloated and slower - at least
> the
> install portion.
> 
> Scott Shafer
> San Antonio, TX
> 210-581-6217
> 
> 
> > -----Original Message-
> > From:   Freeman, Robert [SMTP:[EMAIL PROTECTED]]
> > Sent:   Wednesday, July 17, 2002 4:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> > 
> > This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> > So, I'm guessing this is iAS. I have a hard enough time keeping
> > up with Oracle marketing's changing the names/version of Oracle Net,
> > parallel server, and MTS every opportunity they get!!
> > 
> > RF
> > 
> > 
> > 
> > Robert G. Freeman - Oracle OCP
> > Oracle Database Architect
> > CSX Midtier Database Administration
> > Author
> > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > Oracle9i New Features (Oracle Press)
> > Mastering Oracle8i  (Sybex)
> > 
> > Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> > Cousin Eddie: Those were my mother's dying words. But I
> > guess if your body's covered in third degree burns, and 
> > your foot's caught in a bear trap, you tend to start talkin' 
> > crazy.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Wednesday, July 17, 2002 1:24 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > It really OAS and not iAS?  If it is, you need to upgrade your software.
> > There is  a published exploit against  the version of Apache used by
> > Oracle's latest iAS release.  Oracle has released a patch which stops
> the
> > exploit
> > 
> > I have built Oracle web servers for years, but I am now of the mind that
> > these things should not be built by DBA's but by webmasters. 
> > 
> > I am undecided whether to one should go with iAS or construct your own
> > with
> > Apache.  The mod_plsql module for instance was not created by Oracle.
> It
> > and things  such as forms server and reports server will run against
> such
> > a
> > construction. 
> > 
> > However, we were advised last week that the  Windows NT machines will be
> > converted to XP  this year.  As a result, I  started to look at  the 9i
> > Internet Developer Suite.  About every third line is a statement to the
> > effect that the 9i database, 9 iAS, and 9 iDS are made to work together.
> > 

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Jenkins, Michael - EDS]

Let's not forget the new ".mac"

-Original Message-
Sent: Thursday, July 18, 2002 4:59 PM
To: Multiple recipients of list ORACLE-L


Thats the problem with technology today I think man, the stacks get
more and more complicatedThere is UNIX, NT, IIS, Apache, C, Java, Java
Beans, Java Applets, .NET, ASP, XML, EI EI Oh...

Oh for the day when one could DBA and develop the most incredible C code and
not struggle to understand everything to an expert level.

<>

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.



-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 4:35 PM
To: Multiple recipients of list ORACLE-L


Good luck.  The "smooth" install is at a grinding halt at the moment, with
half the components throwing java exceptions all over the place.  Did I
mention java sucks?

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Freeman, Robert [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 3:10 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> I will see what I can do. Thanks Scott!
> 
> RF
> 
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> Oracle9i New Features (Oracle Press)
> Mastering Oracle8i  (Sybex)
> 
> Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> Cousin Eddie: Those were my mother's dying words. But I
> guess if your body's covered in third degree burns, and 
> your foot's caught in a bear trap, you tend to start talkin' 
> crazy.
> 
> 
> 
> -Original Message-
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 17, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Robert, 
> 
> After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
> get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type,
> and
> it seems to be a lot smoother, albeit more bloated and slower - at least
> the
> install portion.
> 
> Scott Shafer
> San Antonio, TX
> 210-581-6217
> 
> 
> > -Original Message-
> > From:   Freeman, Robert [SMTP:[EMAIL PROTECTED]]
> > Sent:   Wednesday, July 17, 2002 4:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> > 
> > This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> > So, I'm guessing this is iAS. I have a hard enough time keeping
> > up with Oracle marketing's changing the names/version of Oracle Net,
> > parallel server, and MTS every opportunity they get!!
> > 
> > RF
> > 
> > 
> > 
> > Robert G. Freeman - Oracle OCP
> > Oracle Database Architect
> > CSX Midtier Database Administration
> > Author
> > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > Oracle9i New Features (Oracle Press)
> > Mastering Oracle8i  (Sybex)
> > 
> > Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> > Cousin Eddie: Those were my mother's dying words. But I
> > guess if your body's covered in third degree burns, and 
> > your foot's caught in a bear trap, you tend to start talkin' 
> > crazy.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Wednesday, July 17, 2002 1:24 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > It really OAS and not iAS?  If it is, you need to upgrade your software.
> > There is  a published exploit against  the version of Apache used by
> > Oracle's latest iAS release.  Oracle has released a patch which stops
> the
> > exploit
> > 
> > I have built Oracle web servers for years, but I am now of the mind that
> > these things should not be built by DBA's but by webmasters. 
> > 
> > I am undecided whether to one should go with iAS or construct your own
> > with
> > Apache.  The mod_plsql module for instance was not created by Oracle.
> It
> > and things  such as forms server and reports serv

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Freeman, Robert]

Thats the problem with technology today I think man, the stacks get
more and more complicatedThere is UNIX, NT, IIS, Apache, C, Java, Java
Beans, Java Applets, .NET, ASP, XML, EI EI Oh...

Oh for the day when one could DBA and develop the most incredible C code and
not struggle to understand everything to an expert level.

<>

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.



-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 4:35 PM
To: Multiple recipients of list ORACLE-L


Good luck.  The "smooth" install is at a grinding halt at the moment, with
half the components throwing java exceptions all over the place.  Did I
mention java sucks?

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Freeman, Robert [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 3:10 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> I will see what I can do. Thanks Scott!
> 
> RF
> 
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> Oracle9i New Features (Oracle Press)
> Mastering Oracle8i  (Sybex)
> 
> Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> Cousin Eddie: Those were my mother's dying words. But I
> guess if your body's covered in third degree burns, and 
> your foot's caught in a bear trap, you tend to start talkin' 
> crazy.
> 
> 
> 
> -Original Message-
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 17, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Robert, 
> 
> After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
> get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type,
> and
> it seems to be a lot smoother, albeit more bloated and slower - at least
> the
> install portion.
> 
> Scott Shafer
> San Antonio, TX
> 210-581-6217
> 
> 
> > -Original Message-
> > From:   Freeman, Robert [SMTP:[EMAIL PROTECTED]]
> > Sent:   Wednesday, July 17, 2002 4:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> > 
> > This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> > So, I'm guessing this is iAS. I have a hard enough time keeping
> > up with Oracle marketing's changing the names/version of Oracle Net,
> > parallel server, and MTS every opportunity they get!!
> > 
> > RF
> > 
> > 
> > 
> > Robert G. Freeman - Oracle OCP
> > Oracle Database Architect
> > CSX Midtier Database Administration
> > Author
> > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > Oracle9i New Features (Oracle Press)
> > Mastering Oracle8i  (Sybex)
> > 
> > Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> > Cousin Eddie: Those were my mother's dying words. But I
> > guess if your body's covered in third degree burns, and 
> > your foot's caught in a bear trap, you tend to start talkin' 
> > crazy.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Wednesday, July 17, 2002 1:24 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > It really OAS and not iAS?  If it is, you need to upgrade your software.
> > There is  a published exploit against  the version of Apache used by
> > Oracle's latest iAS release.  Oracle has released a patch which stops
> the
> > exploit
> > 
> > I have built Oracle web servers for years, but I am now of the mind that
> > these things should not be built by DBA's but by webmasters. 
> > 
> > I am undecided whether to one should go with iAS or construct your own
> > with
> > Apache.  The mod_plsql module for instance was not created by Oracle.
> It
> > and things  such as forms server and reports server will run against
> such
> > a
> > construction. 
> > 
> > However, we were advised last week that the  Windows NT machin

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Scott . Shafer]

Good luck.  The "smooth" install is at a grinding halt at the moment, with
half the components throwing java exceptions all over the place.  Did I
mention java sucks?

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Freeman, Robert [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 3:10 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:      RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> I will see what I can do. Thanks Scott!
> 
> RF
> 
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> Oracle9i New Features (Oracle Press)
> Mastering Oracle8i  (Sybex)
> 
> Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> Cousin Eddie: Those were my mother's dying words. But I
> guess if your body's covered in third degree burns, and 
> your foot's caught in a bear trap, you tend to start talkin' 
> crazy.
> 
> 
> 
> -Original Message-
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 17, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Robert, 
> 
> After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
> get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type,
> and
> it seems to be a lot smoother, albeit more bloated and slower - at least
> the
> install portion.
> 
> Scott Shafer
> San Antonio, TX
> 210-581-6217
> 
> 
> > -Original Message-
> > From:   Freeman, Robert [SMTP:[EMAIL PROTECTED]]
> > Sent:   Wednesday, July 17, 2002 4:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> > 
> > This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> > So, I'm guessing this is iAS. I have a hard enough time keeping
> > up with Oracle marketing's changing the names/version of Oracle Net,
> > parallel server, and MTS every opportunity they get!!
> > 
> > RF
> > 
> > 
> > 
> > Robert G. Freeman - Oracle OCP
> > Oracle Database Architect
> > CSX Midtier Database Administration
> > Author
> > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > Oracle9i New Features (Oracle Press)
> > Mastering Oracle8i  (Sybex)
> > 
> > Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> > Cousin Eddie: Those were my mother's dying words. But I
> > guess if your body's covered in third degree burns, and 
> > your foot's caught in a bear trap, you tend to start talkin' 
> > crazy.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Wednesday, July 17, 2002 1:24 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > It really OAS and not iAS?  If it is, you need to upgrade your software.
> > There is  a published exploit against  the version of Apache used by
> > Oracle's latest iAS release.  Oracle has released a patch which stops
> the
> > exploit
> > 
> > I have built Oracle web servers for years, but I am now of the mind that
> > these things should not be built by DBA's but by webmasters. 
> > 
> > I am undecided whether to one should go with iAS or construct your own
> > with
> > Apache.  The mod_plsql module for instance was not created by Oracle.
> It
> > and things  such as forms server and reports server will run against
> such
> > a
> > construction. 
> > 
> > However, we were advised last week that the  Windows NT machines will be
> > converted to XP  this year.  As a result, I  started to look at  the 9i
> > Internet Developer Suite.  About every third line is a statement to the
> > effect that the 9i database, 9 iAS, and 9 iDS are made to work together.
> > I
> > haven't figured out what one is giving up if one builds their own web
> > server
> > and also installs components for the 9 iAS distribution.  Is it just
> > convenience?
> > 
> > One reason for giving up the convenience is security.  An exploit is
> > discovered and possibly published.  Apache fixes the problem.  If I have
> > built my own I can get the patch from Apache and  rebuild the web
> server.
> > If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
> > into its offering.  This could be a matter days to over a week.  However
> > weighing-in on the 9 iAS side is the ease of installing a fix.  The
> Ap

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Freeman, Robert]

I will see what I can do. Thanks Scott!

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.



-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 5:29 PM
To: Multiple recipients of list ORACLE-L


Robert, 

After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type, and
it seems to be a lot smoother, albeit more bloated and slower - at least the
install portion.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Freeman, Robert [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, July 17, 2002 4:09 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> So, I'm guessing this is iAS. I have a hard enough time keeping
> up with Oracle marketing's changing the names/version of Oracle Net,
> parallel server, and MTS every opportunity they get!!
> 
> RF
> 
> 
> 
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> Oracle9i New Features (Oracle Press)
> Mastering Oracle8i  (Sybex)
> 
> Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> Cousin Eddie: Those were my mother's dying words. But I
> guess if your body's covered in third degree burns, and 
> your foot's caught in a bear trap, you tend to start talkin' 
> crazy.
> 
> 
> 
> -Original Message-
> Sent: Wednesday, July 17, 2002 1:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> It really OAS and not iAS?  If it is, you need to upgrade your software.
> There is  a published exploit against  the version of Apache used by
> Oracle's latest iAS release.  Oracle has released a patch which stops the
> exploit
> 
> I have built Oracle web servers for years, but I am now of the mind that
> these things should not be built by DBA's but by webmasters. 
> 
> I am undecided whether to one should go with iAS or construct your own
> with
> Apache.  The mod_plsql module for instance was not created by Oracle.  It
> and things  such as forms server and reports server will run against such
> a
> construction. 
> 
> However, we were advised last week that the  Windows NT machines will be
> converted to XP  this year.  As a result, I  started to look at  the 9i
> Internet Developer Suite.  About every third line is a statement to the
> effect that the 9i database, 9 iAS, and 9 iDS are made to work together.
> I
> haven't figured out what one is giving up if one builds their own web
> server
> and also installs components for the 9 iAS distribution.  Is it just
> convenience?
> 
> One reason for giving up the convenience is security.  An exploit is
> discovered and possibly published.  Apache fixes the problem.  If I have
> built my own I can get the patch from Apache and  rebuild the web server.
> If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
> into its offering.  This could be a matter days to over a week.  However
> weighing-in on the 9 iAS side is the ease of installing a fix.  The Apache
> fix  for the aforementioned problem required  a rebuild; you need someone
> wise in the ways of make files and such.   The 9 iAS fix was a simple file
> replacement.
> 
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Wednesday, July 17, 2002 9:18 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Folks,
>  
> I'm a DBA who is really an old developer at heart. I know a little Java, a
> little Asp
> (enough, as they say, to be really dangerous!), I used to do C code that
> now
> makes 
> my head swim to look at. (I think to myself, what the devil was I doing??)
>  
> Anyway, I've finally found some time and a machine here at work to start
> playing with
> OAS just to see what it's all about. Anyone have any good suggestions with
> regards 
> to:
>  
> 1. Sites, books, white papers and the like with good install tips, hints,
> warnings and the like.
> 2. 

RE: A DBA looks at OAS | IAS vs. Locally-built Apache (commen

[Boivin, Patrice J]

I don't think it's deliberate, probably just because products are being
rolled out so quickly and the technology is changing.

OAS and OWS were different from iAS, they used an Oracle-built (I believe)
web server.
iAS relies on Apache.

As for the change from 1.0 to 9I rel 2 for iAS, probably they are trying to
harmonize all the version numbers with the rdbms version.

Question:  In iAS 9I Rel 2, is there still and 806 Oracle home for the Forms
Reports server?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]


 -Original Message-
Sent:   Thursday, July 18, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
(commen

All,
to my mind this conversation (among people who genuinely take an interest in
Oracle products) pretty much demonstrates how confusing Oracle's versioning
system is.
Does anyone think this is deliberate? Is there any gain to them in confusing
customers or is it just incompetence on their part?

Opinions?

Regards,
Mike Hately
Oracle DBA

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 18 July 2002 17:34
To: Multiple recipients of list ORACLE-L


The 9.0.2 differs significantly from the 1.0.2.2 at least for HPUX.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 10:38 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> I believe, about 95% confident, that they are the same.  I think Oracle
> applications customers receive the  the 1.0.2X numbered versions. 
> 
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Thursday, July 18, 2002 7:18 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Now I am confused.  Supposedly, I just received the latest 9iAS from
> Oracle and its version is 1.0.2.2.2a.  Is this 9iAS release 2, 9iAS
> release 1.0.2, etc?
> 
> Gene
> 
> >>> [EMAIL PROTECTED] 07/17/02 05:28PM >>>
> Robert, 
> 
> After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
> get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type,
> and
> it seems to be a lot smoother, albeit more bloated and slower - at least
> the
> install portion.
> 
> Scott Shafer
> San Antonio, TX
> 210-581-6217
> 
> 
> > -Original Message-
> > From:       Freeman, Robert [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Wednesday, July 17, 2002 4:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> > 
> > This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> > So, I'm guessing this is iAS. I have a hard enough time keeping
> > up with Oracle marketing's changing the names/version of Oracle Net,
> > parallel server, and MTS every opportunity they get!!
> > 
> > RF
> > 
> > 
> > 


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (li

RE: A DBA looks at OAS

[Eric D. Pierce]

At work we ordered 9iAS R2 (for NT/Win2000) in May. We 
just got it the other day. I have to wait for some old 
lab machines to go to surplus status (many months) 
before I can make a couple sandbox win2000 servers to 
test it and the 9i db (and 9i iDS).

books

??? http://www.amazon.com/exec/obidos/ASIN/0072190922

doesn't have anything on NT, or 9iAS specifically, but 
for Win2000 tools/environment, w/ the 9i db, or EM:

http://www.amazon.com/exec/obidos/ASIN/0072194626

??? general oracle architecture/technology, apparently 
includes "something" on 9i AS:

http://www.amazon.com/exec/obidos/ASIN/0596001797


see:

www.odtug.com

or go to metalink, click on "top docs" and look 
around.

or otn

regards.
ep



On 17 Jul 2002 at 13:08, Freeman, Robert wrote:

Date sent:  Wed, 17 Jul 2002 13:08:57 -0800
<[EMAIL PROTECTED]>
To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>

> Lot's to consider unfortunately I'm running it on NT ... :-))

...

> --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> > Folks,
> >  
> > I'm a DBA who is really an old developer at heart. I
> > know a little Java, a
> > little Asp
> > (enough, as they say, to be really dangerous!), I
> > used to do C code that now
> > makes 
> > my head swim to look at. (I think to myself, what
> > the devil was I doing??)
> >  
> > Anyway, I've finally found some time and a machine
> > here at work to start
> > playing with
> > OAS just to see what it's all about. Anyone have any
> > good suggestions with
> > regards 
> > to:
> >  
> > 1. Sites, books, white papers and the like with good
> > install tips, hints,
> > warnings and the like.
> > 2. Sites, books, white papers and the like Quick
> > getting started tips.
> > 3. Your own "getting started" experiences of things
> > to do or not to do.
> > 5. Anything I should do before I mess with OAS.
> >  
> > Optimistically hopeful that this will all just go
> > really smooth and I'll
> > have a cool
> > web page that I can bring up soon!

...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Hately Mike]

Gene,
the order as far as memory serves is roughly:

Oracle WebServer 2.x
Oracle Web Server/Oracle Application Server 3.0.x
Oracle Application Server 4.0.x
Oracle 9i Application Server 1.0 - 1.0.2.2.2
Oracle 9i Application Server 9.0.2  (Release 2) - 13th May release date I
think.

There was some confusion in the early days of 9iAS Release 2 over whether it
was available and I seem to remember that we had to assure them that "Yes,
Release 2 is available, honest!" before they would send it out.

There's an advisory for the bug (in Apache - not Oracle's code) and a patch
available.

Hope this helps,
Mike Hately
(Oracle DBA)


-Original Message-
Sent: 18 July 2002 17:34
To: Multiple recipients of list ORACLE-L


I have the cds released Feb-02.  I received them 2 weeks ago.  I would hate
to think Oracle had extra's of the old stuff and passed it on :).  Will be
logging a tar.  

Thanks, 
Gene



 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A DBA looks at OAS | IAS vs. Locally-built Apache (commen

[Hately Mike]

All,
to my mind this conversation (among people who genuinely take an interest in
Oracle products) pretty much demonstrates how confusing Oracle's versioning
system is.
Does anyone think this is deliberate? Is there any gain to them in confusing
customers or is it just incompetence on their part?

Opinions?

Regards,
Mike Hately
Oracle DBA

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 18 July 2002 17:34
To: Multiple recipients of list ORACLE-L


The 9.0.2 differs significantly from the 1.0.2.2 at least for HPUX.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 10:38 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:      RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> I believe, about 95% confident, that they are the same.  I think Oracle
> applications customers receive the  the 1.0.2X numbered versions. 
> 
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Thursday, July 18, 2002 7:18 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Now I am confused.  Supposedly, I just received the latest 9iAS from
> Oracle and its version is 1.0.2.2.2a.  Is this 9iAS release 2, 9iAS
> release 1.0.2, etc?
> 
> Gene
> 
> >>> [EMAIL PROTECTED] 07/17/02 05:28PM >>>
> Robert, 
> 
> After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
> get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type,
> and
> it seems to be a lot smoother, albeit more bloated and slower - at least
> the
> install portion.
> 
> Scott Shafer
> San Antonio, TX
> 210-581-6217
> 
> 
> > -Original Message-
> > From:       Freeman, Robert [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Wednesday, July 17, 2002 4:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> > 
> > This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> > So, I'm guessing this is iAS. I have a hard enough time keeping
> > up with Oracle marketing's changing the names/version of Oracle Net,
> > parallel server, and MTS every opportunity they get!!
> > 
> > RF
> > 
> > 
> > 


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Scott . Shafer]

The 9.0.2 differs significantly from the 1.0.2.2 at least for HPUX.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 10:38 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> I believe, about 95% confident, that they are the same.  I think Oracle
> applications customers receive the  the 1.0.2X numbered versions. 
> 
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Thursday, July 18, 2002 7:18 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Now I am confused.  Supposedly, I just received the latest 9iAS from
> Oracle and its version is 1.0.2.2.2a.  Is this 9iAS release 2, 9iAS
> release 1.0.2, etc?
> 
> Gene
> 
> >>> [EMAIL PROTECTED] 07/17/02 05:28PM >>>
> Robert, 
> 
> After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
> get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type,
> and
> it seems to be a lot smoother, albeit more bloated and slower - at least
> the
> install portion.
> 
> Scott Shafer
> San Antonio, TX
> 210-581-6217
> 
> 
> > -Original Message-
> > From:   Freeman, Robert [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Wednesday, July 17, 2002 4:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> > 
> > This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> > So, I'm guessing this is iAS. I have a hard enough time keeping
> > up with Oracle marketing's changing the names/version of Oracle Net,
> > parallel server, and MTS every opportunity they get!!
> > 
> > RF
> > 
> > 
> > 
> > Robert G. Freeman - Oracle OCP
> > Oracle Database Architect
> > CSX Midtier Database Administration
> > Author
> > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > Oracle9i New Features (Oracle Press)
> > Mastering Oracle8i  (Sybex)
> > 
> > Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> > Cousin Eddie: Those were my mother's dying words. But I
> > guess if your body's covered in third degree burns, and 
> > your foot's caught in a bear trap, you tend to start talkin' 
> > crazy.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Wednesday, July 17, 2002 1:24 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > It really OAS and not iAS?  If it is, you need to upgrade your software.
> > There is  a published exploit against  the version of Apache used by
> > Oracle's latest iAS release.  Oracle has released a patch which stops
> the
> > exploit
> > 
> > I have built Oracle web servers for years, but I am now of the mind that
> > these things should not be built by DBA's but by webmasters. 
> > 
> > I am undecided whether to one should go with iAS or construct your own
> > with
> > Apache.  The mod_plsql module for instance was not created by Oracle.
> It
> > and things  such as forms server and reports server will run against
> such
> > a
> > construction. 
> > 
> > However, we were advised last week that the  Windows NT machines will be
> > converted to XP  this year.  As a result, I  started to look at  the 9i
> > Internet Developer Suite.  About every third line is a statement to the
> > effect that the 9i database, 9 iAS, and 9 iDS are made to work together.
> > I
> > haven't figured out what one is giving up if one builds their own web
> > server
> > and also installs components for the 9 iAS distribution.  Is it just
> > convenience?
> > 
> > One reason for giving up the convenience is security.  An exploit is
> > discovered and possibly published.  Apache fixes the problem.  If I have
> > built my own I can get the patch from Apache and  rebuild the web
> server.
> > If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
> > into its offering.  This could be a matter days to over a week.  However
> > weighing-in on the 9 iAS side is the ease of installing a fix.  The
> Apache
> > fix  for the aforementioned problem required  a rebuild; you need
> someone
> > wise in the ways of make files and such.   The 9 iAS fix was a simple
> file
> > replacement.
> > 
> > Ian MacGregor
> > Stanford Linear Accelerator 

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Gene Sais]

I have the cds released Feb-02.  I received them 2 weeks ago.  I would hate to think 
Oracle had extra's of the old stuff and passed it on :).  Will be logging a tar.  

Thanks, 
Gene

>>> [EMAIL PROTECTED] 07/18/02 11:33AM >>>
Gene, I dunno anymore.  9.0.2 came out in May '02, according to the cd.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Gene Sais [SMTP:[EMAIL PROTECTED]] 
> Sent: Thursday, July 18, 2002 9:18 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> Now I am confused.  Supposedly, I just received the latest 9iAS from
> Oracle and its version is 1.0.2.2.2a.  Is this 9iAS release 2, 9iAS
> release 1.0.2, etc?
> 
> Gene
> 
> >>> [EMAIL PROTECTED] 07/17/02 05:28PM >>>
> Robert, 
> 
> After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
> get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type,
> and
> it seems to be a lot smoother, albeit more bloated and slower - at least
> the
> install portion.
> 
> Scott Shafer
> San Antonio, TX
> 210-581-6217
> 
> 
> > -Original Message-
> > From:   Freeman, Robert [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Wednesday, July 17, 2002 4:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> > 
> > This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> > So, I'm guessing this is iAS. I have a hard enough time keeping
> > up with Oracle marketing's changing the names/version of Oracle Net,
> > parallel server, and MTS every opportunity they get!!
> > 
> > RF
> > 
> > 
> > 
> > Robert G. Freeman - Oracle OCP
> > Oracle Database Architect
> > CSX Midtier Database Administration
> > Author
> > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > Oracle9i New Features (Oracle Press)
> > Mastering Oracle8i  (Sybex)
> > 
> > Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> > Cousin Eddie: Those were my mother's dying words. But I
> > guess if your body's covered in third degree burns, and 
> > your foot's caught in a bear trap, you tend to start talkin' 
> > crazy.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Wednesday, July 17, 2002 1:24 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > It really OAS and not iAS?  If it is, you need to upgrade your software.
> > There is  a published exploit against  the version of Apache used by
> > Oracle's latest iAS release.  Oracle has released a patch which stops
> the
> > exploit
> > 
> > I have built Oracle web servers for years, but I am now of the mind that
> > these things should not be built by DBA's but by webmasters. 
> > 
> > I am undecided whether to one should go with iAS or construct your own
> > with
> > Apache.  The mod_plsql module for instance was not created by Oracle.
> It
> > and things  such as forms server and reports server will run against
> such
> > a
> > construction. 
> > 
> > However, we were advised last week that the  Windows NT machines will be
> > converted to XP  this year.  As a result, I  started to look at  the 9i
> > Internet Developer Suite.  About every third line is a statement to the
> > effect that the 9i database, 9 iAS, and 9 iDS are made to work together.
> > I
> > haven't figured out what one is giving up if one builds their own web
> > server
> > and also installs components for the 9 iAS distribution.  Is it just
> > convenience?
> > 
> > One reason for giving up the convenience is security.  An exploit is
> > discovered and possibly published.  Apache fixes the problem.  If I have
> > built my own I can get the patch from Apache and  rebuild the web
> server.
> > If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
> > into its offering.  This could be a matter days to over a week.  However
> > weighing-in on the 9 iAS side is the ease of installing a fix.  The
> Apache
> > fix  for the aforementioned problem required  a rebuild; you need
> someone
> > wise in the ways of make files and such.   The 9 iAS fix was a simple
> file
> > replacement.
> > 
> > Ian MacGregor
> > Stanford Linear Accelerator Center
> > [EMAIL PROTECTED] 
> > 
> > -Original Message-
> > Sent: Wednesday, July 17, 2002 9:1

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Hately Mike]

Sorry Gene,
the latest version is 9.0.2. 1.0.2.2.2 was the previous release.
Version 9.0.2 is quite different (in respects of install method and hardware
requirements at least) so if you're familiar with 9iAS already you might
want to evaluate R2 for a while. Or sit tight and let the early adopters
flush out the bugs.

Cheers,
Mike

PS Scott, I've had a few battles with 1.0.2.2 but I've found the install for
9.0.2 to be a total pain largely due to the installation instructions which
seem at best cryptic and at worst unfinished. Still, I've learned more than
I would if it had gone smoothly so I suppose I benefit in the long run. =)


-Original Message-
Sent: 18 July 2002 15:18
To: Multiple recipients of list ORACLE-L


Now I am confused.  Supposedly, I just received the latest 9iAS from Oracle
and its version is 1.0.2.2.2a.  Is this 9iAS release 2, 9iAS release 1.0.2,
etc?

Gene

>>> [EMAIL PROTECTED] 07/17/02 05:28PM >>>
Robert, 

After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type, and
it seems to be a lot smoother, albeit more bloated and slower - at least the
install portion.

Scott Shafer
San Antonio, TX
210-581-6217


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[MacGregor, Ian A.]

I believe, about 95% confident, that they are the same.  I think Oracle applications 
customers receive the  the 1.0.2X numbered versions. 

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Thursday, July 18, 2002 7:18 AM
To: Multiple recipients of list ORACLE-L


Now I am confused.  Supposedly, I just received the latest 9iAS from Oracle and its 
version is 1.0.2.2.2a.  Is this 9iAS release 2, 9iAS release 1.0.2, etc?

Gene

>>> [EMAIL PROTECTED] 07/17/02 05:28PM >>>
Robert, 

After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type, and
it seems to be a lot smoother, albeit more bloated and slower - at least the
install portion.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] 
> Sent: Wednesday, July 17, 2002 4:09 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> So, I'm guessing this is iAS. I have a hard enough time keeping
> up with Oracle marketing's changing the names/version of Oracle Net,
> parallel server, and MTS every opportunity they get!!
> 
> RF
> 
> 
> 
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> Oracle9i New Features (Oracle Press)
> Mastering Oracle8i  (Sybex)
> 
> Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> Cousin Eddie: Those were my mother's dying words. But I
> guess if your body's covered in third degree burns, and 
> your foot's caught in a bear trap, you tend to start talkin' 
> crazy.
> 
> 
> 
> -Original Message-
> Sent: Wednesday, July 17, 2002 1:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> It really OAS and not iAS?  If it is, you need to upgrade your software.
> There is  a published exploit against  the version of Apache used by
> Oracle's latest iAS release.  Oracle has released a patch which stops the
> exploit
> 
> I have built Oracle web servers for years, but I am now of the mind that
> these things should not be built by DBA's but by webmasters. 
> 
> I am undecided whether to one should go with iAS or construct your own
> with
> Apache.  The mod_plsql module for instance was not created by Oracle.  It
> and things  such as forms server and reports server will run against such
> a
> construction. 
> 
> However, we were advised last week that the  Windows NT machines will be
> converted to XP  this year.  As a result, I  started to look at  the 9i
> Internet Developer Suite.  About every third line is a statement to the
> effect that the 9i database, 9 iAS, and 9 iDS are made to work together.
> I
> haven't figured out what one is giving up if one builds their own web
> server
> and also installs components for the 9 iAS distribution.  Is it just
> convenience?
> 
> One reason for giving up the convenience is security.  An exploit is
> discovered and possibly published.  Apache fixes the problem.  If I have
> built my own I can get the patch from Apache and  rebuild the web server.
> If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
> into its offering.  This could be a matter days to over a week.  However
> weighing-in on the 9 iAS side is the ease of installing a fix.  The Apache
> fix  for the aforementioned problem required  a rebuild; you need someone
> wise in the ways of make files and such.   The 9 iAS fix was a simple file
> replacement.
> 
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, July 17, 2002 9:18 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Folks,
>  
> I'm a DBA who is really an old developer at heart. I know a little Java, a
> little Asp
> (enough, as they say, to be really dangerous!), I used to do C code that
> now
> makes 
> my head swim to look at. (I think to myself, what the devil was I doing??)
>  
> Anyway, I've finally found some time and a machine here at work to start
> playing with
> OAS just to see what it's all about. Anyone have any good suggestions with
> regards 
> to:
>  
> 1. Sites, books, white papers and the like with good install tips, hints,
> warnings and the like.
> 2. Sites, books, white papers and the like Quick getting started tips.
> 3. Your own "getting started" experiences of things to do

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Scott . Shafer]

Gene, I dunno anymore.  9.0.2 came out in May '02, according to the cd.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Gene Sais [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 9:18 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:      RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> Now I am confused.  Supposedly, I just received the latest 9iAS from
> Oracle and its version is 1.0.2.2.2a.  Is this 9iAS release 2, 9iAS
> release 1.0.2, etc?
> 
> Gene
> 
> >>> [EMAIL PROTECTED] 07/17/02 05:28PM >>>
> Robert, 
> 
> After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
> get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type,
> and
> it seems to be a lot smoother, albeit more bloated and slower - at least
> the
> install portion.
> 
> Scott Shafer
> San Antonio, TX
> 210-581-6217
> 
> 
> > -Original Message-
> > From:   Freeman, Robert [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Wednesday, July 17, 2002 4:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> > 
> > This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> > So, I'm guessing this is iAS. I have a hard enough time keeping
> > up with Oracle marketing's changing the names/version of Oracle Net,
> > parallel server, and MTS every opportunity they get!!
> > 
> > RF
> > 
> > 
> > 
> > Robert G. Freeman - Oracle OCP
> > Oracle Database Architect
> > CSX Midtier Database Administration
> > Author
> > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > Oracle9i New Features (Oracle Press)
> > Mastering Oracle8i  (Sybex)
> > 
> > Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> > Cousin Eddie: Those were my mother's dying words. But I
> > guess if your body's covered in third degree burns, and 
> > your foot's caught in a bear trap, you tend to start talkin' 
> > crazy.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Wednesday, July 17, 2002 1:24 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > It really OAS and not iAS?  If it is, you need to upgrade your software.
> > There is  a published exploit against  the version of Apache used by
> > Oracle's latest iAS release.  Oracle has released a patch which stops
> the
> > exploit
> > 
> > I have built Oracle web servers for years, but I am now of the mind that
> > these things should not be built by DBA's but by webmasters. 
> > 
> > I am undecided whether to one should go with iAS or construct your own
> > with
> > Apache.  The mod_plsql module for instance was not created by Oracle.
> It
> > and things  such as forms server and reports server will run against
> such
> > a
> > construction. 
> > 
> > However, we were advised last week that the  Windows NT machines will be
> > converted to XP  this year.  As a result, I  started to look at  the 9i
> > Internet Developer Suite.  About every third line is a statement to the
> > effect that the 9i database, 9 iAS, and 9 iDS are made to work together.
> > I
> > haven't figured out what one is giving up if one builds their own web
> > server
> > and also installs components for the 9 iAS distribution.  Is it just
> > convenience?
> > 
> > One reason for giving up the convenience is security.  An exploit is
> > discovered and possibly published.  Apache fixes the problem.  If I have
> > built my own I can get the patch from Apache and  rebuild the web
> server.
> > If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
> > into its offering.  This could be a matter days to over a week.  However
> > weighing-in on the 9 iAS side is the ease of installing a fix.  The
> Apache
> > fix  for the aforementioned problem required  a rebuild; you need
> someone
> > wise in the ways of make files and such.   The 9 iAS fix was a simple
> file
> > replacement.
> > 
> > Ian MacGregor
> > Stanford Linear Accelerator Center
> > [EMAIL PROTECTED] 
> > 
> > -Original Message-
> > Sent: Wednesday, July 17, 2002 9:18 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Folks,
> >  
> > I'm a DBA who is really an old developer at heart. I know a little Java,
> a
> > little Asp
> > (enough, as they say, to 

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Gene Sais]

Now I am confused.  Supposedly, I just received the latest 9iAS from Oracle and its 
version is 1.0.2.2.2a.  Is this 9iAS release 2, 9iAS release 1.0.2, etc?

Gene

>>> [EMAIL PROTECTED] 07/17/02 05:28PM >>>
Robert, 

After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type, and
it seems to be a lot smoother, albeit more bloated and slower - at least the
install portion.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] 
> Sent: Wednesday, July 17, 2002 4:09 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> So, I'm guessing this is iAS. I have a hard enough time keeping
> up with Oracle marketing's changing the names/version of Oracle Net,
> parallel server, and MTS every opportunity they get!!
> 
> RF
> 
> 
> 
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> Oracle9i New Features (Oracle Press)
> Mastering Oracle8i  (Sybex)
> 
> Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> Cousin Eddie: Those were my mother's dying words. But I
> guess if your body's covered in third degree burns, and 
> your foot's caught in a bear trap, you tend to start talkin' 
> crazy.
> 
> 
> 
> -Original Message-
> Sent: Wednesday, July 17, 2002 1:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> It really OAS and not iAS?  If it is, you need to upgrade your software.
> There is  a published exploit against  the version of Apache used by
> Oracle's latest iAS release.  Oracle has released a patch which stops the
> exploit
> 
> I have built Oracle web servers for years, but I am now of the mind that
> these things should not be built by DBA's but by webmasters. 
> 
> I am undecided whether to one should go with iAS or construct your own
> with
> Apache.  The mod_plsql module for instance was not created by Oracle.  It
> and things  such as forms server and reports server will run against such
> a
> construction. 
> 
> However, we were advised last week that the  Windows NT machines will be
> converted to XP  this year.  As a result, I  started to look at  the 9i
> Internet Developer Suite.  About every third line is a statement to the
> effect that the 9i database, 9 iAS, and 9 iDS are made to work together.
> I
> haven't figured out what one is giving up if one builds their own web
> server
> and also installs components for the 9 iAS distribution.  Is it just
> convenience?
> 
> One reason for giving up the convenience is security.  An exploit is
> discovered and possibly published.  Apache fixes the problem.  If I have
> built my own I can get the patch from Apache and  rebuild the web server.
> If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
> into its offering.  This could be a matter days to over a week.  However
> weighing-in on the 9 iAS side is the ease of installing a fix.  The Apache
> fix  for the aforementioned problem required  a rebuild; you need someone
> wise in the ways of make files and such.   The 9 iAS fix was a simple file
> replacement.
> 
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, July 17, 2002 9:18 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Folks,
>  
> I'm a DBA who is really an old developer at heart. I know a little Java, a
> little Asp
> (enough, as they say, to be really dangerous!), I used to do C code that
> now
> makes 
> my head swim to look at. (I think to myself, what the devil was I doing??)
>  
> Anyway, I've finally found some time and a machine here at work to start
> playing with
> OAS just to see what it's all about. Anyone have any good suggestions with
> regards 
> to:
>  
> 1. Sites, books, white papers and the like with good install tips, hints,
> warnings and the like.
> 2. Sites, books, white papers and the like Quick getting started tips.
> 3. Your own "getting started" experiences of things to do or not to do.
> 5. Anything I should do before I mess with OAS.
>  
> Optimistically hopeful that this will all just go really smooth and I'll
> have a cool
> web page that I can bring up soon!
>  
> RF
> 
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> C

Re: A DBA looks at OAS

[DBarbour]

Robert,

Just use the iAS (Apache) webserver that comes with 8i and up.  Really
configurable, as simple or complex as you want it to be.  With the various
mod_ plugins, you can be serving up stuff in no time.

David A. Barbour
AISD



   

"Freeman,  

Robert"  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
   Subject: A DBA looks at OAS   

Sent by:   

[EMAIL PROTECTED] 

om 

   

   

07/17/2002 

11:18 AM   

Please respond 

to ORACLE-L

   

   





Folks,

I'm a DBA who is really an old developer at heart. I know a little Java, a
little Asp
(enough, as they say, to be really dangerous!), I used to do C code that
now
makes
my head swim to look at. (I think to myself, what the devil was I doing??)

Anyway, I've finally found some time and a machine here at work to start
playing with
OAS just to see what it's all about. Anyone have any good suggestions with
regards
to:

1. Sites, books, white papers and the like with good install tips, hints,
warnings and the like.
2. Sites, books, white papers and the like Quick getting started tips.
3. Your own "getting started" experiences of things to do or not to do.
5. Anything I should do before I mess with OAS.

Optimistically hopeful that this will all just go really smooth and I'll
have a cool
web page that I can bring up soon!

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A DBA looks at OAS

[Scott . Shafer]

Thanks, mkb.  I'm installing 9.0.2 now on HPUX.  Good info.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: mkb [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, July 17, 2002 12:49 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:      Re: A DBA looks at OAS
> 
> No books or tips.  Just my recent experience *trying*
> to install 9iAS R2 (I hope that's what you meant when
> you wrote OAS).
> 
> I downloaded 9iAS J2EE and Web Cache for Solaris and
> HP-UX.
> 
> Oracle recommends about 1GB ram, 1GB swap and lots of
> free disk space.  Anyway, my target Solaris box had
> 500MB swap, 256MB ram and a 400 MhZ SparcII CPU.  Not
> the ideal platform.  On the HP-UX box, I had 3GB ram,
> a 2 CPU L class machine, lots of swap and lots of
> disk.
> 
> In any case, what I learned is that root privs are
> vital.  Had them on the Solaris box but not on the
> HP-UX machine.  The installs in both cases where
> fairly standard.  I had ran through them quite a few
> times on both servers.  On Solaris becuase of resource
> issues and HP-UX because of root permission issues.
> 
> There are two types of installs.  A mid-tier (less
> config, easier, fewer components) and an
> infrastructure (more config, more components, needs a
> database repoistory).  I did the mid-tier install in
> both cases.
> 
> Make sure you have JDK 1.3 or later installed.
> 
> Before the install for mid-tier in particular, export
> ORACLE_SID=iasdb even if you do not intend to use a
> repository or have a database.
> 
> I created a separate ORACLE_HOME for my install.
> 
> Also, Oracle recommends that you use hostnames, so
> naming methods should reflect hostname.com instead of
> 123.45.67.8.  
> 
> During the install, you will be asked for a password
> for the Eterprise Manager website.  NOTE IT DOWN!!! 
> You'll need it to start and stop the EM website. 
> Oracle recommends that you start and stop services via
> the EM website and not the command line and I'll go
> along with this since I had trouble shutting down
> services via the command line (sometime it worked and
> sometime it did'nt).
> 
> Also, during the install when prompted to run the
> root.sh script, run as root since this script starts
> the Apache httpd daemons.  These need to be started as
> root.  It does a bunch of other config things aswell. 
> See root.sh.  This is vital since after the install is
> complete, the installer then configures the components
> such web cache, OC4J components, Apache config etc. 
> This is the problem I was having on HP-UX, late in the
> day, govt client, sysadmin has left the building.
> 
> Ok, after the install has completed and started all
> the services (hoepfully), you need to apply all
> relevant patches.  For the mid tier install, install
> the patch in the following order:
> 
> 9.0.1.3 patch set
> RDBMS bundled patch
> Oracle Internet Directory path
> Oracle HTTP server patch
> 
> You'll see this in the install notes for the patch. 
> Note that the RDBMS bundled patch is slightly
> different on HP-UX versus Solaris.  Just read the
> instructions carefully if you are on HP-UX.  Solaris
> was a little easier.
> 
> After the patch, you can login to the EM website at
> http://myhostname.com:1810.  If the website does not
> come up, you can start it from the prompt using emctl
> start|stop|status.  Stopping requires password which
> was entered earlier during install.  Password can also
> be changed using emctl set password .
> 
> Using the website, you can/start stop other services
> such as web cache, BC4J, OC4J containers etc.
> 
> The default website can be accessed (hopefully) at
> http://myhostname.com:
> 
> Also, you can start|stop the httpd daemons from the
> command line from $ORACLE_HOME/dcm/bin/dcmctl
> start|stop -ct ohs if the EM website is inaccessible
> for some reason.  Again, Oracle recommends that you do
> all admin through EM the website.
> 
> Similarly, web cache can be started/stopped from the
> prompt by webcachectl start|stop|status.
> 
> Finally, just a couple days ago, we seemed to have
> trouble starting 9iAS.  Seems like some log files had
> their ownership changed.  Don't know how this
> happened.  My guess is some sort of bug.  The way I
> tracked this is tailing the logs while trying to start
> the server.  Since I could'nt get the EM website up, I
> had to use $ORACLE_HOME/dcm/bin/dcmctl start -ct ohs.
> 
> Useful logs were:
> $ORACLE_HOME/opmn/logs/ons.log and ipm.log
> $ORACLE_HOME/dcm/logs/emd_logs/ and dcmctl_logs/
> and of cource
> $ORACLE_HOME/Apache/Apache/logs/error_log and
> access_log

RE: A DBA looks at OAS

[mkb]

Just checked my current config again on Solaris.  ps
-ef shows me two httpd processes owned by root and 10
that I assume are spawned via these as oracle.

Also see 2 dwhttpd running under daemon.

I assume it is under port 80 since I have not changed
the httpd.conf file.

Yes, I guess you are right, these should run under
nobody, but these are my first steps into setting this
up and so I installed it as-is.  No tweaks.

mkb

--- "MacGregor, Ian A." <[EMAIL PROTECTED]> wrote:
> The httpd daemons need to be started as root?  Since
> when?  Is it because you're using the standard HTTP
> PORT OF 80?  Starting these daemons under the nobody
> account is much safer.
> 
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Wednesday, July 17, 2002 10:49 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> No books or tips.  Just my recent experience
> *trying*
> to install 9iAS R2 (I hope that's what you meant
> when
> you wrote OAS).
> 
> I downloaded 9iAS J2EE and Web Cache for Solaris and
> HP-UX.
> 
> Oracle recommends about 1GB ram, 1GB swap and lots
> of
> free disk space.  Anyway, my target Solaris box had
> 500MB swap, 256MB ram and a 400 MhZ SparcII CPU. 
> Not
> the ideal platform.  On the HP-UX box, I had 3GB
> ram,
> a 2 CPU L class machine, lots of swap and lots of
> disk.
> 
> In any case, what I learned is that root privs are
> vital.  Had them on the Solaris box but not on the
> HP-UX machine.  The installs in both cases where
> fairly standard.  I had ran through them quite a few
> times on both servers.  On Solaris becuase of
> resource
> issues and HP-UX because of root permission issues.
> 
> There are two types of installs.  A mid-tier (less
> config, easier, fewer components) and an
> infrastructure (more config, more components, needs
> a
> database repoistory).  I did the mid-tier install in
> both cases.
> 
> Make sure you have JDK 1.3 or later installed.
> 
> Before the install for mid-tier in particular,
> export
> ORACLE_SID=iasdb even if you do not intend to use a
> repository or have a database.
> 
> I created a separate ORACLE_HOME for my install.
> 
> Also, Oracle recommends that you use hostnames, so
> naming methods should reflect hostname.com instead
> of
> 123.45.67.8.  
> 
> During the install, you will be asked for a password
> for the Eterprise Manager website.  NOTE IT DOWN!!! 
> You'll need it to start and stop the EM website. 
> Oracle recommends that you start and stop services
> via
> the EM website and not the command line and I'll go
> along with this since I had trouble shutting down
> services via the command line (sometime it worked
> and
> sometime it did'nt).
> 
> Also, during the install when prompted to run the
> root.sh script, run as root since this script starts
> the Apache httpd daemons.  These need to be started
> as
> root.  It does a bunch of other config things
> aswell. 
> See root.sh.  This is vital since after the install
> is
> complete, the installer then configures the
> components
> such web cache, OC4J components, Apache config etc. 
> This is the problem I was having on HP-UX, late in
> the
> day, govt client, sysadmin has left the building.
> 
> Ok, after the install has completed and started all
> the services (hoepfully), you need to apply all
> relevant patches.  For the mid tier install, install
> the patch in the following order:
> 
> 9.0.1.3 patch set
> RDBMS bundled patch
> Oracle Internet Directory path
> Oracle HTTP server patch
> 
> You'll see this in the install notes for the patch. 
> Note that the RDBMS bundled patch is slightly
> different on HP-UX versus Solaris.  Just read the
> instructions carefully if you are on HP-UX.  Solaris
> was a little easier.
> 
> After the patch, you can login to the EM website at
> http://myhostname.com:1810.  If the website does not
> come up, you can start it from the prompt using
> emctl
> start|stop|status.  Stopping requires password which
> was entered earlier during install.  Password can
> also
> be changed using emctl set password .
> 
> Using the website, you can/start stop other services
> such as web cache, BC4J, OC4J containers etc.
> 
> The default website can be accessed (hopefully) at
> http://myhostname.com:
> 
> Also, you can start|stop the httpd daemons from the
> command line from $ORACLE_HOME/dcm/bin/dcmctl
> start|stop -ct ohs if the EM website is inaccessible
> for some reason.  Again, Oracle recommends that you
> do
> all admin through EM the website.
> 
> Similarly, web cache can be started/stopped from the
> prompt by webcachectl start|stop|status.
> 
> Finally, just a couple days ago, we seemed to have
> trouble starting 9iAS.  Seems like some log files
> had
> their ownership changed.  Don't know how this
> happened.  My guess is some sort of bug.  The way I
> tracked this is tailing the logs while trying to
> start
> the server.  Since I could'nt get the EM website up,
> I
> had to use $ORACLE_HOME/dcm/bi

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Scott . Shafer]

Robert, 

After having just fought a battle with iAS 1.0.2.2 do yourself a favor and
get hold of iAS 9.0.2 (latest release).  I'm installing 9.0.2 as I type, and
it seems to be a lot smoother, albeit more bloated and slower - at least the
install portion.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Freeman, Robert [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, July 17, 2002 4:09 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:      RE: A DBA looks at OAS  |  IAS  vs.  Locally-built Apache
> 
> This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
> So, I'm guessing this is iAS. I have a hard enough time keeping
> up with Oracle marketing's changing the names/version of Oracle Net,
> parallel server, and MTS every opportunity they get!!
> 
> RF
> 
> 
> 
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> Oracle9i New Features (Oracle Press)
> Mastering Oracle8i  (Sybex)
> 
> Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> Cousin Eddie: Those were my mother's dying words. But I
> guess if your body's covered in third degree burns, and 
> your foot's caught in a bear trap, you tend to start talkin' 
> crazy.
> 
> 
> 
> -Original Message-
> Sent: Wednesday, July 17, 2002 1:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> It really OAS and not iAS?  If it is, you need to upgrade your software.
> There is  a published exploit against  the version of Apache used by
> Oracle's latest iAS release.  Oracle has released a patch which stops the
> exploit
> 
> I have built Oracle web servers for years, but I am now of the mind that
> these things should not be built by DBA's but by webmasters. 
> 
> I am undecided whether to one should go with iAS or construct your own
> with
> Apache.  The mod_plsql module for instance was not created by Oracle.  It
> and things  such as forms server and reports server will run against such
> a
> construction. 
> 
> However, we were advised last week that the  Windows NT machines will be
> converted to XP  this year.  As a result, I  started to look at  the 9i
> Internet Developer Suite.  About every third line is a statement to the
> effect that the 9i database, 9 iAS, and 9 iDS are made to work together.
> I
> haven't figured out what one is giving up if one builds their own web
> server
> and also installs components for the 9 iAS distribution.  Is it just
> convenience?
> 
> One reason for giving up the convenience is security.  An exploit is
> discovered and possibly published.  Apache fixes the problem.  If I have
> built my own I can get the patch from Apache and  rebuild the web server.
> If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
> into its offering.  This could be a matter days to over a week.  However
> weighing-in on the 9 iAS side is the ease of installing a fix.  The Apache
> fix  for the aforementioned problem required  a rebuild; you need someone
> wise in the ways of make files and such.   The 9 iAS fix was a simple file
> replacement.
> 
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Wednesday, July 17, 2002 9:18 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Folks,
>  
> I'm a DBA who is really an old developer at heart. I know a little Java, a
> little Asp
> (enough, as they say, to be really dangerous!), I used to do C code that
> now
> makes 
> my head swim to look at. (I think to myself, what the devil was I doing??)
>  
> Anyway, I've finally found some time and a machine here at work to start
> playing with
> OAS just to see what it's all about. Anyone have any good suggestions with
> regards 
> to:
>  
> 1. Sites, books, white papers and the like with good install tips, hints,
> warnings and the like.
> 2. Sites, books, white papers and the like Quick getting started tips.
> 3. Your own "getting started" experiences of things to do or not to do.
> 5. Anything I should do before I mess with OAS.
>  
> Optimistically hopeful that this will all just go really smooth and I'll
> have a cool
> web page that I can bring up soon!
>  
> RF
> 
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> Oracle9i New Features (Oracle Press)
> Mastering Oracle8i  (Sybex)
> 
> Clark Griswold: Eddie, has anyone ever told 

RE: A DBA looks at OAS

[Freeman, Robert]

Lot's to consider unfortunately I'm running it on NT ... :-))

Might ought have mentioned that. :-))

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.



-Original Message-
Sent: Wednesday, July 17, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L


No books or tips.  Just my recent experience *trying*
to install 9iAS R2 (I hope that's what you meant when
you wrote OAS).

I downloaded 9iAS J2EE and Web Cache for Solaris and
HP-UX.

Oracle recommends about 1GB ram, 1GB swap and lots of
free disk space.  Anyway, my target Solaris box had
500MB swap, 256MB ram and a 400 MhZ SparcII CPU.  Not
the ideal platform.  On the HP-UX box, I had 3GB ram,
a 2 CPU L class machine, lots of swap and lots of
disk.

In any case, what I learned is that root privs are
vital.  Had them on the Solaris box but not on the
HP-UX machine.  The installs in both cases where
fairly standard.  I had ran through them quite a few
times on both servers.  On Solaris becuase of resource
issues and HP-UX because of root permission issues.

There are two types of installs.  A mid-tier (less
config, easier, fewer components) and an
infrastructure (more config, more components, needs a
database repoistory).  I did the mid-tier install in
both cases.

Make sure you have JDK 1.3 or later installed.

Before the install for mid-tier in particular, export
ORACLE_SID=iasdb even if you do not intend to use a
repository or have a database.

I created a separate ORACLE_HOME for my install.

Also, Oracle recommends that you use hostnames, so
naming methods should reflect hostname.com instead of
123.45.67.8.  

During the install, you will be asked for a password
for the Eterprise Manager website.  NOTE IT DOWN!!! 
You'll need it to start and stop the EM website. 
Oracle recommends that you start and stop services via
the EM website and not the command line and I'll go
along with this since I had trouble shutting down
services via the command line (sometime it worked and
sometime it did'nt).

Also, during the install when prompted to run the
root.sh script, run as root since this script starts
the Apache httpd daemons.  These need to be started as
root.  It does a bunch of other config things aswell. 
See root.sh.  This is vital since after the install is
complete, the installer then configures the components
such web cache, OC4J components, Apache config etc. 
This is the problem I was having on HP-UX, late in the
day, govt client, sysadmin has left the building.

Ok, after the install has completed and started all
the services (hoepfully), you need to apply all
relevant patches.  For the mid tier install, install
the patch in the following order:

9.0.1.3 patch set
RDBMS bundled patch
Oracle Internet Directory path
Oracle HTTP server patch

You'll see this in the install notes for the patch. 
Note that the RDBMS bundled patch is slightly
different on HP-UX versus Solaris.  Just read the
instructions carefully if you are on HP-UX.  Solaris
was a little easier.

After the patch, you can login to the EM website at
http://myhostname.com:1810.  If the website does not
come up, you can start it from the prompt using emctl
start|stop|status.  Stopping requires password which
was entered earlier during install.  Password can also
be changed using emctl set password .

Using the website, you can/start stop other services
such as web cache, BC4J, OC4J containers etc.

The default website can be accessed (hopefully) at
http://myhostname.com:

Also, you can start|stop the httpd daemons from the
command line from $ORACLE_HOME/dcm/bin/dcmctl
start|stop -ct ohs if the EM website is inaccessible
for some reason.  Again, Oracle recommends that you do
all admin through EM the website.

Similarly, web cache can be started/stopped from the
prompt by webcachectl start|stop|status.

Finally, just a couple days ago, we seemed to have
trouble starting 9iAS.  Seems like some log files had
their ownership changed.  Don't know how this
happened.  My guess is some sort of bug.  The way I
tracked this is tailing the logs while trying to start
the server.  Since I could'nt get the EM website up, I
had to use $ORACLE_HOME/dcm/bin/dcmctl start -ct ohs.

Useful logs were:
$ORACLE_HOME/opmn/logs/ons.log and ipm.log
$ORACLE_HOME/dcm/logs/emd_logs/ and dcmctl_logs/
and of cource
$ORACLE_HOME/Apache/Apache/logs/error_log and
access_log

hth

mkb

--- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> Folks,
>  
> I'm a DBA who is really an old developer at heart. I
> know a little Java, a
> little Asp
> (enough, as they say, to be really dangerous!

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[Freeman, Robert]

This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
So, I'm guessing this is iAS. I have a hard enough time keeping
up with Oracle marketing's changing the names/version of Oracle Net,
parallel server, and MTS every opportunity they get!!

RF



Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.



-Original Message-
Sent: Wednesday, July 17, 2002 1:24 PM
To: Multiple recipients of list ORACLE-L


It really OAS and not iAS?  If it is, you need to upgrade your software.
There is  a published exploit against  the version of Apache used by
Oracle's latest iAS release.  Oracle has released a patch which stops the
exploit

I have built Oracle web servers for years, but I am now of the mind that
these things should not be built by DBA's but by webmasters. 

I am undecided whether to one should go with iAS or construct your own with
Apache.  The mod_plsql module for instance was not created by Oracle.  It
and things  such as forms server and reports server will run against such a
construction. 

However, we were advised last week that the  Windows NT machines will be
converted to XP  this year.  As a result, I  started to look at  the 9i
Internet Developer Suite.  About every third line is a statement to the
effect that the 9i database, 9 iAS, and 9 iDS are made to work together.  I
haven't figured out what one is giving up if one builds their own web server
and also installs components for the 9 iAS distribution.  Is it just
convenience?

One reason for giving up the convenience is security.  An exploit is
discovered and possibly published.  Apache fixes the problem.  If I have
built my own I can get the patch from Apache and  rebuild the web server.
If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
into its offering.  This could be a matter days to over a week.  However
weighing-in on the 9 iAS side is the ease of installing a fix.  The Apache
fix  for the aforementioned problem required  a rebuild; you need someone
wise in the ways of make files and such.   The 9 iAS fix was a simple file
replacement.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, July 17, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L


Folks,
 
I'm a DBA who is really an old developer at heart. I know a little Java, a
little Asp
(enough, as they say, to be really dangerous!), I used to do C code that now
makes 
my head swim to look at. (I think to myself, what the devil was I doing??)
 
Anyway, I've finally found some time and a machine here at work to start
playing with
OAS just to see what it's all about. Anyone have any good suggestions with
regards 
to:
 
1. Sites, books, white papers and the like with good install tips, hints,
warnings and the like.
2. Sites, books, white papers and the like Quick getting started tips.
3. Your own "getting started" experiences of things to do or not to do.
5. Anything I should do before I mess with OAS.
 
Optimistically hopeful that this will all just go really smooth and I'll
have a cool
web page that I can bring up soon!
 
RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To R

RE: A DBA looks at OAS

[MacGregor, Ian A.]

The httpd daemons need to be started as root?  Since when?  Is it because you're using 
the standard HTTP PORT OF 80?  Starting these daemons under the nobody account is much 
safer.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, July 17, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L


No books or tips.  Just my recent experience *trying*
to install 9iAS R2 (I hope that's what you meant when
you wrote OAS).

I downloaded 9iAS J2EE and Web Cache for Solaris and
HP-UX.

Oracle recommends about 1GB ram, 1GB swap and lots of
free disk space.  Anyway, my target Solaris box had
500MB swap, 256MB ram and a 400 MhZ SparcII CPU.  Not
the ideal platform.  On the HP-UX box, I had 3GB ram,
a 2 CPU L class machine, lots of swap and lots of
disk.

In any case, what I learned is that root privs are
vital.  Had them on the Solaris box but not on the
HP-UX machine.  The installs in both cases where
fairly standard.  I had ran through them quite a few
times on both servers.  On Solaris becuase of resource
issues and HP-UX because of root permission issues.

There are two types of installs.  A mid-tier (less
config, easier, fewer components) and an
infrastructure (more config, more components, needs a
database repoistory).  I did the mid-tier install in
both cases.

Make sure you have JDK 1.3 or later installed.

Before the install for mid-tier in particular, export
ORACLE_SID=iasdb even if you do not intend to use a
repository or have a database.

I created a separate ORACLE_HOME for my install.

Also, Oracle recommends that you use hostnames, so
naming methods should reflect hostname.com instead of
123.45.67.8.  

During the install, you will be asked for a password
for the Eterprise Manager website.  NOTE IT DOWN!!! 
You'll need it to start and stop the EM website. 
Oracle recommends that you start and stop services via
the EM website and not the command line and I'll go
along with this since I had trouble shutting down
services via the command line (sometime it worked and
sometime it did'nt).

Also, during the install when prompted to run the
root.sh script, run as root since this script starts
the Apache httpd daemons.  These need to be started as
root.  It does a bunch of other config things aswell. 
See root.sh.  This is vital since after the install is
complete, the installer then configures the components
such web cache, OC4J components, Apache config etc. 
This is the problem I was having on HP-UX, late in the
day, govt client, sysadmin has left the building.

Ok, after the install has completed and started all
the services (hoepfully), you need to apply all
relevant patches.  For the mid tier install, install
the patch in the following order:

9.0.1.3 patch set
RDBMS bundled patch
Oracle Internet Directory path
Oracle HTTP server patch

You'll see this in the install notes for the patch. 
Note that the RDBMS bundled patch is slightly
different on HP-UX versus Solaris.  Just read the
instructions carefully if you are on HP-UX.  Solaris
was a little easier.

After the patch, you can login to the EM website at
http://myhostname.com:1810.  If the website does not
come up, you can start it from the prompt using emctl
start|stop|status.  Stopping requires password which
was entered earlier during install.  Password can also
be changed using emctl set password .

Using the website, you can/start stop other services
such as web cache, BC4J, OC4J containers etc.

The default website can be accessed (hopefully) at
http://myhostname.com:

Also, you can start|stop the httpd daemons from the
command line from $ORACLE_HOME/dcm/bin/dcmctl
start|stop -ct ohs if the EM website is inaccessible
for some reason.  Again, Oracle recommends that you do
all admin through EM the website.

Similarly, web cache can be started/stopped from the
prompt by webcachectl start|stop|status.

Finally, just a couple days ago, we seemed to have
trouble starting 9iAS.  Seems like some log files had
their ownership changed.  Don't know how this
happened.  My guess is some sort of bug.  The way I
tracked this is tailing the logs while trying to start
the server.  Since I could'nt get the EM website up, I
had to use $ORACLE_HOME/dcm/bin/dcmctl start -ct ohs.

Useful logs were:
$ORACLE_HOME/opmn/logs/ons.log and ipm.log
$ORACLE_HOME/dcm/logs/emd_logs/ and dcmctl_logs/
and of cource
$ORACLE_HOME/Apache/Apache/logs/error_log and
access_log

hth

mkb

--- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> Folks,
>  
> I'm a DBA who is really an old developer at heart. I
> know a little Java, a
> little Asp
> (enough, as they say, to be really dangerous!), I
> used to do C code that now
> makes 
> my head swim to look at. (I think to myself, what
> the devil was I doing??)
>  
> Anyway, I've finally found some time and a machine
> here at work to start
> playing with
> OAS just to see what it's all about. Anyone have any
> good suggestions with
> regards 
> to:
>  
> 1. Sites, books, w

Re: A DBA looks at OAS

[mkb]

No books or tips.  Just my recent experience *trying*
to install 9iAS R2 (I hope that's what you meant when
you wrote OAS).

I downloaded 9iAS J2EE and Web Cache for Solaris and
HP-UX.

Oracle recommends about 1GB ram, 1GB swap and lots of
free disk space.  Anyway, my target Solaris box had
500MB swap, 256MB ram and a 400 MhZ SparcII CPU.  Not
the ideal platform.  On the HP-UX box, I had 3GB ram,
a 2 CPU L class machine, lots of swap and lots of
disk.

In any case, what I learned is that root privs are
vital.  Had them on the Solaris box but not on the
HP-UX machine.  The installs in both cases where
fairly standard.  I had ran through them quite a few
times on both servers.  On Solaris becuase of resource
issues and HP-UX because of root permission issues.

There are two types of installs.  A mid-tier (less
config, easier, fewer components) and an
infrastructure (more config, more components, needs a
database repoistory).  I did the mid-tier install in
both cases.

Make sure you have JDK 1.3 or later installed.

Before the install for mid-tier in particular, export
ORACLE_SID=iasdb even if you do not intend to use a
repository or have a database.

I created a separate ORACLE_HOME for my install.

Also, Oracle recommends that you use hostnames, so
naming methods should reflect hostname.com instead of
123.45.67.8.  

During the install, you will be asked for a password
for the Eterprise Manager website.  NOTE IT DOWN!!! 
You'll need it to start and stop the EM website. 
Oracle recommends that you start and stop services via
the EM website and not the command line and I'll go
along with this since I had trouble shutting down
services via the command line (sometime it worked and
sometime it did'nt).

Also, during the install when prompted to run the
root.sh script, run as root since this script starts
the Apache httpd daemons.  These need to be started as
root.  It does a bunch of other config things aswell. 
See root.sh.  This is vital since after the install is
complete, the installer then configures the components
such web cache, OC4J components, Apache config etc. 
This is the problem I was having on HP-UX, late in the
day, govt client, sysadmin has left the building.

Ok, after the install has completed and started all
the services (hoepfully), you need to apply all
relevant patches.  For the mid tier install, install
the patch in the following order:

9.0.1.3 patch set
RDBMS bundled patch
Oracle Internet Directory path
Oracle HTTP server patch

You'll see this in the install notes for the patch. 
Note that the RDBMS bundled patch is slightly
different on HP-UX versus Solaris.  Just read the
instructions carefully if you are on HP-UX.  Solaris
was a little easier.

After the patch, you can login to the EM website at
http://myhostname.com:1810.  If the website does not
come up, you can start it from the prompt using emctl
start|stop|status.  Stopping requires password which
was entered earlier during install.  Password can also
be changed using emctl set password .

Using the website, you can/start stop other services
such as web cache, BC4J, OC4J containers etc.

The default website can be accessed (hopefully) at
http://myhostname.com:

Also, you can start|stop the httpd daemons from the
command line from $ORACLE_HOME/dcm/bin/dcmctl
start|stop -ct ohs if the EM website is inaccessible
for some reason.  Again, Oracle recommends that you do
all admin through EM the website.

Similarly, web cache can be started/stopped from the
prompt by webcachectl start|stop|status.

Finally, just a couple days ago, we seemed to have
trouble starting 9iAS.  Seems like some log files had
their ownership changed.  Don't know how this
happened.  My guess is some sort of bug.  The way I
tracked this is tailing the logs while trying to start
the server.  Since I could'nt get the EM website up, I
had to use $ORACLE_HOME/dcm/bin/dcmctl start -ct ohs.

Useful logs were:
$ORACLE_HOME/opmn/logs/ons.log and ipm.log
$ORACLE_HOME/dcm/logs/emd_logs/ and dcmctl_logs/
and of cource
$ORACLE_HOME/Apache/Apache/logs/error_log and
access_log

hth

mkb

--- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> Folks,
>  
> I'm a DBA who is really an old developer at heart. I
> know a little Java, a
> little Asp
> (enough, as they say, to be really dangerous!), I
> used to do C code that now
> makes 
> my head swim to look at. (I think to myself, what
> the devil was I doing??)
>  
> Anyway, I've finally found some time and a machine
> here at work to start
> playing with
> OAS just to see what it's all about. Anyone have any
> good suggestions with
> regards 
> to:
>  
> 1. Sites, books, white papers and the like with good
> install tips, hints,
> warnings and the like.
> 2. Sites, books, white papers and the like Quick
> getting started tips.
> 3. Your own "getting started" experiences of things
> to do or not to do.
> 5. Anything I should do before I mess with OAS.
>  
> Optimistically hopeful that this will all just go
> really smooth and I'

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

[MacGregor, Ian A.]

It really OAS and not iAS?  If it is, you need to upgrade your software.  There is  a 
published exploit against  the version of Apache used by Oracle's latest iAS release.  
Oracle has released a patch which stops the exploit

I have built Oracle web servers for years, but I am now of the mind that these things 
should not be built by DBA's but by webmasters. 

I am undecided whether to one should go with iAS or construct your own with  Apache.  
The mod_plsql module for instance was not created by Oracle.  It and things  such as 
forms server and reports server will run against such a construction. 

However, we were advised last week that the  Windows NT machines will be converted to 
XP  this year.  As a result, I  started to look at  the 9i Internet Developer Suite.  
About every third line is a statement to the effect that the 9i database, 9 iAS, and 9 
iDS are made to work together.  I haven't figured out what one is giving up if one 
builds their own web server and also installs components for the 9 iAS distribution.  
Is it just convenience?

One reason for giving up the convenience is security.  An exploit is discovered and 
possibly published.  Apache fixes the problem.  If I have built my own I can get the 
patch from Apache and  rebuild the web server.  If I'm wedded to iAS I need to wait 
for Oracle to  incorporate the patch into its offering.  This could be a matter days 
to over a week.  However weighing-in on the 9 iAS side is the ease of installing a 
fix.  The Apache fix  for the aforementioned problem required  a rebuild; you need 
someone wise in the ways of make files and such.   The 9 iAS fix was a simple file 
replacement.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, July 17, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L


Folks,
 
I'm a DBA who is really an old developer at heart. I know a little Java, a
little Asp
(enough, as they say, to be really dangerous!), I used to do C code that now
makes 
my head swim to look at. (I think to myself, what the devil was I doing??)
 
Anyway, I've finally found some time and a machine here at work to start
playing with
OAS just to see what it's all about. Anyone have any good suggestions with
regards 
to:
 
1. Sites, books, white papers and the like with good install tips, hints,
warnings and the like.
2. Sites, books, white papers and the like Quick getting started tips.
3. Your own "getting started" experiences of things to do or not to do.
5. Anything I should do before I mess with OAS.
 
Optimistically hopeful that this will all just go really smooth and I'll
have a cool
web page that I can bring up soon!
 
RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).