Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Thursday, January 6, 2011

11gR2 modify resource to autostart after creating pfile

then modify the resource attributes to start automatically.
For ASM in 11gR2-11.2.0.2:
I created pfile from spfile and started the instance with pfile:

SQL> startup pfile='PATH/init+ASM1.ora';
ASM instance started

Total System Global Area 2120624 bytes
Fixed Size 2212656 bytes
Variable Size 27289364 bytes
ASM Cache 3214564 bytes
*ORA-15110: no diskgroups mounted*

checked the diskgroups:
check the resource is online or offline by:
crsctl status resource -t

Then add the resources that are offline to auto start by:

>crsctl modify resource "ora.DATA_01.dg" -attr "AUTO_START=1"

slpnprdb09cdp(+ASM) /export/home/oracle
>crsctl modify resource "ora.FRA_01.dg" -attr "AUTO_START=1"


SQL> startup
ASM instance started

Total System Global Area 392626176 bytes
Fixed Size 2148392 bytes
Variable Size 365311960 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted

Wednesday, January 5, 2011

ASM device reuse

You want to re use the ASM devices .

in of(output file) give the lun path/storage device path

>dd if=/dev/zero of=/dev/oracle/ASM09/disk16g_t1_0003 bs=1024 count=1000
1000+0 records in
1000+0 records out

Tuesday, January 4, 2011

Cannot configure two CRS instances on the same cluster

Error:
CRS-4000: Command Pin failed, or completed with errors.
you were not able to pin server for the crs installation.

error messages:
Creating OCR keys for user 'oracle', privgrp 'oinstall'..
Operation successful.
CRS-4000: Command Pin failed, or completed with errors.
Command return code of 1 (256) from command: /grid/bin/crsctl pin css -n slpnprdb09cdp
Creating local-only OCR (/grid/bin/crsctl pin css -n slpnprdb09cdp) ... failed
root@ # /grid/bin/crsctl pin css -n slpnprdb09cdp
CRS-4000: Command Pin failed, or completed with errors.



cause:
didn't cleanup the previous Grid infrastructure software properly or existing ASM installation or previous install gone bad

resolution: Run the below as root:
/grid_install_home/crs/install/roothas.pl -delete
How to remove 11gR2 grid infrastructure.

go to :- grid install home/deinstall/

host(+ASM) /cbb09/u0001/oracle/product/11.2.0/grid_1/deinstall
>./deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /cbb09/u0001/oracle/oraInventory/logs/

############ ORACLE DEINSTALL & DECONFIG TOOL START ############


######################### CHECK OPERATION START #########################
Install check configuration START


Checking for existence of the Oracle home location /cbb09/u0001/oracle/product/11.2.0/grid_1
Oracle Home type selected for de-install is: SIHA
Oracle Base selected for de-install is: /cbb09/u0001/oracle
Checking for existence of central inventory location /cbb09/u0001/oracle/oraInventory
Checking for existence of the Oracle Grid Infrastructure home /cbb09/u0001/oracle/product/11.2.0/grid

Install check configuration END

Skipping Windows and .NET products configuration check

Checking Windows and .NET products configuration END

Traces log file: /cbb09/u0001/oracle/oraInventory/logs//crsdc.log

Network Configuration check config START

Network de-configuration trace file location: /cbb09/u0001/oracle/oraInventory/logs/netdc_check2011-01-04_02-55-17-PM.log

Network Configuration check config END

Asm Check Configuration START

ASM de-configuration trace file location: /cbb09/u0001/oracle/oraInventory/logs/asmcadc_check2011-01-04_02-55-19-PM.log