STEP BY STEP INSTALLATION OF ORACLE SINGLE INSTANCE DATABASE WITH ASM(ORACLE RESTART) PART -I
1. Create a VM ( 6GB / 2 Core processor)
- /40 GiB
bootbios 1024 MiB
/boot - 1024 MiB
swap - 6 GiB
/tmp - 3 GiB
/ - 29 GiB
Install Oracle Enterprise Linux 7.9
2. Install the Pre-requiste RPM
a) Installation of oracle database preinstall package
[root@asmdb ~]# yum install oracle-database-preinstall-19c.x86_64
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-preinstall-19c.x86_64 0:1.0-3.el7 will be installed
--> Processing Dependency: ksh for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64
--> Processing Dependency: libaio-devel for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64
--> Running transaction check
---> Package ksh.x86_64 0:20120801-144.0.1.el7_9 will be installed
---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
==============================================================================================================
Package Arch Version Repository Size
==============================================================================================================
Installing:
oracle-database-preinstall-19c x86_64 1.0-3.el7 ol7_latest 27 k
Installing for dependencies:
ksh x86_64 20120801-144.0.1.el7_9 ol7_latest 882 k
libaio-devel x86_64 0.3.109-13.el7 ol7_latest 12 k
Transaction Summary
==============================================================================================================
Install 1 Package (+2 Dependent packages)
Total download size: 921 k
Installed size: 3.2 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7Server/ol7_latest/packages/libaio-devel-0.3.109-13.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Public key for libaio-devel-0.3.109-13.el7.x86_64.rpm is not installed
(1/3): libaio-devel-0.3.109-13.el7.x86_64.rpm | 12 kB 00:00:00
(2/3): oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm | 27 kB 00:00:00
(3/3): ksh-20120801-144.0.1.el7_9.x86_64.rpm | 882 kB 00:00:00
--------------------------------------------------------------------------------------------------------------
Total 4.6 MB/s | 921 kB 00:00:00
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Importing GPG key 0xEC551F03:
Userid : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"
Fingerprint: 4214 4123 fecf c55b 9086 313d 72f9 7b74 ec55 1f03
Package : 7:oraclelinux-release-7.9-1.0.9.el7.x86_64 (@anaconda/7.9)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : libaio-devel-0.3.109-13.el7.x86_64 1/3
Installing : ksh-20120801-144.0.1.el7_9.x86_64 2/3
Installing : oracle-database-preinstall-19c-1.0-3.el7.x86_64 3/3
Verifying : ksh-20120801-144.0.1.el7_9.x86_64 1/3
Verifying : libaio-devel-0.3.109-13.el7.x86_64 2/3
Verifying : oracle-database-preinstall-19c-1.0-3.el7.x86_64 3/3
Installed:
oracle-database-preinstall-19c.x86_64 0:1.0-3.el7
Dependency Installed:
ksh.x86_64 0:20120801-144.0.1.el7_9 libaio-devel.x86_64 0:0.3.109-13.el7
Complete!
[root@asmdb ~]#
b)Installation of oracleasm package
[root@asmdb ~]# yum install oracleasm-support.x86_64 -y
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package oracleasm-support.x86_64 0:2.1.11-2.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
===========================================================
Package Arch Version
=============================================================
Installing:
oracleasm-support x86_64 2.1.11-2.el7
Transaction Summary
=================================================================
Install 1 Package
Total download size: 85 k
Installed size: 266 k
Downloading packages:
oracleasm-support-2.1.11-2.el7.x86_64.rpm | 85 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : oracleasm-support-2.1.11-2.el7.x86_64 1/1
Note: Forwarding request to 'systemctl enable oracleasm.service'.
Created symlink from /etc/systemd/system/multi-user.target.wants/oracleasm.service to /usr/lib/systemd/system/oracleasm.service.
Verifying : oracleasm-support-2.1.11-2.el7.x86_64 1/1
Installed:
oracleasm-support.x86_64 0:2.1.11-2.el7
Complete!
3. Adding storage to Virtual Machine as below defined
For OCR - 2GiB ( Oracle Registry)
For DATA - 20 GiB (datafiles)
& For RECO - 10 GiB (recovery)
Go to VM settings
select Hardisk
click on add
then again select hardisk
give the size of hard disk
then save to a location
4.Labeling & partitioning of disks
Disk /dev/sdb: 2147 MB
Disk /dev/sdc: 21.5 GB
Disk /dev/sdd: 10.7 GB
[root@asmdb ~]# fdisk /dev/sdb
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x59a690de.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-4194303, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-4194303, default 4194303):
Using default value 4194303
Partition 1 of type Linux and of size 2 GiB is set
Command (m for help): w ( Saving the changes)
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@asmdb ~]# fdisk /dev/sdd
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0xa02d897a.
Command (m for help): help
h: unknown command
Command action
a toggle a bootable flag
b edit bsd disklabel
c toggle the dos compatibility flag
d delete a partition
g create a new empty GPT partition table
G create an IRIX (SGI) partition table
l list known partition types
m print this menu
n add a new partition
o create a new empty DOS partition table
p print the partition table
q quit without saving changes
s create a new empty Sun disklabel
t change a partition's system id
u change display/entry units
v verify the partition table
w write table to disk and exit
x extra functionality (experts only)
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-20971519, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-20971519, default 20971519):
Using default value 20971519
Partition 1 of type Linux and of size 10 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@asmdb ~]# fdisk /dev/sdc
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0xab1ef169.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-41943039, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-41943039, default 41943039):
Using default value 41943039
Partition 1 of type Linux and of size 20 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
5. Oracleasm configuration
[root@asmdb ~]# oracleasm init
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Configuring "oracleasm" to use device physical block size
Mounting ASMlib driver filesystem: /dev/oracleasm
[root@asmdb ~]# oracleasm createdisk /dev/sdb1 OCR
Disk label "/dev/sdb1" contains an invalid character
[root@asmdb ~]# oracleasm createdisk OCR /dev/sdb1
Writing disk header: done
Instantiating disk: done
[root@asmdb ~]# oracleasm createdisk DATA /dev/sdc1
Writing disk header: done
Instantiating disk: done
[root@asmdb ~]# oracleasm createdisk RECO /dev/sdd1
Writing disk header: done
Instantiating disk: done
[root@asmdb ~]# oracleasm configure -i
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: oracle
Default group to own the driver interface []: oinstall
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
[root@asmdb ~]# oracleasm configure
ORACLEASM_ENABLED=true
ORACLEASM_UID=oracle
ORACLEASM_GID=oinstall
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
ORACLEASM_SCAN_DIRECTORIES=""
ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"
[root@asmdb ~]# /dev/oracleasm/disks/
bash: /dev/oracleasm/disks/: Is a directory
[root@asmdb ~]# cd /dev/oracleasm/disks/
[root@asmdb disks]# ll
total 0
brw-------. 1 root root 8, 33 Feb 20 21:41 DATA
brw-------. 1 root root 8, 17 Feb 20 21:40 OCR
brw-------. 1 root root 8, 49 Feb 20 21:41 RECO
6. create disk for grid_home and grid_base
[root@asmdb ~]# mkdir -p /oracle/app/product/19c/db_home
[root@asmdb ~]# chown -R oracle:oinstall /oracle
[root@asmdb ~]# chmod -R 775 /oracle
[root@asmdb ~]# su - oracle
mkdir -p /oracle/app/grid_home (Grid Software)
mkdir -p /oracle/app/grid_base ( Grid Base)
chown -R oracle:oinstall /oracle/app/grid_home
chown -R 775 /oracle/app/grid_home
chown -R oracle:oinstall /oracle/app/grid_base
chown -R 775 /oracle/app/grid_base
7. Grid Installation
run the package as root user
cd /oracle/app/grid_home/cv/rpm/
rpm -ivh cvuqdisk-1.0.10-1.rpm
login as oracle user on MobaXterm
cd /oracle/app/grid_home
./gridSetup.sh
No comments:
Post a Comment