Folks at this stage I feel that we should go with the example, and best way to learn the coding part of any language is Hello World program. So here I will discuss about the same.So be ready with the Jdeveloper and demo instance and create the program with me. Step-1 Open the Jdeveloper tool […]
Read MoreIn the previous post we have seen how to compile and overview of deploying BPEL process. Now we will see various ways to deploy BPEL suitcase to specific domain. Just an refresh of BPEL suitcase. We know it is BPEL process archives + Components Now these are the ways in which we can deploy: Using Orcle […]
Read MoreAfter designing BPEL process it goes through following stages: Validate -> Compile -> Deploy During Compilation following activities happens: BPEL process archives + Components =JAR file known as BPEL Suitcase BPEL Suitcase consist of following files: .bpel .wsdl .xml Schemas, java file etc. Deploying is nothing but a copying the above JAR file to deploy folder […]
Read MoreCloning 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 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 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 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 MoreSource: 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 More