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

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 Oracle HTTP server (OHS) Oracle weblogic server (WLS) 11g basic 10.3.6 Developer 10.1.2 APPL_TOP COMMON_TOP INST_TOP Database Tier Oracle 11g Enterprise Edition Rac and ASM

Basically sys and system user called database administrator users The users are created during database installation Both users are automatically granted the DBA role SYS User Sys user can perform all admin operations Owner of the database and data dictionary All base tables and views of the database and dictionary’s stores sys schema When connecting the sys user. Its should be made the sysdba or sysoper privileges Connect sqlplus / as sysdba Sysdba and sysoper users to perform high level of admin tasks Ex : Backup and recovery Startup and shutdown Alter database open/mount Alter database Archivelog/Noarchivelog   SYSTEM User Owner of the additional internal tables and views System user perform all admin tasks except DB upgrade, backup and recovery Default password is manager They contain administrative information used by the oracle tools. Connect syatem/manager Note: For security reasons the de...

Go to System Administrator à Concurrent à Program à Define Search the concurrent program name Click the Enable trace check box and save the concurrent program   Enable Debug from concurrent profile level Navigate to profile -> System Query "Concurrent: Allow Debugging" profile Set profile to "Yes" This should be set in site level. Submit the program Run the below sql query  under APPS User Select concurrent_program_name from fnd_concurrent_programs where enable_trace='N'; TKPROF Below query will provide the process id Select oracle_process_id from fnd_concurrent_requests where request_id=<Request_ID>; Below query will provide the trace file location select value from v$diag_info where name='Diag Trace'; select value from v$parameter where name='user_dump_dest'; Collect the trace file from user_dump_dest location and generate tkprof using below command tkprof <filename>.trc <filename>.txt sys=no  sort...

Step1 : source the EBSapps.env file Step2 : Go to $ADMIN_SCRIPTS_HOME Step 3 : sh admanagedsrvctl.sh stop oacore_server2              sh admanagedsrvctl.sh start oacore_server2              sh admanagedsrvctl.sh status oacore_server2 Ex : sh admanagedsrvctl.sh status oacore_server1 You are running admanagedsrvctl.sh version 120.14.12020000.8 Enter the WebLogic Admin password: oacore_server1 is running. admanagedsrvctl.sh: exiting with status 0 admanagedsrvctl.sh: check the logfile /oracle/PROD/apps/fs1/inst/apps/PROD_prod/logs/appl/admin/log/adoacorectl.txt for more information ... How to start and stop services in R12.2 Click hear