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 Questions about JAVA/JRE in Oracle Apps

 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 version of JDK   Designates the Java Virtual Machines … Continue reading Top Questions about JAVA/JRE in Oracle Apps »

What is voting disks in RAC

Voting 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 in the cluster are available via communication through … 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

R12.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 Step by step upgrade process for R12.2 Upgrade … Continue reading Step by step upgrade process for R12.2 Upgrade Part -4 »

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

R12.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 Step by step upgrade process for R12.2 Upgrade … Continue reading Step by step upgrade process to R12.2 Upgrade part -3 »

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

R12.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 publishing the step 2 in this part Step … Continue reading Step by step upgrade process to R12.2 Upgrade part -2 »

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

R12.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 step upgrade process for R12.2 Upgrade Part -1 … Continue reading Step by step upgrade process for R12.2 Upgrade Part -1 »

How to alter table add column oracle

-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 alteration of the base table or its columns … Continue reading How to alter table add column oracle »

Top AWR useful queries for R12.2/R12.1 Upgrade

R12.1/R12.2 are pretty big  and time consuming upgrade. We need to find all the long running sql in order to resolve the  R12.2 upgrade performance issues. Since each iteration takes lot of time,it is important ,we tried to find out the performances issues in less iterations. Here are Top AWR useful queries to solve R12.2 upgrade performance issues If SQL is still in memory (cursor cache) the following … Continue reading Top AWR useful queries for R12.2/R12.1 Upgrade »

R12.2 RapidWiz Installed Components and System Requirements

R12.2 is the latest release of Oracle EBS. Here are R12.2 RapidWiz  Installed Components and System Requirements Technology Stack Components For a new Release 12.2 installation, Rapid Install automatically installs and configures the required technology stack components for both the database tier and the application tier. On the database tier, the technology stack includes: Oracle Database 12c Release 1 (12.1.0.2)  (  This is when we don’t … Continue reading R12.2 RapidWiz Installed Components and System Requirements »

Awesome Information on HOTPATCH mode in adop

What is Hotpatch mode in R12.0/R12.1 We add hotpatch to the adpatch option list to apply the patches in the environment without putting it into Maintainance Mode.  This  was quite widely used by the customer to apply the small patches to the environment. This seems to have worked in many cases with out issues. Customer upgrading to R12.2 may tend to use the same practice. … Continue reading Awesome Information on HOTPATCH mode in adop »