ORACLE

Total Pageviews

Tuesday, 12 December 2023

ORA-01031: insufficient privileges

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
     grant SYSASM to SYS;                  

--4.  --Again Verify the privileges  to sys user
    select * from v$pwfile_users;        

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