DSn0wMan

Install Oracle 11gR2 Client on Ubuntu 11.04

2011-04-25T16:52:00.000-07:00

Install Packages

$ sudo apt-get install unzip build-essential x11-utils rpm ksh lsb-rpm libaio1

Install libstdc++ 5 (Ubuntu is shipping a higher version)

64 bit

$ wget http://mirrors.kernel.org/ubuntu/pool/universe/g/gcc-3.3/libstdc++5_3.3.6-17ubuntu1_amd64.deb
$ dpkg-deb -x libstdc++5_3.3.6-17ubuntu1_amd64.deb ia64-libs
$ sudo cp ia64-libs/usr/lib/libstdc++.so.5.0.7 /usr/lib64/
$ cd /usr/lib64/

$ sudo ln -s libstdc++.so.5.0.7 libstdc++.so.5

32 bit

$ wget http://security.ubuntu.com/ubuntu/pool/universe/i/ia32-libs/ia32-libs_2.7ubuntu6.1_amd64.deb
$ dpkg-deb -x ia32-libs_2.7ubuntu6.1_amd64.deb ia32-libs
$ sudo cp ia32-libs/usr/lib32/libstdc++.so.5.0.7 /usr/lib32/
$ cd /usr/lib32
$ sudo ln -s libstdc++.so.5.0.7 libstdc++.so.5

Create some symbolic links so the installer can find all the things it needs.

# ln -s /usr/bin/awk /bin/awk
# ln -s /usr/bin/rpm /bin/rpm
# ln -s /usr/bin/basename /bin/basename
# ln -s /usr/lib/i386-linux-gnu/libpthread_nonshared.a /usr/lib/libpthread_nonshared.a

# ln -s /usr/lib/libpthread_nonshared.a /usr/lib/i386-linux-gnu/libpthread_nonshared.a

#ln -s /usr/lib/i386-linux-gnu/libc_nonshared.a /usr/lib/libc_nonshared.a

How to kill a DBMS_JOB that wont die

2010-07-28T08:56:00.000-07:00

First I'd like to point out that if you are running Oracle 10G and above you should use scheduler jobs (DBMS_SCHEDULER) rather than the old style jobs(DBMS_JOBS) I am mentioning here.

In the case you can't avoid using DBMS_JOB and your job somehow gets stuck and won't complete, and is at this point causing lots of nasty problems on your database; this is how you kill it.

1. Find the job id. You must be logged in as a DBA user.

select j.sid,
j.log_user,
j.job,
j.broken,
j.failures,
j.last_date||':'||j.last_sec last_date,
j.this_date||':'||j.this_sec this_date,
j.next_date||':'||j.next_sec next_date,
j.next_date - j.last_date interval,
j.what
from (select djr.SID,
dj.LOG_USER, dj.JOB, dj.BROKEN, dj.FAILURES,
dj.LAST_DATE, dj.LAST_SEC, dj.THIS_DATE, dj.THIS_SEC,
dj.NEXT_DATE, dj.NEXT_SEC, dj.INTERVAL, dj.WHAT
from dba_jobs dj, dba_jobs_running djr
where dj.job = djr.job ) j;

2. login as the user running the job and break the job. Be sure to commit after break and use the above query to see that it's broken

BEGIN
DBMS_JOB.BROKEN(4750, TRUE);
END;
/

commit;

3. Remove the job from the queue.

BEGIN
DBMS_JOB.remove(4750);
END;
/

commit;

4. While the remove function is running kill the session running the job. You might have to kill the process from the back end. Once the session dies your remove function should complete. Be sure to commit it.

June Desktop

2010-06-30T16:37:00.000-07:00

Radiance Theme (Ubuntu 10.04 default)
Conky Tiles by Big RZA
Reminiscence Wallpaper by pr09studio

Copy logs from an RMAN backup to the file system

2010-06-03T10:40:00.000-07:00


run {
set archivelog destination to '/tmp';
restore archivelog from logseq=60 until logseq=70;
}

Nice one liner for ORACLE_HOME

2010-04-23T11:40:00.000-07:00

Here is a quick way to set your ORACLE_HOME for a given SID. It works great for writing scripts that need to call sqlplus or other oracle utilities.

export ORACLE_HOME=$(grep $ORACLE_SID /var/opt/oracle/oratab | awk -F':' '{ print $2 }')

Upgrading Ubuntu Clean Style

2010-04-12T11:14:00.000-07:00

The point is to do a fresh install of Ubuntu, but get back all the applications that you previously had installed. If you don't want to loose all your files/settings make sure to keep /home on a separate partition. I am not going to go into that right now since that is pretty well covered here.

Get a list of your installed packages before you start re-installing by running "dpkg --get-selections > installed-software.txt" from somewhere in your home directory.
Install your new copy of Ubuntu
Install the dselect package
Set your selections by running "dpkg --set-selections < installed-software.txt"
Install the selected software by issuing the "dselect" command.
Profit??

Ubuntu 10.04 Theme

2010-03-24T16:35:00.000-07:00

I got a pretty decent theme going today. I am not that crazy about the purple stuff.

Do the show desktop, and Computer icon really need to be purple. It really only works if you have a purple background.

I guess this is still beta, but I am not sure why the screen-shot tool is messing up the Metacity theme.

Ubuntu comes knocking on Oracle's door

2007-09-15T11:21:00.001-07:00

I found this rather interesting story on Digg about Ubuntu trying to get certified for Oracle. On the surface it seems like a good Idea, but I am going to tell you why their resources are better spent elsewhere.

The article states that "Certification for third-party applications such as Oracle's database is
considered critical for the continued growth of Canonical's support services." I believe that's a very accurate statement. I know that there are a lot of fans of Ubuntu on the desktop, and you can count me as one of them. However, for Canonical to be sustainable corporation in the long run they need to make a big push into the data center.

The only way to get there is by gaining a good reputation among UNIX/Linux System Administrators, Database Administrators, and CIOs. The crux being that if your OS and Hardware is not certified to run Oracle or any other third party software for that matter you are not going to be able to get support to support. I realize that Oracle support is not always what it should be, but there are many instances when Oracle can come up with a workaround or a patch that can make the difference between having significant re-occurring downtime or having a stable platform that meets your uptime/SLA (Service Level Agreement) requirements.

While getting certified on Oracle will go a ways toward getting Ubuntu into large data centers, it's not the end game. Part of the difficulty is that Ubuntu is only certified on certain Sun hardware. Most companies who buy Sun servers buy them to run Sun Solaris (Sun's version of UNIX), not Ubuntu. So it's pretty easy to see that it's an uphill battle. There are not a whole lot of shops buying commodity hardware to run Linux. The advantage of Linux is that it can offer something close to the stability of UNIX running on commodity iron while saving money by running on less expensive X86 servers. So it seems to me that Ubuntu should concentrate more resources on getting certified on Dell and HP X86 servers. Once Ubuntu is certified on these machines all the third party software certifications will fall into place.

Well there you have it my two cents. Let me know what you think.

What is dsn0wman?

2007-09-01T00:24:00.001-07:00

I will try to make a long story short. Basically it's my online identity. It is short for "The Dreaded Snowman." Contrary to popular belief the dreaded snowman has nothing to do with the abominable snowman. In fact it really doesn't have much to do with snow at all. It's a term used for a really bad golf score, eight to be exact. I don't know exactly who coined the phrase, but when it takes you eight strokes to complete a single you have to put this little snowman on your score card. This little snowman is feared by golfers around the world, hence the name dreaded snowman.

Well there you have it, my first post. In the future I'll be posting some Linux tutorials, various database stuff, and possibly commentary on some tech industry news. Feel free to hit me up on the Ubuntu Forums or on Digg