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
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