Day_1🚀 Oracle & ASM Installation & Configuration + Interview Questions

DB:

===

Oracle Software 

Oracle Home 

DB Home 

Database software 

ASM:

====

GI Home (Grid Infrastructure Home) 

ASM Home (Automatic Storage Management Home) 

GI Software 

ASM Software 

Grid Home

Clusterware Software

Clusterware Home  

ASM/GI Installation log location:

/tmp/GridSetupActions2025-07-01_09-41-55AM/gridSetupActions2025-07-01_09-41-55AM.log

-> /u01/app/oraInventory/logs

Database Home Installation log location:

/u01/app/oraInventory/logs/InstallActions2025-07-01_09-56-45AM/installActions2025-07-01_09-56-45AM.log

Database creation log location:

/u01/app/oracle/cfgtoollogs/dbca/TESTDB/trace.log_2025-07-01_10-06-05AM

lab1:

+++++++++++

root scripts:

/u01/app/oraInventory/orainstRoot.sh

- inventory permission 

- inventory ownership and groups 

/u01/app/oracle/product/19.0.0.0/dbhome_1/root.sh

- set permission for /etc/oratab file 

- set environmental variables for Oracle Home 

lab2:

+++++++++++

root scripts:

/u01/app/oraInventory/orainstRoot.sh

- inventory permission 

- inventory ownership and groups 

/u01/app/19.0.0.0/grid/root.sh

- set ASM service and create ASM instance 

- set permission for /etc/oratab file 

- set environmental variables ASM home 

/u01/app/oracle/product/19.0.0.0/dbhome_1/root.sh

- set permission for /etc/oratab file 

- set environmental variables for Oracle Home 

1. Tool used to install Oracle Home / Database Home?

./runInstaller (/u01/app/oracle/product/19.0.0.0/dbhome_1)

2. Tool used to create database? -> DEVDB/TESTDB 

./dbca (/u01/app/oracle/product/19.0.0.0/dbhome_1/bin)

3. Tool used to install GI/ASM Home?

./gridSetup.sh (/u01/app/19.0.0.0/grid)

4. Tool used to create DiskGroup / ASM Storage (+DATA/+RECO)

./asmca (/u01/app/19.0.0.0/grid/bin)

- asmca(GUI)

- sqlplus / as sysasm (command line)

5. Tool used to create ASMDISKS (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 these Virtual Disks -> Partitioned Disks -> ASM disks 

6. How to install/setup oracleasm library 

oracleasm init

oracleasm configure -i

7. How Many Oracle Software are installed on a server oraclelab1 & oraclelab2?

oraclelab1

- Only 1 software 

- DB Home - /u01/app/oracle/product/19.0.0.0/dbhome_1

oraclelab2

- 2 software 

- ASM Home - /u01/app/19.0.0.0/grid 

- DB Home - /u01/app/oracle/product/19.0.0.0/dbhome_1

- Read Inventory file 

cat /u01/app/oraInventory/ContentsXML/inventory.xml

What is inventory?

- Its xml file which will keep a track of all the software installation 

8. How to find out Where is the oraInventory location

- cat /etc/oraInst.loc

9.  How many database are create on a server? 

- cat /etc/oratab

10. How many database are running on a server? 

ps -ef|grep smon

11. How DBA can connect to database / How to connect to database? 

ps -ef|grep smon

su - oracle

. oraenv

env |grep ORA

sqlplus / as sysdba

12. How DBA can connect to ASM Instance / How to connect to ASM Instance? 

ps -ef|grep smon

su - oracle

. oraenv

env |grep ORA

sqlplus / as sysasm

13. How DBA can connect to ASM storage / How to connect to ASM Storage? 

ps -ef|grep smon

su - oracle

. oraenv

env |grep ORA

asmcmd -p

lsdg

lsdsk

14. How to check whether DB is running under ASM storage or OS storage?

DEVDB - OS storage 

TESTDB - ASM storage 

ps -ef|grep smon

sqlplus / as sysdba

select name from v$datafile;

15. Where to download ASM/GI/DB software?

- oracle https://edelivery.oracle.com (free)  

- oracle OTN site (free) 

- https://support.oracle.com (license) 

16. root scripts 

root scripts:

==============

oraclelab1:

/u01/app/oraInventory/orainstRoot.sh

- set inventory permission 

/u01/app/oracle/product/19.0.0.0/dbhome_1/root.sh

- created /etc/oratab file and set permission

oraclelab2:

=================

/u01/app/oraInventory/orainstRoot.sh

- set inventory permission 

/u01/app/19.0.0.0/grid/root.sh

- created /etc/oratab file and set permission and set ASM instance and set asm services 

/u01/app/oracle/product/19.0.0.0/dbhome_1/root.sh

- created /etc/oratab file and set permission

17. Installation logs:

==================

oraclelab1:

++++++++++++++++

OH (runInstaller) - /tmp/InstallActions2024-12-24_09-02-51AM/installActions2024-12-24_09-02-51AM.log

  -> /u01/app/oraInventory/logs

DEVDB (dbca) - /u01/app/oracle/cfgtoollogs/dbca/DEVDB/trace.log_2024-12-24_09-11-27AM

oraclelab2:

++++++++++++++++

ASM (gridSetup.sh) - /tmp/GridSetupActions2024-12-24_09-44-22AM/gridSetupActions2024-12-24_09-44-22AM.log

   -> /u01/app/oraInventory/logs

OH (runInstaller) - /u01/app/oraInventory/logs/InstallActions2025-03-25_09-52-21AM/installActions2025-03-25_09-52-21AM.log

TESTDB (dbca) - /u01/app/oracle/cfgtoollogs/dbca/TESTDB/trace.log_2024-12-24_09-11-27AM

18. In single server can we setup with ASM and without ASM?

- Yes 

lab2:

+ASM -> TESTDB 

OS -> TESTUAT

19. In single server we can create multiple ASM Home and Multiple ASM instance (+ASM) 

- No (In single server we can create only one ASM Home and only one ASM instance (+ASM)

/u01/app/19.0.0.0/grid

20. In single server we can create multiple Oracle Home and Multiple database 

lab1:

+++++

TESTDB:/u01/app/oracle/product/19.0.0.0/dbhome_1

PROD:/u01/app/oracle/product/19.0.0.0/dbhome_1

UATDB:/u01/app/oracle/product/19.0.0.0/dbhome_2

PRODB:/u01/app/oracle/product/19.0.0.0/dbhome_3

DEV:/u01/app/oracle/product/12.0.0.0/dbhome_1

UAT:/u01/app/oracle/product/11.0.0.0/dbhome_1

21. I can install only one Oracle Software and create multiple database from single Oracle Software 

/u01/app/oracle/product/19.0.0.0/dbhome_1

- TESTDB

- UATDB

- PRODDB

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