ORA-01031: insufficient privileges Could not validate ASMSNMP password
In Oracle 11gR2 grid
On one of the rac node create a asm password file and copy the file to remaining nodes of the cluster
grid@test1 bin]$ orapwd file=/u01/app/11.2.0/grid/dbs/orapw+ASM password=oracleasm
grid@test1 dbs]$ scp orapw+ASM node2:/u01/app/11.2.0/grid/dbs/
grid@test1 dbs]$ scp orapw+ASM node3:/u01/app/11.2.0/grid/dbs/
Login in to Oracle database as
export ORACLE_SID=+ASM1
export ORACLE_HOME=/u01/app/11.2.0/grid
grid@test1 bin]$ sqlplus / as sysasm
SQL>create user asmsnmp identified by oracleasm
SQL> grant sysdba to asmsnmp;
In Oracle 11gR2 grid
On one of the rac node create a asm password file and copy the file to remaining nodes of the cluster
grid@test1 bin]$ orapwd file=/u01/app/11.2.0/grid/dbs/orapw+ASM password=oracleasm
grid@test1 dbs]$ scp orapw+ASM node2:/u01/app/11.2.0/grid/dbs/
grid@test1 dbs]$ scp orapw+ASM node3:/u01/app/11.2.0/grid/dbs/
Login in to Oracle database as
export ORACLE_SID=+ASM1
export ORACLE_HOME=/u01/app/11.2.0/grid
grid@test1 bin]$ sqlplus / as sysasm
SQL>create user asmsnmp identified by oracleasm
SQL> grant sysdba to asmsnmp;
No comments:
Post a Comment