Realtime Oracle Apps DBA Interview Questions and Answers

Dear DBA-Mates, Latest Apps DBA Interview Questions and Answers.

Hope you all are doing Good!!! We have some topics but due to busy scheduled not able to present here.

But back with some New Questions and Answers which may useful here, also I found as these are simple and good questions.

Questions:

Q 1. Please describe about your job and task activity?

Note: As we all know this is very common question and answer… It depends on person to person…

Q 2. How to do troubleshoot oacore?

Q 3. Where is location path of oacore log file?

Q 4. How to find out which user is pointing to which oacore in case we have 5 oacore?

Note: Please answer this questions if anyone aware about it.

Q 5. What is http server and how it works?

Q 6. What is http.conf file and ohs.conf file and where is the location?

Q 7. What is EBS Login flow?

Q 8. How to troubleshoot Long running program if there is no lock, no server load and everything is normal?

Q 9. What is EBS version?

Q 10. What will happened if you run Prepare phase?

Q 11. What is location of Patch log?

Q 12. If we have created custom top, how adop will sync to patch file system?

Q 13. How the prepare phase knows to sync Custom_top to patch file system?

Q 14. If we have applied small patches then do we need to run fs_clone phase?

Q 15. If cutover failed due to some reason, how to troubleshooting?

Q 16. If u ran prepare phase, 20 programs are running, and during cutover phase once completed what will be the status of those programs?

Q 17. How to create Weblogic user?

Q 18. Have you worked on any other technique other than EBS/DB?

Q 19. Have you done patching in Endeca?

Q 20. How ebs patch sync with Endeca?

Q 21. What is the version of RAC?

Q 22. What is flaks in 12c RAC , new feature in RAC?

Q 23. How you worked on RMAN?

Q 24. What is backup strategy?

Q 25. How to find out database wait events?

Note: Answer will be publish very soon.

Some more useful and helpful links:

How to change sysadmin password FNDCPASS in R12.1.3

What is PDB and CDB in oracle 12c

ORA-01110 data file 1: system01.dbf recovery

R12.2 ADOP Patching Phases Finalize and Cutover

Concurrent Manager Status System Hold, Fix Manager Solved...

Regards,

ORACLE APPS DBA INTERVIEW QUESTIONS AND ANSWERS ON 31stAug2018

Hey DBA-Mates,

We are back again with some real time interviews Questions and Answers which are asked by DBA in one of top MNC Companies.

We can’t say they will ask the same questions because interviewers always changed. This is only for some ideas and references for interviews which may useful for you all here.

Note: These questions are for experienced Oracle Apps DBAs.

1. Introduction about your experiences.

2. Application Patching steps in R12.1.3.

Click here for Steps...

3. What is DB link and how to create it.

Click here for Steps...

4. What is SRVCTL.

Work-around:

srvctl  status instance -d <DB_name> -i <instance1>, <instance2>

srvctl status database -d <DB_name>

srvctl stop database -d <DB_name> -o immediate

srvctl start instance -d <DB_name> -i <instance_name>

We tried to categorized which easy to understand.
Fore more Help Click here

5. How to recover a table from full Database backup.

Work-around:
Either from FRA if enabled or from database backup(incomplete recovery) or export / import from clone instance.

6. How to recover a dropped table.

Work-around:

Either from FRA if enabled or from database backup(incomplete recovery) or export / import from clone instance.

7. What is ora-504.

8. what to do for timeout error in OPP.

9. What is difference between R12.1.3 and R12.2 patching process.

10. What is cleanup phase.

11. Can we use adpatch in R12.2.

Answer:

We use ADOP phases in R12.2, we can't use adpatch in R12.2 even though ADOP internally call adpatch.

12. Whats are the phases in R12.2.

Main phases are PAFCC i.e 

Prepare phase, 

Apply phase, 

Finalize phase, 

Cutover phase and 

Cleanup phase.

Also FS_clone, abort etc...

13. How to import a single table  from 4 tables dump file.

14. How to compile JSP manually.

Please check here: Steps to Compile JSP manually

15. How to Apply patch in RAC.

Work-around:

We can use Rolling process. i.e. stop one instance then apply patch then start it, 2nd again stop another instance , apply patch and start instance. etc...

16. How to apply Database patch.

Using Opatch . Please check here DATABASE OPATCH...

17. What is napply option.

Answer:
Opatch napply command to apply multiple patches to an Oracle Fusion Middleware Oracle home.

18. How to check database configurations.

19. What to do for long running program in R12.1.3.

20 How can we rollback apps patches.

If it is not mentioned in Readme.html then not possible to revert back the fully applied patch. Partially we can try as per my knowledge.

21. Why we use Rman duplicate , why not restore and recover manually.

22. How check FRA is enabled or not.

sqlplus '/ as sysdba'

SQL> select flashback_on from v$database;

We will keep post or update the Answers for these Questions. Please you all also requested to update/provide answers in comment box which will be useful to all us.

Some more important links:

Oracle error-29548: ORA-29548 Solution (FNDCPASS Error)

R12.2 Cloning Steps

How toDuplicate a database using RMAN backup

R12.2 Interviews Questions and Answers

AD Utilitiesfor Oracle Apps DBA

OracleDeadlocks
CrontabConcepts and details with examples

Regards,

ora-data Team

oracle apps dba interview questions and answers for experienced asked Top MNC company

Hi DBA-Mates,

Today we got these Questions which is asked in Interviews one of the top MNC.

We should not tell the company name here which may raise any concerns. Leave it, we should not worry about that all...

Here, we would like to request you all DBAs, please provide the Answers in Comment box and after reviewing we will provide below the Questions.

We can give here easily all the Answers but we want you guys to do some homework for better understanding and learning, really it work personally.

Question: Hi, How are you?

Answer: Hello, I'm doing well. How are you? [This may different, depends person to person]

Question: 1. Can you please briefly introduce about your experiences. 
Answer : [Best Answer in 10-20 lines, how to start is the main steps.]

Question: 2. How you scale yourself for APPS DBA and Core DBA.

Answer : [As per your skill and knowledge but always keep above 60% -- as per our expert and advice]

Question: 3. Suppose we are applying the patch and got failed due to some tablespace full, how you will take care?

Question: 4. what are the types of patching?
Answer: There are main 4 different types of patches

One-off patch

Mini pack Patch

Family pack patch

Maintenance pack patch

NLS Patch – For Languages patches like English, French, Japanese etc…

Note (Quick-Reference):

few one off patch = mini pack ,

few mini pack / family bundeled = family pack

all family pack fixed = Maintenance pack 

Question: 5. Have you applied HRMS patches?

Question: 6. why we enable maintenance mode?

Answer: Why we need to enable Maintenance Mode in oracle apps

Question: 7. what are the Patching options in R12.1.3?

Question: 8. why we use ADCTRL?

Answer: ADCTRL concepts and details with example

Question: 9. how frequently CPU patches we apply?

Answer: CPU patch concept and steps to apply in real time

Question: 10. What are the steps to apply the APPS Patches?

Answer : Steps to apply Apps patches in Real time scenario with example

Question: 11. Can we enable maintenance mode if our Application is running?
Answer: Yes

Question: 12. What are the High level Cloning Steps?
Answer : Step by Cloning EBS with clear Steps as per real time scenario

Question: 13. What does Adpreclone on APPS Tier?

Question: 14. How Autoconfig works and why we run?

Question: 15. If customers are complaining that a program is running for Long 

time, what you need to take actions?

Question: 16. Why and when we need to run GSS?

Question: 17. Suppose customers are complaining that only one module (example - GL) forms are opening slowly, what we need to check and troubleshoot for this?

Question: 18. Suppose CRM is down then what will happen and what to do?

Question: 19. If CRM is down then who will work for CRM? Which Concurrent Manager will act like CRM?

Question: 20. If status of a program is in Pending and Standby, what it means and what you will do?

Question: 21. Have you worked on PCP? Do you know setup for PCP?

Question: 22. Have you done SSO setup?

Question: 23. What are the parameters asked during applying apps patch? [Unnecessary questions asked by them lol hhhh]

Question: 24. If the concurrent program is running for long time, can we enable trace and how?

Some more important Links:

How to change apss password in R12.1.3

How to Duplicate a database using RMAN backup

How to apply CPU OCT 2015 patch on 10.1.3 in R12.1.3

Oracle RMAN Interview Questions and Answers

Oracle DBA Troubleshooting Tips and Guide

Regards,

ora-data Team

Oracle RMAN Interview Questions and Answers

Hi DBA-mates,

After long time, again we are back with some important RMAN utility Questions and Answers. Now a day it is very important to know about the RMAN details and Configurations.

As per technologies changes, we should also upgrade our self. Now a day’s RMAN is asking in every profile.

I have selected some very important Questions and Answers as per my experiences and I have some more questions which I will be including here soon.

Q1.What is RMAN ?

A.RMAN (Recovery Manager)is an Oracle Database client that performs backup and recovery tasks on your databases and automates administration of your backup strategies.

It greatly simplifies the dba jobs by managing the production database's backing up, restoring, and recovering database files.

Q2.Why to use RMAN ?

A.RMAN gives you access to several backup and recovery techniques and features not available with user-managed backup and recovery. The most noteworthy are the following:

-- Automatic specification of files to include in a backup :  Establishes the name and locations of all files to be backed up.

-- Maintain backup repository:  Backups are recorded in the control file, which is the main repository of RMAN metadata.  Additionally, you can store this metadata in a recovery catalog.

-- Incremental backups: An incremental backup stores only blocks changed since a previous backup.

Thus, they provide more compact backups and faster recovery, thereby reducing the need to apply redo during datafile media recovery.

-- Unused block compression  :  In unused block compression, RMAN can skip data blocks that have never been used

-- Block media recovery: You an repair a datafile with only a small number of corrupt data blocks without taking it offline or restoring it from backup.

-- Binary compression: A binary compression mechanism integrated into Oracle Database reduces the size of backups.

-- Encrypted backups : RMAN uses backup encryption capabilities integrated into Oracle Database to store backup sets in an encrypted format.

-- Corrupt block detection :  RMAN checks for the block corruption before taking its backup.

Q3.How to check RMAN Configuration ?

RMAN>Show all;

Q4.How to Reset to default Configuration ?

A.To reset the default configuration setting use Connect to the target database from sqlplus and run

SQL> connect <sys/passwd as sysdba>@target_database; 

SQL> execute dbms_backup_restore.resetConfig;

Q5. How Many catalog database I can have ?

A.  You can have multiple catalog database for the same target database . But at a time you can connect to only 1 catalog database via RMAN. It’s not recommended to have multiple catalog databases.

Q6. Is this mandatory to use catalog database ?

A.  No ! it’s a optional one.

Q7. What is the difference between catalog database & catalog schema ?

A.  Catalog database is like any other database which contains the RMAN catalog user's schema.

Q8. What are the database file's that RMAN can backup ?

A. RMAN can backup  Controlfile , Datafiles , Archive logs , standby database controfile, Spfile

Q9. What are the database file's that RMAN cannot backup ?

A.  RMAN cannot take backup of the pfile, Redo logs , network configuration files, password files, external  tables and the contents of the Oracle home files

Q10. Can I have archivelogs and datafile backup in a single backupset ?

A.  No . we can not put datafiles and archive logs in the same backupset.

Q11. What is the difference between backup set backup and Image copy backup ?

A :  A backup set is an RMAN-specific proprietary format, whereas an image copy is a bit-for-bit copy of a file. By default, RMAN creates backup sets

Q12. Can I take RMAN backup when the database is Down ?

A. No ! You can take RMAN backup only when the target database is Open or in Mount stage. Its because RMAN keep the backup metadata in controfile . Only in open or mount mode controlfile is accessible.

Note: Please Check for Duplicate RMAN backup and Restore …

Some Important links:

How to Create a Database User and GrantPermissions in Oracle

ORA-609 with TNS-12537: TNS:connectionclosed

Crontab Concepts and details withexamples

How a user interact with an OracleDatabase

Oracle Deadlocks

How To Compile JSP Manually in R12

Hope this may useful and helpful. For any concerns please let us know either in comment box or contact @ora-data.blogspot.com

ref. doc:469777.1

Regards,

ora-data Team

Oracle Apps Interviews Technical Questions and Answers by MNC Companies

Hi DBA-mates,

We are back again with some important Questions which may useful and helpful for any interviews.

I got these Questions from a friend, so I thought to share and it might useful here for all.

Actually, these questions are not for Oracle Apps DBA. These questions are looks like for Oracle DBA (Core).

1. Introduced yourself and your role.

2. How to disable archive log:

Ans. The method for disabling archive log mode described above is the only way to disable archive log mode.

Shutdown edit pfile / spfile (spfile when instance is up of course) to say log_archive_start = false.

startup mount

alter database noarchivelog;

alter database open;

Remember that once you disable archive log mode you need to take a fresh backup once archive log mode is turned back on.

3. RMAN Configuration:

rman>show all ;                                                 ## to check all the configuration.

RMAN> configure controlfile autobackup on;    # for on and off

RMAN> configure backup optimization off;

4. How to check database alert log path?

Ans:

If database if UP and Running:

SQL> show parameters dump

Or SELECT * FROM v$daig_info;

If database is down:

Or you can check as from ps –ef|grep tns then follow the paths…

i.e go till oracle_home (oracle version)

then $ORACEL_HOME/admin/SID_Hostname/diag/rdbms/sid/SID/trace

ls –l alert*

alert_SID.log

5. How to check Table log? (i.e. Logging and Nologging concepts) # not sure

6. How to check blocking session?

Ans:

$ cat block.sql

select sid "Session id ", decode(Block,1, 'Blocking Session','Waiting Session') Details, ctime  "Blocking Time /Waiting time",id2 from v$lock where (block <> 0 or request <>0 ) and ctime > 200 order by id2,Details;

SQL> desc v$lock

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 ADDR                                               RAW(8)

 KADDR                                              RAW(8)

 SID                                                NUMBER

 TYPE                                               VARCHAR2(2)

 ID1                                                NUMBER

 ID2                                                NUMBER

 LMODE                                              NUMBER

 REQUEST                                            NUMBER

 CTIME                                              NUMBER

 BLOCK                                              NUMBER

SQL>

7. How to do expdp and impdp details and concepts.

Ans:

https://ora-data.blogspot.in/search?q=export+and+import

8. How to Apply Database Patches.

Ans:

https://ora-data.blogspot.in/2016/12/how-to-apply-database-patches-in-oracle.html

9. How to Apply Apps patches apply.

Ans:

https://ora-data.blogspot.in/2016/12/apply-apps-patch-using-adpatch-in-r12.1.3.html

Some more Questions and Answers by Top MNC Companies

Regards,

ADADMIN , ADCONFIG and ADMRGPCH

6.  How does ADADMIN know which form files to regenerate?

Answer

--------

How does adadmin know which forms files to regenerate?

---------------------------------------------------------------

With Release 11 adadmin, how does it determine which forms files need to be regenerated when using the Generate Forms Files option?

During the form generation process, adadmin and adaimgr (in this case adadmin) read a file named <prod>file.drv to build a list of objects to generate. 

For example if you are looking at the AZ module forms, there will be a file

called azfile.drv. This file is located in $PROD_TOP/admin/driver.

In your example this is $AZ_TOP/admin/driver.

NOTE - If a product not installed, adpatch does not regenerate forms for that

       product at all

You can test this by putting a dummy form name under entries for formsdev

and forms. This dummy form will be displayed when prompted to select forms for generation via adadmin.

How is this list of files in <prod>file.drv maintained?

-------------------------------------------------------

Any patches that install a new form or remove an existing form will

contain an appropriately updated version of <prod>file.drv.

adconfig:

A wrapper script that calls adconfig.pl. In earlier versions of AutoConfig adconfig.sh/ adconfig.cmd used to call the Java API to start AutoConfig.

AutoConfig Scripts:

On the application tier:
<AD_TOP>/bin

On the database tier:
<RDBMS ORACLE_HOME>/appsutil/bin

Log file created:

On the application tier:
<INST_TOP>/admin/log/<MMDDhhmm>/adconfig.log
On the database tier:
<RDBMS ORACLE_HOME>/appsutil/log/<CONTEXT_NAME>/<MMDDhhmm>/adconfig.log
 

Admrgpch:

Merges multiple patches into a single merged patch.

You can merge multiple patches into a single patch by using AD Merge Patch.

This AD utility is an executable located in AD_TOP/bin that merges multiple

AutoPatch compatible patches into a single, integrated patch. Once the merge is

complete, you use AutoPatch to apply the resulting patch in a single operation.

Using a merged patch reduces the time it takes to complete the patching process.

The command for merging patches is admrgpch.

AD Merge Patch reads the c<patchnum>.drv, d<patchnum>.drv, and g<patchnum>.drv

for each patch in the source directory and merges them to create a single set

of driver files (for example, cmerge99.drv, dmerge99.drv, and gmerge99.drv) in

the destination directory. It also merges the set of files contained in the

individual patches under the source directory according to file revision and

copies them to the destination directory. If a file exists in more than one

source patch, only the highest revision of the file is copied to the

destination directory.

Complete these steps:

1. Review the readme files carefully.

   Some patch readme files contain special instructions for applying merged

   patches. The patch may also require manual steps.

2. Create directories.

   In the patch top area, create a source directory and a destination directory.

   Choose any name for these directories.

3. Unzip patches.

   Copy all the patches to be merged into the source directory and unzip them.

4. Run AD Merge Patch.

   Run AD Merge Patch and supply the arguments for the destination directory

   name and the source directory name. You also need to specify the merged patch

   name, or accept the default.

5. Check AD Merge Patch log files.

   After AD Merge Patch runs, check the admrgpch.log file for errors. The file

   is located in the current working directory (where AD Merge Patch was run).

6. Run the merged patch.

   Once a merged patch is created, apply it just like a single patch.

AD Merge Patch cannot merge patches of different releases, different parallel

modes, or different platforms. However, it can merge patches for a specific

platform with a generic patch, or patches with different source character sets.

AD Merge Patch notifies you if you try to merge incompatible patches.

For example :

$ admrgpch /d01/patches/source /d01/patches/destination -merged_name mergedpatch

Where, mergedpatch is the name of the merged patch.


Thanks & Regards,
ora-data Team.