Modern Oracle DBA

In this post, I will cover some useful basic Environment variables.  Configuration files in R12.2   Important Environment files:-   Lactation :  cd /u01/apps/dev File Name : EBSapps.env This is the main environment file we can source RUN/PATCH edition using this file   Lactation : cd $APPL_TOP location below tow important environment files available    File Name : Apps<CONTEXT_NMAE>.env This file is known as the universal environment file. File Name: <CONTEXT_NAME>.env executable environment of APPL_TOP and oracle   Lactation: cd $INST_TOP/appl/admin File Name: adovars<ONTEXT_NMAE>.env Its contain JAVA HTML related environment variables    10.1.2 Env Files:   Lactation : cd $INST_TOP/ora/10.1.2 File Name:  <CONTEXT_NAME>.env Its contain all 10.1.2 related executable environment     Important Configuration Files:-   Lactation: cd $APPL_TOP/admin File Name: adconfig.txt file is mainly used for ADUtlities. File Na

Before going to the interview prepare the below concepts. It will be easy to crack the interview. Application:- Upgradation Click hear Cloning Click hear Patching Clickhear Migration Log file location Concurrent Manager Clickhear Database:- Database Architecture  Clickhear Datagurad ASM,RAC Database Patching 11g,12c,19c New features OCI Instance creation PDB DB cloning and pdb instance creation   Performance Tuning:-  AWR ADDM ASH Sqltrp Concurrent manager and program slowness Find execution Plan change and pin best plan Cloning issues Basic day-to-day troubleshooting activity Finally search in google and study the current interview questions  à Click hear

Concurrent à Programs à Define Query the particular concurrent program and check the request column and assign the concurrent manager in type column.

Desktop Tier Sun (1.6)   java run time environment Java Virtual machine (JVM)   J2SE Plug-in Application Tier Apache Web Server 2.0 Oracle Forms/Reports 10g Oracle Process Manager and Notification Server (OPMN) Oracle containers for J2EE (OC4J) JRE (Java Runtime Environment) – 1.6 JDK (Java Development Kit) – 1.6.X Database Tier Oracle 11g Enterprise Edition Rac and ASM