Interview Questions For Freshers(0-6 months) Oracle Apps DBA 11i/R12/12i

Here i am listing some very general interview questions for Oracle Apps DBA with 0-6 months experience : Ques 1 Where are the front end user details stored? The front end user details are stored in table fnd_user in database. You can query the database for the details you want to know as follows: logon […]

Read More

Oracle Identity Manager 9.1 released

Oracle Identity Manager is Identity Provisioning & Reconciliation software from Oracle and is part of Oracle Identity Management (IdM) product stack (which in turn is part of Oracle Fusion Middleware).       Oracle Identity Manager is built on Thor Exellerate acquired by Oracle. Oracle Identity Manager version 9.1 is released and now available to download from here For […]

Read More

Oracle Apps 11i DBA Training

DBA’s who wish to quickly learn and upgrade their skillset to Apps DBA, onlineAppsDBA team is offering an intensive online training for 11i Apps DBA (Architecture, Installation, Patching, Cloning, Maintenance). For entire course content click here This course is useful for quick understanding of Oracle Applications 11i from Apps DBA’s eye, useful if you are […]

Read More

Blocks , Extents, Segments in Oracle Database : Back to Basics

On popular demand from our newbie DBA readers, I am starting Oracle Database Back to Basics series where I am going to cover basic concepts and Architecture of Oracle Database (9i, 10g, 11g) Today’s post is dedicated to logical storage component of Oracle Database i.e. Data Blocks, Extents and Segment A. Data Blocks is smallest […]

Read More

Oracle Data Mining and Oracle SOA Suite Job

We are looking for part time/full time consultants in following domain, if you have necessary skills please forward your CV to email id cv @ focusthread.com   ( cv  at focusThread dot com) – Oracle Data Mining : Consultant with minimum three years experience on Oracle 9i/10g Data Mining feature – Oracle SOA Suite : Developers/Administrators with exposure to […]

Read More

Autoconfig in Oracle Apps 11i / R12 / 12i

In Oracle Applications 11i & R12 (12i) all the configuration parameters are captured in two context files: Application context file called the <CONTEXT_NAME>.xml contains the configuration information for the application tier & is located in $APPl_TOP/admin for each node of application tier. Database context file called the <CONTEXT_NAME>.xml contains the configuration information for the database […]

Read More

Enterprise Manager – iAS Console : Changes in 10.1.3

Application Server Control : is application used to maintain Oracle Application Server. Using Application Server Control, you can  – Start/Stop Services of Oracle Application Server (OC4J, HTTP, Web Cache, OID, SSO..) – Configure components of OAS (Oracle Application Server) – Manage/edit users credentials, configuration file, port number – Monitor performance & Usages … Start/Stop Application Server […]

Read More

ORADEBUG – Oracle Utility

 oradebug iutility s especially useful when  things go very bad for example Database hangs,Due to ORA-00600 error your database is crashing frequently, Database just not responding (stop). With oradebug you can see very close view database engine. Oracle Customer support use the utility mainly to debug these issues. You should have sysdba privilege to run this […]

Read More

Oracle PATCHING : adpatch , Maintenance Mode

Patch is a program to fix a particular problem or enhance/add a particular feature in existing program/product/software. In Oracle to apply database patch we use ‘opatch‘ ($ORACLE_HOME/OPatch) where as in order to apply applications patch we use ad utility ‘adpatch‘ ($AD_TOP/bin). For Basic Apps patches terminology & other related details please refer to the following […]

Read More

Performance – Transfering Stats 11i

Source: Oracle Documentations It is possible to transfer statistics between servers allowing consistent execution plans between servers with varying amounts of data. First the statistics must be collected into a statistics table. In the following examples the statistics for the APPSCHEMA user are collected into a new table, STATS_TABLE, which is owned by DBASCHEMA:   […]

Read More