Connecting asm instance with sysasm and getting error ORA-01031: insufficient privileges
Reason : NO SYSASM privileges assigned to SYS user.
Once SYSASM privilege assigned to SYS then will get connected
Steps
--1. --Connect as sysasm
sqlplus / as sysasm
--2. --Verify the privileges to sys user
- select * from v$pwfile_users;
--3. --Grant the sysasm privileges to sys
Steps
--1. --Connect as sysasm
sqlplus / as sysasm
--2. --Verify the privileges to sys user
- select * from v$pwfile_users;
--3. --Grant the sysasm privileges to sys
grant SYSASM to SYS;
--4. --Again Verify the privileges to sys user
--4. --Again Verify the privileges to sys user
select * from v$pwfile_users;
--5. --Connect with password and check
--5. --Connect with password and check
sqlplus sys/<Password> as sysasm
Detail log
[oracle@rac2 dbs]$ echo $ORACLE_HOME
/u01/app/grid/product/11.2.0/grid
[oracle@rac2 dbs]$ export ORACLE_SID=+ASM2
[oracle@rac2 dbs]$ export ORACLE_HOME=/u01/app/grid/product/11.2.0/grid
[oracle@rac2 dbs]$ export PATH=$PATH:$ORACLE_HOME/bin
[oracle@rac2 dbs]$ echo $ORACLE_HOME
/u01/app/grid/product/11.2.0/grid
[oracle@rac2 dbs]$ export ORACLE_SID=+ASM2
[oracle@rac2 dbs]$ export ORACLE_HOME=/u01/app/grid/product/11.2.0/grid
[oracle@rac2 dbs]$ export PATH=$PATH:$ORACLE_HOME/bin
[[oracle@rac1 ~]$ sqlplus sys/Pssword123#_4T as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 16 17:55:34 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
[oracle@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 16 17:57:59 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE FALSE
SQL>
SQL> grant SYSASM to SYS;
Grant succeeded.
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE TRUE
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[oracle@rac1 ~]$
[oracle@rac1 ~]$ sqlplus sys/Pssword123#_4T as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 16 17:59:17 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL>
No comments:
Post a Comment