Upgrade Oracle Grid and Database (11.2.0.1 to 11.2.0.4)

This article is about upgrade of oracle database 11.2.0.1_to 11.2.0.4).

Download the 9413827 or 9706490 patch from oracle support and get apply

Below are attachment to findout patch steps. Now we can update the grid home and oracle home from 11.2.0.1 to 11.2.0.4 .

1) check the pre-req before upgrading the grid home […]

Read More

Converting Standard to Flex Cluster

Introduction Oracle Real Application Cluster (RAC) is a well-known product among Oracle’s solutions to maintain high availability of your business data. Oracle RAC allows the work load to be shared among all the cluster nodes, with N-1 tolerance configuration in case of node failures, where N is the total number of nodes. Oracle RAC is […]

Read More

Converting Standard to Flex ASM

Today we are going to have a look on converting a standard cluster to flex cluster. I wish this information is useful for you.Oracle Flex Clusters contribute a platform for Oracle Real Application Clusters databases with stupendous numbers of nodes, to support massive parallel query operations. Oracle Flex Clusters also provide a platform for other […]

Read More

Oracle Upgrade Grid and Database Home to 12.1.0.2 with GUI

What is Upgration? It is the process of replacing your existing software with an advance version of the identical product.Upgrading your applications usually do not require special tools. Your existing reports should look and behave the same in both products. For Example: Replacing Oracle 9i release to Oracle 10g release, SQL Server 2005 to SQL Server 2008 etc. Why […]

Read More

HTML-Based Application Architecture

Introduction:-  In this article, we are going to learn about HTML-Based Application Architecture. Later on, we will learn about its working process. Being an Application DBA we have knowledge of Oracle Application Architecture. Now we have look on HTML-Based Application Architecture. Oracle HTML-based application are those designed in pure HTML and JavaScript. They dynamically generate HTML pages by executing Java code. […]

Read More

11i and R12 Environment Files/Variables Changes Comparison

Introduction:-  Today we are going to learn about environment files/variables in Oracle application.  Before we go a head we must know what is environment variables An environment variable is a vigorous “object” on a computer that reserves a value, which in turn can be referenced by one or more software programs in Windows. Environment variables succor programs know […]

Read More

RMAN BACKUP Scripts

~~~~~~~~~~~~~~~~~~~~~~~~ # RMAN backup history ~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ # This script will report on all backups – full, incremental and archivelog backups – ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ # This script will report all on full and incremental backups, not archivelog backups – ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ RMAN Incremental Report Generation Query ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Read More

COMPRESSED INCREMENTAL BACKUP

We need compressed full and incremental backup to apply in standby site and for make restoration faster INCREMENTAL LEVEL 0 BACKUP RUN { BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG; DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DISK; } INCREMENTAL LEVEL 1 BACKUP RUN { BACKUP AS COMPRESSED BACKUPSET INCREMENTAL […]

Read More

RECOVER ORACLE DATAFILES WITH NO DOWNTIME

What will happen if dbf file accidentally deleted when the database is still open and how to recover it? On Unix/Linux, when a file is deleted, but a process still has the file open, the file is still there in the filesystem, and only the inode is removed. But the process can continue to use […]

Read More

ERP (Enterprise resource planning)

Introduction:-  Any business achieves their goal by performing multiple activities.  Business is complete itself when it performs all kind of operations properly. The economy of the nation depends on its business’s structure and its growth. Two thousand years ago, India and the East Asian countries had almost 60 per cent share of the world economy. If lookup […]

Read More