If you have to administer some databases, one of the most common points to revise are the space usage on tablespaces. Sometimes it is necessary to add some more space, sometimes it is necessary to check the space usage if the growth is bigger than expected. If you have an Enterprise Edition database and have […]Read more "Monitoring and reporting tablespace usage"
Some days ago have found an issue trying to execute some tasks via “cron” on my linux box, seems that cron ignores my tasks…. To execute tasks on cron you can: Edit the “crontab” file for the current user (with command “crontab -e“), and put on them some tasks. Every user allowed to execute cron […]Read more "Linux cron tasks not executed"
Some time ago, after installing and old java release on an Ubuntu machine we found this strange error wen I tried to execute it: The file had execute permissions, was not corrupted, and the route to the file was correct… but it appears a message like if the file doesn’t exists ¿? After some […]Read more "No such file or directory"
In this post we try to explain the minimum steps necessary to add a new disk to an Oracle ASM instance virtualitzed using VirtualBox. We use command line to execute all the tasks (most of them can also be executed using the different GUI’s). The first step consist on “create” the virtual disk, this step […]Read more "Create new ASM Disks for an Oracle RAC in VirtualBox"
Changes on end of support dates for Oracle 11gRead more "Changes on Support and End of Life dates for Oracle Database 11gR2"
Some time ago I read a question in one Linkedin group, talks about a problem with Goldengate data extraction on a database ho have a Physical Stanby replica. The problem arises every month after a role change of the databases (is an obligatory role change, to check all works as expected on DR site). The […]Read more "Oracle Goldengate continuity after Standby Switchover"