Показаны сообщения с ярлыком ASM. Показать все сообщения
Показаны сообщения с ярлыком ASM. Показать все сообщения

четверг, 19 ноября 2015 г.

Fix ASM diskgroup discovery string to ORCL:*

Issue
$ srvctl config asm
ASM home: /u01/app/oracle/product/11.2.0/grid_1
ASM listener: LISTENER
Spfile: +DATA/asm/asmparameterfile/registry.253.811613369
ASM diskgroup discovery string: /dev/oracleasm/disks/*

$ sqlplus "/as sysasm"
SQL> show parameter asm_diskstring;
asm_diskstring                       string      /dev/oracleasm/disks/*

Solution
1. Install for OEL 6.x
wget http://download.oracle.com/otn_software/asmlib/oracleasmlib-2.0.12-1.el6.x86_64.rpm

rpm -ihv oracleasmlib-2.0.12-1.el6.x86_64.rpm

2. Check visibility from asm user (grid)
oracleasm-discover
Using ASMLib from /opt/oracle/extapi/64/asm/orcl/1/libasm.so
[ASM Library - Generic Linux, version 2.0.12 (KABI_V2)]
Discovered disk: ORCL:DISK1 [2933593688 blocks (1501999968256 bytes), maxio 512, integrity none]
Discovered disk: ORCL:DISK2 [838858752 blocks (429495681024 bytes), maxio 512, integrity none]
Discovered disk: ORCL:DISK3 [2936005222 blocks (1503234673664 bytes), maxio 512, integrity none]

3. Set asm instance parameter for discover
sqlplus "/as sysasm"
ALTER SYSTEM SET asm_diskstring='ORCL:*' SCOPE=SPFILE;

4. Restart asm instance
srvctl stop asm -f
srvctl start asm

5. Check
srvctl config asm
ASM diskgroup discovery string: ORCL:*

четверг, 31 октября 2013 г.

Oracle Grid Standalone update 11.2.0.3 to 11.2.0.4


Backup ASM spfile
$srvctl config asm
ASM home: /u01/app/oracle/product/11.2.0/grid
ASM listener: LISTENER
Spfile: +DATA/asm/asmparameterfile/registry.253.811613369
ASM diskgroup discovery string: /dev/oracleasm/disks/*

$asmcmd
spbackup +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.811613369 /home/oracle/init+ASM.ora.backup

Backup OLR:
The default backup location for the OLR is in the path Grid_home/cdata/host_name

#ocrconfig –local –manualbackup

To restore OLR:
# crsctl stop crs
# ocrconfig -local -restore file_name
# ocrcheck -local
# crsctl start crs
$ cluvfy comp olr

Begin update
Shutdown the database, oem.
. oraenv prompt dbsid
$emctl stop dbconsole
$srvctl stop database -d dbsid

$unset ORA_CRS_HOME
$unset ORACLE_BASE
$unset ORACLE_HOME
$unset ORACLE_SID
Recommended practice is to upgrade an Oracle ASM instance with Oracle Universal Installer or asmca (after install new GI home) ./runInstaller

Confirm that asm, listener, database, oem are running.
. oraenv
+ASM
$crsctl stat res -t

. oraenv
dbsid
$srvctl start database -d dbsid
$emctl start dbconsole


воскресенье, 27 октября 2013 г.

Oracle update 11.2.0.3 to 11.2.0.4

I have Grid Standalone installation 11.2.0.3 and Oracle Database 11.2.0.3
I plan update to 11.2.0.4
Patching end date for 11.2.0.3 is 27-Aug-2015.

1. Need PSU (Doc ID 1392633.1) and Latest Opatch to apply.
Oracle Grid Infrastructure Patch Set Update 11.2.0.3.8 (Includes Database PSU 11.2.0.3.8) - 17272731
2. Download Patch Set 11.2.0.4 13390677

Pre-Upgrade Utility Note 884522.1

Use DBUA for out-of-place installation


to be continued ...

понедельник, 15 апреля 2013 г.

dbv script for ASM datastore


select 'dbv file='''||file_name||''' blocksize='||df2.BLOCK_SIZE||' userid=sys/xxx logfile=dbv-'||tablespace_name||'.log' from dba_data_files df,v$datafile df2
where  df.file_id = df2.FILE#