Applications DBA ?

[SANJAY_G]

Hi all Apps DBAs,

I have been in Oracle Database Administration for 4+ years but never got a chance to work on Oracle Apps. I would like to know what are the things an Apps DBA should know apart from all the normal DBA things.

Appreciate all your feedback as it is really going to help me.

Sanjay

[pando]

App is a pain in the a**
You have to know patching because 11i needs a patch every week or smth, imagine how buggy it is

There are small patchsets and mega patchsets, to patch mega patchsets you probably need like 2~3 weeks sigh

Ah and there is no FK in 11 but there are some in 11i

I have a friend working with App and most of his time he spends on patching

I have another friend working in Oracle and he even says everyone in Oracle support hates App....

I think you get my point

[SANJAY_G]

Thanks Pando,

I got your point
I was wondering what are the responsiblities of apps DBAs that can not be performed by a normal DBA.

Anything else specific about apps DBA? (apart from patching)

Sanjay

[samdba]

Hi,

What Pando says it correct. I have been performing Apps DBA resp. for more than 4 years now.

Patches are most problematic things in Apps and especially when they fail and you get poor support of Oracle.

Apart from patching, it also includes System administration of Apps, developing interface APIs, Application/database cloning, Concurrent manager administration and tuning, configuring self service, workflow, alerts, ADI, ADE etc., application installation , upgrades.

I don't remember anything big than above.

I still enjoy working as Apps DBA.

Thanks,

[akwete]

Hi Sanja,
Samba gave in a nutshell the responsibilities of an Oracle Apps DBA. It is very technical position: see below some more info:

Regards.

Basic responsibilities of Application DBA:

Basic responsibilities of Application DBA:

1. Application installation/upgrade
2. Patches Application. They are Application patches, Database patches, upgrade patches,
interoperability patches etc.
4. Web Server Administration.
5. Concurrent Manager Administration/tuning.
6. System Administration of Application which includes creating a new Apps user,
responsibility, defination of menus, forms, reports etc.
7. Other job tasks are similar to Oracle DBA's job.



[Edited by akwete on 10-16-2002 at 12:54 PM]

[SANJAY_G]

Thank you all for the information.
One more question...
Have you guys attended any course for Oracle Applications? or is it on the job learning while being a DBA.

Sanjay

[samdba]

I learned most of the things on the job except I attended system administration and AOL class from Oracle.

Metalink is a good site for learners.

Thanks,

[sheeja]

Hi

This is Regarding Oracle Financial Application.
In 11i - AOL, Alert Manager, there is an option to configure Windows NT Mail(New Feature) to Send and Recieve Mails (Oracle Alerts-Message).
Anybody knows, what is the configuration?
Our Company Mail Server is Window NT.
But, Our Oracle Application Server is Solaris Machine.
We want to configure the Mail settings .. while sending Oracle Alert from Oracle application, it should reach our NT Mail server.

In Unix settings Alert is working fine.
But, How to do the Windows NT Mail settings on this Application ?

I think, an Oracle Application DBA can reply to this.

Please reply on the following mail id : [email protected]

It's very urgent.

Thanks,

Sheeja.

[pgoenka]

hi all
thanks for the info its really good
but still seeing the job market we may be required to move to oracle applications market..
i have client interview scheduled for tomorrow...and am expecting some question on oracle application DBA also i am a oracle DBA on 8i/9i but no knowledge of apps ..can u people please suggest some basics of application or some book or site on it... or just give a brief introduction of the topics u people just mentioned.. iknow its tough to learn such detailed topic in such short time but i still want to get some basics...
your help will be hight appriciated
Thanks

[harsh77]

Hello All GURU's,

I am working in Oracle APPS for more than one and half year. Where ever I see, I find an Oracle DBA turnout to be a Oracle APPS DBA. I am other way aroung. I know good stuff in ORacle APPS DBA. Starting from Upgrades to Cloning. But I know very little about Oracle :( How can I improve my self in this area.....I know Oracle is really VAST field...where should I start from??

Thx in advance,
Harshal.