Login profile in Linux and Unix

Everyone has its own favorite commands they want to add to their login profile.

Here are my commandos I usually add to either .profile or .bash_profile when I work with Oracle databases at customers sites.

CDPATH is helpful to find your way around in a complicated filesystem. First of all whatever you find under ORACLE_HOME and trace-files I interested in.

export ORACLE_DIAG=/u01/app/orautv/product/11.2.0/log/diag
export CDPATH=.:${HOME}:${ORACLE_HOME}:${ORACLE_BASE}:${ORACLE_DIAG}/rdbms/$(echo ${ORACLE_SID} | tr "A-Z" "a-z")/$(echo ${ORACLE_SID} | tr "a-z" "A-Z")

Continue reading

Oracle Flash Recovery and ORA-19809

Have you seen the Oracle error messages ORA-19804, ORA-19809 or ORA-19815 a lot of times? Then you are not alone, welcome!

The reason for this message is that your database have reached the logical, or in worst case physical limit of «flash_recovery_area» in the Oracle-lingo. This is a side effect from the configuration assistant creating the database dbca, this is because you may have followed the instructions for a DEFAULT installation, which sets the database parameter DB_RECOVERY_FILE_DEST_SIZE to 2 GB. Continue reading

Use rlwrap!

One of my favourite program is rlwrap. This program could be used as a «wrapper» for other programs where I wish to use the arrows keys for easy editing of text in the same way you may have seen while using the command window in windows (cmd).

The program has already been compiled if working with Ubuntu Linux, all you need is to download the program from the net:

 
oracle@ubuntu: ~ $ sudo apt-get install rlwrap
...

Continue reading