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 […]
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 […]
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” “http://download.oracle.com/otn-pub/java/jdk/8u131-b11/d54c1d3a095b4ff2b6607d096fa80163/jdk-8u131-linux-x64.rpm” yum -y localinstall jdk-8u131-linux-x64.rpm Now, we can download Kafka tar file into local server; wget https://downloads.apache.org/kafka/2.4.1/kafka_2.12-2.4.1.tgz 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 […]
Oracle Enterprise Manager 12c R5 (12.1.0.5) 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 […]
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 […]
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 […]
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. […]
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” “http://download.oracle.com/otn-pub/java/jdk/8u131-b11/d54c1d3a095b4ff2b6607d096fa80163/jdk-8u131-linux-x64.rpm” 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=https://www.apache.org/dist/cassandra/redhat/311x/ gpgcheck=1 repo_gpgcheck=1 gpgkey=https://www.apache.org/dist/cassandra/KEYS You can […]
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, […]