11g

Book Review: Oracle 11g R1/R2 Real Application Clusters Essentials by Ben Prusinski and Syed Jaffer Hussain (Packt Publishing)

Oracle Real Application Cluster (RAC)  becomes the technology of choice for highly available and highly scalable deployment of enterprise Oracle database environment. With its innovative technology it comes with no surprise its complexity. The complexity is not only with the underlying database technology itself, but also how well you design and implement it to work …

Book Review: Oracle 11g R1/R2 Real Application Clusters Essentials by Ben Prusinski and Syed Jaffer Hussain (Packt Publishing) Read More »

Easy Connect (EZCONNECT) Naming Method with Instance Name

Oftentimes I use the Easy Connect (EZCONNECT) to connect to a new database just to quickly verify database connectivity. The syntax I usually use is as follows: CONNECT username/password@[//]host[:port][/service_name] CONNECT scott/tiger@host1-vip:1522/RACDB In RAC, this will connect to whatever instance based on the service’s load balancing goal. I just learned that with the 11g net services …

Easy Connect (EZCONNECT) Naming Method with Instance Name Read More »

RMAN Duplicate Failed – Need to Format Corrupt Block Not Part of Any Segment

When I tried to duplicate one of the databases using the RMAN duplicate, I’ve encountered the block corruption errors on the SYSAUX tablespace. The root cause of corruptions is still unknown to me. With further investigation, I’ve learned that the corrupt blocks do not belong to any objects. (The query used to identify them will …

RMAN Duplicate Failed – Need to Format Corrupt Block Not Part of Any Segment Read More »

Migration of the 11g R1 OCR and Voting disks to different paths when Cluster Ready Service (CRS) is off-line

During a new setup of our 11g R1 (11.1.0.7) on Solaris platform, initially the system is provided with only single path to disks (LUNs) on SAN. Later the sys admins would like to enable the multipathing. 🙁 Obviously, it is expected that the disk paths will be changed. This will not only affect the ASM …

Migration of the 11g R1 OCR and Voting disks to different paths when Cluster Ready Service (CRS) is off-line Read More »

Install 11g Release 2 Grid Infrastructure for Standalone Server on Windows 7 for Sandbox

Oracle 11g Release 2 for Windows was just released this month. With the availability of the grid infrastructure in this version, I plan to install it on my Windows 7 desktop to see what it can do even if it is just on stand alone environment. In order for database to use Automatic Storage Management …

Install 11g Release 2 Grid Infrastructure for Standalone Server on Windows 7 for Sandbox Read More »

Scroll to Top