Announcements

Oracle training based on real-time expertise as per industry standards. Upcoming batch details are here.

View batch schedule

Free Oracle mock interview. Register using the link.

Register

#DBAchallenge: submit your questions.

Ask questions
Swipe for more →
Browse by Topic
Latest Posts

    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
    Labels:

    No comments:

    Post a Comment

    Subscribe to: Post Comments (Atom)

    🌟 Proud to be an Oracle ACE Pro! 🚀

    🌟 Proud to be an Oracle ACE Pro! 🚀 I’m excited to share my official Oracle ACE Profile with the Oracle community. 👨‍💻 Mallikarjun ...