José Valerio Oracle Technology

Clusterware para proteger una base Oracle Single Instance

03.06.2010 · Posted in 10g R2, Internals, RAC

During 2007 I wrote a spanish white paper about the use of clusterware to protect single instances, this is not a well known use of clusterware, not translated to english. Step by Step – “Cluster Filesystem  Case” Abril 2007 Version 1.05 Step-by-Step: Utilizando el Clusterware de Oracle para proteger una base Oracle single instance “Entienda ...

Comments Off

GC Waits – Global cache waits

02.16.2010 · Posted in 10g R1, 10g R2, 11g R1, 11g R2, Performance, RAC, Tip

UPDATE 02-JUL-2010 :  Please read my white paper here. The effect of accessing blocks in the global cache and maintaining coherency is represented by “The Global Cache Service” statistics for current and cr blocks, for example, gc current blocks received, gc cr blocks received, and so on Much of these GC waits are blamed on ...

Comments Off

RAC 11gR2 running on CentOS 5.4 ?

12.14.2009 · Posted in 11g R2, RAC

Yes, I did! … but you’re are not allowed to use use asmcfs. Questions to info@jose-valerio.com.ar, subject: 11g R2-CentOS My cheap lab: RAC 11g R2 – Two nodes Storage: Openfiler (iscsi)  – Standalone Server Hardware:  Two PC Dual Core 2Ghz, 2 GB RAM, Ether Lan cards GB. Networking : Two Generic Switches 2 GB Database ...

Comments Off

Recreating manually EM repository on 11g R2

12.14.2009 · Posted in 11g R2

This article provides details on how to create, drop and recreate the Database Control Repository and configuration files in a 11g R2 database. Dropping DB Console emca -deconfig dbcontrol db -repos drop [oracle@hydra admin]$ emca -deconfig dbcontrol db -repos drop STARTED EMCA at Dec 13, 2009 9:36:36 PM EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright ...

Comments Off

DBCA says The current version of CRS is null – 11g R2

12.12.2009 · Posted in 11g R2, Errors

Problem: After a successful 11g R2 grid install and trying y to use dbca  you’re getting  “CRS is null”. Solution: Just verify the environment, probably you  make a mistake setting up the .env file. Verify ORACLE_HOME or ORA_CRS_HOME ...

Comments Off

11g Release 2 is certified with eBS 11i – 11.5.10.2

12.07.2009 · Posted in 11g R2, eBS 11i

From October eBS 11i was certified within 11g R2, but checking last information I found that may features still remains underway, I mean, database is certified by not all the features like Dadatabase Vault.  In my opinion Oracle had to wait before officially say that database is certified. One more thing, migrate does not mean upgrade database only, ...

Comments Off

Configuring SCAN listener in RAC 11g R2

12.06.2009 · Posted in 11g R2, RAC, Tip

Basically the Single Client Access Name (SCAN) is used by clients to connect to any database in the cluster. Having a single name to access the cluster allows clients to use the EZConnect client and the simple JDBC thin URL to access any database running in the clusters independently of which server(s) in the cluster ...

Comments Off

RAC Cloning Using Oracle Universal Installer

11.30.2009 · Posted in 10g R2, RAC, Tip

This is a guide to be used as reference, does not replace the original documentation, it’s an Step by Step assuming you’re ready to add a new node or replace one. I know there are other ways to make this, just to be considered. Basic Concepts Source: Cluster node source. Destination: Cluster node to be ...

Comments Off
Copy Protected by Chetan's WP-CopyProtect.