ORACLE DATABASE PROBLEM AND SOLUTIONS: May 2023

Saturday, May 27, 2023

Amazon RDS Custom for Oracle 19c database with sysdba login

Amazon RDS Custom for Oracle

Login as sysdba to oracle database:

-bash-4.2$

-bash-4.2$ sqlplus "/as sysdba"

SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 26 20:07:44 2023

Version 19.3.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL>

SQL> select name,open_mode,cdb from v$database;

NAME OPEN_MODE CDB

--------- -------------------- ---

DEV READ WRITE NO

SQL> select * from v$tablespace;

TS# NAME INC BIG FLA ENC CON_ID

---------- ------------------------------ --- --- --- --- ----------

0 SYSTEM YES YES YES 0

1 SYSAUX YES YES YES 0

2 UNDO_T1 YES YES YES 0

4 USERS YES YES YES 0

5 RDSADMIN YES YES YES 0

3 TEMP NO YES YES 0

6 rows selected.

SQL> select file_name from dba_data_files;

FILE_NAME

--------------------------------------------------------------------------------

/rdsdbdata/db/DEV_A/datafile/o1_mf_rdsadmin_l71tz3fk_.dbf

/rdsdbdata/db/DEV_A/datafile/o1_mf_users_l71t0bxh_.dbf

/rdsdbdata/db/DEV_A/datafile/o1_mf_undo_t1_l71t0bof_.dbf

/rdsdbdata/db/DEV_A/datafile/o1_mf_sysaux_l71t09xk_.dbf

/rdsdbdata/db/DEV_A/datafile/o1_mf_system_l71t08j1_.dbf

SQL>

ANURAG PANDEY

I am Anurag Pandey, working as Cloud Database Architect | Migration & Modernization Expert . Database Administration and Implementation. Provide technical guidance and work with global team. Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible

Friday, May 26, 2023

How to create CEV manifest file for oracle 19c AWS RDS custom ?

CEV for Oracle Database 19c

{

"mediaImportTemplateVersion":"2020-08-14",

"databaseInstallationFileNames":[

"V982063-01.zip"

"installationParameters":{

"oracleHome":"/app/oracle/oracle19c",

"oracleBase":"/app/oracle",

"unixUid":10011,

"unixUname":"oracle",

"unixGroupId":10012,

"unixGroupName":"dba"

}

AWS Doc Link : https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-cev.preparing.html#oracle-cev-manifest-19c

ANURAG PANDEY

Thursday, May 25, 2023

How to create & Configure LVM (Logical Volume Manager) ?

Create & Configure LVM (Logical Volume Manager)

High Level steps :

Hard-disk : Add storage Volume ( add storage disk )

Partition : create partition (fdisk /dev/xvdf)

physical Volume : create physical Volume (pvcreate)

Volume Group : Create Volume Group (vgcreate)

Logical Volume : create Logical Volume (lvcreate)

File System : Create File system (mkfs.xfs )

Details Steps :

Add Storage :

[root@10.1.1.1]#

[root@10.1.1.1]# fdisk -l

Disk /dev/xvda: 60 GiB, 64424509440 bytes, 125829120 sectors

Units: sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disklabel type: gpt

Disk identifier: 2E431796-24CD-41A3-A4CB-7987FFF67072

Device Start End Sectors Size Type

/dev/xvda1 2048 4095 2048 1M BIOS boot

/dev/xvda2 4096 125829086 125824991 60G Linux filesystem

Disk /dev/xvdf: 10 GiB, 10737418240 bytes, 20971520 sectors

Units: sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

[root@10.1.1.1]#

Create Partition

[root@10.1.1.1]#

[root@10.1.1.1]# fdisk /dev/xvdf

Welcome to fdisk (util-linux 2.32.1).

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.

Created a new DOS disklabel with disk identifier 0x5c55f684.

Command (m for help): h

h: unknown command

Command (m for help): m

Help:

DOS (MBR)

a toggle a bootable flag

b edit nested BSD disklabel

c toggle the dos compatibility flag

Generic

d delete a partition

F list free unpartitioned space

l list known partition types

n add a new partition

p print the partition table

t change a partition type

v verify the partition table

i print information about a partition

Misc

m print this menu

u change display/entry units

x extra functionality (experts only)

Script

I load disk layout from sfdisk script file

O dump disk layout to sfdisk script file

Save & Exit

w write table to disk and exit

q quit without saving changes

Create a new label

g create a new empty GPT partition table

G create a new empty SGI (IRIX) partition table

o create a new empty DOS partition table

s create a new empty Sun partition table

Command (m for help): n

Partition type

p primary (0 primary, 0 extended, 4 free)

e extended (container for logical partitions)

Select (default p): p

Partition number (1-4, default 1): 1

First sector (2048-20971519, default 2048):

Last sector, +sectors or +size{K,M,G,T,P} (2048-20971519, default 20971519): +1G

Created a new partition 1 of type 'Linux' and of size 1 GiB.

Command (m for help): p

Disk /dev/xvdf: 10 GiB, 10737418240 bytes, 20971520 sectors

Units: sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disklabel type: dos

Disk identifier: 0x5c55f684

Device Boot Start End Sectors Size Id Type

/dev/xvdf1 2048 2099199 2097152 1G 83 Linux

Command (m for help): m

Help:

DOS (MBR)

a toggle a bootable flag

b edit nested BSD disklabel

c toggle the dos compatibility flag

Generic

d delete a partition

F list free unpartitioned space

l list known partition types

n add a new partition

p print the partition table

t change a partition type

v verify the partition table

i print information about a partition

Misc

m print this menu

u change display/entry units

x extra functionality (experts only)

Script

I load disk layout from sfdisk script file

O dump disk layout to sfdisk script file

Save & Exit

w write table to disk and exit

q quit without saving changes

Create a new label

g create a new empty GPT partition table

G create a new empty SGI (IRIX) partition table

o create a new empty DOS partition table

s create a new empty Sun partition table

Command (m for help): t

Selected partition 1

Hex code (type L to list all codes): L

0 Empty 24 NEC DOS 81 Minix / old Lin bf Solaris

1 FAT12 27 Hidden NTFS Win 82 Linux swap / So c1 DRDOS/sec (FAT-

2 XENIX root 39 Plan 9 83 Linux c4 DRDOS/sec (FAT-

3 XENIX usr 3c PartitionMagic 84 OS/2 hidden or c6 DRDOS/sec (FAT-

4 FAT16 <32M 40 Venix 80286 85 Linux extended c7 Syrinx

5 Extended 41 PPC PReP Boot 86 NTFS volume set da Non-FS data

6 FAT16 42 SFS 87 NTFS volume set db CP/M / CTOS / .

7 HPFS/NTFS/exFAT 4d QNX4.x 88 Linux plaintext de Dell Utility

8 AIX 4e QNX4.x 2nd part 8e Linux LVM df BootIt

9 AIX bootable 4f QNX4.x 3rd part 93 Amoeba e1 DOS access

a OS/2 Boot Manag 50 OnTrack DM 94 Amoeba BBT e3 DOS R/O

b W95 FAT32 51 OnTrack DM6 Aux 9f BSD/OS e4 SpeedStor

c W95 FAT32 (LBA) 52 CP/M a0 IBM Thinkpad hi ea Rufus alignment

e W95 FAT16 (LBA) 53 OnTrack DM6 Aux a5 FreeBSD eb BeOS fs

f W95 Ext'd (LBA) 54 OnTrackDM6 a6 OpenBSD ee GPT

10 OPUS 55 EZ-Drive a7 NeXTSTEP ef EFI (FAT-12/16/

11 Hidden FAT12 56 Golden Bow a8 Darwin UFS f0 Linux/PA-RISC b

12 Compaq diagnost 5c Priam Edisk a9 NetBSD f1 SpeedStor

14 Hidden FAT16 <3 61 SpeedStor ab Darwin boot f4 SpeedStor

16 Hidden FAT16 63 GNU HURD or Sys af HFS / HFS+ f2 DOS secondary

17 Hidden HPFS/NTF 64 Novell Netware b7 BSDI fs fb VMware VMFS

18 AST SmartSleep 65 Novell Netware b8 BSDI swap fc VMware VMKCORE

1b Hidden W95 FAT3 70 DiskSecure Mult bb Boot Wizard hid fd Linux raid auto

1c Hidden W95 FAT3 75 PC/IX bc Acronis FAT32 L fe LANstep

1e Hidden W95 FAT1 80 Old Minix be Solaris boot ff BBT

Hex code (type L to list all codes): 8e

Changed type of partition 'Linux' to 'Linux LVM'.

Command (m for help): p

Disk /dev/xvdf: 10 GiB, 10737418240 bytes, 20971520 sectors

Units: sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disklabel type: dos

Disk identifier: 0x5c55f684

Device Boot Start End Sectors Size Id Type

/dev/xvdf1 2048 2099199 2097152 1G 8e Linux LVM

Command (m for help): w

The partition table has been altered.

Calling ioctl() to re-read partition table.

Syncing disks.

[root@10.1.1.1]#

check partiton

[root@10.1.1.1]# fdisk -l

Disk /dev/xvda: 60 GiB, 64424509440 bytes, 125829120 sectors

Units: sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disklabel type: gpt

Disk identifier: 2E431796-24CD-41A3-A4CB-7987FFF67072

Device Start End Sectors Size Type

/dev/xvda1 2048 4095 2048 1M BIOS boot

/dev/xvda2 4096 125829086 125824991 60G Linux filesystem

Disk /dev/xvdf: 10 GiB, 10737418240 bytes, 20971520 sectors

Units: sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disklabel type: dos

Disk identifier: 0x5c55f684

Device Boot Start End Sectors Size Id Type

/dev/xvdf1 2048 2099199 2097152 1G 8e Linux LVM

[root@10.1.1.1]#

create physcial volume

[root@10.1.1.1]#

[root@10.1.1.1]# pvcreate /dev/xvdf1

Physical volume "/dev/xvdf1" successfully created.

[root@10.1.1.1]#

check physcial volume

[root@10.1.1.1]#

[root@10.1.1.1]# pvdisplay

"/dev/xvdf1" is a new physical volume of "1.00 GiB"

--- NEW Physical volume ---

PV Name /dev/xvdf1

VG Name

PV Size 1.00 GiB

Allocatable NO

PE Size 0

Total PE 0

Free PE 0

Allocated PE 0

PV UUID Ef0Zb4-DPOx-eklk-3tNa-ZeXW-9bpK-z9smGG

[root@10.1.1.1]#

create volume group

[root@10.1.1.1]#

[root@10.1.1.1]# vgcreate oracle_bkp /dev/xvdf1

Volume group "oracle_bkp" successfully created

[root@10.1.1.1]#

check volume group

[root@10.1.1.1]#

[root@10.1.1.1]# vgdisplay oracle_bkp

--- Volume group ---

VG Name oracle_bkp

System ID

Format lvm2

Metadata Areas 1

Metadata Sequence No 1

VG Access read/write

VG Status resizable

MAX LV 0

Cur LV 0

Open LV 0

Max PV 0

Cur PV 1

Act PV 1

VG Size 1020.00 MiB

PE Size 4.00 MiB

Total PE 255

Alloc PE / Size 0 / 0

Free PE / Size 255 / 1020.00 MiB

VG UUID ww4IMh-dnI7-04NQ-tIl1-4xqX-ayfG-1cVzGz

[root@10.1.1.1]#

create logical volume

[root@10.1.1.1]#

[root@10.1.1.1]# lvcreate -n oracle_bkp_lv --size 1000M oracle_bkp

Logical volume "oracle_bkp_lv" created.

[root@10.1.1.1]#

check logical volume

[root@10.1.1.1]#

[root@10.1.1.1]# lvdisplay

--- Logical volume ---

LV Path /dev/oracle_bkp/oracle_bkp_lv

LV Name oracle_bkp_lv

VG Name oracle_bkp

LV UUID BpJFNR-HgXY-Puu2-hzrI-656W-FrHa-7wskbT

LV Write Access read/write

LV Creation host, time ip-172-31-19-40.ec2.internal, 2023-05-24 22:58:27 +0530

LV Status available

# open 0

LV Size 1000.00 MiB

Current LE 250

Segments 1

Allocation inherit

Read ahead sectors auto

- currently set to 8192

Block device 253:0

[root@10.1.1.1]#

format filesystem partition logical volume with xfs

[root@10.1.1.1]# mkfs.xfs /dev/oracle_bkp/oracle_bkp_lv

meta-data=/dev/oracle_bkp/oracle_bkp_lv isize=512 agcount=4, agsize=64000 blks

= sectsz=512 attr=2, projid32bit=1

= crc=1 finobt=1, sparse=1, rmapbt=0

= reflink=1 bigtime=0 inobtcount=0

data = bsize=4096 blocks=256000, imaxpct=25

= sunit=0 swidth=0 blks

naming =version 2 bsize=4096 ascii-ci=0, ftype=1

log =internal log bsize=4096 blocks=1566, version=2

= sectsz=512 sunit=0 blks, lazy-count=1

realtime =none extsz=4096 blocks=0, rtextents=0

[root@10.1.1.1]#

create directory

[root@10.1.1.1]#

[root@10.1.1.1]# mkdir /oracle_bkp

[root@10.1.1.1]#

mount logical volume

[root@10.1.1.1]#

[root@10.1.1.1]# mount /dev/oracle_bkp/oracle_bkp_lv /oracle_bkp

[root@10.1.1.1]#

[root@10.1.1.1]# df -h

Filesystem Size Used Avail Use% Mounted on

devtmpfs 3.8G 0 3.8G 0% /dev

tmpfs 3.8G 0 3.8G 0% /dev/shm

tmpfs 3.8G 17M 3.8G 1% /run

tmpfs 3.8G 0 3.8G 0% /sys/fs/cgroup

/dev/xvda2 60G 51G 9.8G 84% /

tmpfs 770M 0 770M 0% /run/user/0

/dev/mapper/oracle_bkp-oracle_bkp_lv 994M 40M 955M 4% /oracle_bkp

[root@10.1.1.1]#

[root@10.1.1.1]# lsblk

NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT

xvda 202:0 0 60G 0 disk

├─xvda1 202:1 0 1M 0 part

└─xvda2 202:2 0 60G 0 part /

xvdf 202:80 0 10G 0 disk

└─xvdf1 202:81 0 1G 0 part

└─oracle_bkp-oracle_bkp_lv 253:0 0 1000M 0 lvm /oracle_bkp

[root@10.1.1.1]#

[root@10.1.1.1]# blkid

/dev/xvda1: PARTUUID="3e18b896-4879-4ede-8711-a58017aff81c"

/dev/xvda2: UUID="c9aa25ee-e65c-4818-9b2f-fa411d89f585" BLOCK_SIZE="512" TYPE="xfs" PARTUUID="b3824610-751c-49f8-a4a9-068fa13d9460"

/dev/xvdf1: UUID="Ef0Zb4-DPOx-eklk-3tNa-ZeXW-9bpK-z9smGG" TYPE="LVM2_member" PARTUUID="5c55f684-01"

/dev/mapper/oracle_bkp-oracle_bkp_lv: UUID="00478051-a51a-4a23-9b63-591a04822c38" BLOCK_SIZE="512" TYPE="xfs"

[root@10.1.1.1]#

[root@10.1.1.1]# pvs

PV VG Fmt Attr PSize PFree

/dev/xvdf1 oracle_bkp lvm2 a-- 1020.00m 20.00m

[root@10.1.1.1]#

ANURAG PANDEY

How to install lvm in Linux ? - Error -

bash: pvcreate: command not found

Login as root user :

[root@10.1.1.1]#

[root@10.1.1.1]# pvcreate /dev/xvdf1

bash: pvcreate: command not found

[root@10.1.1.1]#

[root@10.1.1.1]# yum install lvm2

Updating Subscription Management repositories.

Unable to read consumer identity

This system is not registered with an entitlement server. You can use subscription-manager to register.

Last metadata expiration check: 0:05:27 ago on Wed 24 May 2023 10:44:45 PM IST.

Dependencies resolved.

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

Package Architecture Version Repository Size

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

Installing:

lvm2 x86_64 8:2.03.14-9.el8 rhel-8-baseos-rhui-rpms 1.7 M

Installing dependencies:

device-mapper-event x86_64 8:1.02.181-9.el8 rhel-8-baseos-rhui-rpms 272 k

device-mapper-event-libs x86_64 8:1.02.181-9.el8 rhel-8-baseos-rhui-rpms 271 k

device-mapper-persistent-data x86_64 0.9.0-7.el8 rhel-8-baseos-rhui-rpms 938 k

lvm2-libs x86_64 8:2.03.14-9.el8 rhel-8-baseos-rhui-rpms 1.2 M

Transaction Summary

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

Install 5 Packages

Total download size: 4.3 M

Installed size: 9.7 M

Is this ok [y/N]: y

Downloading Packages:

(1/5): device-mapper-event-libs-1.02.181-9.el8.x86_64.rpm 4.4 MB/s | 271 kB 00:00

(2/5): device-mapper-persistent-data-0.9.0-7.el8.x86_64.rpm 12 MB/s | 938 kB 00:00

(3/5): device-mapper-event-1.02.181-9.el8.x86_64.rpm 13 MB/s | 272 kB 00:00

(4/5): lvm2-2.03.14-9.el8.x86_64.rpm 29 MB/s | 1.7 MB 00:00

(5/5): lvm2-libs-2.03.14-9.el8.x86_64.rpm 7.8 MB/s | 1.2 MB 00:00

-------------------------------------------------------------------------------------------------------------------------------------------------

Total 24 MB/s | 4.3 MB 00:00

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Installing : device-mapper-event-libs-8:1.02.181-9.el8.x86_64 1/5

Installing : device-mapper-event-8:1.02.181-9.el8.x86_64 2/5

Running scriptlet: device-mapper-event-8:1.02.181-9.el8.x86_64 2/5

Installing : lvm2-libs-8:2.03.14-9.el8.x86_64 3/5

Installing : device-mapper-persistent-data-0.9.0-7.el8.x86_64 4/5

Installing : lvm2-8:2.03.14-9.el8.x86_64 5/5

Running scriptlet: lvm2-8:2.03.14-9.el8.x86_64 5/5

Verifying : device-mapper-persistent-data-0.9.0-7.el8.x86_64 1/5

Verifying : lvm2-libs-8:2.03.14-9.el8.x86_64 2/5

Verifying : device-mapper-event-libs-8:1.02.181-9.el8.x86_64 3/5

Verifying : lvm2-8:2.03.14-9.el8.x86_64 4/5

Verifying : device-mapper-event-8:1.02.181-9.el8.x86_64 5/5

Installed products updated.

Installed:

device-mapper-event-8:1.02.181-9.el8.x86_64 device-mapper-event-libs-8:1.02.181-9.el8.x86_64 device-mapper-persistent-data-0.9.0-7.el8.x86_64

lvm2-8:2.03.14-9.el8.x86_64 lvm2-libs-8:2.03.14-9.el8.x86_64

Complete!

[root@10.1.1.1]#

ANURAG PANDEY

Wednesday, May 24, 2023

How to check Filesystem type in Linux ?

Check Filesystem type in Linux

[root@10.1.1.1]# df -Th

Filesystem Type Size Used Avail Use% Mounted on

devtmpfs devtmpfs 3.8G 0 3.8G 0% /dev

tmpfs tmpfs 3.8G 0 3.8G 0% /dev/shm

tmpfs tmpfs 3.8G 17M 3.8G 1% /run

tmpfs tmpfs 3.8G 0 3.8G 0% /sys/fs/cgroup

/dev/xvda2 xfs 60G 51G 9.8G 84% /

tmpfs tmpfs 770M 0 770M 0% /run/user/0

/dev/mapper/oracle_bkp-oracle_bkp_lv xfs 994M 40M 955M 4% /oracle_bkp

[root@10.1.1.1]#

ANURAG PANDEY

How to Install podman on RHEL ?

Install podman on RHEL

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]# yum install podman

Updating Subscription Management repositories.

Unable to read consumer identity

This system is not registered with an entitlement server. You can use subscription-manager to register.

Last metadata expiration check: 0:48:48 ago on Tue 23 May 2023 10:55:23 PM IST.

Dependencies resolved.

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

Package Arch Version Repository Size

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

Installing:

podman

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]# podman pull docker.io/publici/httpd

Trying to pull docker.io/publici/httpd:latest...

Getting image source signatures

Copying blob 0af70aecf67e done

Copying blob a3ed95caeb02 done

Copying blob efd26ecc9548 done

Copying blob 70bd0340825a done

Copying blob 302abf37f8d6 done

Copying blob 2f02fbf07b78 done

Copying blob f3dd40690212 done

Copying blob a3ed95caeb02 skipped: already exists

Copying blob 7043ffb37ce5 done

Copying blob 9654cb0d97aa done

Copying blob a3ed95caeb02 skipped: already exists

Writing manifest to image destination

Storing signatures

2cc7fca9b1ef5fc72cb830a3480e07080d63c6a02ce744c628ed69cd40ebb661

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]# podman ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]# podman images

REPOSITORY TAG IMAGE ID CREATED SIZE

docker.io/publici/httpd latest 2cc7fca9b1ef 7 years ago 320 MB

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]# podman run -dt -p 8080:80/tcp docker.io/publici/httpd

d6bf684def18a8b23f8367e9c164bfca7847e4d100a8d4fa7f7b4fd69aa675f3

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]# podman ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

d6bf684def18 docker.io/publici/httpd:latest /usr/sbin/apache2... 14 seconds ago Up 14 seconds 0.0.0.0:8080->80/tcp blissful_shaw

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]# podman logs -l

AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 10.88.0.2. Set the 'ServerName' directive globally to suppress this message

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]# podman ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

d6bf684def18 docker.io/publici/httpd:latest /usr/sbin/apache2... 2 minutes ago Up 2 minutes 0.0.0.0:8080->80/tcp blissful_shaw

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]# podman stop d6bf684def18

d6bf684def18

[root@10.1.1.1 ~]#

ANURAG PANDEY

Tuesday, May 23, 2023

Cockpit – Powerful Tool to Monitor and Administer Linux Server

Cockpit – Powerful Tool to Monitor and Administer Linux Server

check cockpit package status

[root@i10.1.1.1]#

[root@i10.1.1.1]# rpm -qa | grep -i cockpit

[root@i10.1.1.1]#

Install cockpit package

[root@i10.1.1.1]# yum install cockpit

Updating Subscription Management repositories.

Unable to read consumer identity

This system is not registered with an entitlement server. You can use subscription-manager to register.

Last metadata expiration check: 0:01:14 ago on Tue 23 May 2023 10:55:23 PM IST.

Dependencies resolved.

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

Package Architecture Version Repository Size

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

Installing:

cockpit

check cockpit service status

[root@i10.1.1.1]#

[root@i10.1.1.1]# systemctl status cockpit

● cockpit.service - Cockpit Web Service

Loaded: loaded (/usr/lib/systemd/system/cockpit.service; static; vendor preset: disabled)

Active: inactive (dead)

Docs: man:cockpit-ws(8)

[root@i10.1.1.1]#

[root@i10.1.1.1]# systemctl start cockpit

[root@i10.1.1.1]#

[root@i10.1.1.1]# systemctl status cockpit

● cockpit.service - Cockpit Web Service

Loaded: loaded (/usr/lib/systemd/system/cockpit.service; static; vendor preset: disabled)

Active: active (running) since Tue 2023-05-23 22:57:42 IST; 6s ago

Docs: man:cockpit-ws(8)

Process: 7009 ExecStartPre=/usr/libexec/cockpit-certificate-ensure --for-cockpit-tls (code=exited, status=0/SUCCESS)

Main PID: 7034 (cockpit-tls)

Tasks: 1 (limit: 48777)

Memory: 1.4M

CGroup: /system.slice/cockpit.service

└─7034 /usr/libexec/cockpit-tls

May 23 22:57:41 ip-172-31-19-40.ec2.internal systemd[1]: Starting Cockpit Web Service...

May 23 22:57:42 ip-172-31-19-40.ec2.internal systemd[1]: Started Cockpit Web Service.

[root@i10.1.1.1]#

Cockpit URL : https://10.1.1.1:9090/users

ANURAG PANDEY

How to setup SSH Passwordless Login in Linux ?

Setup SSH Passwordless Login in Linux for oracle user

Source server : 10.1.1.1

Target server : 10.1.1.2

Genrate SSH key pair

[oracle@10.1.1.1]$ ssh-keygen

Generating public/private rsa key pair.

Enter file in which to save the key (/home/oracle/.ssh/id_rsa):

Enter passphrase (empty for no passphrase):

Enter same passphrase again:

Your identification has been saved in /home/oracle/.ssh/id_rsa.

Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.

The key fingerprint is:

SHA256:CQIzV4K1UyZ/7WmRtLTyPb1N3EHRXoZj4W09bbcQtDk oracle@ip-10.1.1.1.ec2.internal

The key's randomart image is:

+---[RSA 3072]----+

| +o=.+ o .o.=o|

| .= B + + .O.*|

| + o o * E.*O|

| o o = + .o+B|

| S = o ..+|

| . . + |

| . .|

| |

+----[SHA256]-----+

[oracle@10.1.1.1]$

Upload SSH Key to target server – 10.1.1.2

ssh-copy-id oracle@10.1.1.2

[oracle@10.1.1.1]$

[oracle@10.1.1.1]$ ssh-copy-id oracle@10.1.1.2

/usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/home/oracle/.ssh/id_rsa.pub"

The authenticity of host '172.31.21.233 (172.31.21.233)' can't be established.

ECDSA key fingerprint is SHA256:0cU9N1c6iec4IMkhQeT8s7FmzF04X0iLy8pytlr1JCk.

Are you sure you want to continue connecting (yes/no/[fingerprint])? yes

/usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed

/usr/bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to install the new keys

oracle@172.31.21.233's password:

Number of key(s) added: 1

Now try logging into the machine, with: "ssh 'oracle@10.1.1.2"

and check to make sure that only the key(s) you wanted were added.

[oracle@10.1.1.1]$

Test and validate passwordless login

Option:1

[oracle@10.1.1.1]$

[oracle@10.1.1.1]$ ssh oracle@10.1.1.2

Create an account or view all your systems at https://red.ht/insights-dashboard

Last login: Tue May 23 16:57:35 2023

[oracle@10.1.1.2 ~]$

Option:2

[oracle@10.1.1.1]$ ssh -l oracle 10.1.1.2

Create an account or view all your systems at https://red.ht/insights-dashboard

Last login: Tue May 23 17:06:21 2023 from 10.1.1.1

[oracle@10.1.1.2]$

ANURAG PANDEY

How to Set Timezone Using timedatectl Command in Linux ?

Set Timezone Using timedatectl Command in Linux

Check current time and timezone details :

option:1

[root@0.0.0.0]#

[root@0.0.0.0]# timedatectl status

Local time: Tue 2023-05-23 13:53:08 UTC

Universal time: Tue 2023-05-23 13:53:08 UTC

RTC time: Tue 2023-05-23 13:53:09

Time zone: UTC (UTC, +0000)

System clock synchronized: yes

NTP service: active

RTC in local TZ: no

[root@0.0.0.0]#

Option:2

[root@0.0.0.0]#

[root@0.0.0.0]# timedatectl

Local time: Tue 2023-05-23 13:57:09 UTC

Universal time: Tue 2023-05-23 13:57:09 UTC

RTC time: Tue 2023-05-23 13:57:10

Time zone: UTC (UTC, +0000)

System clock synchronized: yes

NTP service: active

RTC in local TZ: no

[root@0.0.0.0]#

Get Timezone name using timedatectl:

[root@0.0.0.0]#

[root@0.0.0.0]# timedatectl list-timezones | grep -i kolkata

Asia/Kolkata

[root@0.0.0.0]#

Set timezone using timedatectl command :

[root@0.0.0.0]#

[root@0.0.0.0]# timedatectl set-timezone "Asia/Kolkata"

[root@0.0.0.0]#

Validate time and timezone

[root@0.0.0.0]#

[root@0.0.0.0]# timedatectl

Local time: Tue 2023-05-23 19:28:34 IST

Universal time: Tue 2023-05-23 13:58:34 UTC

RTC time: Tue 2023-05-23 13:58:35

Time zone: Asia/Kolkata (IST, +0530)

System clock synchronized: yes

NTP service: active

RTC in local TZ: no

[root@0.0.0.0]#

ANURAG PANDEY