This article is about upgrade of oracle database 11.2.0.1_to 11.2.0.4). [oracle@india2 grid]$ ./runcluvfy.sh stage -pre crsinst -upgrade -n india1,india2 -rolling -src_crshome /u01/11.2.0/grid -dest_crshome /u01/11.2.4/grid -dest_version 11.2.0.4.0 -fixup -fixupdir /home/oracle/logs -verbose |tee /home/oracle/logs/runcluvfy1210.out [oracle@india2 logs]$ more runcluvfy.out |grep -i ‘failed’ india2 missing 9413827 or 9706490 failed india1 missing 9413827 or 9706490 failed Result: Check for Oracle patch […]
All posts by Anuradha Mudgal
Anuradha Mudgal
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 […]
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 […]
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 […]
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. […]
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 […]
RMAN BACKUP Scripts
~~~~~~~~~~~~~~~~~~~~~~~~ # RMAN backup history ~~~~~~~~~~~~~~~~~~~~~~~~ set lines 150 set pages 900 col start for a20 col end for a20 col status format a11 col input_bytes_display format a10 col output_bytes_display format a10 col status_weight format 99999 SELECT to_char(start_time,’YYYY.MM.DD HH24:MI:SS’) “Start” , to_char(end_time,’YYYY.MM.DD HH24:MI:SS’) “End”, status, status_weight, input_type, input_bytes_display, output_bytes_display FROM V$RMAN_BACKUP_JOB_DETAILS WHERE ( start_time between […]
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 […]
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 […]
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 […]