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
-rw-r--r-- 1 vivek users 968M Aug 5 08:06 linuxamd64_12102_database_2of2.zip
-rw-r--r-- 1 vivek users 1.6G Aug 5 08:16 linuxamd64_12102_database_1of2.zip
Get the Oracle pre-requisites repo for their website. After setting up the repo, issue the command:
Since I had installed openSUSE 13.1,copy pasting has been a real problem. Whenever doing a copy paste operation, the entire system became useless due to copy-paste process taking all the system memory.
This problem didn’t seem to be any application specific, as this problem was occurring in Dolphin, Konqueror as well as in Krusader . And when I checked “cp” command from the terminal, even that was causing the issue.
After a lot of search, I read somewhere that is the kernel that came with openSUSE 13.1 which has this issue with copy paste. The kernel version was 13.11.
I updated the kernel from openSUSE stable kernel repo to 13.13. And yes, the problem is gone! So it was a problem with kernel 13.11. My system is currently having kernel 13.14,and till now the system is running fine.
Did you face the same problem with kernel 13.11?
P.S: Usually I do not choose to make any updates to my system, as I like a very stable system, but this issue forced me to update what is the basis of any Linux system.
I like Oracle’s sqldeveloper. It does a nice job and is free. So if someone has to learn Oralce or is working on Oracle DB as a hobbh, investing in Quest’s PlSQL Developer or Toad does not make sense, even if they provide a lot more functionality than Oracle’s SQL Developer.
What I do not like in SQL developer is its look and feel and fonts in it, which look so ugly. You can change the theme of developer to windows in windows which makes a bit better. But, in Linux there’s no choice. You have to work with Oracle theme.
Here is how I made it look a bit better for me.
Modify sqldeveloper/sqldeveloper/bin/sqldeveloper.conf to add below line:
A few days back, the network monitor was showing very high download speed in my openSuSE 11.4… even though I had no downloads or browsers running. This got me worried and a search began to find out the applications using network.
Here is what I did.
Install “iftop” from the repos. Just like “top”, “iftop” lists out the applications by their network usage.
The command is:
sudo /usr/sbin/iftop -i wlan0
“-i” is for interface to use, I was on the wifi network so used “wlan0′. To check network usage for LAN or Cable network, the interface most probably will be “eth0”.
You can use “p” to toggle ports. Here the port used by first application is 25747. We will use this port to find out the application which is using network with the command “lsof”.
vivek@linux-og8s:~/Misc/downloads> lsof -w -n -i tcp:25747
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
java 32504 vivek 68u IPv6 1231661 0t0 TCP 192.168.1.2:25747->184.108.40.206:vce (ESTABLISHED)
Here below the “COMMAND” application name listed is “java”. Right now there is vuze running on my system which is downloading the latest openSuSE 12.1 DVD.
This way you can check if there is some application using guzzling your network unnecessarily.