Database RAC Dataguard RMAN Performance Tuning Feedback
Database Migration & Upgradation
DataGuard
ASM & RAC
Exadata
RMAN Backup & Recovery
Oracle Cloud AWS Azure Google Cloud
DevOps Ansible Kubernetes Terraform
Shell Scripting Powershell Scripting
Infomratica Others

Tuesday, April 21, 2026

Interview_Questions_6 | Oracle RAC Installation, Cluster Services & Administration

1. Tool used for Cluster Installation prechecks?
./runcluvfy.sh (/u01/app/19.0.0.0/grid)

2. Tool used to install GI/ASM/Clusterware Home?
./gridSetup.sh (/u01/app/19.0.0.0/grid)

3. Tool used to install Oracle Home / Database Home / DB Home?
./runInstaller (/u01/app/oracle/product/19.0.0.0/dbhome_1)

4. Tool used to create DiskGroup / ASM Storage (+OCR/+DATA/+RECO)
./asmca (/u01/app/19.0.0.0/grid/bin)

5. Tool used to create database? -> DEVDB 
./dbca (/u01/app/oracle/product/19.0.0.0/dbhome_1/bin)

6. Log location of GI/ASM/Clusterware installation
GI/ASM/Clusterware Installation log location:
- /tmp/GridSetupActions2025-07-17_11-19-39AM
After Installation log will move to
- tail -f /u01/app/oraInventory/logs/GridSetupActions2025-07-17_11-19-39AM/gridSetupActions2025-07-17_11-19-39AM.log

root.sh script execution log location:
node1 -> tail -f /u01/app/oracle/crsdata/oraclelab1/crsconfig/rootcrs_oraclelab1_2025-07-17_11-37-47AM.log
node2 -> tail -f /u01/app/oracle/crsdata/oraclelab2/crsconfig/rootcrs_oraclelab2_2025-07-17_11-46-00AM.log

node1 -> /u01/app/19.0.0.0/grid/root.sh
node2 -> /u01/app/19.0.0.0/grid/root.sh
- configure cluster 
- configure OLR/OCR/Votedisks
- starts cluster daemons
- Set ASM instance 
- Set ASM storage 
- many more  

7. orainventory root scripts 

node1 -> /u01/app/oraInventory/orainstRoot.sh
node2 -> /u01/app/oraInventory/orainstRoot.sh
- set permission (read / write ) on /u01/app/oraInventory
- set ownership/group ownership on /u01/app/oraInventory

8. oracle root script execution 

node1 -> /u01/app/oracle/product/19.0.0.0/dbhome_1/root.sh
node2 -> /u01/app/oracle/product/19.0.0.0/dbhome_1/root.sh
- create and grant permission on /etc/oratab 
- set env variable 

9. Log location of Oracle Home / Database Home / DB Home installation
tail -f /u01/app/oraInventory/logs/InstallActions2025-07-18_08-59-12AM/installActions2025-07-18_08-59-12AM.log

10. Log location of database creation  
tail -f /u01/app/oracle/cfgtoollogs/dbca/DEVDB/trace.log_2025-07-18_09-16-06AM

11. Tool used to create ASMDISKS using virtual disks(ASMDISK1/ASMDISK2/ASMDISK3)?
oracleasm library 
oracleasm createdisk ASMDISK1 /dev/sdb1
oracleasm createdisk ASMDISK2 /dev/sdc1
oracleasm createdisk ASMDISK3 /dev/sdd1

Because ASM can not understand virtual disks / partitioned disks 
ASM can only understand RAW disks / Physical disks / Block devices 
We fooled ASM by converting or labelling there Virtual Disks -> Partitioned Disks -> ASM disks 

12. How to install/setup oracleasm library 
oracleasm init
oracleasm configure -i

13. Where to download GI / ASM / Clusterware software? 
- oracle edelivery (free) 
- OTN (free)
- support.oracle.com (license) 

14. Where to download Oracle Home / Database Home / DB Home software? 
- oracle edelivery (free) 
- OTN (free)
- support.oracle.com (license) 

15. check ASM and DB instance are running or not?
ps -ef|grep smon

16. check ASM and DB instance owner?
ps -ef|grep smon

+ASM1/+ASM2 -> oracle 
DEVDB1/DEVDB2 -> oracle 

+ASM1/+ASM2 -> grid 
DEVDB1/DEVDB2 -> oracle 

+ASM1/+ASM2 -> grid 
DEVDB1/DEVDB2 -> oraprod  

17. How to connect to ASM instance?
ps -ef|grep smon
su - oracle
. oraenv -> +ASM1/+ASM2
env |grep ORA
sqlplus / as sysasm 

vi /etc/oratab
+ASM1:/u01/app/19.0.0.0/grid:Y

vi /etc/oratab
+ASM2:/u01/app/19.0.0.0/grid:Y


vi /home/oracle/.bash_profile

export ORACLE_SID=+ASM1
export ORACLE_HOME=/u01/app/19.0.0.0/grid
export ORACLE_BASE=/u01/app/oracle
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$PATH:$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$PATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

vi /home/oracle/.bash_profile

export ORACLE_SID=+ASM2
export ORACLE_HOME=/u01/app/19.0.0.0/grid
export ORACLE_BASE=/u01/app/oracle
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$PATH:$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$PATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

18. How to connect to DB instance?
ps -ef|grep smon
su - oracle
. oraenv -> DEVDB1/DEVDB2
env |grep ORA
sqlplus / as sysdba

vi /etc/oratab
DEVDB1:/u01/app/oracle/product/19.0.0.0/dbhome_1:Y

vi /etc/oratab
DEVDB2:/u01/app/oracle/product/19.0.0.0/dbhome_1:Y


vi /home/oracle/.bash_profile

export ORACLE_SID=DEVDB1
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$PATH:$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$PATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

vi /home/oracle/.bash_profile

export ORACLE_SID=DEVDB2
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$PATH:$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$PATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib


+ASM1  - node1 -> grid ->  /home/grid/.bash_profile
DEVDB1 - node1 -> oracle ->  /home/oracle/.bash_profile
su - grid
su - oracle

+ASM2  - node2 -> grid ->  /home/grid/.bash_profile
DEVDB2 - node2 -> oracle ->  /home/oracle/.bash_profile
su - grid
su - oracle

+ASM1 & DEVDB1 - node1 -> oracle ->  /home/oracle/.bash_profile
+ASM2 & DEVDB2 - node2 -> oracle ->  /home/oracle/.bash_profile
We can set only 1 evn variable in .bash_profile 

19. How to connect to ASM storage / ASM diskgroups?
OCR, DATA, RECO

ps -ef|grep smon
su - oracle
. oraenv -> +ASM1/+ASM2
env |grep ORA
asmcmd -p
ASMCMD [+] > lsdg

20. Check cluster status and cluster resource and OS daemons:
ps -ef|grep smon
su - oracle
. oraenv -> +ASM1/+ASM2
env |grep ORA

crsctl --- Tool

crsctl stat res -t -init ------ cluster resource for a single node 
crsctl stat res -t  ----- cluster resource for all node
ps -ef|grep d.bin ------- OS daemons

21. What all softwares are installed on my server 
node1: 19C GI & 19C DB 
node2: 19C GI & 19C DB

- looking at inventory file
cat /u01/app/oraInventory/ContentsXML/inventory.xml

node1: 19C GI & 19C DB + 12c DB + 19C DB 
node2: 19C GI & 19C DB + 12c DB + 19C DB  

node1
/u01/app/19.0.0.0/grid - +ASM1
/u01/app/oracle/product/19.0.0.0/dbhome_1 - DEVDB1
/u01/app/oracle/product/12.0.0.0/dbhome_1 - TESTDB1
/u01/app/oracle/product/19.0.0.0/dbhome_2 - UATDB1

node2
/u01/app/19.0.0.0/grid - +ASM2
/u01/app/oracle/product/19.0.0.0/dbhome_1 - DEVDB2
/u01/app/oracle/product/12.0.0.0/dbhome_1 - TESTDB2
/u01/app/oracle/product/19.0.0.0/dbhome_2 - UATDB2

22.  How to get inventory location?
cat /etc/oraInst.loc

23. check database status and database Instance status:

ps -ef|grep smon
su - oracle
. oraenv -> DEVDB1/DEVDB2
env |grep ORA
sqlplus / as sysdba
select instance_name, status from v$instance;
select name, open_mode from v$database;

select instance_name, status from gv$instance;
select name, open_mode from gv$database;

srvctl --- Tool 

srvctl status database -d DEVDB
srvctl status instance -i DEVDB1 -d DEVDB
srvctl status instance -i DEVDB2 -d DEVDB

24. How many database are create on a server? 
cat /etc/oratab
crsctl stat res -t (set environmental variable to ASM/GI owner ) 

25.  How many instance are running on a server? 
ps -ef|grep smon
crsctl stat res -t

26. How to find how many RAC node or cluster nodes? 
ps -ef|grep smon
su - oracle
. oraenv -> +ASM1/+ASM2
env |grep ORA

[oracle@oraclelab1 ~]$ olsnodes
oraclelab1
oraclelab2

27. How to verify whether it RAC database or standalone?
srvctl config database -d DEVDB

sqlplus / as sysdba
show parameter cluster 
select instance_name, status from gv$instance;

28. Oracle Home / Database Home / DB Home
GI Home / grid Home / ASM Home / Clusterware Home 

DB: -> /u01/app/oracle/product/19.0.0.0/dbhome_1
===
Oracle Software 
Database software 
DB Software 
Oracle Home 
Database Home 
DB home 

GI / ASM / Clusterware : -> /u01/app/19.0.0.0/grid
====
GI Home (Grid Infrastructure Home) 
ASM Home (Automatic Storage Management Home) 
Grid Home
Clusterware Home  
Clusterware Software
ASM Software 
GI Software 

29.  Root script 
/u01/app/oraInventory/orainstRoot.sh
- set inventory permission and ownership 
- group ownership 

/u01/app/19.0.0.0/grid/root.sh
- Configure and start Cluster resource, OS daemons and create ASM Instance 

/u01/app/oracle/product/19.0.0.0/dbhome_1/root.sh
- created /etc/oratab file and set permission and env

30. GUI mode installation Vs silent mode 
- GUI - Demo - directly login to server / VM and installed GI & DB

- In case if we don't have direct login to server
- vnc server 
- tiger vnc 
- vnc viewer
- xming or many more

xming
https://mallik034.blogspot.com/2020/04/srchttpsdrive.html

vnc viewer 
https://mallik034.blogspot.com/2025/05/install-oracle-using-vnc.html

- Even some customer will not allow these GUI screens 
- command line (silent/Manual method)
- create response file and then install it (Oracle doc ID)

Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: mallikarjun.ramadurg@gmail.com / vismotechnologies@gmail.com

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

2 Node RAC | GI Installation & Configuration | 2 Node RAC Oracle Home & DB Installation

Setting up Labs:  ================================== 2 node RAC setup  node1 - +ASM1 (DEVDB1) - oraclelab1.localdomain.com node2 - +ASM2 (DE...