Oracle 11g Architecture Diagram with Explanation. In below flash video, you can get all Dynamics Views, Background Components and Background Processes. For Flash Video: 11g Interactive in Flash To Download in PDF : 11g Architecture in PDF Soon I will upload for Oracle 12c also. Cheers !!!!
Articles Tagged: ORACLE 11g
Background Processes in Oracle RAC
Oracle RAC Background Processes Image Source The GCS and GES processes, and the GRD collaborate to enable Cache Fusion. The Oracle RAC processes and their identifiers are as follows: 1. ACMS: Atomic Controlfile to Memory Service (ACMS) In an Oracle RAC environment, the ACMS per-instance process is an agent that contributes to ensuring a distributed […]
Startup And Shutdown Modes Of An Oracle Database
An oracle database can be started in various modes. Each mode is used by the DBA’s to perform some specific operation in the database. Nomount State: We can bring database to nomount state from shutdown state. When we start an oracle database in nomount state then oracle will create the oracle instance. The instance is […]
RAC : 11gR2 Clusterware Startup Sequence
Here is the brief explanation that how the clusterware brings up step by step . 1. When a node of an Oracle Clusterware cluster start/restarts, OHASD is started by platform-specific means. OHASD is the root for bringing up Oracle Clusterware. OHASD has access to the OLR (Oracle Local Registry) stored on the local file system. […]
Back Up & Restore an Oracle ASM Password File with pwget Command
In this article we are showing how to backup and restore password file of Oracle ASM with pwget command. pwget Purpose Returns the location of the password file for the Oracle ASM or database instance. pwcopy Purpose Copies an Oracle ASM or database instance password file to the specified location. pwset Purpose Sets the location […]
Different ways to find spfile location in Oracle RAC
1. By using SqlPlus $ sqlplus / as sysasm SQL> show parameter spfile NAME TYPE VALUE —— —— ————————————————- spfile string +DATA/ASM/ASMPARAMETERFILE/registry.253.822856169 SQL> 2. By using ASMCMD find command $ asmcmd find –type ASMPARAMETERFILE +DATA “*” +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.822856169 3. By using spget command ASMCMD> spget +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.822856169 […]
Use spget and spmove command in Oracle ASM
Starting with ASM version 11.2, the ASM spfile can be stored in an ASM disk group. Indeed, during a new ASM installation, the Oracle Universal Installer (OUI) will place the ASM spfile in the disk group that gets created during the installation. New ASMCMD commands To support this feature, new ASMCMD commands were introduced to […]
Rename Empty Diskgroup on ASM 11gR2
The goal here is to rename the DATA diskgroup to DG_PROD_DATA – here is the situation before the rename operation : # asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 4096 1048576 32756 31828 244 15792 0 N DATA_OCR/ MOUNTED EXTERN N 512 4096 1048576 16378 […]
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). [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 […]
Separating OCR and Voting Disk in Oracle Clusterware 12c
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Objective: Describe the advantages of separating OCR and RV and also present the process needed to do this. NOTE: Although the procedure was performed in version 11gR2, the steps are the same for version 12c. In this article, we will […]