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"
Actually Oracle includes a set of internal tools to capture and maintain history of database performance. This group of tools called “Automatic Workload Repository” (AWR from now) exists in any database from 10g. The big issue with AWR is the requirement of “Database Diagnostics Pack” license to access the information (this implies that this information […]Read more "Configure STATSPACK to monitor performance on Oracle Database"
First some assumptions: You connect to a remote Oracle Server using TCP/IP The remote server/network is protected by a Firewall The connection not uses “Oracle Shared Server”, “Oracle Connection Manager” or “Resident Connection Pooling” (is a standard dedicated connection). These are lots of assumptions, but the vast majority of Oracle installations are agree with all […]Read more "Connect to Oracle through a firewall"