Tuesday 11 September 2012

ASM insufficient Privileges and while starting syntax error or unresolved network name 'LISTENER_+ASM'

For the above error,

as well as [oracle@racdr ~]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 8 13:00:14 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup mount pfile ='/u01/app/oracle/diag/asm/+asm/+ASM/trace/init+ASM.ora';
ORA-01031: insufficient privileges
SQL> conn sys as sysasm
Enter password:
ERROR:
ORA-01031: insufficient privileges

We  need to export all the home paths corectly

For ex.. while starting ASM.(11g)

ORACLE HOME should be grid home and also Grid home should be grid home..
export ORACLE_SID as +ASM


If you have any parameter like sqlnet.authentication_services inside your sqlnet.ora file comment that one. And also comment the LOCAL_LISTENER 'LISTENER_+ASM' (if exist ) in the pfile.

Better U create a pfile using ASM alertlog File

Following Steps has to be done.

 $export ORACLE_SID=+ASM
$export ORACLE_HOME=<Your Grid Oracle Home>
$export PATH=$PATH:$ORACLE_HOME/bin

Create the pfile with below values under $ORACLE_HOME/dbs

$cd $ORACLE_HOME/dbs
$vi init+ASM.ora

large_pool_size = 12M
instance_type = "asm"
remote_login_passwordfile= "EXCLUSIVE"
asm_power_limit = 1
diagnostic_dest = "/u01/app/oracle"
asm_diskstring='/dev/oracleasm/disks/*'

$sqlplus "/as sysasm"

sql>startup pfile='?/dbs/init+ASM.ora';

sql>alter diskgroup data mount; (Mention ur diskgroup name)


To catch details of ur ASM

You can use following commands for Linux.
# rpm -qa |grep oracleasm
# /etc/init.d/oracleasm status
# lsmod |grep -i asm
# cat /proc/filesystems |grep -i asm
# ls -l /usr/sbin/oracleasm-discover
# /etc/init.d/oracleasm listdisks
$ /etc/init.d/oracleasm listdisks | xargs /etc/init.d/oracleasm querydisk -p
# ls -l /dev/oracleasm/disks/*
# cat /proc/partitions
# cat /etc/sysconfig/oracleasm
# ls -l /etc/sysconfig/oracleasm*
Ur comments are welcome


 

No comments:

Post a Comment