ASM Installation Updated 12 Apr 2016, 08:40
Share
Ocean Data Search this site
Services
Navigation Oracle > ASM >
Home
ASM Installation
About Ocean Data
Services
Automate OEM 13
patching Steps to create ASM instance:
cas_cluster_creati…
Cassandra
Docker Basics
[email protected]*+ASM->. oraenv
Extending lvm with
no partitions
ORACLE_SID = [+ASM] ? +ASM
Issue dump
Monitoring The Oracle base remains unchanged with value /grid/app/grid
MySQL
OpenStack [email protected]*+ASM->cd $ORACLE_HOME/dbs
Standards
Oracle [email protected]*+ASM-> vi init+ASM.ora
PostgreSQL
init+ASM.ora
Server Pricing
+ASM.__large_pool_size=16777216
SQL Server
Support Info
+ASM.__oracle_base='/grid
System Notices
/app/grid'#ORACLE_BASE set from in
Utopia
memory value
Sitemap
Recent site +ASM.asm_diskgroups='DATA','FRA'#Manual
activity Mount
Oracle Restart
Production *.asm_diskstring='/dev/oracleasm/disks/*'
Databases
edited by Sebastien *.asm_power_limit=1
Blanc
*.core_dump_dest='/grid/app/grid
PostgreSQL
Troubleshooting
/diag/asm/+asm/+ASM/cdump'
guide for
ServiceDesk *.diagnostic_dest='/grid/app/grid'
edited by Sebastien
Blanc *.instance_type='asm'
PostgreSQL *.large_pool_size=12M
edited by Sebastien
Blanc
*.remote_login_passwordfile='EXCLUSIVE'
PostgreSQL
Troubleshooting
guide for
ServiceDesk [email protected]*+ASM->su
created by Sebastien
Blanc
Password:
Killing Database
Sessions root@ithfdb67:/export/home/grid# which oracleasm
edited by Ashiqur
Rahman /usr/sbin/oracleasm
View All
root@ithfdb67:/export/home/grid# oracleasm configure -i
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
root@ithfdb67:/grid/app/11.2.0/grid/dbs# cat /etc/sysconfig/oracleasm
#
# This is a configura on file for automa c loading of the Oracle
# Automa c Storage Management library kernel driver. It is generated
# By running /etc/init.d/oracleasm configure. Please use that method
# to modify this file
# ORACLEASM_ENABLED: 'true' means to load the driver on boot.
ORACLEASM_ENABLED=true
# ORACLEASM_UID: Default user owning the /dev/oracleasm mount point.
ORACLEASM_UID=grid
# ORACLEASM_GID: Default group owning the /dev/oracleasm mount point.
ORACLEASM_GID=asmadmin
# ORACLEASM_SCANBOOT: 'true' means scan for ASM disks on boot.
ORACLEASM_SCANBOOT=true
# ORACLEASM_SCANORDER: Matching pa erns to order disk scanning
ORACLEASM_SCANORDER=""
# ORACLEASM_SCANEXCLUDE: Matching pa erns to exclude disks from scan
ORACLEASM_SCANEXCLUDE=""
# ORACLEASM_USE_LOGICAL_BLOCK_SIZE: 'true' means use the logical block
size
# reported by the underlying disk instead of the physical. The default
# is 'false'
ORACLEASM_USE_LOGICAL_BLOCK_SIZE=false
root@ithfdb67:/grid/app/11.2.0/grid/dbs# oracleasm status
Checking if ASM is loaded: no
Checking if /dev/oracleasm is mounted: no
root@ithfdb67:/grid/app/11.2.0/grid/dbs# oracleasm init
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Configuring "oracleasm" to use device physical block size
Mounting ASMlib driver filesystem: /dev/oracleasm
root@ithfdb67:/grid/app/11.2.0/grid/dbs# oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes
root@ithfdb67:/grid/app/11.2.0/grid/dbs# ls -ls /dev/s*
0 brw-rw---- 1 root disk 8, 0 Oct 7 10:10 /dev/sda
0 brw-rw---- 1 root disk 8, 1 Oct 7 10:10 /dev/sda1
0 brw-rw---- 1 root disk 8, 2 Oct 7 10:10 /dev/sda2
0 brw-rw---- 1 root disk 8, 16 Oct 7 10:10 /dev/sdb
0 brw-rw---- 1 root disk 8, 17 Oct 7 10:10 /dev/sdb1
0 brw-rw---- 1 root disk 8, 32 Oct 7 10:10 /dev/sdc
0 brw-rw---- 1 root disk 8, 33 Oct 7 10:10 /dev/sdc1
0 brw-rw---- 1 root disk 8, 48 Oct 7 10:10 /dev/sdd
0 brw-rw---- 1 root disk 8, 49 Oct 7 10:10 /dev/sdd1
0 brw-rw---- 1 root disk 8, 64 Oct 7 10:10 /dev/sde
0 brw-rw---- 1 root disk 8, 65 Oct 7 10:10 /dev/sde1
0 crw-rw---- 1 root disk 21, 0 Oct 7 10:10 /dev/sg0
0 crw-rw---- 1 root disk 21, 1 Oct 7 10:10 /dev/sg1
0 crw-rw---- 1 root disk 21, 2 Oct 7 10:10 /dev/sg2
0 crw-rw---- 1 root disk 21, 3 Oct 7 10:10 /dev/sg3
0 crw-rw---- 1 root disk 21, 4 Oct 7 10:10 /dev/sg4
0 crw-rw---- 1 root disk 21, 5 Oct 7 10:10 /dev/sg5
0 crw-rw---- 1 root disk 21, 6 Oct 7 10:10 /dev/sg6
0 crw-rw---- 1 root root 21, 7 Oct 7 10:10 /dev/sg7
0 crw-rw---- 1 root root 10, 231 Oct 7 10:10 /dev/snapshot
0 lrwxrwxrwx 1 root root 15 Oct 7 10:10 /dev/stderr -> /proc/self/fd/2
0 lrwxrwxrwx 1 root root 15 Oct 7 10:10 /dev/stdin -> /proc/self/fd/0
0 lrwxrwxrwx 1 root root 15 Oct 7 10:10 /dev/stdout -> /proc/self/fd/1
0 lrwxrwxrwx 1 root root 4 Oct 7 10:10 /dev/systty -> tty0
/dev/shm:
total 0
root@ithfdb67:/grid/app/11.2.0/grid/dbs# oracleasm createdisk DISK1 /dev/sdb1
Writing disk header: done
Instantiating disk: done
root@ithfdb67:/grid/app/11.2.0/grid/dbs# oracleasm createdisk DISK1 /dev/sdc1
Disk "DISK1" already exists
root@ithfdb67:/grid/app/11.2.0/grid/dbs# oracleasm createdisk DISK2 /dev/sdc1
Writing disk header: done
Instantiating disk: done
root@ithfdb67:/grid/app/11.2.0/grid/dbs# oracleasm createdisk DISK3 /dev/sdd1
Writing disk header: done
Instantiating disk: done
root@ithfdb67:/grid/app/11.2.0/grid/dbs# oracleasm createdisk DISK4 /dev/sde1
Writing disk header: done
Instantiating disk: done
root@ithfdb67:/grid/app/11.2.0/grid/dbs# oracleasm listdisks
DISK1
DISK2
DISK3
DISK4
[Note : If unable to list disks then do oracleasm scandisks , it's required after server reboot ]
root@ithfdb67:/export/home/grid# ls -la /dev/oracleasm/disks/*
brw-rw---- 1 grid asmadmin 8, 17 Oct 8 14:57 /dev/oracleasm/disks/DISK1
brw-rw---- 1 grid asmadmin 8, 33 Oct 8 14:57 /dev/oracleasm/disks/DISK2
brw-rw---- 1 grid asmadmin 8, 49 Oct 8 14:57 /dev/oracleasm/disks/DISK3
brw-rw---- 1 grid asmadmin 8, 65 Oct 8 14:57 /dev/oracleasm/disks/DISK4
root@ithfdb67:/grid/app/11.2.0/grid/dbs# exit
exit
[email protected]*+ASM->crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.cssd ora.cssd.type OFFLINE OFFLINE
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE ithfdb67
ora.ons ora.ons.type OFFLINE OFFLINE
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ithfdb67'
CRS-2673: Attempting to stop 'ora.evmd' on 'ithfdb67'
CRS-2677: Stop of 'ora.evmd' on 'ithfdb67' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ithfdb67' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
[email protected]*+ASM->crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'ithfdb67'
CRS-2672: Attempting to start 'ora.diskmon' on 'ithfdb67'
CRS-2676: Start of 'ora.diskmon' on 'ithfdb67' succeeded
CRS-2676: Start of 'ora.cssd' on 'ithfdb67' succeeded
[email protected]*+ASM->crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.cssd ora.cssd.type ONLINE ONLINE ithfdb67
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE ithfdb67
ora.ons ora.ons.type OFFLINE OFFLINE
ASM home: /grid/app/11.2.0/grid
ASM listener was not found
PRCA-1032 : ASM listener LISTENER does not exist
Spfile:
ASM diskgroup discovery string: ++no-value-at-resource-creation--never-updated-through-ASM++
ASM is not running.
ASM is running on ithfdb67
[email protected]*+ASM->sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 8 14:26:53 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount pfile=/grid/app/11.2.0/grid/dbs/init+ASM.ora
ASM instance started
Total System Global Area 321507328 bytes
Fixed Size 2228024 bytes
Variable Size 294113480 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15017: diskgroup "FRA" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "FRA"
ORA-15017: diskgroup "DATA" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
SQL> show parameter diskstring
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring string /dev/oracleasm/disks/*
SQL> CREATE DISKGROUP DATA NORMAL REDUNDANCY FAILGROUP FG1 DISK '/dev/oracleasm/disks
/DISK1' FAILGROUP FG2 DISK '/dev/oracleasm/disks/DISK2'
ATTRIBUTE
'au_size'='4M',
'compatible.asm' = '11.2',
'compatible.rdbms' = '11.2',
'sector_size'='512';
Diskgroup created.
SQL> CREATE DISKGROUP FRA NORMAL REDUNDANCY
FAILGROUP FG1 DISK
'/dev/oracleasm/disks/DISK3'
FAILGROUP FG2 DISK
'/dev/oracleasm/disks/DISK4'
ATTRIBUTE
'au_size'='4M',
'compatible.asm' = '11.2',
'compatible.rdbms' = '11.2',
'sector_size'='512';
Diskgroup created.
SQL> shutdown
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup mount pfile=/grid/app/11.2.0/grid/dbs/init+ASM.ora
ASM instance started
Total System Global Area 321507328 bytes
Fixed Size 2228024 bytes
Variable Size 294113480 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> create spfile from pfile;
File created.
SQL> shutdown
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area 321507328 bytes
Fixed Size 2228024 bytes
Variable Size 294113480 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATA MOUNTED
FRA MOUNTED
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[email protected]*+ASM->crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE ithfdb67
ora.FRA.dg ora....up.type ONLINE ONLINE ithfdb67
ora.asm ora.asm.type ONLINE ONLINE ithfdb67
ora.cssd ora.cssd.type ONLINE ONLINE ithfdb67
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE ithfdb67
ora.ons ora.ons.type OFFLINE OFFLINE
[email protected]*+ASM->asmcmd
ASMCMD> cd +DATA
ASMCMD> ls
ASMCMD> mkdir oradb/
Create following dir:
+DATA/oradb
+DATA/oradb/UTT01D/
+DATA/oradb/UTT01D/dat/
+DATA/oradb/UTT01D/redo1/
+DATA/oradb/UTT01D/redo2/
+DATA/oradb/UTT01D/tmp/
+FRA/oradb/UTT01C/fra/UTT01C
ASMCMD> cd +FRA/
ASMCMD> ls
ASMCMD> mkdir oradb/
ASMCMD> cd oradb/
ASMCMD> mkdir UTT01D/
ASMCMD> cd UTT01D/
ASMCMD> mkdir fra/
ASMCMD> cd fra/
ASMCMD> mkdir UTT01D/
ASMCMD> cd UTT01D/
ASMCMD> pwd
+FRA/oradb/UTT01D/fra/UTT01D
Add files
Recent Site Activity | Report Abuse | Print Page | Remove Access | Powered By Google Sites
