Oracle Database can be migrated Non ASM to ASM storage using RMAN command, asmcmd and dbms_file_transfer. With 12c onwards, we can even migrate using the online move datafile command to minimize the downtime. Here in this post, I am concentrating on RMAN methods. How to migrate Oracle database to ASM storage using RMAN There are […]
How to migrate Oracle database from Non ASM to ASM storage Read More »
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
Socket mode for forms in R12 Read More »
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
Oracle partition index Read More »
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
