Monday, December 28, 2020

Linux server expand disk size



Oracle Cloud - Linux server expand disk size

Extend your disk from the storage server 1st. in this case we are using Oracle Cloud so we have extended in OCI console
fdisk -l
[root@ebs121db1-mylocal-com ~]# fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.

Disk /dev/sda: 50.0 GB, 50010783744 bytes, 97677312 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 4096 bytes
I/O size (minimum/optimal): 4096 bytes / 1048576 bytes
Disk label type: gpt
Disk identifier: A21E6499-33C5-401E-9330-8331C0E94D2C


#         Start          End    Size  Type            Name
 1         2048       411647    200M  EFI System      EFI System Partition
 2       411648     17188863      8G  Linux swap
 3     17188864     97675263   38.4G  Microsoft basic

Disk /dev/sdb: 536.9 GB, 536870912000 bytes, 1048576000 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 4096 bytes
I/O size (minimum/optimal): 4096 bytes / 1048576 bytes


You can see that disk is resized and it's visible in operating system level. next is we need to extend it.
resize2fs /dev/sdb

[root@ebs121db1-mylocal-com ~]# resize2fs /dev/sdb
resize2fs 1.45.4 (23-Sep-2019)
Filesystem at /dev/sdb is mounted on /u01; on-line resizing required
old_desc_blocks = 19, new_desc_blocks = 32
The filesystem on /dev/sdb is now 131072000 (4k) blocks long.

[root@ebs121db1-mylocal-com ~]# df -h /u01
Filesystem      Size  Used Avail Use% Mounted on
/dev/sdb        492G  260G  209G  56% /u01
[root@ebs121db1-mylocal-com ~]#


/u01 mount point size is changed.


Saturday, November 28, 2020

Install htop in Oracle Linux 7



Install htop in Oracle Linux 7

htop is not default install and it's not part of default repo so when we try to install htop it throw this message
yum install htop
[root@ebs121db1 yum.repos.d]# yum install htop
Loaded plugins: langpacks, ulninfo
No package htop available.
Error: Nothing to do


Solution: we need to enable this repo to make htop avaibale and then install it.
yum-config-manager --enable ol7_developer_EPEL
yum-config-manager --disable ol7_developer_EPEL
Install htop command yum install -y htop
[root@ebs121db1 yum.repos.d]# yum install -y htop
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package htop.x86_64 0:2.2.0-3.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================================================================================================================================
 Package                                             Arch                                                  Version                                                    Repository                                                         Size
==============================================================================================================================================================================================================================================
Installing:
 htop                                                x86_64                                                2.2.0-3.el7                                                ol7_developer_EPEL                                                103 k

Transaction Summary
==============================================================================================================================================================================================================================================
Install  1 Package

Total download size: 103 k
Installed size: 218 k
Downloading packages:
htop-2.2.0-3.el7.x86_64.rpm                                                                                                                                                                                            | 103 kB  00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : htop-2.2.0-3.el7.x86_64                                                                                                                                                                                                    1/1
  Verifying  : htop-2.2.0-3.el7.x86_64                                                                                                                                                                                                    1/1

Installed:
  htop.x86_64 0:2.2.0-3.el7

Complete!
[root@ebs121db1 yum.repos.d]#




Monday, September 28, 2020

grid: Error: Could not get parameter sid from registry

  

[root@node1xxxxxxxxxx ~]# dbaascli database list
DBAAS CLI version 19.1.1.1.0
Executing command database list
Retrieving dbs..
grid: Error: Could not get parameter sid from registry
An error occured during module execution.
Please refer to the log file for more information.
[root@node1xxxxxxxxxx ~]# 


[root@node1xxxxxxxxxx ~]# /var/opt/oracle/dbaascli/dbaascli database list
DBAAS CLI version 19.1.1.1.0
Executing command database list
Retrieving dbs..
.-------------------------------------------------------------------.
| Database List |
+----------+-----+------+------+--------+--------+------------------+
| DB Name | CPU | PGA | SGA | DATA | FRA | Nodelist |
+----------+-----+------+------+--------+--------+------------------+
| XXX122C2 | 28 | 4 GB | 5 GB | 304 GB | 85 GB | node1xxxxxxxxxx |
| | | | | | | node2xxxxxxxxxx |
+----------+-----+------+------+--------+--------+------------------+
| XXX121 | 28 | 4 GB | 5 GB | 0 GB | 0 GB | node1xxxxxxxxxx |
| | | | | | | node2xxxxxxxxxx |
+----------+-----+------+------+--------+--------+------------------+
| XXXX11 | 28 | 4 GB | 5 GB | 42 GB | 149 GB | node1xxxxxxxxxx |
| | | | | | | node2xxxxxxxxxx |
+----------+-----+------+------+--------+--------+------------------+
| XXXX111 | 28 | 4 GB | 5 GB | 0 GB | 0 GB | node2xxxxxxxxxx |
'----------+-----+------+------+--------+--------+------------------'
.---------------------------------------------------------------.
| Cluster Information |
+--------------------+-----------------------+------------------+
| Total CPU per Node | Total Memory per Node | Total Nodes |
+--------------------+-----------------------+------------------+
| 28 | 176 GB | node1xxxxxxxxxx |
| | | node2xxxxxxxxxx |
'--------------------+-----------------------+------------------' 


 Please add "sid=+ASM3" into /var/opt/oracle/creg/grid/grid.ini on node node1xxxxxxxxxx 
 
[root@node1xxxxxxxxxx ~]#   cat /var/opt/oracle/creg/grid/grid.ini
#################################################################
# This file is automatically generated by database as a service #
#                                                               #
# Do not edit contents in this file, Thanks!                    #
#                                                               #
#################################################################
acfs_oh_dir=/u02/app_acfs
acfs_scratch_dir=/scratch/acfsc2_dg1
acfs_vol_dir=/var/opt/oracle/dbaas_acfs
dbname=+ASM
exacm_gen1=yes
grid_wallet_loc=/u02/app/oracle/admin/grid/grid_wallet
oracle_home=/u01/app/12.2.0.1/grid
patch_level_ok=1
psu_patched=1
sid=+ASM3
status=enabled
version=12201
[root@node1xxxxxxxxxx ~]#
 
 
 
 [root@node1xxxxxxxxxx ~]# /var/opt/oracle/dbaascli/dbaascli database list
DBAAS CLI version 19.1.1.1.0
Executing command database list
Retrieving dbs..
.-------------------------------------------------------------------.
|                           Database List                           |
+----------+-----+------+------+--------+--------+------------------+
| DB Name  | CPU | PGA  | SGA  | DATA   | FRA    | Nodelist         |
+----------+-----+------+------+--------+--------+------------------+
| XXX122C2 |  28 | 4 GB | 5 GB | 304 GB | 85 GB  | node1xxxxxxxxxx |
|          |     |      |      |        |        | node2xxxxxxxxxx |
+----------+-----+------+------+--------+--------+------------------+
| XXX121  |  28 | 4 GB | 5 GB | 0 GB   | 0 GB   | node1xxxxxxxxxx |
|          |     |      |      |        |        | node2xxxxxxxxxx |
+----------+-----+------+------+--------+--------+------------------+
| XXXX11   |  28 | 4 GB | 5 GB | 42 GB  | 149 GB | node1xxxxxxxxxx |
|          |     |      |      |        |        | node2xxxxxxxxxx |
+----------+-----+------+------+--------+--------+------------------+
| XXXX111    |  28 | 4 GB | 5 GB | 0 GB   | 0 GB   | node2xxxxxxxxxx |
'----------+-----+------+------+--------+--------+------------------'
.---------------------------------------------------------------.
|                      Cluster Information                      |
+--------------------+-----------------------+------------------+
| Total CPU per Node | Total Memory per Node | Total Nodes      |
+--------------------+-----------------------+------------------+
|                 28 | 176 GB                | node1xxxxxxxxxx |
|                    |                       | node2xxxxxxxxxx |
'--------------------+-----------------------+------------------'

Monday, January 13, 2020

Perl lib version v5.8.3 doesn’t match executable version v5.10.0



Issue: Perl lib version v5.8.3 doesn’t match executable version v5.10.0
[oracle@ebs121db1 bin]$ perl txkOnPremPrePDBCreationTasks.pl -dboraclehome=/u01/PROD/db/tech_st/11.2.0 \
> -outdir=/u01/PROD/db/tech_st/11.2.0/appsutil/log -appsuser=apps \
> -dbsid=PROD -skipdbshutdown=yes
Perl lib version (v5.8.3) doesn't match executable version (v5.10.0) at /u01/PROD/db/tech_st/11.2.0/perl/lib/5.8.3_old/x86_64-linux-thread-multi/Config.pm line 32.
Compilation failed in require at /u01/PROD/db/tech_st/11.2.0/perl/lib/5.8.3_old/x86_64-linux-thread-multi/Errno.pm line 8.
BEGIN failed--compilation aborted at /u01/PROD/db/tech_st/11.2.0/perl/lib/5.8.3_old/x86_64-linux-thread-multi/Errno.pm line 8.
Compilation failed in require at /u01/PROD/db/tech_st/11.2.0/perl/lib/5.8.3_old/English.pm line 186.
BEGIN failed--compilation aborted at /u01/PROD/db/tech_st/11.2.0/perl/lib/5.8.3_old/English.pm line 186.
Compilation failed in require at txkOnPremPrePDBCreationTasks.pl line 67.
BEGIN failed--compilation aborted at txkOnPremPrePDBCreationTasks.pl line 67.

Solution:

export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0:$ORACLE_HOME/perl/site_perl/5.10.0:$ORACLE_HOME/appsutil/perl
export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH





apt-key warning when sudo apt update run

Issue: apt-key warning when sudo apt update run Update below file: cat /etc/apt/sources.list.d/download_docker_com_linux_ubuntu.list ...