Category Archives: Oracle

ORACLE TUTORIALS

Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction

Here I am presenting the Oracle tutorials on Various Oracle products

  1. Oracle database
  2. Oracle sql/plsql
  3. Oracle application
  4. Weblogic
  5. Performance tuning.

These articles will be  really help in understanding the oracle products and getting started on Oracle system

Top 115 HFM Interview Questions And Answer Part-2

Last updated on September 5th, 2017 at 05:33 pmHere we are starting the series on hfm interview questions and answers. We would be presenting 115 frequently asked HFM interview questions in Four part series Top 115 HFM Interview Questions Part-1 Top 115 HFM Interview Questions And Answer Part-2 Top 115 HFM Interview Questions Part-3 Top 115 HFM interview questions Part-4 Here is Part -2 Questions. … Continue reading Top 115 HFM Interview Questions And Answer Part-2 »

Top 115 HFM Interview Questions Part-1

Last updated on September 5th, 2017 at 05:32 pmHere we are starting the series on HFM Interview questions. We would be presenting 115 frequently asked HFM interview questions in Four part series Top 115 HFM Interview Questions Part-1 Top 115 HFM Interview Questions And Answer Part-2 Top 115 HFM Interview Questions Part-3 Top 115 HFM interview questions Part-4   Here is Part -1 Questions. Question … Continue reading Top 115 HFM Interview Questions Part-1 »

Oracle Cloud :Infrastructure-as-a-Service Concepts

Oracle Cloud:Infrastructure-as-a-Service Overview Oracle’s Infrastructure-as-a-Service (IaaS) provides a complete infrastructure for enterprise workloads, including compute services, storage services, and network services. It enables organisation to run any type of workload in the cloud and in particular run Oracle workloads in the most optimized way. This gives an excellent option to clients to not purchase hardware and instead can purchase IaaS resources based on consumption IaaS … Continue reading Oracle Cloud :Infrastructure-as-a-Service Concepts »

All Useful 11g Dynamic Performance Views

What is Oracle Dynamic Performance Views Oracle Dynamic Performance Views is a set of views(V_$) which are defined over very low level Oracle views called the X$ views View. We have views for complete set of operations. V$ names are synonyms which point to the V_$ views What is X$view :The X$ views are very low level representations of Oracle internal database structures. They are … Continue reading All Useful 11g Dynamic Performance Views »

Top 46 Oracle ASM Interview Questions

Oracle ASM is widely used in IT industry. Here I have compiled Top 46 Oracle ASM Interview Questions to enhance the knowledge about Oracle ASM instance Question 1 What is ASM in Oracle? Answer Oracle ASM is Oracle’s volume manager specially designed for Oracle database data. It is available since Oracle database version 10g and many improvements have been made in versions 11g release 1 and … Continue reading Top 46 Oracle ASM Interview Questions »

Troubleshooting 12c database issues with EBS

Here is the compilation of known 12c database issues with EBS. Hope it helps Issue 1 The database was recently upgraded from 11g to 12c, and when trying to register database to sso using: $FND_TOP/bin/txkrun.pl the following error is received: ‘ORA-28040: No matching authentication protocol’ Resolution:To resolve the issue test the following steps in a development instance and then migrate accordingly: Copy ojdbc6.jar and orai18n.jar into … Continue reading Troubleshooting 12c database issues with EBS »

Awesome 24 Concurrent Manager Interview questions

Here are awesome 24 Concurrent Manager Interview questions asked in most interview to test concurrent Manager working skills   Question 1: What are different types of concurrent manager? Answer There are several types of concurrent manager. Important ones: Internal Manager Standard Manager. Conflict Resolution Manager Internal monitors Service Manager Transaction Manager Custom Manager Defined Read more on below link Oracle Concurrent Manager Question 2: What is … Continue reading Awesome 24 Concurrent Manager Interview questions »

How to create DMZ for EBS R12

This post I will explaining my experience with setting up DMZ for EBS R12. We will first go through some of the important terms DMZ The DMZ, which stands for Demilitarized Zone consists of the portions of a corporate network that are between the corporate intranet and the Internet. The DMZ can be a simple one segment LAN or it can be broken down into … Continue reading How to create DMZ for EBS R12 »

Pre-Built Oracle database for learning and testing using Oracle Developer VM

Oracle developer day pre-installed virtual machine is very useful to perform lab testing on Oracle database. It is very helpful for practicing about Oracle database on Linux machine on your laptop. You can also export your application database and import into this pre-installed oracle VM, It is very quick and easy to setup. Here is the steps to setup Oracle developer day VM  Please note that … Continue reading Pre-Built Oracle database for learning and testing using Oracle Developer VM »

Top FAQ about Oracle E-Business Suite on Oracle Cloud

Oracle E-Business Suite on Oracle Cloud is the simply using the IAAS  and PAAS model with the Oracle Cloud. You are basically transferring your very own EBS instance on Oracle cloud Infrastructure.This is different from ERP /SCM SAAS  model  provided by the Oracle Here are some important Faq to clear your confusion surrounding EBS on Oracle cloud 1. What is Oracle E-Business Suite on Oracle … Continue reading Top FAQ about Oracle E-Business Suite on Oracle Cloud »

All about FNDLOAD command and WFLOAD command

INTRODUCTION TO FNDLOAD The loader is a general-purpose utility that moves structured data between a text file and a database. Structures supported by the loader include master-detail relationships, and foreign key reference relationships, including arbitrary chains of said relationships. The loader operates in one of three modes: download, upload, or upload_partial. In the download mode, data is downloaded from the database to a text file; … Continue reading All about FNDLOAD command and WFLOAD command »

Virtual IP Addresses : VIP in Oracle RAC

Last updated on September 17th, 2017 at 05:42 pmWhat is VIP in Oracle RAC? High Availability (HA) databases are less than satisfactory if database clients are unable to connect or reconnect quickly when planned or unplanned downtime causes one or more instances to become unavailable. Database clients use TNS descriptors to contact a TNS listener on one of the cluster nodes from a list of … Continue reading Virtual IP Addresses : VIP in Oracle RAC »