ON CALL DBA SUPPORT

— Database blog

Archive for the ‘ASM’ Category

Configuring ASM failed with the following message: ORA-00845: MEMORY_TARGET not supported on this system

Posted by ssgottik on 13/12/2015

ERROR DURING INSTALLATION :
Configuring ASM failed with the following message:
Configuring HA resource failed. The following error occurred:
PRCR-1079 : Failed to start resource ora.asm
CRS-5017: The resource action “ora.asm start” encountered the following error:
ORA-00845: MEMORY_TARGET not supported on this system
. For details refer to “(:CLSN00107:)” in “/u01/app/grid/diag/crs/nracm1/crs/trace/ohasd_oraagent_grid.trc”.

CRS-2674: Start of ‘ora.asm’ on ‘nracm1’ failed

SOLUTION :

Starting with Oracle Database 12c, If MEMORY_MAX_TARGET or MEMORY_TARGET is set to a non zero value, and an incorrect size is assigned to the shared memory, it will result in an ORA-00845 error at startup.

Increase the size of MEMORY_TARGET and RESTART THE INSTALLATION.

Thanks

Posted in ASM | Leave a Comment »

Oracle Grid Infrastructure is not configured properly. ASMCA needs Oracle Grid Infrastructure to configure ASM.

Posted by ssgottik on 28/08/2015

CaptureSOLUTION:

export ORACLE_HOME=/u01/app/11.2.0/grid_1

$ORACLE_HOME/perl/bin/perl -I$ORACLE_HOME/perl/lib -I$ORACLE_HOME/crs/install $ORACLE_HOME/crs/install/roothas.pl

Posted in ASM | Leave a Comment »

DROPPING A DISK IN A ASM DISKGROUP (11g R2)

Posted by ssgottik on 28/04/2014

From 11g R2 on wards no need to unmount the diskgroup to add and drop the disks:

SQL > alter diskgroup data drop disk  ‘/ora00/oracle/disk100’ ;

SQL >rebalance power 6;

Thanks,

Satish.G.S

Posted in ASM | Leave a Comment »

ADDING DISK TO ASM(11G R2)

Posted by ssgottik on 28/04/2014

From 11g R2 on wards no need to unmount the diskgroup to add and drop the disks:

SQL > alter diskgroup data add disk  ‘/ora00/oracle/disk100’ , ‘ora00/oracle/disk101’

SQL >rebalance power 6;

Thanks,

Satish.G.S

Posted in ASM | Leave a Comment »

ORA-15000: command disallowed by current instance type

Posted by ssgottik on 05/03/2014

ORA-15000: command disallowed by current instance type

When you try to connect to ASM instance remotly you will get this error:

SOLUTION :

connect to the ASM instance as sysasm :

$ sqlplus
SQLPLUS > CONNECT SCOTT/TIGER AS SYSASM

If above fix did not worked for you, then you have to add one more step:

1. Take the backup of the listener.ora file.

2. stop the lisneter :

$lsnrctl stop listener

3. Add below entry to listener.ora file :

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = +ASM)
(ORACLE_HOME = /u01/app/oracle/product/11g/grid)
)
)

3. Start listener :

$lsnrctl start listener

TNS ENTRY :

ASM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VMLINUX1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ASM)(INSTANCE_NAME = +ASM)(UR=A)
)
)

Posted in ASM | Leave a Comment »

ASMLIB INSTALLATION AND CREATING ASM DISKS USING ASMLIB

Posted by ssgottik on 20/10/2013

 REFERANCE : Doc ID 580153.1

There are two different methods to configure ASM on Linux:

ASM with ASMLib I/O: This method creates all Oracle database files on raw block devices managed by ASM using ASMLib calls. RAW devices are not required with this method as ASMLib works with block devices.
ASM with Standard Linux I/O: This method creates all Oracle database files on raw character devices managed by ASM using standard Linux I/O system calls. You will be required to create RAW devices for all disk partitions used by ASM.

You can download the ASMLIB rpm’s from below URL:

http://www.oracle.com/technetwork/server-storage/linux/downloads/index-088143.html

http://www.oracle.com/technetwork/server-storage/linux/downloads/rhel5-084877.html

STEP 01: LOG IN AS ROOT USER AND INSTALL THE RPMS

[root@node1 ASMLIB]# rpm -Uvh oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm \

> oracleasmlib-2.0.4-1.el5.i386.rpm \
> oracleasm-support-2.1.8-1.el5.i386.rpm
warning: oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing… ########################################### [100%]
1:oracleasm-support ########################################### [ 33%]
2:oracleasm-2.6.18-164.el########################################### [ 67%]
3:oracleasmlib ########################################### [100%]

STEP 02: CONFIGURE ASMLIB


[root@node1 ASMLIB]# /etc/init.d/oracleasm configure
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 []: oracle
Default group to own the driver interface []: dba
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
Initializing the Oracle ASMLib driver: [ OK ]
Scanning the system for Oracle ASMLib disks: [ OK ]

STEP 03 :CREATE ASM DISK 

[root@node1 ASMLIB]# /etc/init.d/oracleasm listdisks
[root@node1 ASMLIB]#
[root@node1 ~]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb1
Marking disk “VOL1” as an ASM disk: [ OK ]
[root@node1 ~]# /etc/init.d/oracleasm createdisk VOL2 /dev/sdc1
Marking disk “VOL2” as an ASM disk: [ OK ]
[root@node1 ~]# /etc/init.d/oracleasm createdisk VOL3 /dev/sdd1
Marking disk “VOL3” as an ASM disk: [ OK ]
[root@node1 ~]# /etc/init.d/oracleasm createdisk VOL4 /dev/sde1
Marking disk “VOL4” as an ASM disk: [ OK ]
[root@node1 ~]# /etc/init.d/oracleasm createdisk VOL5 /dev/sdf1
Marking disk “VOL5” as an ASM disk: [ OK ]
[root@node1 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
VOL4
VOL5
[root@node1 ~]#

Posted in ASM | Leave a Comment »