Home / Home

Home

Apps DBA Interview Questions Part 5

1.What is Online Patching? Online patching is a new patching mechanism that is available with R12.2 that allows the application of patches while the system is up and running, and the users are working as normal.   2.Which Oracle E-Business Suite releases Online...

Apps DBA Interview Questions Part 4

What is the difference between alter and FNDCPASS in changing apps password? FNDCPASS will update some FND tables other than standard tables. Where is the concurrent manager log file located? $COMMON_TOP/admin/log Or $APPLCSF/$APPLLOG What are the different types of...

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...

Apps DBA Interview Questions Part 2

You are applying a patch , can you open another session and run adadmin ? Yes, We can run unless you are running a process where workers are involved. You are applying a patch , can you open another session in another node and run adpatch? No, because it will create...

Apps DBA Interview Questions Part 1

Briefly Describe the architecture of Oracle Applications? Oracle Applications follow a Three tier architecture: Database Tier containing the RDBMS database. Middle-Tier containing various servers like Forms Server, Web Server, Concurrent Processing Server, Admin...

ELFCLASS64 at /usr/lib64/perl5/XSLoader.pm line 70

ERROR ============================================= *** Latest formsapp.ear has been deployed *** ============================================= Program : /u01/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Tue Sep 4 05:45:23 2015 Perl script txkChkFormsDeployment.pl got executed successfully

Read More »

Temporary Tablespace and Datafile Management in Oracle database

Temporary Tablespace and Datafile Management in Oracle database   1.  For Finding temp file and temp tablespace with size SELECT file#,         status,         bytes / 1024 / 1024 “Size_MB”,         name  FROM   v$tempfile;  SELECT file_name,         tablespace_name,         bytes / 1024 / 1024 / 1024,         status  FROM   dba_temp_files;    …

Read More »
Skip to toolbar