Cloning is the act of creating an identical copy of an already existing Oracle Applications system. Simply copying all of the components from source to target system does not provide us a working Oracle Applications system, there are various configuration files that must be changed & for this purpose we do Cloning. Do keep […]
Read MoreHere 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 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 MoreDBA’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 MoreOn 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 MoreWe 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 MoreIn 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 MoreApplication 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 Moreoradebug 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 MorePatch 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