RE: Oracle Application Server Admin

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <Brandon.Allen@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 23 Jan 2008 09:30:17 -0500

P.S.  The text logs continue to grow.... At about 2Gbs they impact
performance.... And at some point can crash some things....   Just one
aspect of maintaining the logs.


I know people who do NOT do what I am doing.   The easy way out was to
create a shutdown script and tag onto the end of it code to rotate or
delete most of the logs, and/or whatever else.


Of course this is much easier and your text logs will not become that
huge, but it requires shutdown/startup.   I'm trying to maintain without
shutdown which is more complicated.


Joel Patterson 
Database Administrator 
904  727-2546 


From: Patterson, Joel 
Sent: Wednesday, January 23, 2008 9:26 AM
To: 'Brandon.Allen@xxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle Application Server Admin


Yes, I am the only DBA here, and AS went in as part of EM Grid.   Sun
Solaris.   I am presently working on a cleanup script, (and other in
combination) to rotate all logs without shutting down anything.   Ie


This has become quite a project and I have created a document(s) to help
decipher all that is involved, and it is not nearly complete.   (I can
send it to get input on how helpful it is - note it is still a work in
progress.   (now on orion-application.xml's)).


I am not doing any of it from webcache admin or app server admin, or em
admin.   Perhaps after I have it all finely tuned I will begin looking
at some of the GUI options.   I have found out that not all options are
available in the GUI(s).  Like... I believe it is Webcache that will
allow rotation size and period in the xml, where the gui only allows
one, (but not going to double check now).


I can't count the logs yet.    Logs include but are probably not limited
to opmn, webcache, apache, sysman, oc4j (j2ee)... I'll stop there.

Some are self cleaning....  Like turning off text logging and turning on
ODL logging for all oc4j instances.   But then now you have about 6 or 7
xml files for each oc4j instance, and I have three instances by default.
Now instead of one file for each type of log (text logging), you have 6
(or so) directories of logs and an equivelant amount of configuration
xml files to edit.     (I can't get to hands off log rotation and
maintenance solely from the Gui, which is why I am not using it now).


I am doing all my edits in the xml configuration files.   For instance,
text logging is simpler but it each type will write to a log file, and
only one log file forever, and you have to shutdown to delete or rotate
it.   ODL logging changes directory structures and is self cleaning.


Anyway, that was just to highlight some of the complexity to maintain an
app server that Only is there for EM!    It is taking more time that I
anticipated, and there is a learning curve, not to mention 'documenting'
what you think you learned.


I expect this to drag on for a couple more weeks, (not full time), but
wish to get back to some "DBA" stuff.




Joel Patterson 
Database Administrator 
904  727-2546 


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon
Sent: Tuesday, January 22, 2008 5:31 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle Application Server Admin


Hi List,


I've recently been enlisted as the admin for Oracle App Server 10gR2 and
every day I'm realizing more and more how much effort this is going to
require for setup and ongoing support.  I have no prior App Server
experience so this is no minor task for me to pick up.  This is our
company's first experience with OAS so we're trying to figure out whose
responsibility it should be ultimately and I'm just curious what other
shops typically do.  Are any of you DBAs also being asked to take on OAS
admin (similar to an "Apps DBA"), or do your shops have dedicated staff
for this role, or another group that takes this on in addition to their
primary role?




Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do
not consent to Internet email for messages of this kind. Opinions,
conclusions and other information in this message that do not relate to
the official business of this company shall be understood as neither
given nor endorsed by it.

Other related posts: