Category Archives: Oracle RAC

How to disable and enable archive log in Oracle RAC

This document describes how to enable and disable archive log in Oracle RAC database. ENABLE ARCHIVE LOG MODE IN RAC. Step1: stop database instance on node1 using sqlplus. [oracle@rac-node1 bin]# sqlplus /nolog SQL> select instance_name from v$instance; TEST1 SQL> shutdown … Continue reading

Posted in Database administration, Oracle RAC | Leave a comment

Add disk or mount point to Oracle RAC servers

How to add disk to Oracle RAC servers as OCFS2 500GB Disk partition has added from SAN to all four nodes for Database Logical Backup. How to Detect a New Hard Disk without Rebooting Linux Servers This command is very … Continue reading

Posted in Linux commands for DBA, Ocfs2, Oracle RAC | Tagged | Leave a comment

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

When I tried to create a  new database for RAC environment using DBCA, It shows the error about invalid grid and diskgroup not mounted. Error Details are ORA-27300: OS system dependent operation:invalid_egid failed with status: 1 ORA-27301: OS failure message: … Continue reading

Posted in ASM, Oracle RAC | 1 Comment

Steps To Shutdown/Startup The CRS, OHAS, ASM & RDBMS Services on RAC 11.2 Configuration

The present document provides in detail the steps to shutdown/startup The CRS, OHAS, ASM & RDBMS Services on a RAC 11.2. Configuration: 1) Connect to node #1, then please check if the CRS/OHAS & services are enabled to autostart as … Continue reading

Posted in Exadata, Oracle RAC | Leave a comment

Create Oracle RAC Database in Silent Mode on Exadata

Database Version 11gR2 -bash-4.1$ pwd/u01/app/oracle/product/11.2.0.3/dbhome_1 -bash-4.1$ cd bin -bash-4.1$ ./dbca -silent -createDatabase -templateName General_Purpose.dbc -g dbName EBSPROD -sid EBSPROD -sysPassword welcome1 -systemPassword welcome1 -sysm anPassword welcome1 -dbsnmpPassword welcome1 -emConfiguration LOCAL -storageType ASM -diskGroupName DATA_DAH1 -datafileJarLocation $ORACLE_HOME/assistants/dbca/ templates -nodeinfo dbserver1,dbserver2 -characterset … Continue reading

Posted in Exadata, Oracle RAC | Leave a comment

How to Recreate OCR/Voting Disk Accidentally Deleted

How to Recreate OCR/Voting Disk Accidentally Deleted  APPLIES TO: Oracle Server – Enterprise Edition – Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1] Generic UNIX Generic Linux GOAL The goal of this document is to help customers who have accidentally … Continue reading

Posted in Oracle RAC | Leave a comment

How to add instance to oracle RAC database

I am having two nodes oracle RAC  , now I am adding 3rd instance to this database. SQL> startup pfile=’/archive/pfile-rman.ora’ ORACLE instance started. Total System Global Area 1.0737E+10 bytes Fixed Size                  2114104 bytes Variable Size            1560284616 bytes Database Buffers         9160359936 … Continue reading

Posted in Oracle RAC | Leave a comment