Experience: is what you get soon after you need it.
GIAC Cloud Penetration Tester (GCPN)
GIAC Cloud Security Automation (GCSA)
GIAC Security Essentials (GSEC)
Certified Kubernetes Administrator (CKA)
Cloud Certified Security Professional (ISC2)
CyberSecurity Certified Professional (ISC2)
AWS Certified Solutions Architect Associate
Azure Certified Architect Expert
Azure Certified Architect
Azure Certified Administrator
Oracle Cloud Infrastructure 2018 Certified Architect Associate.
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.
Oracle Database Cloud Administrator Certified Professional.
Oracle Database Cloud Service Operations Certified Associate.
Search This Blog
Thursday, January 6, 2011
11gR2 modify resource to autostart after creating pfile
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
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
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
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