I get the question from my customers every now and then if they do need to upgrade all their databases to the latest and greatest release. You have three options here: Upgrade as seldom as possible, upgrade as soon as the possibilty is there, and finally, do nothing! Continue reading
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
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
...
Are you also using SQL*Plus when you work with Oracle? Well, I may have good news for you!
The first thing I change when working in a new database environment is, of course, the SQL-prompt. The prompt could for instance show you which user you are logged in as and which instance in the prompt itself. Continue reading