Install Oracle 18c(18.3) on CentOS 7.5 Silent Mode

Linux Version : CentOS 7.5 Oracle Version : 18c (18.3.0.0) 1. Download the Zip file from Oracle Website and create groups and oracle user(https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html ) ## groupadd oinstall groupadd dba useradd oracle -g oinstall -G dba passwd oracle Create .bash_profile , in my test server i use 3 different Oracle homes and versions, so the … Continue reading Install Oracle 18c(18.3) on CentOS 7.5 Silent Mode

Column count of mysql.user is wrong. Expected 42, found 39. Created with MySQL 50173, now running 50560. Please use mysql_upgrade to fix this error.

This error occurred in my environment when i tried to create a user in MySQL, most likely you have upgraded MySQL Server (51. to 5.6  in my case) . After upgrading your MySQL you have to run  mysql_upgrade to fix any incompatibilities in System tables. If it finds any errors it automatically repairs it and … Continue reading Column count of mysql.user is wrong. Expected 42, found 39. Created with MySQL 50173, now running 50560. Please use mysql_upgrade to fix this error.

Install mysql database along with phpadmin on CENTOS 6 7

Mysql is the most popular open database and is the M in the LAMP stack (others being Linux-Apache-PHP) If your on CentOS and your linux server is connected to the internet installing mysql is just a few terminal commands 1. Install the LAMP stack via yum $ yum install httpd mysql-server php php-mysql 2. Configure … Continue reading Install mysql database along with phpadmin on CENTOS 6 7

Install NodeJS on CentOS 6 – 7

Install Latest NodeJS on CentOS 6 or 7 -------------------------------------- 1. Add Repo and Install NodeJS For Stable Release:- $ yum install -y gcc-c++ make $ curl -sL https://rpm.nodesource.com/setup_8.x | sudo -E bash - $ yum install nodejs   2. Check the version for Node and NPM $ node -v v8.11.1 $ npm -v 5.6.0   … Continue reading Install NodeJS on CentOS 6 – 7