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

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 (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 […]

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

INSTALL AND RUN XWINDOWS/X11 ON LINUX

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” “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 […]

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