Below section I have tried to present all the important features in Oracle Database management
Step 1: Prepare the server to be added a) Shared the Database Storage b) Shared the OCR and voting disk c) Check the new box for ssh connectivity Step 2: Run cluvfy cluvfy stage -post hwos -n SUN12OS Step 3: Add node to Cluster using the $ORACLE_HOME/oui/bin/addnode.sh from the node existing in cluster And choose …
How to add any node to Oracle RAC cluster in 10g and 11g Read More »
How to setup diag wait in cluster 1. Execute as root#crsctl stop crs #/bin/oprocd stop 2. Ensure that Clusterware stack is down on all nodes by executing #ps -ef |egrep “crsd.bin|ocssd.bin|evmd.bin|oprocd” This should return no processes. If there are clusterware processes running and you proceed to the next step, you will corrupt your OCR. Do …
There is one important attribute in 11gR2 cluster ie. AUTO_START We can check it using following command $ crsctl status resource ora.TEST.db -p | grep AUTO_START AUTO_START=restore – always: Restarts the resource when the server restarts regardless of the state of the resource when the server stopped. – restore: Restores the resource to the same …
why-database-not-startup-automatic in 11gR2 cluster Read More »
What is Oracle cluster The Oracle Clusterware was introduced in 10.1 (initially called CRS ) and is the product that lies under RAC. It enables servers to operate together as if they are one server. Each server looks like any standalone server. However, each server has additional processes that communicate with each other so the …
Prior to 10g, every query must be re-executed even if there is no change in the tables. This reexecution is unnecessary for few static tables and only caching using at client tools resolve this issue. But, in 11g, query results can be cached in SGA. Just to avoid confusion, this is much different from buffer …
