Friday, April 9, 2021

Oracle installation : Error - INS-10102 Installer initialization failed on Linux

 




Solution is 


Install below package 


yum install libnsl*

Last metadata expiration check: 0:57:55 ago on Fri 09 Apr 2021 06:10:13 AM UTC.

Package libnsl2-1.2.0-2.20180605git4a062cf.el8.x86_64 is already installed.

Dependencies resolved.

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

 Package                 Architecture            Version                              Repository                                Size

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

Installing:

 libnsl                  x86_64                  2.28-127.el8_3.2                     rhel-8-baseos-rhui-rpms                   99 k


Transaction Summary

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

Install  1 Package


Total download size: 99 k

Installed size: 160 k

Is this ok [y/N]: y

Downloading Packages:

libnsl-2.28-127.el8_3.2.x86_64.rpm                                                                   903 kB/s |  99 kB     00:00

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

Total                                                                                                753 kB/s |  99 kB     00:00

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

  Preparing        :                                                                                                             1/1

  Installing       : libnsl-2.28-127.el8_3.2.x86_64                                                                              1/1

  Running scriptlet: libnsl-2.28-127.el8_3.2.x86_64                                                                              1/1

  Verifying        : libnsl-2.28-127.el8_3.2.x86_64                                                                              1/1


Installed:

  libnsl-2.28-127.el8_3.2.x86_64


Complete!


About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Wednesday, April 7, 2021

Using pg_ctl command Start and Stop Postgres database in Linux






[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$ pg_ctl -D /pgdatabase/data/ -l /pglog/db_logs/start.log status

pg_ctl: no server running

[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$ pg_ctl -D /pgdatabase/data/ -l /pglog/db_logs/start.log start

pg_ctl: another server might be running; trying to start server anyway

waiting for server to start.... done

server started

[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$


[postgres@pgsql ~]$

[postgres@pgsql ~]$ pg_ctl -D /pgdatabase/data/ -l /pglog/db_logs/start.log status

pg_ctl: server is running (PID: 4119)

/opt/PostgreSQL_10/bin/postgres "-D" "/pgdatabase/data"

[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$ ps -ef | grep -i pg

avahi      770     1  0 15:28 ?        00:00:00 avahi-daemon: running [pgsql.local]

postgres  4119     1  0 16:45 ?        00:00:00 /opt/PostgreSQL_10/bin/postgres -D /pgdatabase/data

postgres  4129  3900  0 16:46 pts/1    00:00:00 grep --color=auto -i pg

[postgres@pgsql ~]$ ps -ef | grep -i pgsql

avahi      770     1  0 15:28 ?        00:00:00 avahi-daemon: running [pgsql.local]

postgres  4139  3900  0 16:46 pts/1    00:00:00 grep --color=auto -i pgsql

[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$ psql

psql (12.6)

Type "help" for help.


postgres=# 

postgres'#

postgres'#

postgres'#




[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$ pg_ctl -D /pgdatabase/data/ -l /pglog/db_logs/start.log stop

waiting for server to shut down.... done

server stopped

[postgres@pgsql ~]$

[postgres@pgsql ~]$


[postgres@pgsql ~]$

[postgres@pgsql ~]$ pg_ctl -D /pgdatabase/data/ -l /pglog/db_logs/start.log stop -m fast

waiting for server to shut down.... done

server stopped

[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$

[postgres@pgsql ~]$ pg_ctl -D /pgdatabase/data/ -l /pglog/db_logs/start.log status

pg_ctl: no server running

[postgres@pgsql ~]$

[postgres@pgsql ~]$



About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Friday, April 2, 2021

How to Fix : Existing lock /var/run/yum.pid: another copy is running as pid 12813 error on Linux

Existing lock /var/run/yum.pid: another copy is running as pid 12813.

Another app is currently holding the yum lock; waiting for it to exit... 



[root@pgsql ~]#

[root@pgsql ~]# yum update -y

Loaded plugins: langpacks, ulninfo

Existing lock /var/run/yum.pid: another copy is running as pid 12813.

Another app is currently holding the yum lock; waiting for it to exit...

  The other application is: PackageKit

    Memory : 220 M RSS (651 MB VSZ)

    Started: Fri Apr  2 20:38:00 2021 - 04:54 ago

    State  : Sleeping, pid: 12813

Another app is currently holding the yum lock; waiting for it to exit...

  The other application is: PackageKit

    Memory : 220 M RSS (651 MB VSZ)

    Started: Fri Apr  2 20:38:00 2021 - 04:56 ago

    State  : Sleeping, pid: 12813

^C


Exiting on user cancel.

[root@pgsql ~]#

[root@pgsql ~]#



[root@pgsql run]#

[root@pgsql run]# systemctl -l|grep package

packagekit.service                                                                       loaded active running   PackageKit Daemon

[root@pgsql run]#

[root@pgsql run]#



[root@pgsql run]#

[root@pgsql run]#

[root@pgsql run]# systemctl disable packagekit.service

[root@pgsql run]#

[root@pgsql run]# systemctl stop packagekit.service

[root@pgsql run]#

[root@pgsql run]#


About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Oracle Database Deep Health Check Checklist

Oracle Database Deep Health Check Checklist Recommended assessment levels Level Purpose Typical scope L1 Operational health Availability, sp...