ORACLE APPS DBA TRAINING - Online Training for SAP|Oracle|JAVA|Microsoft|Mobile Apps|Testing|SAS|Hadoop - Acutesoft Solutions
India:+91 (0)9848346149, USA: +1 973-619-0109, UK: +44 207-993-2319 Santosh@acutesoft.com
Select Page

ORACLE APPS DBA

ORACLE APPS DBA ONLINE TRAINING

ORACLE APPS DBA ONLINE TRAINING IN INDIA, USA & UK

ORACLE APPS DBA ONLINE TRAINING IN CANADA

ORACLE APPS DBA ONLINE TRAINING IN AUSTRALIA

ORACLE APPS DBA ONLINE TRAINING

ORACLE APPS DBA COURSE CURRICULUM

Download [PDF]

  • Overview of the Architecture
      Defining an Oracle server
      Database, Instance
      Understanding Physical structure
      Memory structure, process structure
      logical structure, execution of SQL statements
      User sessions
  • Installing oracle database
      System requirements
      Pre-install steps – checking certification
      software compatibility, hardware
      compatibility
      creating Unix logins, setting kernel parameter
      applying OS level patches
      Installing the software ,post install steps
      Creating a New Database
      Identifying the application
      no. of applications the DB will support.
      Understanding TS
      changing initialization parameters- SGA size
      Processes, TS Naming conventions, Block
      sizes, Type of DB
      No. of Users the DB has to support etc.
      Dropping a Database, sysaux, Tablespace
      Default tablespace.
  • Managing an Oracle Database
      Creating and Managing initialization files- PFILE
      SPFILE , Adv.Of SPFILE over PFILE
      Identifying the various states
      options of instance startup/shutdown DB mount
      open stages
      Monitoring Alert
      Trace files in udump, bdump
      cdump for DB troubleshooting
      Configuring System Global Area (SGA) – DB buffer Cache
      Log buffer and shared pool
      Understanding Back ground processes-Mandatory
      Optional and the jobs performed by them using the data dictionary to retrieve information about the database- Vs DBA_views
  • Managing Tablespaces and datafiles
      Creating and Altering Tablespaces, adding, resizing, renaming a Datafile, renaming Tablespace
      Tablespace- offline, online, read only, read write, temporary Tablespace groups multiple blocks
      Creating and managing a Tablespace when using OMF and advantages of OMF feature
      Extent Management – Dictionary managed and locally managed Tablespaces AUTOALLOCATE./UNIFORM )and advantages of locally managed over dictionary managed Tablespace
      Big file Tablespace, temporary Tablespace group
  • Storage Management
      Creating, maintaining tables using appropriate storage settings- initial, minextents pctfree etc
      Obtaining table information like avg row length, chained rows, etc. after analyzing the tables
      Managing, listing diff types of indexes and their uses, creating B-tree and Bitmap indexes, Maintaining indexes, identifying unused indexes, obtaining index information
  • Oracle Data Pump
      Introduction, Benefits of Data pump export and import
      Data pump export and import modes
      Transport of Tablespace across different platform’s
  • Maintaining the control file, redo log files and archive log files
      Importance role, sizing contents, multiplexing and backing up of the control file
      Purpose of and how online redo log file work with their associated background processes
      Controlling log switches and check points, multiplexing and archiving online redo log files
  • Database patching
      Applying RDBMS patches using OPatch utility, applying PATCHSET ,analyzing the readme file , applying multiple patches with napply option
      Overview of oraInventory – central inventory and local inventory
      Removing applied rdbms patches using rollback option
  • Networking Overview
      Explaining solution included with oracle for managing complex networks
      Oracle net Architecture – Explaining the key components Role in client/Server connections
      Oracle Net Services Server side configuration. Oracle Net services client-side configuration
      Configuring and maintaining distributed DB’s by creating DB links, Materialized views
      Usage and configuring of oracle shared server components of the Oracle shared server, configuring shared servers and dispatchers, identifying useful data dictionary view
  • Backup and Recovery
      Describing the basics of DB backup, Restore and Recovery, Listing the types of Failures that may occur in an oracle environment. Defining Backup and Recovery Strategies
      Instance and media Recovery structures- Describing the Oracle Processes, memory structure and files related to recovery, identifying the importance of check points, redo log files and archived log files
      User Managed Backups and Recoveries – Backup and recovery operations closed and open DB backups(hot and Cold). Complete Recovery identifying the situations which require incomplete recovery from loss of online redo logs, creating clone DB�s
      Oracle Recovery Manager (RMAN) – Features and components, Repository. channel allocation, configuring RMAN environment, complete and incomplete Recovery and Full/Incremental compressed backups, incremental backups with block change tracking RMAN compressed Backups
  • Database cloning
      Pre-clone steps on the target(dev server)–backup the key config and environment files ,export any schemas if needed
      Cloning the database using cold backup and hot backup(partial clone/full clone)
      Copying the files to the target , configure the instance on the target, post clone steps
  • Database upgrade
      Db upgrade from 9i to 10g(10.2.0.3) applying the bug fixers of 10.2.0.3 , running pre-upgrade tool(utlu102i.sql)
      Analyzing the obsolete/deprecated parameter ,backing up connect role ,checking for invalid objects if any
      Compiling invalid objects and gather sys statistics as post upgrade steps
  • Performance Tuning
      Overview of Tuning phases , Goals , Methodology and common performance problems
      DB conf. and I/O issues file striping, optimizing /tuning sorting operations, Diagnosing partitioning Redo log files configuration, online segment shrinking
  • Managing Undo Segments
      Understanding Oracle Undo Segments, Retention Policy, retention guarantee
  • Enabling Oracle’s parallel query option , multiple DB writers Log writers table caching
      Gather statistics of database ,schema ,table ,index
      Overview of reorganization of database ,schema
      Sizing SGA – Shared pool(reuse stmts, etc) buffer Cache, Redo log Buffers cache
      Tuning Rollback /Undo segments – Usage , configuration, detecting and resolving problem
  • Diagnostic and Tuning Tools – Alert Log files, Tkprof, Explain plan, Dynamic performance viewview, STATASTICS_LEVEL parameter to collect statistics AWR, ADDM

ORACLE APPLICATIONS DBA OVERVIEW


Oracle Applications is an Enterprise Resource Planning Software, which is run by large industries to control their industry-wide operations.

This software involves separate segments known as modules for separate business processes.

Each module is basically a collection of forms (with some data displaying reports) where at each stage of the business process, data needs to be entered.

The forms enforce industry best-practices controls on data input and process flow.

An Oracle Applications DBA is very different from a regular Oracle database administrator and requires specialized skills in business administration and Oracle application server architectures.

The Oracle Applications DBA job role is less compartmentalized than a traditional Oracle DBA and the Oracle Applications DBA must also have skills in these areas:

Database Design – Many shops require customized functional extensions and reporting data marts and the Oracle Applications DBA must have outstanding Database design skills.

racle Application Server – The Oracle Applications DBA must understand the internals of the Oracle concurrent manager and understand how to monitor and tune Oracle Applications.

Functional Expertise – Many shops requires a business degree and a general understanding of the Oracle Applications module. For example, accountants are widely used to support Oracle eBusiness Suite (Oracle Financials), and accountants with an IT background are easily trained in Oracle Applications DBA support.

DEMOS VIDEOS

UPCOMING DEMOS

For updated Schedules please contact
calls

Oracle Apps DBA Interview Questions and Answers


  • Describe the architecture of Oracle Applications?
      Oracle Applications follow a 3 Tier architecture
      – Database Tier
      – Middle Tier
      – Desktop Tier
      Database tier contains RDBMS database called as oracle database server.
      Database tier stores all the data needed by oracle applications.
      Middle tier or Application Tier containing various servers configured with listeners like web server, forms server, admin server, reports server.
      Database server communicates with middle tier, doesn’t directly communicate with desktop tier.
      Desktop tier contains client desktop where users access oracle applications through web browsers.
  • How do you delete a responsibility from oracle applications?
      Responsibility is a level of authority given to Oracle Applications users.
      It is a collection of requests, forms and menus attached to user.
      Records are used for monitoring and security purpose so we can’t disable responsibilities.
      However, responsibilities can be disabled by assigning an end date to the effective period.
      We can delete a responsibility from both backend and frontend.
  • What are the components of Oracle Applications technology layer?
      Oracle Applications technology layer comprises the following products
      Oracle Applications DBA (AD)
      Oracle Applications object library (FND)
      Oracle Common Modules (AK)
      Oracle Applications Utilities (AU)
      Oracle Alert (ALR)
      Oracle Workflow (WF)
      Oracle Applications Framework (FWK)
      Oracle XML Publisher (XML)
  • How many Oracle Homes are there in Oracle Applications and what is the importance of each one of them?
      Oracle Applications have three Oracle Homes
      Oracle Home is an environment where oracle products run.
      Database Oracle Home in the database tier that acts as the Oracle Home for the Oracle database.
      Oracle Home in the application tier called as 8.0.6 Oracle Home. It is called the technology stack Oracle Home and used by forms, reports and discoverer.
      IAS Oracle Home, used by the Oracle HTTP Server (Web Listener).
      We can run multiple releases of same products simultaneously by using multiple oracle homes.
  • Can I enable real application clusters in the database tier along with oracle applications?
      Yes, real application clusters can also be configured with Oracle Applications
      RAC allows multiple instances to mount and open a single database.
      RAC requires shared disk storage and a dedicated network interconnect.
      When any one of the node fails, database services can be still available on remaining nodes.
      In that case, more than one instance of Oracle runs and the data file are stored at a central location accessible from the entire instance.
  • Where are Apache log files and configuration files stored and list each of them?
      Apache log files are stored in $IAS_ORACLE_HOME/Apache/Apache/logs.
      The log files are error_log, error_log_pls, access_log and access_log_pls.
      Apache configuration files are stored in $IAS_ORACLE_HOME/Apche/Apache/conf directory.
      The main configuration files are httpd.conf, apps.conf, httpd_pls.conf,oprocmgr.conf, and oracle_apache.conf.
  • How to recreate a DBC file and where is it located?
      Running Autoconfig will recreate the DBC file
      DBC is a database connect descriptor file which stores database connection information used by application tier (web browsers) to connect to database.
      The file is located in FND_SECURE directory.
      you can also create the DBC file by running the script adgendbc.sh
      We can find the above script at $COMMON_TOP/admin/install directory.
  • List out the important configuration files in APPL_TOP?
      Important configuration files available in the APPL_TOP are
      APPLSYS.env/APPSORA.env
      Adovars.env
      SID.xml
      Adconfig.txt
      Adjareas.txt
      Topfile.txt
      Appsweb.cfg
      Hostname_SID.dbc
      Adpltfrm.txt
      Adjborg.txt
      Adjborg2.txt
  • Which utility is used for changing the password of the application users and how it runs?
      The password of the application users can be changed using the FNDCPASS utility.
      You must have system and applications password for running FNDCPASS.
      FNDCPASS will run in the following manner:
      FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME.
      FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
      FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME.
  • What are the scripts do you use while Apps cloning?
      A type of script that’s made a comeback in hot scripts is clone script.
      adpreclone.pl prepares the source system and adcfgclone.pl configures the target system.
      Both the scripts are located in $COMMON_TOP/admin/scripts/contextname directory.
      Adpreclone.pl collects information about the database.
      It also creates generic templates of files containing source specified hardcore values.
  • What is the configuration file for adutilities (like adadmin,adconfig etc)?
      adconfig.txt @APPL_TOP/admin
  • What is adrelink?
      adrelink will relink the executables with the libraries. Generally we will go for adrelink when some patch delivers some library files, or when executables were corrupted.
  • How to find the version of a file?
      1. adident Header 2. strings -a filename grep Header
  • What is adodfcmp utility?
      This utility is used to recreate/repair corrupted database objects from odf(object defination files) files.
  • How you will change apps password?
      FNDCPASS 0 y apps/ system/ SYSTEM APPLSYS
  • What if apps password is changed with alter command?
      Applications won’t work.
  • What is the difference between alter and FNDCPASS in changing apps password?
      FNDCPASS will update some fnd tables other than standard tables.
  • Where the FNDCPASS utility is located?
      Concurrent node @FND_TOP/bin
  • How to find out what component of u r oracle applications were installed on which node?
      Xml file (context file)
  • How to find the version of httpd/Apache web server?
      $IAS_ORACLE_HOME/Apache/bin/httpd version
  • What is the configuration file for httpd and what is the location of it ?
      httpd.conf @IAS_ORACLE_HOME/Apache/Apache/conf
  • Where you will see when you have some problem with u r webserver(httpd/Apache)?
      access_log & error_log @IAS_ORACLE_HOME/Apache/Apache/logs
  • When Apache starts what other components its start ?
      PL/SQL Listener, Servlet Engine, OJSP Engine
  • What is jserv?
      jserv is nothing but servlet engine which will run u r servlets. It’s a module of apache which supports servlets.
  • What is self service application?
      Whatever part of u r oracle application u r able to see through web browser is self service.
  • Where u will see when u r not able to get self service applications?
      access_log,error_log, error_pls, jserv.log, wdbsvr.app(for apps password)
  • What is the location of jserv.log?
      IAS_ORACLE_HOME/Apache/Jserv/log
  • What is the location of wdbsvr.app ?
      IAS_ORACLE_HOME/Apache/modplsql/cfg
  • What are jserv.conf and jserv.properties files?
      These are the configuration files which were used to start jvm’s(servlet engine) by apache.
  • What is mean by clearing cache and bouncing apache?
      Stop apache (adapcctl.sh stop apps)
        Clear cache – Go to $COMMON_TOP/html/_pages and delete _oa_html directory
      (rm r _oa__html)
      Start apache (adapcctl.sh start apps)
  • What is forms configuration file and its location?
      appsweb_contextname.cfg @$COMMON_TOP/html/bin
  • What are the different modes u can start u r form server?
      socket and servlet
  • What is the difference beween socket and servlet mode?
      In socket mode forms sessions are represented by f60webmx
      In servlet mode forms sessions are represented by apache processes.
  • What is forms metric server and client?
      When there are more than one form sever instances then forms metric server and client will be used to load balance.
  • Where the forms server related errors will be logged?
      access_log and error_log
  • What is report server configuration and log file name and its location?
      Configuration file – REP_.ora
      Log file – REP_.log @806_ORACLE_HOME/reports60/server
  • What is CGIcmd.dat file and its location?
      CGIcmd.dat file is the run time parameter file the report server located @ 806_ORACLE_HOME/reports60/server
  • What is the significance of DISPLAY variable?
      Vnc server should be up and running at the specified port value in DISPLAY variable, otherwise reportserver may not able to show the graphics in Reports.
  • Where is the concurrent manager log file located?
      $COMMON_TOP/admin//log or $APPLCSF/$APPLLOG
  • Is apps password necessary to start all the components of oracle application?
      No. Only to start/stop concurrent managers apps password is needed.
  • What is a concurrent manager?
      A concurrent manager is one which runs concurrent requests.
  • What are the different types of concurrent managers?
      Internal concurrent manager – Will start all other managers and monitor
      Standard Manager – All concurrent request by default will to go this
      Conflict resolution manager – Concurrent programs with incompatibilities will be handled by this
      Transaction manager – Handle all transaction requests
  • What are actual and target count in “Adminster Concurrent Managers form”?
      Target is the no. of concurrent processes a manager is supposed to start(specified in the definition of concurrent manager). Actual is the no. of processes a manager started actually.
      Target and Actual should be always same.
  • What if Target and Actual are not same?
      It means at operating system level resources are low to accommodate the required processes for concurrent managers.
  • What are work shifts?
      Work shifts are nothing but timings at which the concurrent manager is supposed to run.
  • What if internal concurrent manager target and actual are not same?
      we need to bounce the concurrent manager using adcmctl.sh
  • How to bounce a single concurrent manager?
      From frontend using “Administer Concurrent Manager form”.
  • When we change apps password , is it necessary to bounce application?
      Only we need to bounce concurrent managers.
  • What is dbc file and its location?
      dbc file contain database connection information. DBC file is used by oracle applications to connect to database. Its location is $FND_TOP/secure
  • What is the other script by which u can start apache other than adapcctl.sh?
      apachectl @IAS_ORACLE_HOME/Apache/bin
  • What is the configuration file for PL/SQL listener?
      httpd_pls.conf @IAS_ORACLE_HOME/Apache/Apache/conf
  • How to skip copy portion while applying a patch?
      Adpatch options=nocopyportion
  • How to merge patches and what type of patches can be merged?
      admrgpch. We can merge any kind of application patches, if any of the patch contain a u-driver then merged patch will contain u_merged.drv otherwise c_merged.drv, d_merged.drv and g_merged.drv
  • What is the Tiered architecture of u r instance?
      Two Tier: Web and Forms on one node and Conc, admin and report on other node.
  • How to find formserver version?
      f60gen and press enter, it will tell u the formserver version or we can find out from the frondend using help menu.
  • What is RRA?
      RRA stands for Report Review Agent. RRA is nothing but FNDFS which is part of apps listener. RRA job is to pick the log/out file from the file system and show on the editor when u press view log/out button in “View concurrent request form”.
  • What is apps listener?
      Apps lintener is the combination of FNDFS and FNDSM. FNDSM is service manager which will monitor application services on that node when GSM:enable profile value is “Y”.
  • What is GSM?
      GSM stands for Generic service Manager, which will monitor application processes like web, forms etc and restarts any of this processes if goes down.
  • How to find the application version like 11.5.8/11.5.9*.?
      select release_name from fnd_product_groups;
  • How to find the database/sqlplus version?
      select banner from v$version;
  • How to find out what are the languages enabled in u r applications?
      Query fnd_languages
  • What is the size of u r database?
      200 to 500 GB
  • What are the problems u have faced while shutting down applications?
      While shutting down application generally concurrent manager won’t go down because some or the other request may be running. We will see what are the concurrent requests running by querying fnd_concurrent_requests, fnd_concurrent_program_vl, v$session,v$process and v$sqltext. If that request is only doing some select statement then we will kill those requests, otherwise we will check what time it will take to complete by querying the previous runs of that request and then we will decide what to do.
  • What are the problems u have faced while starting up applications?
      Most of the time we will encounter problem with starting up concurrent managers. Reasons , database listener may be down or FNDSM entries are wrong in tnsnames.ora of 806_ORACLE_HOME.
  • How to find the locks and what is the resolution?
      we can find general locks with the following query:
      select * from sys.dba_dml_locks order by session_id.
      We can find the dead locks with the following query:
      select * from v$lock where lmode > 0 and id1 in (select distinct id1 from v$lock where request > 0)
      If it’s a dead lock, we need to kill that session.
  • How to kill a database session?
      alter system kill session “&sid,&sno”;
  • How to find adconfig is enabled for oracle operating system user/database?
      If appsutil directory is there in RDBMS_ORACLE_HOME
  • Which files tell u the database helath?
      alert log file @RDBMS_ORACLE_HOME/admin//bdump
  • How to apply a rdbms patch?
      Using opatch
  • How to find opatch is enabled or not for u r database?
      If Opatch directory exists under RDBMS_ORACLE_HOME.