Apps dba Interview

IBM Interview:

=========

1.What's daily activity oracle application dba

2. daily oracle dba backup sstragies

3. describe oracle r12 architureh

4.describe oracle dba architure    

5.what are process ill happen user login in oracle application

6. what are process ill happen user accesing from in oracle application

7. what are process ill happen user access table in oracle application

8. suppose user could’nt accessing oracle login pages what we ill do.:

Answer:

1. first we check any user descktop weather having host entry about instance

   Ip addesss, Hosetname

1.       checking all services running correctly or

2.       Apache running correctly  (or) else go è $IAS_ORACLE_HOME/APACHE/APACHE/log/

9.  Whats is main different oracle 11i/R12:

1. inst_top only contain r12 not in oracle 11i

2. oracle home 10.1.2 and webserver home 10.1.3  but  in 11i oracle 8i

3. opmn not there

Difference Between Oracle apps 11i & R12

Summary of Changes :

Component	Release 11i	Release 12
Database	9.2	10.2
Developer	6i	10i
Application Server	1.0	10.1
Client Plug-in	Jinitiator	SUN JRE
Java Containers	Jserv	OC4J

Changes in Detail :

APPMGR
	OLD	NEW
APPL_TOP	$HOME/<SID>appl	$HOME/apps/apps_st/appl
COMMON_TOP	$HOME/<SID>comn	$HOME/apps/apps_st/comn
ORACLE_HOME	$HOME/<SID>ora/8.0.6	$HOME/apps/tech_st/10.1.2
IAS_ORACLE_HOME	$HOME/<SID>ora/iAS	$HOME/apps/tech_st/10.1.3
ORACLE
	OLD	NEW
ORACLE_HOME	$HOME/<SID>db/10.2.0	$HOME/db/tech_st/10.2.0
ORADATA	$HOME/<SID>data	$HOME/db/apps_st/data
INST_TOP (New Addition)
	OLD	NEW
INST_TOP	NA	$HOME/inst/apps/<context_name>

What’s new in Oracle Apps R12

Key points to Note:

1.             Oracle Applications Release 12 is the latest release in the chain of E-Business Suite Releases by Oracle.

2.             This release came up with the new file system model

3.             Autoconfig will not write anything in APPL_TOP, COMMON_TOP area in R12.

4.             All instance specific configurations, log files are written in INST_TOP area. This home provides the ability to share Applications and technology stack.

R12 new features

1.             Applications Server 9i is replaced by 10g (10.1.3.X)

2.             Forms & Reports Version 6i (8.0.6) are replaced by Forms & Reports Version 10g i.e. 10.1.2.X

3.             mod_jserv is replaced by oc4j

4.             Java/ JDK version 1.3.X or 1.4.X will be replaced by JDK 1.5.X

Techstack Components Changes

·                     Database (RDBMS_ORACLE_HOME) - 10.2.0.2

·                     FORMS ORACLE_HOME (8.0.6 ORACLE HOME equivalence) - 10.1.2

·                     OC4J_ORACLE_HOME (iAS ORACLE_HOME equivalence) - 10.1.3

File system level changes

·                     A new top INSTANCE_TOP is introduced in Release 12 for configuration and log files along with the other TOP's in existing in 11i.

·                     All instance specific configurations, log files are written in INST_TOP area. 

·                     This home provides the ability to share Applications and technology stack.

What is INSTANCE TOP 

·                     Instance home is the top-level directory for an applications instance which is known as Instance Home and is denoted the environment variable $INST_TOP. 

·                     This contains all the config files, log files, SSL certificates etc.

Advantages of new INSTANCE HOME

·                     The additional Instance Home makes the middle tier easier to manage and organized since the data is kept separate from the config files.

·                     The Instance Home also has the ability to share the Applications and Technology stack code across multiple instances.

·                     Another advantage of the Instance Home is that the autoconfig writes only in INST_TOP so APPL_TOP and ORACLE_HOME can also be made read only file system if required.

10. system administrator responsibility:

11. Whats Shared appl top

12. what mean PCP parallel concurrent manager

13. Patching
=======
a. what are type of patching avaliable
b. what are type of patch mode there
c. how increase performace of patch
--> whats mean adpatch and what are option its ll ask.
d.what is different hotpatch--> adpatch
e. what's mean marge patch and how to apply what are option it will ask
f. where is logfile ill generate.
g. suppose the patch ill getting error what ill u do.
h. suppose u forgot to apply pre-questing patch what ill u do.
i. how apply rollback patch


14.  adcrtl
1. what s means adctrl 
2. how to stop adpatch using adctrl
3. how quite adctrl 

Cloning:

1. what are cloning u r doing in oracle 12
2.what are error u r facing while cloing
3. why should we run adpreclone wheather 
4. weather all time its neccessary to run  adperclone.

rman:
 1. what will happen u run adcfgclone dbTechstack
2. what are post cloning activity
3. waiht are erro u are spacing while doing cloning

upgrade:

1. how upgrade 9i to 10g or 10g 11g step by step question;

Jagan interview question:

Hi,

1, what is autoconfig.
2. ifcontext_file or evvironment file corrupted how to restore.
3. DB and application working slow.
4. how to create custom_top.
5. different between 11i &nr12 .
6. concurrent actual 1 target 0 how to resolve the issue.
7. central inventory corrupted how to restore.
8. what is us of adrelink.
9. adpatch failed what will do.
10.how to apply merge patch.