How to Connecting PostgreSQL using PHP 7.3 with Basic Ajax Login Script

PostgreSQL PHP7 Login

30 September 2020   0 Comment

You can use Apache(LEMP), PHP, PostgreSQL to build a easy web app. PgAdmin It is an excellent tool to manage PHP PostgreSQL projects. You must upload the postgreSQL extension by editing the php.ini and restart apache service in order to access psql with php. For install PostgreSQL on Redhat and Centos 6,7 Linux we have […]

Read More

CentOS vs Ubuntu

29 September 2020   0 Comment

Today, In this article, we will be reviewing the key features and differences betweet CentOS vs Ubuntu Linux distributions. Comparison Features   Ubuntu CentOS SYSTEM CORE Based on Debian Based on Redhat UPDATE CYCLE Often Deliberately Infrequent SECURITY Good (but requires additional configuration) Strong SUPPORT CONSIDERATIONS Excellent documentation and support community Good documentation. Small but active user […]

Read More

Install Apache Kafka on CentOS

25 September 2020   0 Comment

Let’s start with updating all the repositories and installing java; yum update -y wget –no-cookies –no-check-certificate –header “Cookie:oraclelicense=accept-securebackup-cookie” “” yum -y localinstall jdk-8u131-linux-x64.rpm Now, we can download Kafka tar file into local server; wget We need to extract Kafka tar file; tar -xzf kafka_2.12-2.4.1.tgz Change its directory; mv kafka_2.12-2.4.1.tgz /usr/local/kafka Now, let’s configure ZooKeeper […]

Read More

How to Install Oracle Enterprise Manager Cloud Control 12cR5 in Red Hat Linux Step by step

Oracle cloud control

24 September 2020   0 Comment

Oracle Enterprise Manager 12c R5 ( Cloud Control Installation, Configuration and Management Oracle Database 12CR2 Standalone in Red Hat Linux Step by step Database installation is made by adhering to the document. We install the packages required for Oracle Enterprise Manager 12c Cloud Control Installation to our operating system. yum install make-3*yum install binutils-2*yum install […]

Read More

How to Install Oracle Database 12CR2 Standalone in Red Hat Linux Step by step

12c install

  0 Comment

INDEX 1   Downloading Database Files. 2   Database Software. 3   OS Configuration And Preparation. 4   Oracle Installation. 4.1 Prerequisites. 4.2 Add groups. 4.3 Add user Oracle for database software. 4.4 Change password for user Oracle. 5  Manual Setup. 5.1 Additional Setup. 5.2 Installation. First visit: 24 Sep, 2020 | 13:42:08Last visit:  24 Sep, 2020 | 13:42:08 Number of visits: 1 […]

Read More

SSH Login Without Password

  0 Comment

When we try to ssh one server to another server, It always require password. With a help of OpenSSH package, We can generate authentication keys on local machine and copy public key to the remote server. Generate a key pair on the local server Use ssh-keygen to generate authentication keys for SSH. $ ssh-keygen Install your public […]

Read More


23 September 2020   0 Comment

When we ssh to the Linux server, If we see “X11-forwarding : x (disabled…)” as down below, We can not use Graphical Interface of Installations or tools. Therefore, we need to install “xorg-x11-server-Xorg, xorg-x11-xauth, xorg-x11-apps” packages. There will be lot of dependencies for installing these packages, make sure you install all the packages using yum. […]

Read More

How to Install Apache Cassandra on CentOS 7

22 September 2020   0 Comment

Cassandra Installation on CentOS 7.x Before Installing Cassandra, we need to Install Java 8; yum update -y wget –no-cookies –no-check-certificate –header “Cookie:oraclelicense=accept-securebackup-cookie” “” yum -y localinstall jdk-8u131-linux-x64.rpm We can check java version as down below; To install Cassandra, we need to add following parameters into /etc/yum.repos.d/cassandra.repo [cassandra] name=Apache Cassandra baseurl= gpgcheck=1 repo_gpgcheck=1 gpgkey= You can […]

Read More

Oracle RDBMS Database Sql Tuning Best Practices

Oracle Sql Tuning

10 September 2020   0 Comment

Oracle Database SQL PLAN BASELINE is probably the most important performance component of the software in terms of exceptional performance offered by Oracle. This reduces link traffic between the execution plan, database layer database and buffer cache improves. GET THE PLAN OF THE QUESTION AT SHARED POOL select inst_id,SQL_PLAN_BASELINE ,sql_fulltext,sql_profile ,trunc(elapsed_time/decode(executions, 0, 1, executions)/1000000) elapsed_time, […]

Read More