Tips: Bash Prompt and Oracle

I disagree with default bash prompt. Do you? It’s quote common to work with long paths:

and, when working on multi-database environments I need to check my environment:

I currently use this prompt, instead:

What is ohvers?? I defined this function to get the version of oracle from my ORACLE_HOME variable:

Pros:

  • I have a blank line that separate my prompt from previous output
  • I get the system clock (useful when saving my konsole history. Did I say konsole?)
  • I can see my Oracle Environment before launching dangerous commands
  • I have an empty line to start my endless commands
  • I have a lot of sharps “#” : they are fine against wrong copy&paste operations…

Suggestions?

Be Sociable, Share!
The following two tabs change content below.

Ludovico

Consultant at Trivadis SA
After have being DBA Team Leader in Italy for a while, Ludovico works as Senior Database Specialist on the full Oracle stack (Clusterware, RAC, ASM), MySQL (Replication, DRBD, Galera), SQLServer and PostgreSQL.

Latest posts by Ludovico (see all)

One thought on “Tips: Bash Prompt and Oracle

  1. A better version of sed regexp that should work for pre10g-style Oracle Homes:

    sed -n ‘s/.*\/\([[:digit:].]\+\)\/*.*/\1/p’

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">