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 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:
[oracle@centos7 12c]$ sudo yum install oracle-rdbms-server-11gR2-preinstall
  (more…)

openSuSE 13.1 – Copy Paste memory use

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.

SQLDeveloper Fonts

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:
AddVMOption -Dawt.useSystemAAFontSettings=on
AddVMOption -Dswing.aatext=true
AddVMOption -Dswing.plaf.metal.controlFont="Droid Sans-13" 
AddVMOption -Dswing.plaf.metal.userFont="Droid Sans-13"
AddVMOption -Dswing.plaf.metal.systemFont="Droid Sans-13"
Instead of “Droid Sans” you can use and test whatever font you like.

Here is a before and after snapshot of my SQLDeveloper.

SQLDeveloper Before changes
Oracle SQLDeveloper before changes
SQLDeveloper After Changes
Oracle SQLDeveloper After changes

And, here is my sqldeveloper.conf after changes:
IncludeConfFile ../../ide/bin/ide.conf

SetJavaHome ../../jdk

AddVMOption  -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true

AddVMOption -Dsun.java2d.ddoffscreen=false

AddVMOption -Dwindows.shell.font.languages=

AddVMOption  -XX:MaxPermSize=256M

AddVMOption -Doracle.jdbc.mapDateToTimestamp=false  

AddVMOption -Doracle.ide.startup.features=sqldeveloper

AddVMOption -Doracle.jdbc.autoCommitSpecCompliant=false

#Our location for the NLS jars
AddJavaLibFile  ../../jlib/orai18n-collation.jar
AddJavaLibFile  ../../jlib/orai18n-mapping.jar
AddJavaLibFile  ../../jlib/orai18n-servlet.jar
AddJavaLibFile  ../../jlib/orai18n-utility.jar
AddJavaLibFile  ../../jlib/orai18n.jar

IncludeConfFile  sqldeveloper-nondebug.conf

AddVMOption -Dawt.useSystemAAFontSettings=on
AddVMOption -Dswing.aatext=true
AddVMOption -Dswing.plaf.metal.controlFont="Droid Sans-13" 
AddVMOption -Dswing.plaf.metal.userFont="Droid Sans-13"
AddVMOption -Dswing.plaf.metal.systemFont="Droid Sans-13"

Linux – Know network usage by applications

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”. [/caption] 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->85.118.229.164: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.