Author: techgoeasy

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 »

Helpful Free Courses on Udemy

About UdemyUdemy.com is an online learning platform. It is aimed at professional adults who want to add new skills to their resumes, or explore their passions.[1] Unlike academic MOOC programs driven by traditional collegiate coursework, Udemy provides a platform for experts of any kind to create courses which can be offered to the public, either at no charge or for a tuition fee.[2] Udemy provides … Continue reading Helpful Free Courses on Udemy »

Virtual IP Addresses(VIP) in Oracle RAC

What 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 listeners on all cluster nodes. TNS descriptors for … Continue reading Virtual IP Addresses(VIP) in Oracle RAC »

Top Questions about JAVA/JRE in Oracle Apps

Last updated on April 1st, 2017 at 08:06 am  1) What is the JDK and the JRE? JDK(SDK): Java (Standard) Developer Kit. JRE: Java Runtime Environment This is the full suite of Java products necessary for development in Java.    Designates the set of tool necessary for developing in Java. It includes its own JRE, development libraries, JAVA compiler (javac)… It is a scaled down … Continue reading Top Questions about JAVA/JRE in Oracle Apps »

What is voting disks in RAC

Last updated on April 1st, 2017 at 08:09 amVoting Disks in RAC Description Voting disk is a file that manages information about node membership.It is located on the shared cluster system or a shared raw device file or ASM(11gr2 onwards) .Its primary purpose is to help in a situation where the private network communication fails.CSS (Cluster Synchronization Service) is the service that determines which nodes … Continue reading What is voting disks in RAC »

Demonstration/Viewlet/Videos for Many Oracle features

Oracle has provided lot  of Demonstration/Viewlet/Videos on Oracle features like RMAN,Flashback,standby etc Each demonstration has a description and links to the demo.  Some demos have a ‘demo’ link that will play in your browser on any platform.  Others have a ‘download’ link which will download an executable file to your computer that will only play on a Windows system. Some demos offer both options. Here … Continue reading Demonstration/Viewlet/Videos for Many Oracle features »

A great overview about Oracle cursors

Oracle Cursor Oracle Uses work area called Private SQL areas to execute SQL Statements and store information. A Oracle Cursor is a PL/SQL construct that allows you to name these work areas, and to access their stored information Types of Cursor Implicit Cursors Explicit Cursors   Implicit cursors Explicit Cursors Implicit Cursor are declared by PL/SQL implicitly for all DML Statements and for single row … Continue reading A great overview about Oracle cursors »

Step by step upgrade process for R12.2 Upgrade Part -4(Applying 12.2.6 Release Update Pack)

Last updated on April 14th, 2017 at 02:35 pmR12.2 Upgrade consists of following part Pre Upgrade preparation steps Main upgrade  using Main Upgrade Driver for R12.2.0 (merged with pre-installed Oracle E-Business Suite Consolidated Upgrade Patch for R12.2.0) Online Patching Enablement Applying the latest  R12.AD.C.Delta.n and R12.TXK.C.Delta.n Applying 12.2.n Release Update Pack (RUP) We have already taken care of part 1 , 2,3 in previous Post … Continue reading Step by step upgrade process for R12.2 Upgrade Part -4(Applying 12.2.6 Release Update Pack) »

Step by step upgrade process to R12.2 Upgrade part -3

Last updated on April 14th, 2017 at 02:32 pmR12.2 Upgrade consists of following part Pre Upgrade preparation steps Main upgrade  using Main Upgrade Driver for R12.2.0 (merged with pre-installed Oracle E-Business Suite Consolidated Upgrade Patch for R12.2.0) Online Patching Enablement Applying the latest  R12.AD.C.Delta.n and R12.TXK.C.Delta.n Applying 12.2.n Release Update Pack (RUP) We have already taken care of part 1 and 2 in previous Post … Continue reading Step by step upgrade process to R12.2 Upgrade part -3 »

Step by step upgrade process to R12.2 Upgrade part -2(Main Upgrade Driver for R12.2.0)

Last updated on April 14th, 2017 at 02:30 pmR12.2 Upgrade consists of following part Pre Upgrade preparation steps Main upgrade  using Main Upgrade Driver for R12.2.0 (merged with pre-installed Oracle E-Business Suite Consolidated Upgrade Patch for R12.2.0) Online Patching Enablement Applying the latest  R12.AD.C.Delta.n and R12.TXK.C.Delta.n Applying 12.2.n Release Update Pack (RUP) We have already taken care of part 1 in previous Post We are … Continue reading Step by step upgrade process to R12.2 Upgrade part -2(Main Upgrade Driver for R12.2.0) »

Step by step upgrade process for R12.2 Upgrade Part -1

Last updated on April 14th, 2017 at 02:21 pmR12.2 Upgrade consists of following part Pre Upgrade preparation steps Main upgrade  using Main Upgrade Driver for R12.2.0 (merged with pre-installed Oracle E-Business Suite Consolidated Upgrade Patch for R12.2.0) Online Patching Enablement Applying the latest  R12.AD.C.Delta.n and R12.TXK.C.Delta.n Applying 12.2.n Release Update Pack (RUP) We will be taking care of step 1 in this post. Step by … Continue reading Step by step upgrade process for R12.2 Upgrade Part -1 »

How to alter table add column oracle

Last updated on April 1st, 2017 at 08:11 am-You Add a new column using the ALTER TABLE statement. – The table must be contained in your schema To alter a table, or you should either have  ALTER object privilege for the table or the ALTER ANY TABLE system privilege. -If a view, materialized view, trigger,  function-based index, check constraint, function, procedure of package depends on a base table, the … Continue reading How to alter table add column oracle »