Very Common Oracle Apps DBA Questions

I collection few regular asked question for Oracle Apps DBA to hire Apps DBA for my team, now publishing for reader’s use. These question are even relevant for Oracle Technical experts / developer also.  I would like to request share your questions if you have any.

Q. What is difference between fresh database and vision database install types ?
Fresh Database –
Database is installed with Apps but with no data
Vision Database – Database installed with Apps with dummy data

Q. Whatis US directory in $AD_TOP or under various product TOP’s .
US directory is default language directory in Oracle Applications. If you have multiple language Installed in your Applications then you will see other language directories beside US, that directory will contain reports, fmx and other code in that respective directory like FR for France, AR for arabic, simplifies chinese or spanish.

Q. Whats main concurrent Manager types.
ICM – Internal Concurrent Manager which manage concurrent Managers
Standard Managers – Which Manage processing of requests.
CRM – Conflict Resolution Managers , resolve conflicts in case of incompatibility.

Q. Where is Concurrent Manager log file location ?
By default standard location is $APPLCSF/$APPLLOG , in some cases it can go to $FND_TOP/log as well.

. List some ad utilities and their functions?
adadmin, adctrl, adpatch, adlicmgr, admrgpch, adsplice and adworker

Q. List out the modules related to oracle Apps DBA ?

FND – Application Object Library, AU – Application Utilities, AD – Application DBA

Q. How many concurrent mangers can be used ? what is the limit ?
There is no such documented limit on number of concurrent managers, as long as you have enough operating system resource (memory).

Q. How would you check if the tablespace is in backup mode ?
– Check in v$backup
SQL> SELECT d.tablespace_name, b.status FROM dba_data_files d, v$backup b
WHERE d.file_id = b.FILE# and b.STATUS = ‘ACTIVE’ ;

Q. What is “Custom TOP” in apps ?
– Custom top is similar to other tops under APPL_TOP but containing custom (client) specific functionality. Apps DBA need to define custom TOP and register all custom code under CUSTOM TOP

Q. if you find that under $FND_TOP/secure directory, there are many .dbc files, how would you know which is the correct one ?
– System picks up dbc file based on profile option value “Applications Database ID

Q Where is applications start/stop scripts stored ?

Ans: $COMMON_TOP/admin/scripts/$CONTEXT_NAME

How to confirm if Report Server is Up & Running ?

Ans: Report Server is started by executable rwmts60 on concurrent manager Node & this file is under $ORACLE_HOME/bin .execute command on your server like
ps -ef | grep rwmts60
You should get output like
applmgr ……. rwmts60 name=REP60_VISION
where VISION is your Instance name.
Else you can submit a request like “Active Users” with display set to PDF, check output & log file to see if report server can display PDF files

How you will start Discoverer in Oracle Apps 11i ?

Ans: In order to start dicoverer you can use script under $OAD_TOP/admin/scripts/$CONTEXT_NAME
or under $ORACLE_HOME/discwb4/util (under Middle/Application Tier)

How to check number of forms users at any time ?

Ans: Forms Connections initiate f60webmx connections so you can use
ps -ef | grep f60webmx | wc –l

What is 0 & Y in FNDCPASS, FNDLOAD or WFLOAD ?

Ans: 0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where
0 is request id (request ID 0 is assigned to request ID’s which are not submitted via Submit Concurrent Request Form.
‘Y’ indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.

Q. What are .ldt & .lct files which you see in apps patch or with FNDLOAD ?

Ans: .ldt & .lct stands for Loader datafile & Loader configuration files, used frequently in migrating customization, profile options, configuration data, etc.. across Instances.

Q. What is dev60cgi & f60cgi ?

Ans: cgi stands for Common Gateway Interface and these are Script Alias in Oracle Apps used to access forms server . Usually Form Server access directly via http://hostname:port/dev60cgi/f60cgi

Q. How to compile an Oracle Reports file ?

Ans: Utility adrepgen is used to compile Reports. Synatx is given below

adrepgen userid=apps\ source = $PRODUCT_TOP\srw\filename.rdf dest=$PRODUCT_TOP\srw\filename.rdf stype=rdffile dtype=rdffile logfile=x.log overwrite=yes batch=yes dunit=character

Extra tips – Team Work – Hare and Tortoise Story

A very nice story about — Compeition, Capability, Team Work and Collaborative Success….

I am not sure about author but found on slideshare and sharing it here… enjoy and i am sure it will be an inspiration.

Once upon a time a tortoise and a hare had an argument about who was faster. They decided to settle the argument with a race. They agreed on a route and started off the race. The hare shot ahead and ran briskly for some time. Then seeing that he was far ahead of the tortoise, he thought he’d sit under a tree for some time and relax before continuing the race. He sat under the tree and soon fell asleep. The tortoise plodding on overtook him and soon finished the race, emerging as the undisputed champ. The hare woke up and realised that he’d lost the race. The moral of the story is that “Slow and steady wins the race”

This is the version of the story that we have all grown up with.

But then recently, someone told me a more interesting version of this story. It continues….

The hare was disappointed at losing the race and he did some Defect Prevention (Root Cause Analysis). He realised that he’d lost the race only because he had been overconfident, careless & lax. Root Cause If he had not taken things for granted, there’s no way the tortoise could have beaten him. So he challenged the tortoise to another race. The tortoise agreed. This time, the hare went all out & ran without stopping from start to finish. He won by several miles.

The moral of the story Fast & consistent will always beat the slow and steady.

If you have two people in your organisation, one slow, methodical & reliable, and the other fast and still reliable at what he does, the fast and reliable chap will consistently climb the organisational ladder faster than the slow, methodical chap. It’s good to be slow and steady; but its better to be fast and reliable.

But the story doesn’t end here. The tortoise did some thinking this time, and realised that there’s no way he can beat the hare in a race the way it was currently formatted. He thought for a while, and then challenged the hare to another race, but on a slightly different route. The hare agreed. They started off. In keeping with his self-made commitment to be consistently fast, the hare took off and ran top speed until he came to a broad river. The finishing line was a couple of kilometres on the other side of the river The hare sat there wondering what to do. In the meantime the tortoise trundled along, got into the river, swam to the opposite bank, continued walking & finished the race.

In an organisation, if you are a good speaker, make sure you create opportunities to give presentations that enable the senior management to notice you. The moral of the story ? First identify your core competency & then change the playing field to suit your core competency.

The Story still hasn’t ended!

The hare and the tortoise, by this time, had become pretty good friends & they did some thinking together. Both realised that the last race could have been run much better. So they decided to do the last race again but to run as a team this time. They started off, and this time the hare carried the tortoise till the riverbank. Then, the tortoise took over and swam across with the hare on his back. On the opposite bank, the hare again carried the tortoise and they reached the finishing line together. They both felt a greater sense of satisfaction than they’d felt earlier.

It’s good to be individually brilliant & to have strong core competencies; but unless you’re able to work in a team & harness each other’s core competencies, you’ll always perform below par because there will always be situations at which you’ll do poorly & someone else does well. \

The moral of the story

  1. Teamwork is mainly about situational leadership, letting the person with the relevant core competency for a situation take leadership.
  2. There are more lessons to be learnt from this story 1. Note that neither the hare nor the tortoise gave up after failures. The hare decided to work harder and put in more effort after his failure.
  3. The tortoise changed his strategy because he was already working as hard as he could. In life, when faced with failure, sometimes it is appropriate to work harder and put in more efforts
  4. Sometimes it is appropriate to change strategy and try something different. And sometimes it is appropriate to do both.
  5. The hare and the tortoise also learnt another vital lesson. When we stop competing against a Rival & instead start competing against the Situation, we perform far better.

A different view on – How organization works sometime –

A nice narrative about , how simple things get complicated 🙂

Every day, a small ant arrives at work very early and starts work immediately. She produces a lot and she was happy.

The Chief, a lion, was surprised to see that the ant was working without supervision. He thought if the ant can produce so much without supervision, wouldn’t she produce even more if she had a supervisor! So he recruited a cockroach who had extensive experience as supervisor and who was famous for writing excellent reports.

The cockroach’s first decision was to set up a clocking in attendance system. He also needed a secretary to help him write and type his reports and … he recruited a spider, which managed the archives and monitored all phone calls.

The lion was delighted with the cockroach’s reports and asked him to produce graphs to describe production rates and to analyse trends, so that he could use them for presentations at Board‘s meetings. So the cockroach had to buy a new computer and a laser printer and… recruited a fly to manage the IT department. The ant, who had once been so productive and relaxed, hated this new plethora of paperwork and meetings which used up most of her time…!

The lion came to the conclusion that it was high time to nominate a person in charge of the department where the ant worked. The position was given to the cicada, whose first decision was to buy a carpet and an ergonomic chair for his office. The new person in charge, the cicada, also needed a computer and a personal assistant, who he brought from his previous department, to help him prepare a Work and Budget Control Strategic Optimisation Plan …

The Department where the ant works is now a sad place, where nobody laughs anymore and everybody has become upset… It was at that time that the cicada convinced the boss , the lion, of the absolute necessity to start a climatic study of the environment . Having reviewed the charges for running the ant’s department, the lion found out that the production was much less than before.

So he recruited the owl, a prestigious and renowned consultant to carry out an audit and suggest solutions. The owl spent three months in the department and came up with an enormous report, in several volumes, that concluded : “ The department is overstaffed …”

Guess who the lion fires first?

The ant, of course, because she “ showed lack of motivation and had a negative attitude

RoundPegg Webinars – Making great hires , building team and develop great culture

I personally find these very useful and informative, I am sure will give a good information to you as well. These are webinars so do use your HEadPhone to listen commentary

SlideShare webinar – How to do Hiring

Webinar – How to Build teams

Webinar – How to develop Organization Culture