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

Change Date and Time Formats In Oracle Database?

Change Date and Time Formats In Oracle Database? Option 1. If We want to change this format to DD/MONTH/YYYY format. SQL> alter session set nls_date_format=’DD/MONTH/YYYY’; Session altered. SQL> select sysdate …

Read More »

How to Find Database Object and it’s Corresponding Datafiles

How to Find Database Object and it’s Corresponding Datafiles SELECT DISTINCT t.ts#, t.name                AS Tablespace_name, d.name                AS DATAFILE, s.owner, s.segment_name, s.segment_type, s.bytes / 1024 / 1024 AS “MB” FROM   v$tablespace t, v$datafile d, dba_segments s WHERE  t.ts# = d.ts# AND t.name = s.tablespace_name AND s.owner = ‘APPS’;  

Read More »
Skip to toolbar