EBS 12.2 ADOP Interview Questions With Scenarios

Top 50 Oracle Apps DBA Interview Questions

How to find the Database version?
What is the top command?
What is a consolidated patch?
How to skip a worker and why?
What are the different modes you can run your adpatch?
In how many phases autoconfig will run?
How to run auto-config in test mode?

Oracle Apps dba Interview with US Top MNC in USA

The procedure to increase or decrease JVM was quite simple in R12.1.X. In Oracle E-Business Suite Release 12, the oacore, oafm, forms and forms-c4ws services were deployed as applications on OC4J instances and were managed by Oracle Process Manager (OPMN).So we just need to increase the numprocs in opmn.xml and start the services or run autoconfig with decrease numprocs in Context file

AD_OBJECTS is the Oracle E-Business Suite workaround to the unreliable STATUS column in DBA_OBJECTS. AD_OBJECTS shows the correct status for each object visible in the current edition. It also shows whether the object is “actual” (a real object) in the current edition, or a “stub” object (the object definition was inherited from a previous edition). You can query AD_OBJECTS to locate objects that need to be recompiled before use:

An: Yes. Online patching depends on the Edition Based Redefinition (EBR) feature that was introduced in the Oracle 11gR2 Database. Most notably, EBR allows editioning of code objects in the database. To do this, it provides new object types such as editions, editioning views, and cross-edition triggers, all of which are part of the Online Patching infrastructure.

Deletion of managed servers needs to be done on the run file system when there is no active ADOP cycle. During the next adop prepare, the Configuration Change Detector identifies that the addition has been made and the managed servers are automatically synced up from the run file system to the patch file system. The synchronization also gets done when fs_clone is executed.

Ans: During the apply phase of an Online Patching cycle, you apply Oracle Fusion Middle-ware patches to the Oracle homes of the patch edition file system. Then, after the cut over phase is complete, you synchronize the file systems by performing an fs_clone operation. (Also see My Oracle Support Knowledge Document 1355068.1, as listed in Appendix A.)

Enroll in Oracle Apps DBA Training from Real-Time Experts

Q31. Where are .fmb (Forms) stored

Ans:

They will be under $AU_TOP/forms/US.

Q32. When you run f60gen to compile the forms : .fmx will be put to where ?

Ans:

$PRODUCT_TOP/forms/US/ of respective product of form.

Q33. What is stored in “mesg” directory under each product top ??

Ans:

“mesg” contains language specific message files and error message for the product.

Q34. What is stored in “bin” directory under each product top

Ans:

“bin” directory contains executable files like in $AP_TOP/bin you will see APPBCF APTZGF apxamex.ctl apxboav.ctl apxdiner.ctl apxgecmc.ctl apxusbv.ctl APXXTR

Q35. How to compile apps schema and when to compile?

Ans:

You can use “adadmin” utility to compile apps schema (other methods like utlrp.sql exists). Usually you compile apps after application of the patches, maintanance patch, upgrade, runtime error due to AD_DDL packages or scenarios where there are invalid objects in apps schema.

Q36. How many database connections are allowed during fresh installation of oracle application.

Ans:

100 Connections. (Number has increased to 250 for Pluggable Databases in 12c)

Q37.Utility used to apply application patch is ?

Ans:

Q38. For database patch utility used to apply patch is ??

Ans:

Q39. What are .lgi files for ?

Ans:

While applying patch put the system in maintenance mode by running.

$adadmin and then select option 5 (change maintenance mode) after that select options enable/disable maintenance mode. (You can also change system to maintenence mode using $AD_TOP/patch/115/sql/adsetmmd.sql)

Q40.By default where adadmin log file will go??

Ans:

Q41. How to check what adpatch is doing ??

Ans:

“adctrl” is the utility to do check status of ad worker, including adpatch.

Q42. What are various stages of adpatch worker

Ans:

First of all workers will be in “waiting” stage after that jobs will be “assigned” then “running“, If error doesn’t come it will move to “complete” (waiting -> assigned -> running -> complete)

If error comes it will go like waiting -> assigned -> running -> failed -> fixed -> restarted -> completed

Q43. What is Default number of workers:

Ans:

2 times the number of CPU on the database server.

Q44. Have you ever seen worker status as deferred, while using adctrl ??

Ans:

Once you start applying patch , manager assigns jobs and unique ID to each worker. Manager will also insert one row into FND_INSTALL_PROCESSES table for each worker with information about who is doing what !

these two columns are important for us from the fnd_install_processes. Manager will monitor the workers by these two columns about status of the assigned job.Once worker is done with first job, manager will assign it the second job to do with the status update as .

Once all the worker’s status is completed for all the jobs, manager will tell the workers to shutdown and will drop fnd_install_process table.

Q45. What happens if worker is working on some particular job say updating some table but that table is locked ??? so what the worker will do in such situation…

Ans:

That’s the AD_DEFERRED_JOBS table which will be created at the time of FND_INSTALL_PROCESSES and ad_deferred_jobs too will be dropped with FND_INSTALL_PROCESSES. First time when worker checks and find that table is locked, that job fails and manager will automatically defers the job, and it will assigns a new job to the worker.

The job which was waiting in ad_deferred_jobs table will be assigned again till time it will not become failed or completed.

In such situation above, worker will wait till either the lock is released or timed out is reached and We (DBA) need not to take any action till the job status becomes fails…. once it shows its failed we can fix it and restart it.

Q46. Why APPS schema present in the 11i application ??

Ans:

It reduces traffic because all the product schemas will grant full privileges to Apps schema. so it will have full access to the complete Oracle application.

All the products like AP,AR,FIN has the code for respective products and APPS will have access to all these code objectives too. Apps will have all the synonyms for base tables and sequences as well.

Q47.Why do you need GUEST/ORACLE To connect to database?

Ans:

The GUEST user account is used in the application internally ( it is an application user). One of the major needs of this account is when there is a need to decrypt the APPS password (which is stored in an encrypted format in the apps tables). In order to decrypt the APPS password, the GUEST username/password is used to accomplish this task (using “Guest User Password” profile option).

GUEST account is used to obtain the decrypted value of the apps password for internal processes (i.e. when there is a need to connect as apps internally).

when the account gets locked/end-dated then you will see a blank page when you try to login to the instance.In that scenario you will have to correct this situation from the back-end as you will not be able to login to the application.

You will not find much details about the GUEST account documented anywhere ( may be coz of security reasons).

Key points :

s_guest_user is GUEST and s_guest_pwd is EXPORT in adconfig xml file.

select fnd_web_sec.validate_login(‘GUEST’,’ORACLE’) FROM DUAL; ( to validate if guest user is corrrect)

select fnd_profile.value(‘GUEST_USER_PWD’) from dual; (to find the current guest user password)

Check the GUEST/ORACLE password is present in DBC file at $FND_TOP/secure directory as well as at $FND_TOP/secure/SID_hostname directory.

Q48. What is the purpose of JSERV?

Ans:

Oracle 11i uses Jserv as the servlet engine. R12 uses OC4J as the servlet engine.

R12 uses version 10g of the Oracle Application Server, which does not have or use jserv

Once you click on the Oracle E-Business Home Page link, the request is forwarded by Apache to Jserv. Jserv sends it to Appslogin servlet.

Q49.What is Apache JServ?

Ans:

The 100% pure Java server application that acts as an independent servlet-request server.

Q50.What is mod_jserv?

Ans:

The Apache module that converts HTTP requests to servlet requests, connecting to the proper servlet engine and sending back the HTTP response to the client.

oracle apps dba interview questions r12.2

Frequently asked Oracle APPS DBA questions and links for answers

– What are the different phases of ADOP cycle Answer

– Steps to apply EBS 12.2 patches using adop Answer

– Why oracle recommends an odd number of voting disks Answer

– What is default EBS and weblogic ports in EBS Answer

– How to compile invalids packages in Oracle EBS Database Answer

– How will you enable RESTRICTED Login Mode in Database Answer

– How to troubleshoot Long Running Concurrent Requests Answer

– What is Split Brain Syndrome in Oracle RAC Answer

– How to apply weblogic patches in EBS 12.2 Answer

– What is Voting Disk in Oracle RAC Answer

– What is meaning of i, g and c in Oracle Database Version Answer

– How to create Guaranteed Restore Point in Database for recovery Answer

– Pre-requisite information to create a Database Link (DB Link) Answer

– SQL Tuning Advisor in Oracle Database Answer

– How to Monitor Dataguard Answer

– How will you tune Database Performance Issue Answer

– EBS 12.1.3 difference between 10.1.2 and 10.1.3 homes Answer

– EBS 11i to EBS R12.2 Upgrade High Level Steps Answer

– What is the difference between a PFILE and SPFILE Answer

Check other sets of interview questions.

APPS DBA Interview Questions- Click Here

HRMS Interview Questions- Click Here

Internship Question For Intern- Click Here

The Service Manager (FNDSM) PID can be used to locate all concurrent manager and service processes on the node, since the Service Manager (FNDSM) is the parent process

* Install 64 Bit Database 11.2.0.4 software on the new 64 Bit Linux machine. * Move 11i database from old Linux 32-bit to new Linux-64 bit machine and attach 11i application to new 64 Bit database.

$ perl adconfig.pl dbTier PART 6 : CONFIGURE TARGET APPLICATION SYSTEM ——————————————– $ perl adcfgclone.pl appsTier

Yes Applications R11.5.6 and below requires to first upgrade to R11.5.10.2/10gR2 Applications R11.5.7 and up can be directly upgraded to R12

There are different components with RapidClone that are used when cloning an Oracle Applications instance. These are:

oracle apps dba interview questions r12.2

Oracle Apps dba Interview with US Top MNC in USA

Enroll in Oracle Apps DBA Training from Real-Time Experts

Frequently asked Oracle APPS DBA questions and links for answers

Related posts:

Related Posts

The Top 20 XHTML Interview Questions for Web Developers in 2023

Preparing for a Udacity Interview: Commonly Asked Questions and How to Answer Them

Leave a Reply Cancel reply