quarta-feira, 21 de março de 2012

Failed to write the checkpoint:'' with status:FAIL.Error code is 32512

Improper Oracle Grid Infrastructure configuration found on this host
Deconfigure the existing cluster configuration before starting
to configure a new Grid Infrastructure
run '/u01/app/11.2.0.3/grid/crs/install/roothas.pl -deconfig'
to configure existing failed configuration and then rerun root.sh
/u01/app/11.2.0.3/grid/perl/bin/perl -I/u01/app/11.2.0.3/grid/perl/lib -I/u01/app/11.2.0.3/grid/crs/install /u01/app/11.2.0.3/grid/crs/install/roothas.pl execution failed

[root@ dev]# /u01/app/11.2.0.3/grid/crs/install/roothas.pl -deconfig
Using configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_params
Oracle Restart stack is not active on this node
Restart the SIHA stack (use /u01/app/11.2.0.3/grid/bin/crsctl start has) and retry
Failed to write the checkpoint:'' with status:FAIL.Error code is 32512
Failed to verify HA resources



Solution:
$GRID_HOME/crs/install/roothas.pl -deinstall -force

Re-run root.sh

sexta-feira, 16 de março de 2012

Determining Database DBID - Database not open

[oracle@orcl ~]$ strings /u02/oradata/orcl/sysaux01.dbf | grep DB_ID
DB_ID 941873125

or

[oracle@orcl ~]$ strings /bkp/orcl/backupset/df_ORCL_11_1_787935734.dbf | grep MAXVALUE
941982635, MAXVALUE,

UDEV rules for device persistency and permissions/ownerships in OEL6/REDHAT 6 for ASM

http://gjilevski.wordpress.com/2011/05/10/udev-rules-for-device-persistency-and-permissionsownerships-in-oel6redhat-6-for-asm/