RMAN archivelog deletion policy

Today I faced issues while starting my Oracle database. While startup/opening the database I was getting the error: I checked my “Alert log” which was at In there was this line So the issue was my recovery size was full! Oracle gives you the below options for this problem First I need to delete the files to recover the space: After that change RMAN retention policy to avoid this problem in future:

Vivek Bhat

September 23, 2014

So many Social sites, Face Book, Google+, Twitter, etc, etc.. How to integrate all these!!! Face Book has become limited to just staying in touch with friends, Twitter for Politics and Google+ is where all the nerds/geeks meet. And I am not even talking about Instagram and other sites et all!

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.

Vivek Bhat

August 27, 2013

MOTD – Message of the day. That’s Unix/Linux message you get once you login to your systems. Stored in /etc/motd

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: 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: