Oracle EBS File system has APPL_TOP,COMMON_TOP, ORACLE_HOME, IAS_ORACLE_HOME( R12/R12.1) , MIDDLEWARE_HOME(R12.). We have run filesystem and Patch filesystem in R12.2 also. There are many product directories inside APPL_TOP and Each Product directories has many directory and files inside them. We have more than 200 product directories and Each of these has similar structure. I have …
Oracle EBS file system(Product Top) Read More »
Introduction of Socket mode for forms Forms by default run in Servlet mode in R12 and above as this is the preferred and recommended deployment model for deploying forms on the web. In this mode, there is a java Servlet called the Forms Listener Servlet, manages the communication between the Forms Java Client and OracleAS …
Default tablespace How to find the default tablespace at the Database level Values of the current setting of the Default can be found using the below queries COLUMN property_name FORMAT A30 COLUMN property_value FORMAT A30 COLUMN description FORMAT A50 SET LINESIZE 200 SELECT * FROM database_properties WHERE property_name like ‘%TABLESPACE’; PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ———— ————- …
How to check default tablespace in Oracle database Read More »
In the previous article, we learned about Oracle Partitioned table. In continuation of that series,i will here be presenting the Oracle partition index Here are the some of facts about Understanding Partitioned Indexes Local Partition Indexes A local index on a partitioned table is created where the index is partitioned in exactly the same manner as …
INTRODUCTION TO WFLOAD COMMAND The WFLOAD command/ loader (workflow definitions loader) is a utility that moves workflow data between a file and a database. It is used to upgrade,upload and download the workflow data. It is located in $FND_TOP/bin DOWNLOAD The download operation of the loader is invoked in the following manner: WFLOAD logon [0 …
This is a small compilation of Oracle RAC interview Questions which include both the Oracle RAC-specific questions and Oracle Clusterware questions. This is good for experienced level Professional Oracle RAC-specific Questions Question 1. What are Oracle RAC and its uses? Answer Oracle RAC is a cluster database where multiple instances of Oracle run multiple nodes …
Oracle RAC interview Questions Read More »
