What are the Oracle database and Grid/RAC health check/Monitoring tool’s?

Hang Manger

Quality Of service Management

TAF (Trace file analyser) (1513912.1)

Exacheck

Memory Guard

Cluster Healthcheck advisor

Cluster Health monitor

Cluster Verification utility

ORAchk

DBSAT (Database Security Assessment tool)

OSwatcher (301137.1)

Read More

What are the RAC/Grid specific daemons in Oracle 12c

CRSD (Cluster Ready Service Daemon):

CRSD is primarily responsible for maintaining the availability of the application resources such as DB instances. Main responsibility of the CRSD daemon is starting and stopping of the resources, relocating the resources when required to another node in the event of failure and updating the resource profiles in the OCR file and also responsible for backing up the OCR file.

Read More

What are the requirements for Oracle RAC / Grid 11g, 12c installation

What is Cluster, requirements to build cluster database.

Oracle clusterware enables one or more than servers into single unit and communicate each other. Oracle cluster manages the resources such as server names, VIP’s, private IP’s, Public IP’s, scan IP’s, databases, listeners, instances, services and so on, and these resources doesn’t allow to modify. For example resources names like as ora.host_name.resource_name.

Hardware requirements for the Oracle RAC

Hardware components (Servers) of the clusterware is similar. However, a server is part of the cluster requires second network to communicate each other, this second network is called as the interconnect. This interconnect network is a private network using a switch that only the nodes in the cluster can access.

Note: Oracle doesn’t support using cross cables as clusterware interconnects.

1.       At least two network interfaces to the public network.

2.       At least two network interfaces to the private interconnect network.

 Storage requirements for the Oracle Clusterware / Grid infrastructure:

The clusterware servers required common shared storage (cluster-aware storage) mounted in all servers. Oracle clusterware supports NFS, iSCSI, DAS, NAS and SAN storage's.

Oracle RAC/Grid Components:
OCR

Voting Disk

OLR

Networking Configurations:
Scan IP’s

Public IP’s

Private IP’s

Virtual IP’s

Oracle Clusterware Stack:

1.       Cluster ready services Stack

2.       Oracle high availability services stack

Cluster Ready Services Stack:

1.       Cluster Ready Services (CRS)

2.       Cluster Synchronization Services (CSS)

3.       Oracle ASM

4.       Cluster Time Synchronization Service

5.       Event Management (EVM)

6.       Oracle Notification Service (ONS)

7.       Oracle Agent (oraagent)

8.       Oracle Root Agent (orarootagent)

Oracle High Availability Service Stack:

1.       Cluster Logger service (ologgerd)

2.       System Monitor Service (osysmond)

3.       Grid Plug and Play (GPNPD)

4.       Grid interprocess Communication (GIPC)

5.       Multicast Domain Name Service (mDNS)

6.       Oracle Grid Naming Service (GNS)

Read More

How to register the new database to existing Oracle RAC / Grid

How to register new database home, Database and listener into Grid home

As a DBA in some time we have to add node into the Cluster / Grid. We can use the below commands for adding new oracle home, cluster home database and listener.

bash-3.2$ srvctl add database -d prddb -o /oracle/app/product/11.1.0/db_1

bash-3.2$ srvctl add instance -d prddb -i prddb2 -n proddb2

bash-3.2$ srvctl add instance -d prddb -i prddb3 -n proddb3

verify the configuration of database and instances using

bash-3.2$ srvctl config database -d prddb

bash-3.2$ srvctl config database -d prddb -a

proddb1 prddb1 /oracle/app/product/11.1.0/db_1

proddb2 prddb2 /oracle/app/product/11.1.0/db_1

proddb3 prddb3 /oracle/app/product/11.1.0/db_1

DB_UNIQUE_NAME: prddb

DB_NAME: prddb

ORACLE_HOME: /oracle/app/product/11.1.0/db_1

SPFILE: +DG1/nowprod/spfileprddb.ora

DOMAIN: null

DB_ROLE: null

START_OPTIONS: null

POLICY:  AUTOMATIC

ENABLE FLAG: DB ENABLED

We can modify the spfile/pfile parameter location using below command

srvctl modify database -d prddb -p '/oracle/app/product/11.1.0/db_1/spfileprddb.ora' -s open

Read More