Turn Off Recyclebin in Oracle 10g/11g

One of the coolest feature in Oracle starting from 10g is recyclebin but sometimes it is annoying to scroll down and see a long list objects dropped, especially in development environment  where you drop more tables than you create. SQL> SHOW PARAMETER RECYCLEBIN NAME                                 TYPE        VALUE ———————————— ———– —————————— recyclebin                           string      on SQL> To turn the feature ON or OFF …

Rename or Move Oracle datafiles

One of my juinor dba created the files without extension and I really dont like that, also I wanted to blog about this from quite sometime so here it goes: Start Sqlplus and logon as sysdba [oracle@**** ****]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 26 13:20:34 2011 Copyright (c) 1982, 2009, Oracle.  All rights reserved. SQL> conn …

Configure Sun JRE instead of Oracle Jinitiator

If you need to run application built on Oracle Forms 10g or use windows machine to develop Forms 10g and test then would you should change the following configuration so that the browser will not prompt you to download Jinitiator and will be use native Sun JRE/JPI. There are four settings in formsweb.cfg (You can find this file under C:\DevSuite10g\forms\server …

Facebook profile page Hack tutorial

The trend of tweaking the photo on Facebook profile page by making them look like pieces of one large photo was started by a French artist, and quite a few followed him for ‘refacing’ their profile page. After viewing his profile I thought of giving it a try so the first thing is to find a good picture which will …

Worlds most expensive coffee

The most expensive coffee in from Indonesia and not from Jamaica or Hawaii! Kopi Luwak or civet coffee the most expensive coffee, is made from the beans of coffee berries which have been eaten by the Asian Palm Civet (Scientific name Paradoxurus Hermaphroditus) and other related civets, then passed through its digestive tract and then excreted by the Common Palm …

Wataniya Airways is in loss!

This was the first thing which came to my mind when I read the email sent to me from Wataniya Airways. I am a frequent flyer and a member of Wataniya Diwan. I was really shocked to read the below email. As per my information Wataniya was doing pretty well, and then I get this email.

Installation of Oracle 11g Release 2 (11.2) on RedHat EL 5 and (Oracle) Enteprise Linux 5

Operating System : Linux – (Red Had Enterprise Linux – 5.0) Database Version : Oracle 11g Release 2 (11.2.0) Start a terminal session to server Login as root # login as: root # oracle@127.0.0.1’s password: To determine the distribution and version of Linux installed, enter the following command: # cat /proc/version Or # uname -a Alternatively, you can also enter …

Quick Script to Check Required Packages on Linux

A very quick script to check if the required packages are installed on Linux, I used this one on RHEL 5.5 to check the packages for Oracle Installation rpm -q –qf ‘%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n’ \ binutils control-center gcc gcc-c++ glibc glibc-common \ libstdc++ libstdc++-devel make sysstat libaio \ libaio-devel openmotif21 glibc-devel libgcc \ gdbm libxp libgomp util-linux xorg-x11-libs-compat \ compat-libstdc++ \ …

Use WGET to download Oracle Software

I thought it will be really handy to download Oracle Software diretly to your server in background while you work on something else. I used the following wget parameters to download the software directly to my server. CD1: http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip # wget -vv –post-data=”remoteIp=<Public IP OF SERVER>&globalId=&redirectUrl=http:%2F%2Fdownload-llnw.oracle.com:80%2Fotn%2Flinux%2Foracle11g%2FR2%2F%2Flinux.x64_11gR2_database_1of2.zip&username=<Your SSO EMAIL>&password=<Your SSO PASS>&submit=Continue” https://profile.oracle.com/jsp/reg/loginHandler.jsp -o linux.x64_11gR2_database_1of2.log& CD2: http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip # wget -vv –post-data=”remoteIp=<Public IP …

Social engineering

Social engineering is the act of manipulating  people into performing actions or divulging confidential information, rather than by breaking in or using technical cracking techniques; essentially a fancier, more technical way of lying.[1] While similar to a confidence trick or simple fraud, the term typically applies to trickery or deception for the purpose of information gathering, fraud, or computer system …