Explore topic-wise InterviewSolutions in .

The cluster STACK will be down due to the fact that cssd is unable to MAINTAIN the integrity, this is true in 10g, from 11gR2 onwards, the crsd stack will be down, the house still up and running. You can ADD the OCR BACK by restoring the automatic backup or import the manual backup.

The cluster stack will be down due to the fact that cssd is unable to maintain the integrity, this is true in 10g, from 11gR2 onwards, the crsd stack will be down, the house still up and running. You can add the OCR back by restoring the automatic backup or import the manual backup.

Yes, as per documentation, if you have multiple voting disk you can add ONLINE, but if you have only one voting disk, by that cluster will be down as its lost you just NEED to start crs in exclusive mode and add the vote disk USING

crsctl add vote disk <PATH&GT;

Yes, as per documentation, if you have multiple voting disk you can add online, but if you have only one voting disk, by that cluster will be down as its lost you just need to start crs in exclusive mode and add the vote disk using

crsctl add vote disk <path>

CRSCTL ENABLE CRS (as ROOT)

to DISABLE

crsctl disable crs (as root)

crsctl enable crs (as root)

to disable

crsctl disable crs (as root)

CRSCTL stop cluster (possible only from 11gr2), please note crsctl commands BECOMES global now, if you do not specify node specifically the command executed GLOBALLY

for example:

• crsctl stop crs (stops in all crs resource in all NODES).
• crsctl stop crs –n <neonate) (stops only in specified node).

crsctl stop cluster (possible only from 11gr2), please note crsctl commands becomes global now, if you do not specify node specifically the command executed globally

for example:

With Oracle Cluster ware 11g release 2, Oracle Universal Installer (OUI) detects when the minimum requirements for an INSTALLATION are not met, and creates shell scripts, called fixup scripts, to finish incomplete system configuration steps. If OUI detects an incomplete task, then it generates fixup scripts (runfixup.sh). You can run the fixup SCRIPT after you click the Fix and Check Again Button.

The Fixup script does the FOLLOWING:

If necessary sets kernel parameters to VALUES required for successful installation, INCLUDING:

• Shared memory parameters.
• Open file descriptor and UDP send/receive parameters.

Sets permissions on the Oracle Inventory (central inventory) directory. Reconfigures primary and secondary group memberships for the installation owner, if necessary, for the Oracle Inventory directory and the operating system privileges groups.

• Sets shell limits if necessary to required values.

With Oracle Cluster ware 11g release 2, Oracle Universal Installer (OUI) detects when the minimum requirements for an installation are not met, and creates shell scripts, called fixup scripts, to finish incomplete system configuration steps. If OUI detects an incomplete task, then it generates fixup scripts (runfixup.sh). You can run the fixup script after you click the Fix and Check Again Button.

The Fixup script does the following:

If necessary sets kernel parameters to values required for successful installation, including:

Sets permissions on the Oracle Inventory (central inventory) directory. Reconfigures primary and secondary group memberships for the installation owner, if necessary, for the Oracle Inventory directory and the operating system privileges groups.

1. Each cluster node has a local registry for node-specific RESOURCES.
2. The OLR should be manually created after installing Grid Infrastructure on each node in the cluster.
3. One of its functions is to facilitate Cluster ware startup in situations where the ASM STORES the OCR and voting disks.
4. You can CHECK the status of the OLR using ocrcheck.

In 10g its not possible, where in 11g it is possible

[ROOT@pic1]# crsctl START CLUSTER -all

[root@pic2]# crsctl stop cluster –all

In 10g its not possible, where in 11g it is possible

[root@pic1]# crsctl start cluster -all

[root@pic2]# crsctl stop cluster –all

$ cluvfy COMP nodecon -N all –verbose

$ cluvfy comp nodecon -n all –verbose

To add a SCAN VIP resource:

• $ SRVCTL add scan -n cluster01-scan

To remove Cluster ware resources from SCAN VIPs:

• $ srvctl remove scan [-F]

To add a SCAN listener resource:

• $ srvctl add scan listener
• $ srvctl add scan listener -p 1521

To remove Cluster ware resources from all SCAN listeners:

• $ srvctl remove scan listener [-f]

To add a SCAN VIP resource:

To remove Cluster ware resources from SCAN VIPs:

To add a SCAN listener resource:

To remove Cluster ware resources from all SCAN listeners:

On a single node in the cluster, add the new global interface specification:

• $ oifcfg setif -global eth2/192.0.2.0:cluster_interconnect

VERIFY the CHANGES with oifcfg getif and then stop Cluster ware on all nodes by running the following COMMAND as root on each node:

• # oifcfg getif
• # crsctl stop CRS

Assign the network address to the new network adapters on all nodes using ifconfig:

• #ifconfig eth2 192.0.2.15 netmask 255.255.255.0 BROADCAST 192.0.2.255

Remove the former adapter/subnet specification and restart Cluster ware:

• $ oifcfgdelif -global eth1/192.168.1.0
• # crsctl start crs

On a single node in the cluster, add the new global interface specification:

Verify the changes with oifcfg getif and then stop Cluster ware on all nodes by running the following command as root on each node:

Assign the network address to the new network adapters on all nodes using ifconfig:

Remove the former adapter/subnet specification and restart Cluster ware:

• CAT /etc/oracle/OCR.loc

ocrconfig local=+DATA

local_only=FALSE

• #OCRCHECK (ALSO about OCR INTEGRITY)

ocrconfig local=+DATA

local_only=FALSE

$ CRSCTL check CRS

CRS-4638: Oracle High AVAILABILITY Services is online.

CRS-4537: CLUSTER Ready Services is online.

CRS-4529: Cluster Synchronization Services is online.

CRS-4533: EVENT Manager is online.

$ crsctl check crs

CRS-4638: Oracle High Availability Services is online.

CRS-4537: Cluster Ready Services is online.

CRS-4529: Cluster Synchronization Services is online.

CRS-4533: Event Manager is online.

To check the viability of Cluster Synchronization SERVICES (CSS) ACROSS nodes:

$ crsctl check cluster

CRS-4537: Cluster Ready Services is online.

CRS-4529: Cluster Synchronization Services is online.

CRS-4533: EVENT MANAGER is online.

To check the viability of Cluster Synchronization Services (CSS) across nodes:

$ crsctl check cluster

CRS-4537: Cluster Ready Services is online.

CRS-4529: Cluster Synchronization Services is online.

CRS-4533: Event Manager is online.

To start or stop Oracle Cluster ware on a specific node:

• # crsctl stop CRS
• # crsctl start crs

To ENABLE or DISABLE Oracle Cluster ware on a specific node:

• # crsctl enable crs
• # crsctl disable crs

To start or stop Oracle Cluster ware on a specific node:

To enable or disable Oracle Cluster ware on a specific node:

Crsctl manages CLUSTER ware-related operations:

• Starting and stopping Oracle Cluster ware.
• Enabling and disabling Oracle Cluster ware daemons.
• Registering cluster RESOURCES.

Srvctl manages Oracle resource–related operations:

• Starting and stopping DATABASE instances and services.
• Also from 11gR2 manages the cluster resources like network, VIP, disks ETC.

Crsctl manages cluster ware-related operations:

Srvctl manages Oracle resource–related operations:

A scan listener is SOMETHING that additional to node listener which LISTENS the incoming db connection requests from the client which got through the scan IP, it got ENDPOINTS CONFIGURED to node listener where it routes the db connection requests to particular node listener.

A scan listener is something that additional to node listener which listens the incoming db connection requests from the client which got through the scan IP, it got endpoints configured to node listener where it routes the db connection requests to particular node listener.

In 11gr2 the listeners will run from Grid INFRASTRUCTURE software home

• The node LISTENER is a process that helps establish network connections from ASM clients to the ASM instance.
• Runs by default from the Grid $ORACLE_HOME/bin directory.
• Listens on port 1521 by default.
• Is the same as a DATABASE instance listener.
• Is capable of listening for all database instances on the same MACHINE in addition to the ASM instance.
• Can run concurrently with separate database listeners or be replaced by a separate database listener.
• Is named tnslsnr on the Linux platform.

In 11gr2 the listeners will run from Grid Infrastructure software home

Grid Naming service is alternative service to DNS , which will ACT as a sub DOMAIN in your DNS but managed by Oracle, with GNS the connection is routed to the CLUSTER IP and MANAGES internally.

Grid Naming service is alternative service to DNS , which will act as a sub domain in your DNS but managed by Oracle, with GNS the connection is routed to the cluster IP and manages internally.

Software that provides various INTERFACES and services for a cluster. Typically, this INCLUDES capabilities that:

• Allow the cluster to be MANAGED as a whole.
• PROTECT the integrity of the cluster.
• Maintain a registry of resources across the cluster.
• Deal with changes to the cluster.
• PROVIDE a common view of resources.

Software that provides various interfaces and services for a cluster. Typically, this includes capabilities that:

Basically Oracle kernel need to switched on with RAC On option when you convert to RAC, that is the difference as it facilitates few RAC bg process like LMON, LCK, LMD, LMS ETC.

To turn on RAC:

• # link the oracle libraries
• $ cd $ORACLE_HOME/rdbms/lib
• $ make -F ins_rdbms.mk rac_on
• # rebuild oracle
• $ cd $ORACLE_HOME/bin
• $ relink oracle

Oracle RAC is composed of two or more database instances. They are composed of Memory structures and background processes same as the single instance database. Oracle RAC instances use two processes GES(Global ENQUEUE Service), GCS(Global Cache Service) that enable cache fusion.

Oracle RAC instances are composed of following background processes:

• ACMS—Atomic Controlfile to Memory Service (ACMS)
• GTX0-j—Global Transaction Process
• LMON—Global Enqueue Service Monitor
• LMD—Global Enqueue Service Daemon
• LMS—Global Cache Service Process
• LCK0—Instance Enqueue Process
• RMSn—Oracle RAC Management Processes (RMSn)
• RSMN—Remote Slave Monitor

Basically Oracle kernel need to switched on with RAC On option when you convert to RAC, that is the difference as it facilitates few RAC bg process like LMON, LCK, LMD, LMS etc.

To turn on RAC:

Oracle RAC is composed of two or more database instances. They are composed of Memory structures and background processes same as the single instance database. Oracle RAC instances use two processes GES(Global Enqueue Service), GCS(Global Cache Service) that enable cache fusion.

Oracle RAC instances are composed of following background processes:

VIP, NODE APPS ETC.

VIP, Node apps etc.

• CLUSTER Interconnect (HAIP)
• Shared STORAGE (OCR/Voting Disk)
• Cluster WARE software

Well, there is not MUCH difference between 10g and 11gR (1) RAC.

But there is a significant difference in 11gR2.

Prior to 11gR1 (10g) RAC, the following were MANAGED by Oracle CRS:

• Databases
• Instances
• Applications
• Node Monitoring
• Event Services
• High Availability

From 11gR2 (onwards) it’s completed HA stack managing and providing the following resources as like the other cluster SOFTWARE like VCS etc.

• Databases
• Instances
• Applications
• Cluster Management
• Node Management
• Event Services
• High Availability
• Network Management (provides DNS/GNS/MDNSD services on behalf of other TRADITIONAL services) and SCAN – Single Access Client Naming method, HAIP.
• STORAGE Management (with help of ASM and other new ACFS filesystem).
• Time synchronization (rather depending upon traditional NTP).
• Removed OS dependent hang checker etc, manages with own additional monitor process.

Well, there is not much difference between 10g and 11gR (1) RAC.

But there is a significant difference in 11gR2.

Prior to 11gR1 (10g) RAC, the following were managed by Oracle CRS:

From 11gR2 (onwards) it’s completed HA stack managing and providing the following resources as like the other cluster software like VCS etc.