Home / Interview Questions / Apps DBA Interview Questions / Apps DBA Interview Questions Part 3

Apps DBA Interview Questions Part 3

What is adctrl?
  • Adctrl is one of the ad-utilities, which is used to check the status of workers and to manage the workers.
How to skip a worker and why?

We can skip a worker using option 8 in adctrl which is hidden. We will go for skipping a worker when we have executed the job which the worker is supposed to do.

How adpatch knows what are the pre-requisite for the patch which it is applying?

With every patch there is a file called b.ldt file which contains the pre-requisite information. Adpatch load this into database using FNDLOAD and check, whether those pre-requisite patches were applied or not.

What is FNDLOAD ?

FNDLOAD is a utility which is similar to SQL-LOADER but loads code objects into database, where as SQL-LOADER loads data objects into database.

What C-driver will do?

C-driver copies the files from patch unzipped directory to required location in the application file system. Before copying, it will check the file version of the existing file at the file system with file version in the patch. If the patch file version is higher than the file at file system level, only then C-driver will copy that files.

How adpatch will know the file versions of the patch delivered files?

With each patch a file with name f.ldt is delivered , which contain the file versions. Adpatch will use this file to compare the file versions with the file on file system.

What is the adpatch log file location?

$APPL_TOP/admin/[SID-name]/log

What are the different modes you can run your adpatch?

a) Interactive – default mode

b) Non interactive – Use defaults files to store prompt values (adpatch defaultsfile= interactive=no)

b) Test – Without actually applying a patch just to check. (adpatch apply=no)

 

What is autoconfig?

Autoconfig is an adutility which is used to maintain application environment and configuration files.

What are the parameter autoconfig will ask for?

Context file name and APPS user password.

What is context file?

Context file is a central repository, which stores all application configuration information.

How you will find autoconfig is enabled/not for your applications?
  1. Open any .env or configuration files, the first few lines will tell u that this files are maintained by autoconfig.
  2. If contextname.xml file is there in $APPL_TOP/admin
How autoconfig will create .env and configuration files?
  1. Autoconfig will go to each and every top template directory take the templates from there and fill the values from context.xml file and create the required files.
What is for “validating apps schema” option in adadmin?

It will check for the corrupted objects in apps schema

What is “Compile APPS Schema” option in adadmin?

It will compile the invalid database objects.

How to find invalid objects in database?

select count(*) from dba_objects where status=’INVALID’;

What is adrelink?

Adrelink will relink the executables with the libraries. Generally we go for adrelink when some patch delivers some library files, or when executable were corrupted.

What is adodfcmp utility?

This utility is used to recreate/repair corrupted database objects from ODF(object definition files) files.

About Syed Saad Ali

As a certified and experienced Oracle Database Administrator with Almost 10 Years of Experience I am able to perform all levels of database maintenance and am fully qualified to do Oracle updates as well. Capitalizing on my interest in Business & IT both, I chose to navigate my career towards Enterprise Solutions, which has enabled me to excel in the combination of both. I have developed exceptional analytical skills that allow me to diagnose and take care of issues immediately. Extremely skilled in planning and execution of special projects in time- critical environments. Extensive knowledge in directing, coordinating and exercising concern authority for planning, organization, control and successful completions. Very skilled at solving customer relations issues by seeking first to understand and then to be understood. Effectively able to communicate with customers, vendors and management.

Check Also

Apps Technical Interview Questions Part 5

Leave a Reply