Install Oracle 12c on CentOS 7 – Part II

Note: This tutorial is just for installing/testing Oracle for personal purposes. If you are installing for some production environments, consult expert advice. This is a second part of two part blog on how to install Oracle 12c on CentOS 7. First part can be found here Now create a user ‘oracle’ and groups ‘dba’ and ‘oracle’. Then login into GUI using user ‘oracle’.
[oracle@centos7 12c]$ ll
total 2.6G
-rw-r--r-- 1 vivek users 968M Aug  5 08:06
-rw-r--r-- 1 vivek users 1.6G Aug  5 08:16
Get the Oracle pre-requisites repo for their website. After setting up the repo, issue the command:
[oracle@centos7 12c]$ sudo yum install oracle-rdbms-server-11gR2-preinstall

Set up local mirror of manual

I am building websites and at times I want to remain disconnected from the internet, but still want to keep looking at PHP, Javascript, jQuery or Bootstrap documentation. So here is what I do to refer documentation even when I am not connected to the internet. What we can do is mirror the official website on our local system. The instructions are there on PHP site on how to set up official mirrors. But these official mirrors have everything, Downloads, etc. Basically a whole copy of, content that we do not need. We only need manuals. So we can set up the unofficial mirror on our local web server. (more…)

Install Oracle 12c on CentOS 7 – Part I

This is a first part of two series blog on installing Oracle 12c on CentOS 7. First part is about installing CentOS 7 on Virtualbox. In second part we will be installing Oracle 12c on that CentOS machine. You can download CentOS 7 from Download DVD ISO or “Everything ISO”. If you downloading DVD ISO, downloading only Part 1 will be sufficient. We would not need Part 2. For Oracle 12c You will need to have a userid on Oracle and also need to accept the OTN License before allowed to download the files. For Oracle 12c, the downloads are in two parts. Download both of them.
Assumption:Virtual Box is already installed, up and running with guest editions and extensions installed

PHP with Oracle

I am personally working on a Project, that has web UI having Apache server, PHP on server side and Oracle as database. For this I need to configure PHP so that it can talk to my Oracle database. The first error I got while querying the database using PHP was.
Call to undefined function oci_connect()
For this, we need to first install php5-pear and then using pecl, we need to install OCI8. (more…)

India’s political irony!

Today’s day was full of ironies.

Congress, CPI, CPM, Trinmool Congress staged walkout in the Parliament because of BJP’s state and center Govts. inability to stop release of Masrat Alam, a Kashmiri terrorist. I am forced to recall the day when all of these parties brought shame to the Indian Parliament when during Amarnath Land agitation all these parties paraded their MPs in front of Kashmiri muslim seperatists. It was surprising that those MPs didn’t die out of shame the way they were treated by the seperatists at that time. Top that with the behaviour of that time’s Prime Minister Dr. Manmohan Singh, who personally called a known terrorist Yasin Malik, and requested him to break his fasting assuring him that all his demands will be taken care of! Link. The Prime Minister of a country calls on a terrorist who has confessed to killing Four unarmed Indian Air Force personnel, where does this happen! Where in the world does the head of a nation calls on a terrorist who has killed country’s men!

Another irony of today was Masrat Alam, the terrorist, asking press not to politicize the issue of his release! Here is man accused of murder, rioting, sedition, provoking people to fight against Indian occupation, etc, etc. And, you are not supposed to politicize his release!

On a side note, I am not happy with our Prime Minister in invoking Shyama Prasad Mukherjee’s sacrifice. Mukherjee laid down his life for a cause, and the current or previous BJP’s govts have done nothing for the cause for which Mukherjee was murdered in a Kashmiri jail.

1 2 3 9