2 labs - setup
===============
Types Of databases
===================
1) Standalone - This is DBA course
- Standalone without ASM (Install database on OS file system / OS storage)------------------ DEVDB - oraclelab1
- Standalone with ASM (Install database on ASM file system / ASM storage) - Restart Server ------- TESTDB - oraclelab2
2) RAC - This is RAC course
- RAC database
- RAC Onenode database
Standalone without ASM -> oraclelab1.rar (Link #1) (OS file system / OS storage) - DEVEB
=========================
oraclelab1.localdomain.com (Linux VM 7.9)
Standalone with ASM -> oraclelab2.rar (Link #1) (ASM file system / ASM storage) - TESTDB
=======================
oraclelab2.localdomain.com (Linux VM 7.9)
Standalone without ASM -> oraclelab1.rar (Link #1) (OS file system / OS storage) - DEVEB
=========================
oraclelab1.localdomain.com (Linux VM 7.9)
1. Setup oraclelab1 server - 192.168.0.151
2. Download 19c Oracle Software and Install
3. Create Database -> DEVDB
Standalone with ASM -> oraclelab2.rar (Link #1) (ASM file system / ASM storage) - TESTDB
=======================
oraclelab2.localdomain.com (Linux VM 7.9)
1. Setup oraclelab2 server - 192.168.0.152
2. Download 19c ASM Software and Install and Setup ASM storage
3. Download 19c Oracle Software and Install
4. Create Database -> TESTDB
Standalone without ASM -> oraclelab1.rar (Link #1) (OS file system / OS storage) - DEVEB
=========================
oraclelab1.localdomain.com (Linux VM 7.9)
1. Setup oraclelab1 server - 192.168.0.151
2. Download 19c Oracle Software and Install
3. Create Database -> DEVDB
Microsoft Windows [Version 10.0.26200.7840]
(c) Microsoft Corporation. All rights reserved.
C:\Users\MallikarjunRamadurg>ipconfig
Windows IP Configuration
Ethernet adapter Ethernet 5:
Connection-specific DNS Suffix . :
IPv4 Address. . . . . . . . . . . : 172.29.81.79
Subnet Mask . . . . . . . . . . . : 255.255.255.255
Default Gateway . . . . . . . . . : 0.0.0.0
Ethernet adapter Ethernet 4:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Wireless LAN adapter Local Area Connection* 3:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Wireless LAN adapter Local Area Connection* 4:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Wireless LAN adapter Wi-Fi:
Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::ce3d:c42a:f5bb:c2c2%8
IPv4 Address. . . . . . . . . . . : 192.168.0.101
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.0.1
Ethernet adapter Bluetooth Network Connection:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
C:\Users\MallikarjunRamadurg>ipconfig /all
Windows IP Configuration
Host Name . . . . . . . . . . . . : APAC-JHZG814
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No
Ethernet adapter Ethernet 5:
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : PANGP Virtual Ethernet Adapter Secure #2
Physical Address. . . . . . . . . : 02-50-41-00-00-01
DHCP Enabled. . . . . . . . . . . : No
Autoconfiguration Enabled . . . . : Yes
IPv4 Address. . . . . . . . . . . : 172.29.81.79(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.255
Default Gateway . . . . . . . . . : 0.0.0.0
DHCPv6 IAID . . . . . . . . . . . : 67260481
DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-2F-83-F1-C5-A0-02-A5-04-C3-C9
DNS Servers . . . . . . . . . . . : 10.34.128.6
10.34.128.7
10.1.253.53
10.1.253.140
10.1.253.141
NetBIOS over Tcpip. . . . . . . . : Enabled
Ethernet adapter Ethernet 4:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Realtek USB GbE Family Controller #2
Physical Address. . . . . . . . . : 94-05-BB-1E-38-52
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
Wireless LAN adapter Local Area Connection* 3:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Microsoft Wi-Fi Direct Virtual Adapter #3
Physical Address. . . . . . . . . : A0-02-A5-04-C3-CA
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
Wireless LAN adapter Local Area Connection* 4:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Microsoft Wi-Fi Direct Virtual Adapter #4
Physical Address. . . . . . . . . : A2-02-A5-04-C3-C9
DHCP Enabled. . . . . . . . . . . : No
Autoconfiguration Enabled . . . . : Yes
Wireless LAN adapter Wi-Fi:
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Intel(R) Wi-Fi 6E AX211 160MHz
Physical Address. . . . . . . . . : A0-02-A5-04-C3-C9
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::ce3d:c42a:f5bb:c2c2%8(Preferred)
IPv4 Address. . . . . . . . . . . : 192.168.0.101(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Lease Obtained. . . . . . . . . . : 09 March 2026 08:01:39
Lease Expires . . . . . . . . . . : 09 March 2026 10:01:38
Default Gateway . . . . . . . . . : 192.168.0.1
DHCP Server . . . . . . . . . . . : 192.168.0.1
DHCPv6 IAID . . . . . . . . . . . : 111149733
DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-2F-83-F1-C5-A0-02-A5-04-C3-C9
DNS Servers . . . . . . . . . . . : 192.168.0.1
NetBIOS over Tcpip. . . . . . . . : Enabled
Ethernet adapter Bluetooth Network Connection:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Bluetooth Device (Personal Area Network)
Physical Address. . . . . . . . . : A0-02-A5-04-C3-CD
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
C:\Users\MallikarjunRamadurg>
1. Setup oraclelab1 server
- Its done by Linux admin - Linux admin will be setting up server and providing access to DBAs
- Download oraclelab1.rar file from Link #1 >>> Ready_VMs_Standalone (folder)
https://drive.google.com/drive/folders/183dcnQtLtEp8mS3MX3VvCyiKjrpNGicT?usp=sharing
- Download and install winran from link #2 software to unzip oraclelab1.rar >>> Other Tools for DBAs (folder)
https://drive.google.com/drive/folders/1mh5j3hBMad0cCpV7mhph2mmyAGYfwx3U?usp=sharing
- Download and Install Oracle Virtualbox from Link# 2 and setup oraclelab1 >>> Other Tools for DBAs (folder)
https://drive.google.com/drive/folders/1mh5j3hBMad0cCpV7mhph2mmyAGYfwx3U?usp=sharing
- Setup oraclelab1 - add oraclelab1 to oracle virtual box
- Network setup (Its done by network admin and they will assign IP address)
cmd> ipconfig
cmd> ipconfig /all
- get laptop/desktop IP address -> 192.168.0.101
- Subnet - 255.255.255.0
- gateway -> 192.168.0.1
- Get DNS IP address from laptop/desktop -> 192.168.0.1
- Assign IP address to VM oraclelab1 in the same range of your laptop/desktop IP address -> 192.168.0.151 (10 to 240)
- Access oraclelab1 (192.168.0.151) from putty / mobaxterm, putty / mobaxterm software can be downloaded from link #2 and Install on your laptop >>> Other Tools for DBAs (folder)
https://drive.google.com/drive/folders/1mh5j3hBMad0cCpV7mhph2mmyAGYfwx3U?usp=sharing
- add IP address (192.168.1.101) into vi /etc/hosts file
192.168.0.151 oraclelab1.localdomain.com oraclelab1
2. Download and Install Oracle Home/Oracle Software
Download 19c Oracle Software and Install ->
Oracle Home
Oracle Software
DB Software
DB Home
a. Download DB software (19c) from https://edelivery.oracle.com (Oracle Database 19c 19.3.0.0.0) or
- Download it from Google drive Link #2 >>> Oracle Software and Patches >>> 19c Software >>> 19c_DB
- https://drive.google.com/drive/folders/1Oa9c0lhRhOMaEUB9UQiaaKp0BmqZNYWn
- Oracle Database 19c 19.3.0.0.0 ( Oracle Database In-Memory, Oracle Database Vault )
- DB - V982063-01.zip
b. Install Oracle Software / Oracle Home / DB Home / DB software
- Copy DB SW from lapttop/Desktop to VM (oraclelab1)
- Use winscp
- WinSCP is software or tool download from Link #2
- Shared folder (preferred)
- Directory creation & SW unzip
- mkdir -p /u01/app/oracle/product/19.0.0.0/dbhome_1
- unzip /media/sf_Software/DB_19c_Software/V982063-01.zip -d /u01/app/oracle/product/19.0.0.0/dbhome_1
- unzip V982063-01.zip -d /u01/app/oracle/product/19.0.0.0/dbhome_1
- yum install oracle* --skip-broken
(It will set all kernel parameters and it will install all pre-requisite rpms and set all shared memory setting and create all oracle user & groups)
- yum -y install oracle-database-preinstall-19c
- yum -y install oracle-database-preinstall-21c
https://docs.oracle.com/en/database/oracle/oracle-database/19
https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/running-rpm-packages-to-install-oracle-database.html
- Optional (In case if you installed above RPM)
- User & group create (Not required)
# groupadd dba
# groupadd oinstall
# useradd -g oinstall -G oinstall,dba oracle
Advantages of oracle pre-requisite rpm installation
- all kernel parameter are set
- all the required rpms are auto installed
- all the oracle user and groups are auto created
- Change permission
#chown -R oracle:oinstall /u01
- passwd oracle (set password)
- Database SW Installation / Oracle SW Installation / Oracle Home Installation (from GUI screen as oracle user)
$ cd /u01/app/oracle/product/19.0.0.0/dbhome_1
$ ./runInstaller
3. Create Database -> DEVDB
$ cd /u01/app/oracle/product/19.0.0.0/dbhome_1/bin (from GUI screen as oracle user)
$ ./dbca
Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::ce3d:c42a:f5bb:c2c2%8
IPv4 Address. . . . . . . . . . . : 192.168.0.101
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.0.1
DNS Servers . . . . . . . . . . . : 192.168.0.1
Standalone with ASM -> oraclelab2.rar (Link #1) (ASM file system / ASM storage) - TESTDB
=======================
oraclelab2.localdomain.com (Linux VM 7.9)
1. Setup oraclelab2 server - 192.168.0.152
2. Download 19c ASM Software and Install and Setup ASM storage
3. Download 19c Oracle Software and Install
4. Create Database -> TESTDB
Standalone with ASM -> oraclelab2.rar
=====================
oraclelab2.localdomain.com
1. Install or setup oraclelab2.localdomain.com
- Its done by Linux admin - Linux admin will be setting up server and providing access to DBAs
- Download oraclelab2.rar file from Link #1 >>> Ready_VMs_Standalone (folder)
https://drive.google.com/drive/folders/183dcnQtLtEp8mS3MX3VvCyiKjrpNGicT?usp=sharing
- Download and install winran from link #2 software to unzip oraclelab1.rar >>> Other Tools for DBAs (folder)
https://drive.google.com/drive/folders/1mh5j3hBMad0cCpV7mhph2mmyAGYfwx3U?usp=sharing
- We need this WinRAR software to unzip oraclelab2.rar
- Download and Install Oracle Virtualbox from Link# 2 and setup oraclelab1 >>> Other Tools for DBAs (folder)
https://drive.google.com/drive/folders/1mh5j3hBMad0cCpV7mhph2mmyAGYfwx3U?usp=sharing
- Setup oraclelab2 - add oraclelab1 to oracle virtual box
- Network setup
cmd> ipconfig
cmd> ipconfig /all
- get laptop/dektop IP address -> 192.168.0.101
- Subnet -> 192.168.0.101
- gateway -> 192.168.0.101
- Get DNS IP address from laptop/dektop -> 192.168.0.1
- Assign IP address to VM oraclelab2 in the same range of your laptop/desktop IP address -> 192.168.0.152 (10 to 240)
- Access oraclelab2 (192.168.0.152) from putty / mobaxterm, putty / mobaxterm software can be downloaded from link #2 and Install on your laptop >>> Other Tools for DBAs (folder)
https://drive.google.com/drive/folders/1mh5j3hBMad0cCpV7mhph2mmyAGYfwx3U?usp=sharing
- add IP address (192.168.0.152) into vi /etc/hosts file
192.168.0.152 oraclelab2.localdomain.com oraclelab2
2. Download 19c ASM Software and Install and Setup ASM storage
GI Home (Grid Infrastructure Home)
ASM Home (Automatic Storage Management Home)
GI Software
ASM Software
Grid Home
Clusterware Software
Clusterware Home
a. Download ASM/GI software (19c) - https://edelivery.oracle.com (Oracle Database 19c 19.3.0.0.0)
- Oracle Database 19c 19.3.0.0.0 ( Oracle Database In-Memory, Oracle Database Vault )
- Download it from Google drive Link #2 >>> Oracle Software and Patches >>> 19c Software
- https://drive.google.com/drive/folders/1mh5j3hBMad0cCpV7mhph2mmyAGYfwx3U
- DB - V982063-01.zip
- GI/ASM - V982068-01.zip
b. Install GI Software / ASM Home / Clusterware Software / ASM Software / GI Home
- Copy GI SW from laptop/Desktop to VM (oraclelab2)
- Use winscp
- Shared folder (preferred)
- Directory creation & SW unzip
- mkdir -p /u01/app/19.0.0.0/grid
- unzip /media/sf_Software/Grid_19c_Software/V982068-01.zip -d /u01/app/19.0.0.0/grid
- unzip V982068-01.zip -d /u01/app/19.0.0.0/grid
- mkdir -p /u01/app/oracle/product/19.0.0.0/dbhome_1
- unzip /media/sf_Software/DB_19c_Software/V982063-01.zip -d /u01/app/oracle/product/19.0.0.0/dbhome_1
- unzip V982063-01.zip -d /u01/app/oracle/product/19.0.0.0/dbhome_1
- yum install oracle* --skip-broken
- It will set all kernel parameters and
- pre-requisite rpms and
- shared memory setting
- auto create users and groups
- yum -y install oracle-database-ee-19c
- yum -y install oracle-database-ee-21c
https://docs.oracle.com/en/database/oracle/oracle-database/19
- Optional (In case if you installed above RPM) (Not Needed)
- User & group create
# groupadd dba
# groupadd oinstall
# useradd -g oinstall -G oinstall,dba oracle
Advantages of oracle pre-requisite rpm installation
- all kernel parameter are set
- all the required rpms are auto installed
- all the oracle user and groups are auto created
- Change permission
#chown -R oracle:oinstall /u01
- passwd oracle (set password)
Our lab:
========
ASM - installed with oracle user
DB - installed with oracle user
========
ASM - installed with grid user
DB - installed with oracle user
ASM - installed with oraasm/oragrid/grid user
DB - installed with oraprod/orauat/oradev user
c. shared disks / raw disks for ASM installation
a. add virtual disks to VM (oraclelab2) - /dev/sdb, /dev/sdc, /dev/sdd - There are virtual disks
b. ASM will not understand virtual disks
c. ASM will understand only physical disks / raw disks / block devices
d. We need to make my ASM fool
- Tell ASM that these physical disks (/dev/sdb, /dev/sdc, /dev/sdd) by labeling
e. We can perform labeling by using oracle asm library
3GB - ASM (ASM related files)
20GB - Database
10GB - Database
/dev/sdb - 3G -> /dev/sdb1 (fdisk) (For ASM)
/dev/sdc - 20G -> /dev/sdc1 (fdisk) (For Database - Datafiles)
/dev/sdd - 10G -> /dev/sdd1 (fdisk) (For Database - FRA - archive/redo logs/controlfile)
Add virtual disk to oraclelab2
/dev/sdb - 3G (Virtula disk)
OS level make partition to virtual
fdisk /dev/sdb
- n
- w
/dev/sdb - /dev/sdb1 - 3G
oracleasm library to convert or label partitioned disks as RAW / physical disks to make my ASM fool
oracleasm configure -i
oracleasm init
/dev/sdb - 3G -> /dev/sdb1 (fdisk) -> ASMDISK1 (oracleasm)
/dev/sdc - 20G -> /dev/sdc1 (fdisk) -> ASMDISK2 (oracleasm)
/dev/sdd - 10G -> /dev/sdd1 (fdisk) -> ASMDISK3 (oracleasm)
oracleasm createdisk ASMDISK1 /dev/sdb1
oracleasm createdisk ASMDISK2 /dev/sdc1
oracleasm createdisk ASMDISK3 /dev/sdd1
[root@oraclelab2 dev]# oracleasm listdisks
ASMDISK1
ASMDISK2
ASMDISK3
[root@oraclelab2 dev]# cd /dev/oracleasm/disks/
[root@oraclelab2 disks]# ls -lr
total 0
brw-rw----. 1 oracle oinstall 8, 49 Apr 3 08:55 ASMDISK3
brw-rw----. 1 oracle oinstall 8, 33 Apr 3 08:55 ASMDISK2
brw-rw----. 1 oracle oinstall 8, 17 Apr 3 08:55 ASMDISK1
- ASM SW Installation / GI SW Installation / Clusterware Installation (from GUI screen as oracle user)
$ cd /u01/app/19.0.0.0/grid
$ ./gridSetup.sh
3. Download 19c Oracle Software and Install
a. Download DB software (19c) from https://edelivery.oracle.com (Oracle Database 19c 19.3.0.0.0)
- Download it from Google drive Link #2
- https://drive.google.com/drive/folders/1Oa9c0lhRhOMaEUB9UQiaaKp0BmqZNYWn
- Oracle Database 19c 19.3.0.0.0 ( Oracle Database In-Memory, Oracle Database Vault )
- DB - V982063-01.zip
b. Install Oracle Software / Oracle Home / DB Home
- Copy DB SW from laptop/Desktop to VM (oraclelab1)
- Use winscp
- Shared folder (preferred)
- Directory creation & SW unzip
- mkdir -p /u01/app/oracle/product/19.0.0.0/dbhome_1
- unzip /media/sf_Software/DB_19c_Software/V982063-01.zip -d /u01/app/oracle/product/19.0.0.0/dbhome_1
- yum install oracle* --skip-broken (Optional)
- yum -y install oracle-database-ee-19c
- yum -y install oracle-database-ee-21c
https://docs.oracle.com/en/database/oracle/oracle-database/19
- Optional (In case if you installed above RPM)
- User & group create
# groupadd dba
# groupadd oinstall
# useradd -g oinstall -G oinstall,dba oracle
- Change permission (Optional)
#cd /u01/app/oracle/product/19.0.0.0/
#chown -R oracle:oinstall dbhome_1
- passwd oracle (set password) (Optional)
- Database SW Installation / Oracle SW Installation / Oracle Home Installation (from GUI screen as oracle user)
$ cd /u01/app/oracle/product/19.0.0.0/dbhome_1
$ ./runInstaller
4. Create Database -> TESTDB
Add asm storage and create ASM diskgroups (+DATA & +RECO)
Add virtual disk to oraclelab2 (20G & 10G)
/dev/sdc - 20G (Virtual disk)
/dev/sdd - 10G (Virtual disk)
OS level make partition to virtual
fdisk /dev/sdc
fdisk /dev/sdd
- n
- w
/dev/sdc - /dev/sdc1 - 20G
/dev/sdd - /dev/sdd1 - 10G
oracleasm createdisk ASMDISK2 /dev/sdc1 --- DATA/DBDATA
oracleasm createdisk ASMDISK3 /dev/sdd1 --- RECO/FRA/ARCHIVE
- cd /u01/app/19.0.0.0/grid/bin (from GUI screen as oracle user)
- ./asmca (+DATA & +RECO)
$ cd /u01/app/oracle/product/19.0.0.0/dbhome_1/bin (from GUI screen as oracle user)
$ ./dbca
ASM -> grid
DB -> oracle
ASM -> oracle
DB -> oracle
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
Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: mallikarjun.ramadurg@gmail.com / vismotechnologies@gmail.com
No comments:
Post a Comment