Category Archives for Uncategorized
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 MoreOracle 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 MoreBlocks , 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 MoreOracle 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 MoreAutoconfig 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 MoreORADEBUG – 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 MorePerformance – 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: SQL> […]
Read MoreTables Used by Purge Concurrent Request Concurrent Program
Source: Oracle Documentations Log and Output files retention policy can be controlled by you at o/s level. Once you decide the retention policy for these logs and output files, the Purge Concurrent Request Concurrent Program or the Manager Data Concurrent Program will act, based on the information located in the database tables to determine which […]
Read MoreLog files in $APPLCSF/$APPLLOG directory
I would like to share some important things here. You all might know these, but Oracle Apps newbie will get benefited. As we know that, when ever any Concurrent Request is submitted, log and output files are stored in $APPLCSF/$APPLOG and $APPLCSF/$APPLOUT directories respectively. Apart from *.req files, some other files are also getting stored […]
Read MoreOracle Apps DBA Interview/Technical Question : 10g AS with Apps 11i/R12/12i
Here are few more interview question, focused on Oracle 10g Application Server, Apps 11i/r12/12i and integration of Oracle E-Business Suite with 10g AS (Portal/OID/SSO) Q. Explain Architecture of 10g AS A. Infrastructure Tier (MR+IM) & Middle Tier (J2EE, Portal, Wireless, Discoverer, Forms & Reports) Q. Explain broad level steps to install 10g AS A. Install […]
Read More