1.What is Partition Pruning ? Oracle optimizes SQL statements to mark the partitions or subpartitions that need to be accessed and eliminates (prunes) unnecessary partitions or subpartitions from access by …
Read More »Real Application Cluster(RAC) Interview Questions Part 5
1.What is a diskgroup in ASM? A disk group consists of multiple disks and is the fundamental object that ASM manages. Each disk group contains the metadata that is required …
Read More »Unable to determine SMTP server to use: set FND_SMTP_HOST
ERROR Unable to determine SMTP server to use: set FND_SMTP_HOST Outpost Processor has encountered the below error. This error can be found in OPP logs: —————————————- [GC 14000K->8905K(20284K), 0.0074280 secs] ProcessorException: Unable …
Read More »Error Occurred While Attempting to Establish an Applications File Server Connection
ERROR ” An error occurred while attempting to establish an Applications File Server connection. There may be a network configuration problem, or the TNS listener may not be running on ” Solutions …
Read More »Forms Servlet mode to Socket mode conversion on Release 12 Apps
Forms Servlet mode to Socket mode conversion on Release 12 Apps Run the following command to enable Forms Socket Mode on Forms/web nodes (Place correct context file name and port …
Read More »Unable To Create New Legal Entities – ORA-06512: at “CTXSYS.DRVDML”
ERROR Unable To Create New Legal Entities – ORA-06512: at “CTXSYS.DRVDML” , ORA-06512: at “HR.DR$HR_LOCATIONS_N1TC
Read More »Real Application Cluster(RAC) Interview Questions Part 4
1.What is dynamic remastering? When will the dynamic remastering happens? Dynamic Remastering is ability to move the ownership of resource from one instance to another instance in RAC. Dynamic Resource …
Read More »Introduction to Oracle Applications
Introduction to Oracle Applications
Read More »Real Application Cluster(RAC) Interview Questions Part 3
1.How would to find location of OCR file when CRS is down?
Read More »General Ledger Interview Questions Part 7
1.What is journal, how many types of journal?
Read More »