Cloud Computing Cloud Computing is often described as a stack, as a response to the broad range of services built on top of one another under the moniker “Cloud”. The generally accepted definition of Cloud Computing comes from the National Institute of Standards and Technology (NIST), essentially says that; Cloud computing is a model for […]
All posts by Skant Gupta
New Background Processes in Oracle 12c
List of New Background Processes in Oracle 12c Name Expanded Name Short Description Long Description External Properties AQPC AQ Process Coordinator Per instance AQ global coordinator AQPC is responsible for performing administrative tasks for AQ Master Class Processes including commands like starting, stopping, and other administrative tasks. This process is automatically started on instance startup. […]
Background Processes in Oracle ASM
Once the ASM instance is started, all the basic background processes, as well as some that are specific to the operation of ASM, are started. Notice that all the ASM processes begin with asm, whereas the RDBMS instance processes begin with ora. On Unix, the ASM processes can be listed using the following command: ps […]
Oracle 11g Architecture Diagram with Explanation
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 !!!!
Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS )
This article was written by Skant Gupta and Joel Perez in Oracle OTN When creating an Oracle Database Cloud Service database deployment at the Oracle Database Cloud Service level, you can create an Oracle Data Guard configuration. Since we will talk about Oracle Data Guard, let’s remember the concept: Oracle Data Guard enables production Oracle databases to survive disasters and […]
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 […]
Migrating Oracle ASM Disk Groups without OCR or Voting Files
To migrate Oracle ASM disk groups without Oracle Cluster Registry (OCR) or voting files to Oracle ASMFD: Log in as the Oracle Grid Infrastructure owner on any node to run the commands in this procedure. List the existing disk groups: $ $ORACLE_HOME/bin/asmcmd lsdg List the associated disks: $ $ORACLE_HOME/bin/asmcmd lsdsk -G diskgroup Check if Oracle […]
Quiescing a Oracle Database
There are times when a DBA needs to perform work on the database that requires no other ACTIVE sessions. This is very common is development databases, where a DBA tries to run a package or a modify a table when the application is till running. There are also frequent occurrences where too much IT support […]
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. […]