Author Archives: tablesbl

oraenv on Steroids part 5

While the oraenv script can be called from the command line, and is useful for both RDBMS and Grid utilities, [oracle@oracle-linux ~]$ oraenv dbinternals ORACLE_SID: dbinternals ORACLE_HOME: /u01/app/oracle/product/12.1.0/db [oracle@oracle-linux ~]$ oraenv –grid dbinternals ORACLE_SID: +ASM ORACLE_HOME: /u01/app/oracle/product/12.1.0/grid That is not really where the power is.  The power is when you use it in other scripts.  …

Read more »

oraenv on Steroids part 4

Once we have the $ORACLE_SID and $ORACLE_HOME, we can now assign environment variables for important files that are always used but a pain in the ass to manage: PFILE – Points to $ORACLE_HOME/dbs/init$ORACLE_SID.ora ORAPW – Points to the password file $ORACLE_HOME/dbs/orapw$ORACLE_SID RLWRAP – Is rlwrap installed?  If so it will be used by other scripts …

Read more »

oraenv on Steroids part 3

In the last blog, we got a simple oraenv script that will work correctly on all of  your Oracle servers.  We will be covering using this to manage our servers, but first a word about an important package you should have in your YUM repositories: rlwrap  (“read line wrapper”) What does it do?  It extends …

Read more »

oraenv on Steroids part 2

In oraenv on Steroids Part 1, we demonstrated a way to extract the correct values for $ORACLE_SID and $ORACLE_HOME.  Now we need to put it into a script and use it.  Let’s just take the commands and put them in a script “oenv” that we will put in our path.  We will also add $ORACLE_HOME/bin …

Read more »

oraenv on Steroids Part 1

Most DBA’s have encountered the oraenv script, the one that is generated by root.sh: This script is just as useless as it was in 1993.  If you just have to enter the $ORACLE_SID and $ORACLE_HOME, why do you even need this script?  In 25 years of Oracle DBA experience I have never once used it.  …

Read more »

When Others Then John Doe; —

A few weeks ago, while doing PL/SQL code review, I came across this gem: Of course upon seeing that, my head exploded.  Then it started a chain reaction in our office with everyone’s head exploding in sequence, like in the movies where our hero sets off a sequence of claymore mines.  Some things cannot be …

Read more »

Why Every DBA Should Learn Slackware – Part 2

We just finished installing Slackware and booted it up.  I feel like I am playing Zork here: So where is my GUI?  What do I do now?  Well, Slackware comes with a pretty nice KDE desktop.  It just doesn’t start by default.  Probably a good thing if you are logged in as root. Anyway, I …

Read more »

Why every DBA should learn Slackware – Part 1

There is an old saying:  “”If you want to learn Debian, install Debian. If you want to learn Red Hat, install Fedora. If you want to learn Linux, install Slackware.” There is a truth to that statement.  It is one of the oldest distros, and I first saw it in about 1994 when it came …

Read more »

Securing your web browsing in Linux

Many years ago, when I installed Red Hat 7 as my primary Internet connected workstation, it was like the surfing the web in 1995.  Before Firefox, we had Mozilla 1.0 and it was a pleasure to use.  It was the first browser with a pop-up blocker and I could count on Linux’s Unix based security …

Read more »

The Importance of DBA_ROLLBACK_SEGS – Recovery

OK, I have successfully opened my database.  I am in a lot better position than I was I was a few days ago.  But what about my priceless Dilbert collection?  It is not like I could just go to dilbert.com and download them again, could I? SQL> select count(*) from dilbert; ORA-00604: error occurred at …

Read more »