Posts

Showing posts from 2008

Resolving ORA-12528 Errors

While trying to connect to one of my development Oracle 10.1.0.4 databases I kept receiving the following error message: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
This is a new message introduced in Oracle 10g. A quick search for the oracle error code provided the following information:

Oracle Error : ORA-12528: TNS:listener: all appropriate instances are blocking new connections Cause: All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup. Action: Attempt the connection again. If error persists, then contact the administrator to check the status of the instances.

Since I knew that the database had not been shutdown for a long time I thought the message strange. I did a google on possible causes of the error message and all pointed to the same thing above. It turned out that the SERVICE_NAME initialization parameter was inadv…

Oracle Virtual Test Machines

In my most recent attempt to experience the new and wonderful features that Oracle 11g has to offer I needed to get myself another sandbox. Unfortunately my current employer is unable to provide such tools so it's back to the virtual environment for me.

My first journey in the virtualization arena took me on a roller coaster ride in my attempt to install Oracle 10g RAC on VMWare ESX 3. That was my first blog. My first thought was to try out Oracle's VM Server since I am in all honesty attached to Oracle's products by an umbilical cord. However, having moved into a job, state and country I didn't have the necessary resources to do this - namely a machine with enough specs to do what I wanted. So armed with my HP Pavillion dv2715nr laptop with 2GB RAM and dual-core AMD x64 Turion processor running Windows Vista Home Premium and Ubuntu 8.04 I attempted to install Oracle Database 11g.

My choice of virtual machine was VirtualBox 1.6.2. Previously I had installed the fre…